The quickbooks tap authenticates but fails with "Invalid format string" on any object #102
Description
Hello, we are testing the quickbooks tap and it successfully authenticates but every object throws an error that the time_extracted is not a valid format. Any help would be greatly appreciated! Please see the log below:
(venv) PS C:\Users\rbliss\Meltano\rea-meltano> meltano run tap-quickbooks target-jsonl
2024-04-30T16:04:16.425603Z [warning ] Failed to create symlink to 'meltano.exe': administrator privilege required
2024-04-30T16:04:16.433604Z [info ] Environment 'dev' is active
2024-04-30T16:04:17.134238Z [info ] INFO Instance URL :- https://quickbooks.api.intuit.com/v3/company/xxxxxx cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:17.136239Z [info ] INFO Attempting login via OAuth2 cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:17.137239Z [info ] INFO Making POST request to https://oauth.platform.intuit.com/oauth2/v1/tokens/bearer with body {'grant_type': 'refresh_token', 'client_id': 'xxxxxx', 'client_secret': 'xxxxxx', 'refresh_token': 'xxxxxx'} cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:17.780926Z [info ] INFO OAuth2 login successful cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:17.782883Z [info ] INFO Starting new login timer cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:17.785882Z [info ] INFO Starting sync cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:17.786867Z [info ] INFO Account: Skipping - not selected cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:17.787854Z [info ] INFO Bill: Skipping - not selected cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:17.788868Z [info ] INFO Class: Skipping - not selected cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:17.789863Z [info ] INFO CustomerType: Skipping - not selected cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:17.790823Z [info ] INFO PaymentMethod: Skipping - not selected cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:17.790823Z [info ] INFO Payment: Skipping - not selected cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:17.791836Z [info ] INFO Transfer: Skipping - not selected cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:17.792824Z [info ] INFO CompanyInfo: Skipping - not selected cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:17.793825Z [info ] INFO TaxRate: Skipping - not selected cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:17.794827Z [info ] INFO TaxCode: Skipping - not selected cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:17.795823Z [info ] INFO Term: Skipping - not selected cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:17.796823Z [info ] INFO Department: Skipping - not selected cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:17.797828Z [info ] INFO CreditMemo: Skipping - not selected cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:17.797828Z [info ] INFO Customer: Skipping - not selected cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:17.799827Z [info ] INFO Employee: Skipping - not selected cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:17.800824Z [info ] INFO Invoice: Skipping - not selected cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:17.800824Z [info ] INFO Item: Starting cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:17.801822Z [info ] INFO Syncing Quickbooks data for stream Item cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:17.802822Z [info ] INFO Making GET request to https://quickbooks.api.intuit.com/v3/company/xxxxx/query with params: {'query': 'SELECT * FROM Item STARTPOSITION 0 MAXRESULTS 100', 'minorversion': '45'} cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:17.802822Z [info ] WARNING Unknown message type ACTIVATE_VERSION in message {'type': 'ACTIVATE_VERSION', 'stream': 'Item', 'version': 1714493057785} cmd_type=elb consumer=True job_name=dev:tap-quickbooks-to-target-jsonl name=target-jsonl producer=False run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=target-jsonl
2024-04-30T16:04:18.503903Z [info ] INFO METRIC: {"type": "counter", "metric": "record_count", "value": 1, "tags": {"endpoint": "Item"}} cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:18.504903Z [info ] CRITICAL Error syncing Item: Invalid format string cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:18.505901Z [info ] Traceback (most recent call last): cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:18.506901Z [info ] File "C:\Users\xxxxx\Meltano\rea-meltano.meltano\extractors\tap-quickbooks\venv\Lib\site-packages\tap_quickbooks\sync.py", line 64, in sync_stream cmd_type=elb
consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:18.508903Z [info ] sync_records(qb, catalog_entry, state, counter, state_passed) cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:18.510907Z [info ] File "C:\Users\xxxxx\Meltano\rea-meltano.meltano\extractors\tap-quickbooks\venv\Lib\site-packages\tap_quickbooks\sync.py", line 105, in sync_records cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:18.512905Z [info ] singer.write_message( cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:18.514907Z [info ] File "C:\Users\xxxxx\Meltano\rea-meltano.meltano\extractors\tap-quickbooks\venv\Lib\site-packages\singer\messages.py", line 217, in write_message cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:18.515904Z [info ] sys.stdout.write(format_message(message) + '\n') cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:18.517903Z [info ] ^^^^^^^^^^^^^^^^^^^^^^^ cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:18.518901Z [info ] File "C:\Users\xxxxx\Meltano\rea-meltano.meltano\extractors\tap-quickbooks\venv\Lib\site-packages\singer\messages.py", line 213, in format_message cmd_type=elb
consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:18.519902Z [info ] return json.dumps(message.asdict(), use_decimal=True) cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True
run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:18.520903Z [info ] ^^^^^^^^^^^^^^^^ cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:18.521903Z [info ] File "C:\Users\xxxxx\Meltano\rea-meltano.meltano\extractors\tap-quickbooks\venv\Lib\site-packages\singer\messages.py", line 63, in asdict cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:18.522902Z [info ] result['time_extracted'] = u.strftime(as_utc) cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:18.523902Z [info ] ^^^^^^^^^^^^^^^^^^ cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:18.524903Z [info ] File "C:\Users\xxxxx\Meltano\rea-meltano.meltano\extractors\tap-quickbooks\venv\Lib\site-packages\singer\utils.py", line 43, in strftime cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:18.525902Z [info ] dt_str = dtime.strftime(format_str) cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:18.526901Z [info ] ^^^^^^^^^^^^^^^^^^^^^^^^^^ cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:18.527903Z [info ] ValueError: Invalid format string cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:18.528902Z [info ] cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:18.528902Z [info ] The above exception was the direct cause of the following exception: cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:18.529902Z [info ] cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:18.530905Z [info ] Traceback (most recent call last): cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:18.532902Z [info ] File "", line 198, in run_module_as_main cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True
run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:18.533901Z [info ] File "", line 88, in run_code cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:18.533901Z [info ] File "C:\Users\xxxxx\Meltano\rea-meltano.meltano\extractors\tap-quickbooks\venv\Scripts\tap-quickbooks.exe_main.py", line 7, in cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:18.534901Z [info ] File "C:\Users\xxxx\Meltano\rea-meltano.meltano\extractors\tap-quickbooks\venv\Lib\site-packages\tap_quickbooks_init.py", line 319, in main cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:18.535904Z [info ] raise e cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:18.536902Z [info ] File "C:\Users\xxxxx\Meltano\rea-meltano.meltano\extractors\tap-quickbooks\venv\Lib\site-packages\tap_quickbooks_init_.py", line 310, in main cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:18.537902Z [info ] main_impl() cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:18.538901Z [info ] File "C:\Users\xxxxx\Meltano\rea-meltano.meltano\extractors\tap-quickbooks\venv\Lib\site-packages\tap_quickbooks_init_.py", line 297, in main_impl cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:18.539902Z [info ] do_sync(qb, catalog, state, state_passed) cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:18.540902Z [info ] File "C:\Users\xxxxx\Meltano\rea-meltano.meltano\extractors\tap-quickbooks\venv\Lib\site-packages\tap_quickbooks_init_.py", line 256, in do_sync cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:18.541902Z [info ] counter = sync_stream(qb, catalog_entry, state, state_passed) cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:18.543902Z [info ] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:18.544903Z [info ] File "C:\Users\xxxxx\Meltano\rea-meltano.meltano\extractors\tap-quickbooks\venv\Lib\site-packages\tap_quickbooks\sync.py", line 70, in sync_stream cmd_type=elb
consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:18.546902Z [info ] raise Exception("Error syncing {}: {}".format( cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:18.547905Z [info ] Exception: Error syncing Item: Invalid format string cmd_type=elb consumer=False job_name=dev:tap-quickbooks-to-target-jsonl name=tap-quickbooks producer=True run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=tap-quickbooks
2024-04-30T16:04:18.548903Z [info ] ERROR Unable to parse: cmd_type=elb consumer=True job_name=dev:tap-quickbooks-to-target-jsonl name=target-jsonl producer=False run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=target-jsonl
2024-04-30T16:04:18.549902Z [info ] 2024-04-30 16:04:17.786867+00:00 cmd_type=elb consumer=True job_name=dev:tap-quickbooks-to-target-jsonl name=target-jsonl producer=False run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=target-jsonl
2024-04-30T16:04:18.551904Z [info ] cmd_type=elb consumer=True job_name=dev:tap-quickbooks-to-target-jsonl name=target-jsonl producer=False run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=target-jsonl
2024-04-30T16:04:18.552903Z [info ] Traceback (most recent call last): cmd_type=elb consumer=True job_name=dev:tap-quickbooks-to-target-jsonl name=target-jsonl producer=False run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=target-jsonl
2024-04-30T16:04:18.553903Z [info ] File "", line 198, in run_module_as_main cmd_type=elb consumer=True job_name=dev:tap-quickbooks-to-target-jsonl name=target-jsonl producer=False run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=target-jsonl
2024-04-30T16:04:18.554903Z [info ] File "", line 88, in run_code cmd_type=elb consumer=True job_name=dev:tap-quickbooks-to-target-jsonl name=target-jsonl producer=False run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=target-jsonl
2024-04-30T16:04:18.555903Z [info ] File "C:\Users\xxxxx\Meltano\rea-meltano.meltano\loaders\target-jsonl\venv\Scripts\target-jsonl.exe_main.py", line 7, in cmd_type=elb consumer=True job_name=dev:tap-quickbooks-to-target-jsonl name=target-jsonl producer=False run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=target-jsonl
2024-04-30T16:04:18.556903Z [info ] File "C:\Users\xxxxxx\Meltano\rea-meltano.meltano\loaders\target-jsonl\venv\Lib\site-packages\target_jsonl.py", line 92, in main cmd_type=elb consumer=True job_name=dev:tap-quickbooks-to-target-jsonl name=target-jsonl producer=False run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=target-jsonl
2024-04-30T16:04:18.557905Z [info ] state = persist_messages( cmd_type=elb consumer=True job_name=dev:tap-quickbooks-to-target-jsonl name=target-jsonl producer=False run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=target-jsonl
2024-04-30T16:04:18.559903Z [info ] ^^^^^^^^^^^^^^^^^ cmd_type=elb consumer=True job_name=dev:tap-quickbooks-to-target-jsonl name=target-jsonl producer=False run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=target-jsonl
2024-04-30T16:04:18.561904Z [info ] File "C:\Users\xxxxx\Meltano\rea-meltano.meltano\loaders\target-jsonl\venv\Lib\site-packages\target_jsonl.py", line 42, in persist_messages cmd_type=elb consumer=True job_name=dev:tap-quickbooks-to-target-jsonl name=target-jsonl producer=False run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=target-jsonl
2024-04-30T16:04:18.563918Z [info ] o = singer.parse_message(message).asdict() cmd_type=elb consumer=True job_name=dev:tap-quickbooks-to-target-jsonl name=target-jsonl producer=False run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=target-jsonl
2024-04-30T16:04:18.565909Z [info ] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ cmd_type=elb consumer=True job_name=dev:tap-quickbooks-to-target-jsonl name=target-jsonl producer=False run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=target-jsonl
2024-04-30T16:04:18.566904Z [info ] File "C:\Users\xxxxxx\Meltano\rea-meltano.meltano\loaders\target-jsonl\venv\Lib\site-packages\singer\messages.py", line 185, in parse_message cmd_type=elb consumer=True job_name=dev:tap-quickbooks-to-target-jsonl name=target-jsonl producer=False run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=target-jsonl
2024-04-30T16:04:18.568904Z [info ] obj = json.loads(msg, use_decimal=True) cmd_type=elb consumer=True job_name=dev:tap-quickbooks-to-target-jsonl name=target-jsonl producer=False run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=target-jsonl
2024-04-30T16:04:18.569903Z [info ] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ cmd_type=elb consumer=True job_name=dev:tap-quickbooks-to-target-jsonl name=target-jsonl producer=False run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=target-jsonl
2024-04-30T16:04:18.570903Z [info ] File "C:\Users\xxxxx\Meltano\rea-meltano.meltano\loaders\target-jsonl\venv\Lib\site-packages\simplejson_init.py", line 533, in loads cmd_type=elb consumer=True job_name=dev:tap-quickbooks-to-target-jsonl name=target-jsonl producer=False run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=target-jsonl
2024-04-30T16:04:18.571905Z [info ] return cls(encoding=encoding, **kw).decode(s) cmd_type=elb consumer=True job_name=dev:tap-quickbooks-to-target-jsonl name=target-jsonl producer=False run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=target-jsonl
2024-04-30T16:04:18.573904Z [info ] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ cmd_type=elb consumer=True job_name=dev:tap-quickbooks-to-target-jsonl name=target-jsonl producer=False run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=target-jsonl
2024-04-30T16:04:18.574904Z [info ] File "C:\Users\xxxxxx\Meltano\rea-meltano.meltano\loaders\target-jsonl\venv\Lib\site-packages\simplejson\decoder.py", line 373, in decode cmd_type=elb consumer=True job_name=dev:tap-quickbooks-to-target-jsonl name=target-jsonl producer=False run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=target-jsonl
2024-04-30T16:04:18.575903Z [info ] raise JSONDecodeError("Extra data", s, end, len(s)) cmd_type=elb consumer=True job_name=dev:tap-quickbooks-to-target-jsonl name=target-jsonl producer=False run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=target-jsonl
2024-04-30T16:04:18.577913Z [info ] simplejson.scanner.JSONDecodeError: Extra data: line 1 column 5 - line 2 column 1 (char 4 - 33) cmd_type=elb consumer=True job_name=dev:tap-quickbooks-to-target-jsonl name=target-jsonl producer=False run_id=cfaad42d-2b86-4545-99a9-bc4aab7501cf stdio=stderr string_id=target-jsonl
2024-04-30T16:04:18.603901Z [error ] Extractor and loader failed
2024-04-30T16:04:18.604902Z [error ] Block run completed. block_type=ExtractLoadBlocks err=RunnerError('Extractor and loader failed') exit_codes={<PluginType.EXTRACTORS: 'extractors'>: 1, <PluginType.LOADERS: 'loaders'>: 1} set_number=0 success=False
Need help fixing this problem? Visit http://melta.no/ for troubleshooting steps, or to
join our friendly Slack community.
Run invocation could not be completed as block failed: Extractor and loader failed