TenantSyncCoordinator.RunTenantSyncAsync

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

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

Parameters

CurrentCulture
""
CurrentUICulture
""

State

03/13/2026 08:00:24 (+20.929s) Succeeded

Latency:
22ms
Duration:
20.907s
Result:
{"$type":"RmsQboIntegration.Web.Infrastructure.Dtos.MeltanoRunResult, web","ExitCode":1,"StdOut":"","StdErr":"2026-03-13T08:00:04.337978Z [info ] meltano Environment 'tenant' is active\n2026-03-13T08:00:04.620071Z [info ] meltano Running job with name 'tenant:tap-quickbooks-to-target-postgres:tenant-1' and run ID '019ce635-b196-7748-83d7-be74797fddba'\n2026-03-13T08:00:04.709084Z [info ] meltano Using systemdb state backend \n2026-03-13T08:00:04.710413Z [warning ] meltano No state was found, complete import.\n2026-03-13T08:00:04.993728Z [info ] tap-quickbooks INFO Instance URL :- https://sandbox-quickbooks.api.intuit.com/v3/company/9341456531142773\n2026-03-13T08:00:04.994787Z [info ] tap-quickbooks INFO Attempting login via OAuth2\n2026-03-13T08:00:04.995257Z [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-13T08:00:05.550464Z [info ] target-postgres target-postgres v0.6.3, Meltano SDK v0.53.5\n2026-03-13T08:00:05.551014Z [info ] target-postgres Skipping parse of env var settings...\n2026-03-13T08:00:09.543998Z [info ] tap-quickbooks INFO OAuth2 login successful \n2026-03-13T08:00:09.545205Z [info ] tap-quickbooks INFO REFRESH TOKEN: RT1-159-H0-1782095738zhk7s6lbkxsg4sacz4qp\n2026-03-13T08:00:09.546056Z [info ] tap-quickbooks INFO Starting new login timer \n2026-03-13T08:00:09.547440Z [info ] tap-quickbooks INFO Starting sync \n2026-03-13T08:00:09.547991Z [info ] tap-quickbooks INFO Account: Starting \n2026-03-13T08:00:09.551005Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Account\n2026-03-13T08:00:09.551489Z [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-13T08:00:09.891324Z [info ] target-postgres Hard delete: False \n2026-03-13T08:00:14.449334Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 89, \"tags\": {\"endpoint\": \"Account\"}}\n2026-03-13T08:00:14.450090Z [info ] tap-quickbooks INFO Account: Completed sync (89 rows)\n2026-03-13T08:00:14.450562Z [info ] tap-quickbooks INFO Bill: Starting \n2026-03-13T08:00:14.451067Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Bill\n2026-03-13T08:00:14.451417Z [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-13T08:00:14.462343Z [info ] target-postgres An activate version message for 'Account' was received. Draining...\n2026-03-13T08:00:14.548462Z [info ] target-postgres Inserting with SQL: INSERT INTO dc5c8393_27a7_40e7_880f_7f8a03cf5f40 (\"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-13T08:00:14.653087Z [info ] target-postgres Hard delete: False \n2026-03-13T08:00:14.814715Z [info ] target-postgres Hard delete: False \n2026-03-13T08:00:15.207976Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 15, \"tags\": {\"endpoint\": \"Bill\"}}\n2026-03-13T08:00:15.208632Z [info ] tap-quickbooks INFO Bill: Completed sync (15 rows)\n2026-03-13T08:00:15.209005Z [info ] tap-quickbooks INFO Class: Starting \n2026-03-13T08:00:15.209560Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Class\n2026-03-13T08:00:15.209991Z [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-13T08:00:15.213328Z [info ] target-postgres An activate version message for 'Bill' was received. Draining...\n2026-03-13T08:00:15.300937Z [info ] target-postgres Inserting with SQL: INSERT INTO c82c154b_4e8e_4813_ab66_f4a5264202a1 (\"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-13T08:00:15.399142Z [info ] target-postgres Hard delete: False \n2026-03-13T08:00:15.499812Z [info ] tap-quickbooks INFO Response with no data {'QueryResponse': {}, 'time': '2026-03-13T01:00:15.358-07:00'}\n2026-03-13T08:00:15.500569Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 0, \"tags\": {\"endpoint\": \"Class\"}}\n2026-03-13T08:00:15.500944Z [info ] tap-quickbooks INFO Class: Completed sync (0 rows)\n2026-03-13T08:00:15.501301Z [info ] tap-quickbooks INFO CustomerType: Starting \n2026-03-13T08:00:15.503261Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream CustomerType\n2026-03-13T08:00:15.503699Z [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-13T08:00:15.563676Z [info ] target-postgres Hard delete: False \n2026-03-13T08:00:15.633821Z [info ] target-postgres Hard delete: False \n2026-03-13T08:00:15.791280Z [info ] target-postgres Hard delete: False \n2026-03-13T08:00:15.846291Z [info ] tap-quickbooks INFO Response with no data {'QueryResponse': {}, 'time': '2026-03-13T01:00:15.682-07:00'}\n2026-03-13T08:00:15.847231Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 0, \"tags\": {\"endpoint\": \"CustomerType\"}}\n2026-03-13T08:00:15.847768Z [info ] tap-quickbooks INFO CustomerType: Completed sync (0 rows)\n2026-03-13T08:00:15.848160Z [info ] tap-quickbooks INFO PaymentMethod: Starting \n2026-03-13T08:00:15.850220Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream PaymentMethod\n2026-03-13T08:00:15.850712Z [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-13T08:00:15.923331Z [info ] target-postgres Hard delete: False \n2026-03-13T08:00:16.087567Z [info ] target-postgres Hard delete: False \n2026-03-13T08:00:16.687987Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 7, \"tags\": {\"endpoint\": \"PaymentMethod\"}}\n2026-03-13T08:00:16.688653Z [info ] tap-quickbooks INFO PaymentMethod: Completed sync (7 rows)\n2026-03-13T08:00:16.689050Z [info ] tap-quickbooks INFO Payment: Starting \n2026-03-13T08:00:16.689986Z [info ] target-postgres An activate version message for 'PaymentMethod' was received. Draining...\n2026-03-13T08:00:16.691492Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Payment\n2026-03-13T08:00:16.691969Z [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-13T08:00:16.782926Z [info ] target-postgres Inserting with SQL: INSERT INTO \"84aaa6bc_4d49_4361_b8d3_e5fbcabd1238\" (\"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-13T08:00:16.876904Z [info ] target-postgres Hard delete: False \n2026-03-13T08:00:16.985475Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 16, \"tags\": {\"endpoint\": \"Payment\"}}\n2026-03-13T08:00:16.986529Z [info ] tap-quickbooks INFO Payment: Completed sync (16 rows)\n2026-03-13T08:00:16.986928Z [info ] tap-quickbooks INFO Transfer: Starting \n2026-03-13T08:00:16.987474Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Transfer\n2026-03-13T08:00:16.987813Z [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-13T08:00:17.066182Z [info ] target-postgres Hard delete: False \n2026-03-13T08:00:17.085365Z [info ] target-postgres An activate version message for 'Payment' was received. Draining...\n2026-03-13T08:00:17.170406Z [info ] target-postgres Inserting with SQL: INSERT INTO a796356c_37de_4005_b4f7_5f1a6ddb2765 (\"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-13T08:00:17.262327Z [info ] target-postgres Hard delete: False \n2026-03-13T08:00:17.419304Z [info ] target-postgres Hard delete: False \n2026-03-13T08:00:17.426582Z [info ] tap-quickbooks INFO Response with no data {'QueryResponse': {}, 'time': '2026-03-13T01:00:17.321-07:00'}\n2026-03-13T08:00:17.427325Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 0, \"tags\": {\"endpoint\": \"Transfer\"}}\n2026-03-13T08:00:17.427711Z [info ] tap-quickbooks INFO Transfer: Completed sync (0 rows)\n2026-03-13T08:00:17.428207Z [info ] tap-quickbooks INFO CompanyInfo: Starting \n2026-03-13T08:00:17.431158Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream CompanyInfo\n2026-03-13T08:00:17.431625Z [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-13T08:00:17.503972Z [info ] target-postgres Hard delete: False \n2026-03-13T08:00:17.691456Z [info ] target-postgres Hard delete: False \n2026-03-13T08:00:17.743068Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 1, \"tags\": {\"endpoint\": \"CompanyInfo\"}}\n2026-03-13T08:00:17.743755Z [info ] tap-quickbooks INFO CompanyInfo: Completed sync (1 rows)\n2026-03-13T08:00:17.744184Z [info ] tap-quickbooks INFO TaxRate: Starting \n2026-03-13T08:00:17.744843Z [info ] target-postgres An activate version message for 'CompanyInfo' was received. Draining...\n2026-03-13T08:00:17.745749Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream TaxRate\n2026-03-13T08:00:17.746253Z [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-13T08:00:17.863915Z [info ] target-postgres Inserting with SQL: INSERT INTO eb438e17_e467_409a_a038_c7a240f05d5f (\"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-13T08:00:17.958499Z [info ] target-postgres Hard delete: False \n2026-03-13T08:00:17.977274Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 3, \"tags\": {\"endpoint\": \"TaxRate\"}}\n2026-03-13T08:00:17.977890Z [info ] tap-quickbooks INFO TaxRate: Completed sync (3 rows)\n2026-03-13T08:00:17.978291Z [info ] tap-quickbooks INFO TaxCode: Starting \n2026-03-13T08:00:17.981078Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream TaxCode\n2026-03-13T08:00:17.981524Z [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-13T08:00:18.122668Z [info ] target-postgres Hard delete: False \n2026-03-13T08:00:18.129683Z [info ] target-postgres An activate version message for 'TaxRate' was received. Draining...\n2026-03-13T08:00:18.205124Z [info ] target-postgres Inserting with SQL: INSERT INTO \"52df96dc_0f91_4be0_802e_f9689981de98\" (\"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-13T08:00:18.241089Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 5, \"tags\": {\"endpoint\": \"TaxCode\"}}\n2026-03-13T08:00:18.241757Z [info ] tap-quickbooks INFO TaxCode: Completed sync (5 rows)\n2026-03-13T08:00:18.242174Z [info ] tap-quickbooks INFO Term: Starting \n2026-03-13T08:00:18.245157Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Term\n2026-03-13T08:00:18.245703Z [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-13T08:00:18.301833Z [info ] target-postgres Hard delete: False \n2026-03-13T08:00:18.531469Z [info ] target-postgres Hard delete: False \n2026-03-13T08:00:18.544541Z [info ] target-postgres An activate version message for 'TaxCode' was received. Draining...\n2026-03-13T08:00:18.622120Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 5, \"tags\": {\"endpoint\": \"Term\"}}\n2026-03-13T08:00:18.622884Z [info ] tap-quickbooks INFO Term: Completed sync (5 rows)\n2026-03-13T08:00:18.623396Z [info ] tap-quickbooks INFO Department: Starting \n2026-03-13T08:00:18.624427Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Department\n2026-03-13T08:00:18.624957Z [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-13T08:00:18.634439Z [info ] target-postgres Inserting with SQL: INSERT INTO \"2345eb7b_2e23_47ba_b312_80b0bb5923ec\" (\"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-13T08:00:18.719950Z [info ] target-postgres Hard delete: False \n2026-03-13T08:00:18.879928Z [info ] target-postgres Hard delete: False \n2026-03-13T08:00:18.892107Z [info ] target-postgres An activate version message for 'Term' was received. Draining...\n2026-03-13T08:00:18.990470Z [info ] tap-quickbooks INFO Response with no data {'QueryResponse': {}, 'time': '2026-03-13T01:00:18.851-07:00'}\n2026-03-13T08:00:18.991297Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 0, \"tags\": {\"endpoint\": \"Department\"}}\n2026-03-13T08:00:18.991795Z [info ] tap-quickbooks INFO Department: Completed sync (0 rows)\n2026-03-13T08:00:18.992181Z [info ] tap-quickbooks INFO CreditMemo: Starting \n2026-03-13T08:00:18.996481Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream CreditMemo\n2026-03-13T08:00:18.997073Z [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-13T08:00:19.001406Z [info ] target-postgres Inserting with SQL: INSERT INTO \"297853db_a1e6_481c_b8c0_eb55391f6bef\" (\"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-13T08:00:19.112862Z [info ] target-postgres Hard delete: False \n2026-03-13T08:00:19.293273Z [info ] target-postgres Hard delete: False \n2026-03-13T08:00:19.299462Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 1, \"tags\": {\"endpoint\": \"CreditMemo\"}}\n2026-03-13T08:00:19.299886Z [info ] tap-quickbooks INFO CreditMemo: Completed sync (1 rows)\n2026-03-13T08:00:19.300178Z [info ] tap-quickbooks INFO Customer: Starting \n2026-03-13T08:00:19.303514Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Customer\n2026-03-13T08:00:19.303880Z [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-13T08:00:19.380886Z [info ] target-postgres Hard delete: False \n2026-03-13T08:00:19.572588Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 29, \"tags\": {\"endpoint\": \"Customer\"}}\n2026-03-13T08:00:19.573389Z [info ] tap-quickbooks INFO Customer: Completed sync (29 rows)\n2026-03-13T08:00:19.574151Z [info ] tap-quickbooks INFO Employee: Starting \n2026-03-13T08:00:19.574686Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Employee\n2026-03-13T08:00:19.575314Z [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-13T08:00:19.601951Z [info ] target-postgres Hard delete: False \n2026-03-13T08:00:19.609424Z [info ] target-postgres An activate version message for 'CreditMemo' was received. Draining...\n2026-03-13T08:00:19.699355Z [info ] target-postgres Inserting with SQL: INSERT INTO \"342db08f_c774_4808_998b_9aab051937f9\" (\"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-13T08:00:19.797818Z [info ] target-postgres Hard delete: False \n2026-03-13T08:00:19.972674Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 2, \"tags\": {\"endpoint\": \"Employee\"}}\n2026-03-13T08:00:19.973335Z [info ] tap-quickbooks INFO Employee: Completed sync (2 rows)\n2026-03-13T08:00:19.973721Z [info ] tap-quickbooks INFO Invoice: Starting \n2026-03-13T08:00:19.978250Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Invoice\n2026-03-13T08:00:19.978926Z [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-13T08:00:19.991887Z [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, 8, 0, 19, 908848, \ntzinfo=datetime.timezone.utc), 'version': 1773388819299}]\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-13T08:00:20.002986Z [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, 8, 0, 19, 908848, tzinfo=datetime.timezone.utc), \\'version\\': 1773388819299}]\\n(Background on this error at: https://sqlalche.me/e/20/f405)' plugin_exc_type=ProgrammingError\n2026-03-13T08:00:20.209557Z [error ] meltano Loader failed \n2026-03-13T08:00:20.210080Z [error ] meltano Block run completed \n2026-03-13T08:00:20.213264Z [info ] meltano Run completed \n"}

+13ms Processing

Server:
cfd059752a2d:1
Worker:
f104c6ee

+4ms Enqueued

03/13/2026 08:00:03 Created