TenantSyncCoordinator.RunTenantSyncAsync

The job is finished. It will be removed automatically 03/14/2026 14:00:33.
// Id: #606
using RmsQboIntegration.Web.Infrastructure.Services.Inbound;

var tenantSyncCoordinator = Activate<TenantSyncCoordinator>();
await tenantSyncCoordinator.RunTenantSyncAsync(1, null);

Parameters

CurrentCulture
""
CurrentUICulture
""

State

03/13/2026 14:00:33 (+21.903s) Succeeded

Latency:
45ms
Duration:
21.885s
Result:
{"$type":"RmsQboIntegration.Web.Infrastructure.Dtos.MeltanoRunResult, web","ExitCode":1,"StdOut":"","StdErr":"2026-03-13T14:00:12.294888Z [info ] meltano Environment 'tenant' is active\n2026-03-13T14:00:12.585841Z [info ] meltano Running job with name 'tenant:tap-quickbooks-to-target-postgres:tenant-1' and run ID '019ce77f-67a7-7de2-83ff-186c00c4575a'\n2026-03-13T14:00:12.760596Z [info ] meltano Using systemdb state backend \n2026-03-13T14:00:12.762134Z [warning ] meltano No state was found, complete import.\n2026-03-13T14:00:13.066911Z [info ] tap-quickbooks INFO Instance URL :- https://sandbox-quickbooks.api.intuit.com/v3/company/9341456531142773\n2026-03-13T14:00:13.067995Z [info ] tap-quickbooks INFO Attempting login via OAuth2\n2026-03-13T14:00:13.068466Z [info ] tap-quickbooks INFO Making POST request to https://oauth.platform.intuit.com/oauth2/v1/tokens/bearer with body {'grant_type': 'refresh_token', 'client_id': 'AB2Ag97vCYR7yvqjdapSSml5MDCvHMV8nZ7AsR548WCiiTDkzE', 'client_secret': 'DTZzG7J8Mt5eowadYeKz8qAsQHpeA68iXi4AqqVd', 'refresh_token': 'RT1-159-H0-1782095738zhk7s6lbkxsg4sacz4qp'}\n2026-03-13T14:00:13.510604Z [info ] target-postgres target-postgres v0.6.3, Meltano SDK v0.53.5\n2026-03-13T14:00:13.511306Z [info ] target-postgres Skipping parse of env var settings...\n2026-03-13T14:00:17.744258Z [info ] tap-quickbooks INFO OAuth2 login successful \n2026-03-13T14:00:17.745309Z [info ] tap-quickbooks INFO REFRESH TOKEN: RT1-159-H0-1782095738zhk7s6lbkxsg4sacz4qp\n2026-03-13T14:00:17.746520Z [info ] tap-quickbooks INFO Starting new login timer \n2026-03-13T14:00:17.748078Z [info ] tap-quickbooks INFO Starting sync \n2026-03-13T14:00:17.748639Z [info ] tap-quickbooks INFO Account: Starting \n2026-03-13T14:00:17.752471Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Account\n2026-03-13T14:00:17.753186Z [info ] tap-quickbooks INFO Making GET request to https://sandbox-quickbooks.api.intuit.com/v3/company/9341456531142773/query with params: {'query': 'SELECT * FROM Account STARTPOSITION 0 MAXRESULTS 100', 'minorversion': '75'}\n2026-03-13T14:00:18.133012Z [info ] target-postgres Hard delete: False \n2026-03-13T14:00:22.669323Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 89, \"tags\": {\"endpoint\": \"Account\"}}\n2026-03-13T14:00:22.669880Z [info ] tap-quickbooks INFO Account: Completed sync (89 rows)\n2026-03-13T14:00:22.670208Z [info ] tap-quickbooks INFO Bill: Starting \n2026-03-13T14:00:22.670558Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Bill\n2026-03-13T14:00:22.670750Z [info ] tap-quickbooks INFO Making GET request to https://sandbox-quickbooks.api.intuit.com/v3/company/9341456531142773/query with params: {'query': 'SELECT * FROM Bill STARTPOSITION 0 MAXRESULTS 100', 'minorversion': '75'}\n2026-03-13T14:00:22.684754Z [info ] target-postgres An activate version message for 'Account' was received. Draining...\n2026-03-13T14:00:22.760150Z [info ] target-postgres Inserting with SQL: INSERT INTO \"14adb2ce_403a_4ac1_94f3_ad40a4edabe6\" (\"Name\", \"SubAccount\", \"Description\", \"FullyQualifiedName\", \"Active\", \"Classification\", \"AccountType\", \"AccountSubType\", \"AcctNum\", \"CurrentBalance\", \"CurrentBalanceWithSubAccounts\", \"CurrencyRef\", \"ParentRef\", \"Id\", \"MetaData\", _sdc_extracted_at, _sdc_received_at, _sdc_batched_at, _sdc_deleted_at, _sdc_sequence, _sdc_table_version, _sdc_sync_started_at) VALUES (:Name, :SubAccount, :Description, :FullyQualifiedName, :Active, :Classification, :AccountType, :AccountSubType, :AcctNum, :CurrentBalance, :CurrentBalanceWithSubAccounts, :CurrencyRef, :ParentRef, :Id, :MetaData, :_sdc_extracted_at, :_sdc_received_at, :_sdc_batched_at, :_sdc_deleted_at, :_sdc_sequence, :_sdc_table_version, :_sdc_sync_started_at)\n2026-03-13T14:00:22.860386Z [info ] target-postgres Hard delete: False \n2026-03-13T14:00:23.016181Z [info ] target-postgres Hard delete: False \n2026-03-13T14:00:23.503923Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 15, \"tags\": {\"endpoint\": \"Bill\"}}\n2026-03-13T14:00:23.504930Z [info ] tap-quickbooks INFO Bill: Completed sync (15 rows)\n2026-03-13T14:00:23.505357Z [info ] tap-quickbooks INFO Class: Starting \n2026-03-13T14:00:23.505877Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Class\n2026-03-13T14:00:23.506263Z [info ] tap-quickbooks INFO Making GET request to https://sandbox-quickbooks.api.intuit.com/v3/company/9341456531142773/query with params: {'query': 'SELECT * FROM Class STARTPOSITION 0 MAXRESULTS 100', 'minorversion': '75'}\n2026-03-13T14:00:23.506783Z [info ] target-postgres An activate version message for 'Bill' was received. Draining...\n2026-03-13T14:00:23.663927Z [info ] target-postgres Inserting with SQL: INSERT INTO \"2d4cb6d6_a4ed_4e65_a04e_1e7afdf22d31\" (\"Id\", \"VendorRef\", \"Line\", \"CurrencyRef\", \"TxnDate\", \"APAccountRef\", \"SalesTermRef\", \"LinkedTxn\", \"TotalAmt\", \"DueDate\", \"MetaData\", \"DocNumber\", \"PrivateNote\", \"ExchangeRate\", \"DepartmentRef\", \"HomeBalance\", \"RecurDataRef\", \"Balance\", _sdc_extracted_at, _sdc_received_at, _sdc_batched_at, _sdc_deleted_at, _sdc_sequence, _sdc_table_version, _sdc_sync_started_at) VALUES (:Id, :VendorRef, :Line, :CurrencyRef, :TxnDate, :APAccountRef, :SalesTermRef, :LinkedTxn, :TotalAmt, :DueDate, :MetaData, :DocNumber, :PrivateNote, :ExchangeRate, :DepartmentRef, :HomeBalance, :RecurDataRef, :Balance, :_sdc_extracted_at, :_sdc_received_at, :_sdc_batched_at, :_sdc_deleted_at, :_sdc_sequence, :_sdc_table_version, :_sdc_sync_started_at)\n2026-03-13T14:00:23.747601Z [info ] tap-quickbooks INFO Response with no data {'QueryResponse': {}, 'time': '2026-03-13T07:00:23.626-07:00'}\n2026-03-13T14:00:23.748452Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 0, \"tags\": {\"endpoint\": \"Class\"}}\n2026-03-13T14:00:23.748941Z [info ] tap-quickbooks INFO Class: Completed sync (0 rows)\n2026-03-13T14:00:23.749334Z [info ] tap-quickbooks INFO CustomerType: Starting \n2026-03-13T14:00:23.751734Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream CustomerType\n2026-03-13T14:00:23.752268Z [info ] tap-quickbooks INFO Making GET request to https://sandbox-quickbooks.api.intuit.com/v3/company/9341456531142773/query with params: {'query': 'SELECT * FROM CustomerType STARTPOSITION 0 MAXRESULTS 100', 'minorversion': '75'}\n2026-03-13T14:00:23.764910Z [info ] target-postgres Hard delete: False \n2026-03-13T14:00:23.913703Z [info ] target-postgres Hard delete: False \n2026-03-13T14:00:23.998822Z [info ] target-postgres Hard delete: False \n2026-03-13T14:00:24.098112Z [info ] tap-quickbooks INFO Response with no data {'QueryResponse': {}, 'time': '2026-03-13T07:00:23.920-07:00'}\n2026-03-13T14:00:24.098877Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 0, \"tags\": {\"endpoint\": \"CustomerType\"}}\n2026-03-13T14:00:24.099391Z [info ] tap-quickbooks INFO CustomerType: Completed sync (0 rows)\n2026-03-13T14:00:24.099745Z [info ] tap-quickbooks INFO PaymentMethod: Starting \n2026-03-13T14:00:24.102681Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream PaymentMethod\n2026-03-13T14:00:24.103298Z [info ] tap-quickbooks INFO Making GET request to https://sandbox-quickbooks.api.intuit.com/v3/company/9341456531142773/query with params: {'query': 'SELECT * FROM PaymentMethod STARTPOSITION 0 MAXRESULTS 100', 'minorversion': '75'}\n2026-03-13T14:00:24.136171Z [info ] target-postgres Hard delete: False \n2026-03-13T14:00:24.217418Z [info ] target-postgres Hard delete: False \n2026-03-13T14:00:24.380943Z [info ] target-postgres Hard delete: False \n2026-03-13T14:00:25.048348Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 7, \"tags\": {\"endpoint\": \"PaymentMethod\"}}\n2026-03-13T14:00:25.049008Z [info ] tap-quickbooks INFO PaymentMethod: Completed sync (7 rows)\n2026-03-13T14:00:25.049440Z [info ] tap-quickbooks INFO Payment: Starting \n2026-03-13T14:00:25.050390Z [info ] target-postgres An activate version message for 'PaymentMethod' was received. Draining...\n2026-03-13T14:00:25.052499Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Payment\n2026-03-13T14:00:25.052979Z [info ] tap-quickbooks INFO Making GET request to https://sandbox-quickbooks.api.intuit.com/v3/company/9341456531142773/query with params: {'query': 'SELECT * FROM Payment STARTPOSITION 0 MAXRESULTS 100', 'minorversion': '75'}\n2026-03-13T14:00:25.151541Z [info ] target-postgres Inserting with SQL: INSERT INTO \"5768dd57_5cab_49b5_a1eb_5de62f2cc7e4\" (\"Name\", \"SyncToken\", \"Type\", \"Active\", \"Id\", \"MetaData\", _sdc_extracted_at, _sdc_received_at, _sdc_batched_at, _sdc_deleted_at, _sdc_sequence, _sdc_table_version, _sdc_sync_started_at) VALUES (:Name, :SyncToken, :Type, :Active, :Id, :MetaData, :_sdc_extracted_at, :_sdc_received_at, :_sdc_batched_at, :_sdc_deleted_at, :_sdc_sequence, :_sdc_table_version, :_sdc_sync_started_at)\n2026-03-13T14:00:25.244419Z [info ] target-postgres Hard delete: False \n2026-03-13T14:00:25.409377Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 16, \"tags\": {\"endpoint\": \"Payment\"}}\n2026-03-13T14:00:25.410139Z [info ] tap-quickbooks INFO Payment: Completed sync (16 rows)\n2026-03-13T14:00:25.410692Z [info ] tap-quickbooks INFO Transfer: Starting \n2026-03-13T14:00:25.411075Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Transfer\n2026-03-13T14:00:25.411695Z [info ] tap-quickbooks INFO Making GET request to https://sandbox-quickbooks.api.intuit.com/v3/company/9341456531142773/query with params: {'query': 'SELECT * FROM Transfer STARTPOSITION 0 MAXRESULTS 100', 'minorversion': '75'}\n2026-03-13T14:00:25.469508Z [info ] target-postgres Hard delete: False \n2026-03-13T14:00:25.489386Z [info ] target-postgres An activate version message for 'Payment' was received. Draining...\n2026-03-13T14:00:25.559824Z [info ] target-postgres Inserting with SQL: INSERT INTO \"390d1e8f_bd58_4775_b83e_bc5b83c38fa0\" (\"Id\", \"TotalAmt\", \"CustomerRef\", \"SyncToken\", \"CurrencyRef\", \"PrivateNote\", \"PaymentMethodRef\", \"UnappliedAmt\", \"DepositToAccountRef\", \"ExchangeRate\", \"Line\", \"TxnSource\", \"ARAccountRef\", \"TxnDate\", \"CreditCardPayment\", \"MetaData\", \"TaxExemptionRef\", \"PaymentRefNum\", _sdc_extracted_at, _sdc_received_at, _sdc_batched_at, _sdc_deleted_at, _sdc_sequence, _sdc_table_version, _sdc_sync_started_at) VALUES (:Id, :TotalAmt, :CustomerRef, :SyncToken, :CurrencyRef, :PrivateNote, :PaymentMethodRef, :UnappliedAmt, :DepositToAccountRef, :ExchangeRate, :Line, :TxnSource, :ARAccountRef, :TxnDate, :CreditCardPayment, :MetaData, :TaxExemptionRef, :PaymentRefNum, :_sdc_extracted_at, :_sdc_received_at, :_sdc_batched_at, :_sdc_deleted_at, :_sdc_sequence, :_sdc_table_version, :_sdc_sync_started_at)\n2026-03-13T14:00:25.657470Z [info ] target-postgres Hard delete: False \n2026-03-13T14:00:25.801707Z [info ] tap-quickbooks INFO Response with no data {'QueryResponse': {}, 'time': '2026-03-13T07:00:25.698-07:00'}\n2026-03-13T14:00:25.802574Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 0, \"tags\": {\"endpoint\": \"Transfer\"}}\n2026-03-13T14:00:25.802961Z [info ] tap-quickbooks INFO Transfer: Completed sync (0 rows)\n2026-03-13T14:00:25.803360Z [info ] tap-quickbooks INFO CompanyInfo: Starting \n2026-03-13T14:00:25.807123Z [info ] target-postgres Hard delete: False \n2026-03-13T14:00:25.807676Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream CompanyInfo\n2026-03-13T14:00:25.808133Z [info ] tap-quickbooks INFO Making GET request to https://sandbox-quickbooks.api.intuit.com/v3/company/9341456531142773/query with params: {'query': 'SELECT * FROM CompanyInfo STARTPOSITION 0 MAXRESULTS 100', 'minorversion': '75'}\n2026-03-13T14:00:25.878848Z [info ] target-postgres Hard delete: False \n2026-03-13T14:00:26.089245Z [info ] target-postgres Hard delete: False \n2026-03-13T14:00:26.202326Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 1, \"tags\": {\"endpoint\": \"CompanyInfo\"}}\n2026-03-13T14:00:26.203101Z [info ] tap-quickbooks INFO CompanyInfo: Completed sync (1 rows)\n2026-03-13T14:00:26.203549Z [info ] tap-quickbooks INFO TaxRate: Starting \n2026-03-13T14:00:26.204200Z [info ] target-postgres An activate version message for 'CompanyInfo' was received. Draining...\n2026-03-13T14:00:26.206664Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream TaxRate\n2026-03-13T14:00:26.207259Z [info ] tap-quickbooks INFO Making GET request to https://sandbox-quickbooks.api.intuit.com/v3/company/9341456531142773/query with params: {'query': 'SELECT * FROM TaxRate STARTPOSITION 0 MAXRESULTS 100', 'minorversion': '75'}\n2026-03-13T14:00:26.402930Z [info ] target-postgres Inserting with SQL: INSERT INTO \"4480007b_7137_43ed_82ea_c9e826a5491a\" (\"Id\", \"SyncToken\", \"CompanyName\", \"CompanyAddr\", \"LegalAddr\", \"SupportedLanguages\", \"Country\", \"Email\", \"WebAddr\", \"NameValue\", \"FiscalYearStartMonth\", \"CustomerCommunicationAddr\", \"PrimaryPhone\", \"LegalName\", \"MetaData\", \"CompanyStartDate\", _sdc_extracted_at, _sdc_received_at, _sdc_batched_at, _sdc_deleted_at, _sdc_sequence, _sdc_table_version, _sdc_sync_started_at) VALUES (:Id, :SyncToken, :CompanyName, :CompanyAddr, :LegalAddr, :SupportedLanguages, :Country, :Email, :WebAddr, :NameValue, :FiscalYearStartMonth, :CustomerCommunicationAddr, :PrimaryPhone, :LegalName, :MetaData, :CompanyStartDate, :_sdc_extracted_at, :_sdc_received_at, :_sdc_batched_at, :_sdc_deleted_at, :_sdc_sequence, :_sdc_table_version, :_sdc_sync_started_at)\n2026-03-13T14:00:26.493897Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 3, \"tags\": {\"endpoint\": \"TaxRate\"}}\n2026-03-13T14:00:26.494587Z [info ] tap-quickbooks INFO TaxRate: Completed sync (3 rows)\n2026-03-13T14:00:26.495048Z [info ] tap-quickbooks INFO TaxCode: Starting \n2026-03-13T14:00:26.497585Z [info ] target-postgres Hard delete: False \n2026-03-13T14:00:26.498175Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream TaxCode\n2026-03-13T14:00:26.498572Z [info ] tap-quickbooks INFO Making GET request to https://sandbox-quickbooks.api.intuit.com/v3/company/9341456531142773/query with params: {'query': 'SELECT * FROM TaxCode STARTPOSITION 0 MAXRESULTS 100', 'minorversion': '75'}\n2026-03-13T14:00:26.651747Z [info ] target-postgres Hard delete: False \n2026-03-13T14:00:26.658956Z [info ] target-postgres An activate version message for 'TaxRate' was received. Draining...\n2026-03-13T14:00:26.736244Z [info ] target-postgres Inserting with SQL: INSERT INTO \"7726baa7_e4e2_464f_b4f4_d2df53705756\" (\"Name\", \"SyncToken\", \"RateValue\", \"AgencyRef\", \"SpecialTaxType\", \"EffectiveTaxRate\", \"DisplayType\", \"TaxReturnLineRef\", \"Active\", \"OriginalTaxRate\", \"Description\", \"Id\", \"MetaData\", _sdc_extracted_at, _sdc_received_at, _sdc_batched_at, _sdc_deleted_at, _sdc_sequence, _sdc_table_version, _sdc_sync_started_at) VALUES (:Name, :SyncToken, :RateValue, :AgencyRef, :SpecialTaxType, :EffectiveTaxRate, :DisplayType, :TaxReturnLineRef, :Active, :OriginalTaxRate, :Description, :Id, :MetaData, :_sdc_extracted_at, :_sdc_received_at, :_sdc_batched_at, :_sdc_deleted_at, :_sdc_sequence, :_sdc_table_version, :_sdc_sync_started_at)\n2026-03-13T14:00:26.766756Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 5, \"tags\": {\"endpoint\": \"TaxCode\"}}\n2026-03-13T14:00:26.767472Z [info ] tap-quickbooks INFO TaxCode: Completed sync (5 rows)\n2026-03-13T14:00:26.767861Z [info ] tap-quickbooks INFO Term: Starting \n2026-03-13T14:00:26.770327Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Term\n2026-03-13T14:00:26.770802Z [info ] tap-quickbooks INFO Making GET request to https://sandbox-quickbooks.api.intuit.com/v3/company/9341456531142773/query with params: {'query': 'SELECT * FROM Term STARTPOSITION 0 MAXRESULTS 100', 'minorversion': '75'}\n2026-03-13T14:00:26.831138Z [info ] target-postgres Hard delete: False \n2026-03-13T14:00:27.039993Z [info ] target-postgres Hard delete: False \n2026-03-13T14:00:27.065876Z [info ] target-postgres An activate version message for 'TaxCode' was received. Draining...\n2026-03-13T14:00:27.166416Z [info ] target-postgres Inserting with SQL: INSERT INTO \"0743c196_fe55_4cd4_ba21_83d47e308d4a\" (\"Id\", \"Name\", \"PurchaseTaxRateList\", \"SalesTaxRateList\", \"TaxGroup\", \"Taxable\", \"Active\", \"Description\", \"Hidden\", \"MetaData\", \"TaxCodeConfigType\", _sdc_extracted_at, _sdc_received_at, _sdc_batched_at, _sdc_deleted_at, _sdc_sequence, _sdc_table_version, _sdc_sync_started_at) VALUES (:Id, :Name, :PurchaseTaxRateList, :SalesTaxRateList, :TaxGroup, :Taxable, :Active, :Description, :Hidden, :MetaData, :TaxCodeConfigType, :_sdc_extracted_at, :_sdc_received_at, :_sdc_batched_at, :_sdc_deleted_at, :_sdc_sequence, :_sdc_table_version, :_sdc_sync_started_at)\n2026-03-13T14:00:27.183192Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 5, \"tags\": {\"endpoint\": \"Term\"}}\n2026-03-13T14:00:27.183842Z [info ] tap-quickbooks INFO Term: Completed sync (5 rows)\n2026-03-13T14:00:27.184356Z [info ] tap-quickbooks INFO Department: Starting \n2026-03-13T14:00:27.187070Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Department\n2026-03-13T14:00:27.187590Z [info ] tap-quickbooks INFO Making GET request to https://sandbox-quickbooks.api.intuit.com/v3/company/9341456531142773/query with params: {'query': 'SELECT * FROM Department STARTPOSITION 0 MAXRESULTS 100', 'minorversion': '75'}\n2026-03-13T14:00:27.546535Z [info ] target-postgres Hard delete: False \n2026-03-13T14:00:27.585998Z [info ] tap-quickbooks INFO Response with no data {'QueryResponse': {}, 'time': '2026-03-13T07:00:27.424-07:00'}\n2026-03-13T14:00:27.587289Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 0, \"tags\": {\"endpoint\": \"Department\"}}\n2026-03-13T14:00:27.587508Z [info ] tap-quickbooks INFO Department: Completed sync (0 rows)\n2026-03-13T14:00:27.587621Z [info ] tap-quickbooks INFO CreditMemo: Starting \n2026-03-13T14:00:27.591824Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream CreditMemo\n2026-03-13T14:00:27.592065Z [info ] tap-quickbooks INFO Making GET request to https://sandbox-quickbooks.api.intuit.com/v3/company/9341456531142773/query with params: {'query': 'SELECT * FROM CreditMemo STARTPOSITION 0 MAXRESULTS 100', 'minorversion': '75'}\n2026-03-13T14:00:27.812521Z [info ] target-postgres Hard delete: False \n2026-03-13T14:00:27.820942Z [info ] target-postgres An activate version message for 'Term' was received. Draining...\n2026-03-13T14:00:27.925324Z [info ] target-postgres Inserting with SQL: INSERT INTO dba4200e_e6c3_426f_b73e_5ac77a5f708e (\"Id\", \"Name\", \"SyncToken\", \"DiscountPercent\", \"DiscountDays\", \"Active\", \"Type\", \"MetaData\", \"DayOfMonthDue\", \"DiscountDayOfMonth\", \"DueNextMonthDays\", \"DueDays\", _sdc_extracted_at, _sdc_received_at, _sdc_batched_at, _sdc_deleted_at, _sdc_sequence, _sdc_table_version, _sdc_sync_started_at) VALUES (:Id, :Name, :SyncToken, :DiscountPercent, :DiscountDays, :Active, :Type, :MetaData, :DayOfMonthDue, :DiscountDayOfMonth, :DueNextMonthDays, :DueDays, :_sdc_extracted_at, :_sdc_received_at, :_sdc_batched_at, :_sdc_deleted_at, :_sdc_sequence, :_sdc_table_version, :_sdc_sync_started_at)\n2026-03-13T14:00:27.968076Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 1, \"tags\": {\"endpoint\": \"CreditMemo\"}}\n2026-03-13T14:00:27.968736Z [info ] tap-quickbooks INFO CreditMemo: Completed sync (1 rows)\n2026-03-13T14:00:27.969146Z [info ] tap-quickbooks INFO Customer: Starting \n2026-03-13T14:00:27.971756Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Customer\n2026-03-13T14:00:27.972308Z [info ] tap-quickbooks INFO Making GET request to https://sandbox-quickbooks.api.intuit.com/v3/company/9341456531142773/query with params: {'query': 'SELECT * FROM Customer STARTPOSITION 0 MAXRESULTS 100', 'minorversion': '75'}\n2026-03-13T14:00:28.044725Z [info ] target-postgres Hard delete: False \n2026-03-13T14:00:28.245570Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 29, \"tags\": {\"endpoint\": \"Customer\"}}\n2026-03-13T14:00:28.246098Z [info ] tap-quickbooks INFO Customer: Completed sync (29 rows)\n2026-03-13T14:00:28.246381Z [info ] tap-quickbooks INFO Employee: Starting \n2026-03-13T14:00:28.246929Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Employee\n2026-03-13T14:00:28.247273Z [info ] tap-quickbooks INFO Making GET request to https://sandbox-quickbooks.api.intuit.com/v3/company/9341456531142773/query with params: {'query': 'SELECT * FROM Employee STARTPOSITION 0 MAXRESULTS 100', 'minorversion': '75'}\n2026-03-13T14:00:28.311994Z [info ] target-postgres Hard delete: False \n2026-03-13T14:00:28.393001Z [info ] target-postgres Hard delete: False \n2026-03-13T14:00:28.565411Z [info ] target-postgres Hard delete: False \n2026-03-13T14:00:28.573263Z [info ] target-postgres An activate version message for 'CreditMemo' was received. Draining...\n2026-03-13T14:00:28.700358Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 2, \"tags\": {\"endpoint\": \"Employee\"}}\n2026-03-13T14:00:28.701054Z [info ] tap-quickbooks INFO Employee: Completed sync (2 rows)\n2026-03-13T14:00:28.701474Z [info ] tap-quickbooks INFO Invoice: Starting \n2026-03-13T14:00:28.705471Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Invoice\n2026-03-13T14:00:28.706055Z [info ] tap-quickbooks INFO Making GET request to https://sandbox-quickbooks.api.intuit.com/v3/company/9341456531142773/query with params: {'query': 'SELECT * FROM Invoice STARTPOSITION 0 MAXRESULTS 100', 'minorversion': '75'}\n2026-03-13T14:00:28.706529Z [info ] target-postgres Inserting with SQL: INSERT INTO \"24183cbc_5b64_4927_b68c_e55de5774fab\" (\"RemainingCredit\", \"Id\", \"MetaData\", \"CustomField\", \"DocNumber\", \"TxnDate\", \"CurrencyRef\", \"CustomerRef\", \"ClassRef\", \"Line\", \"CustomerMemo\", \"TotalAmt\", \"Balance\", _sdc_extracted_at, _sdc_received_at, _sdc_batched_at, _sdc_deleted_at, _sdc_sequence, _sdc_table_version, _sdc_sync_started_at) VALUES (:RemainingCredit, :Id, :MetaData, :CustomField, :DocNumber, :TxnDate, :CurrencyRef, :CustomerRef, :ClassRef, :Line, :CustomerMemo, :TotalAmt, :Balance, :_sdc_extracted_at, :_sdc_received_at, :_sdc_batched_at, :_sdc_deleted_at, :_sdc_sequence, :_sdc_table_version, :_sdc_sync_started_at)\n2026-03-13T14:00:28.797911Z [info ] target-postgres Hard delete: False \n2026-03-13T14:00:29.000951Z [info ] target-postgres Hard delete: False \n╭─────────────────────────────── Error details ────────────────────────────────╮\n│ │\n│ /meltano/.meltano/loaders/target-postgres/venv/lib/python3.12/site-packages/ │\n│ psycopg/cursor.py:117 in execute │\n│ │\n│ 117 │ │ │ raise ex.with_traceback(None) │\n│ │\n│ /meltano/.meltano/loaders/target-postgres/venv/lib/python3.12/site-packages/ │\n│ sqlalchemy/engine/default.py:952 in do_execute │\n│ │\n│ 952 │ │ cursor.execute(statement, parameters) │\n│ │\n│ /meltano/.meltano/loaders/target-postgres/venv/lib/python3.12/site-packages/ │\n│ sqlalchemy/engine/base.py:1967 in _exec_single_context │\n│ │\n│ 1967 │ │ │ │ │ self.dialect.do_execute( │\n│ │\n│ ... 18 frames hidden ... │\n╰──────────────────────────────────────────────────────────────────────────────╯\nProgrammingError: (psycopg.errors.UndefinedTable) relation \n\"public.RawChangeEvents\" does not exist\nLINE 1: INSERT INTO public.\"RawChangeEvents\"\n ^\nQUERY: INSERT INTO public.\"RawChangeEvents\"\n (\n \"TenantId\",\n \"EntityType\",\n \"EntityKey\",\n \"QboEntityId\",\n \"SchemaName\",\n \"TableName\",\n \"Operation\",\n \"SourcePayloadJson\",\n \"Status\",\n \"AttemptCount\",\n \"CreatedAtUtc\",\n \"UpdatedAtUtc\"\n )\n VALUES\n (\n tenant_id,\n entity_type,\n entity_key,\n entity_id,\n TG_TABLE_SCHEMA,\n TG_TABLE_NAME,\n TG_OP,\n source_row::text,\n 0,\n 0,\n timezone('utc', now()),\n timezone('utc', now())\n )\nCONTEXT: PL/pgSQL function capture_qbo_raw_change() line 30 at SQL statement\n[SQL: UPDATE tenant_9341456531142773_raw.\"Customer\" SET \n_sdc_deleted_at=%(deletedate)s::TIMESTAMP WITHOUT TIME ZONE WHERE \n(tenant_9341456531142773_raw.\"Customer\"._sdc_table_version < %(version)s::BIGINT\nOR tenant_9341456531142773_raw.\"Customer\"._sdc_table_version IS NULL) AND \ntenant_9341456531142773_raw.\"Customer\"._sdc_deleted_at IS NULL]\n[parameters: {'deletedate': datetime.datetime(2026, 3, 13, 14, 0, 28, 916188, \ntzinfo=datetime.timezone.utc), 'version': 1773410427968}]\n(Background on this error at: https://sqlalche.me/e/20/f405)\n\nThe above exception was the direct cause of the following exception:\n\n╭─────────────────────────────── Error details ────────────────────────────────╮\n│ │\n│ /meltano/.meltano/loaders/target-postgres/venv/lib/python3.12/site-packages/ │\n│ psycopg/cursor.py:117 in execute │\n│ │\n│ 117 │ │ │ raise ex.with_traceback(None) │\n│ │\n│ /meltano/.meltano/loaders/target-postgres/venv/lib/python3.12/site-packages/ │\n│ sqlalchemy/engine/default.py:952 in do_execute │\n│ │\n│ 952 │ │ cursor.execute(statement, parameters) │\n│ │\n│ /meltano/.meltano/loaders/target-postgres/venv/lib/python3.12/site-packages/ │\n│ sqlalchemy/engine/base.py:1967 in _exec_single_context │\n│ │\n│ 1967 │ │ │ │ │ self.dialect.do_execute( │\n│ │\n╰──────────────────────────────────────────────────────────────────────────────╯\nUndefinedTable: relation \"public.RawChangeEvents\" does not exist\nLINE 1: INSERT INTO public.\"RawChangeEvents\"\n ^\nQUERY: INSERT INTO public.\"RawChangeEvents\"\n (\n \"TenantId\",\n \"EntityType\",\n \"EntityKey\",\n \"QboEntityId\",\n \"SchemaName\",\n \"TableName\",\n \"Operation\",\n \"SourcePayloadJson\",\n \"Status\",\n \"AttemptCount\",\n \"CreatedAtUtc\",\n \"UpdatedAtUtc\"\n )\n VALUES\n (\n tenant_id,\n entity_type,\n entity_key,\n entity_id,\n TG_TABLE_SCHEMA,\n TG_TABLE_NAME,\n TG_OP,\n source_row::text,\n 0,\n 0,\n timezone('utc', now()),\n timezone('utc', now())\n )\nCONTEXT: PL/pgSQL function capture_qbo_raw_change() line 30 at SQL statement\n\n2026-03-13T14:00:29.015149Z [error ] target-postgres (psycopg.errors.UndefinedTable) relation \"public.RawChangeEvents\" does not exist\nLINE 1: INSERT INTO public.\"RawChangeEvents\"\n ^\nQUERY: INSERT INTO public.\"RawChangeEvents\"\r\n (\r\n \"TenantId\",\r\n \"EntityType\",\r\n \"EntityKey\",\r\n \"QboEntityId\",\r\n \"SchemaName\",\r\n \"TableName\",\r\n \"Operation\",\r\n \"SourcePayloadJson\",\r\n \"Status\",\r\n \"AttemptCount\",\r\n \"CreatedAtUtc\",\r\n \"UpdatedAtUtc\"\r\n )\r\n VALUES\r\n (\r\n tenant_id,\r\n entity_type,\r\n entity_key,\r\n entity_id,\r\n TG_TABLE_SCHEMA,\r\n TG_TABLE_NAME,\r\n TG_OP,\r\n source_row::text,\r\n 0,\r\n 0,\r\n timezone('utc', now()),\r\n timezone('utc', now())\r\n )\nCONTEXT: PL/pgSQL function capture_qbo_raw_change() line 30 at SQL statement plugin_exc_message='(psycopg.errors.UndefinedTable) relation \"public.RawChangeEvents\" does not exist\\nLINE 1: INSERT INTO public.\"RawChangeEvents\"\\n ^\\nQUERY: INSERT INTO public.\"RawChangeEvents\"\\r\\n (\\r\\n \"TenantId\",\\r\\n \"EntityType\",\\r\\n \"EntityKey\",\\r\\n \"QboEntityId\",\\r\\n \"SchemaName\",\\r\\n \"TableName\",\\r\\n \"Operation\",\\r\\n \"SourcePayloadJson\",\\r\\n \"Status\",\\r\\n \"AttemptCount\",\\r\\n \"CreatedAtUtc\",\\r\\n \"UpdatedAtUtc\"\\r\\n )\\r\\n VALUES\\r\\n (\\r\\n tenant_id,\\r\\n entity_type,\\r\\n entity_key,\\r\\n entity_id,\\r\\n TG_TABLE_SCHEMA,\\r\\n TG_TABLE_NAME,\\r\\n TG_OP,\\r\\n source_row::text,\\r\\n 0,\\r\\n 0,\\r\\n timezone(\\'utc\\', now()),\\r\\n timezone(\\'utc\\', now())\\r\\n )\\nCONTEXT: PL/pgSQL function capture_qbo_raw_change() line 30 at SQL statement\\n[SQL: UPDATE tenant_9341456531142773_raw.\"Customer\" SET _sdc_deleted_at=%(deletedate)s::TIMESTAMP WITHOUT TIME ZONE WHERE (tenant_9341456531142773_raw.\"Customer\"._sdc_table_version < %(version)s::BIGINT OR tenant_9341456531142773_raw.\"Customer\"._sdc_table_version IS NULL) AND tenant_9341456531142773_raw.\"Customer\"._sdc_deleted_at IS NULL]\\n[parameters: {\\'deletedate\\': datetime.datetime(2026, 3, 13, 14, 0, 28, 916188, tzinfo=datetime.timezone.utc), \\'version\\': 1773410427968}]\\n(Background on this error at: https://sqlalche.me/e/20/f405)' plugin_exc_type=ProgrammingError\n2026-03-13T14:00:29.211110Z [error ] meltano Loader failed \n2026-03-13T14:00:29.211958Z [error ] meltano Block run completed \n2026-03-13T14:00:29.217478Z [info ] meltano Run completed \n"}

+32ms Processing

Server:
cfd059752a2d:1
Worker:
091b31ca

+5ms Enqueued

03/13/2026 14:00:11 Created