TenantSyncCoordinator.RunTenantSyncAsync

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

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

Parameters

CurrentCulture
""
CurrentUICulture
""

State

03/13/2026 07:00:30 (+21.620s) Succeeded

Latency:
28ms
Duration:
21.603s
Result:
{"$type":"RmsQboIntegration.Web.Infrastructure.Dtos.MeltanoRunResult, web","ExitCode":1,"StdOut":"","StdErr":"2026-03-13T07:00:10.101383Z [info ] meltano Environment 'tenant' is active\n2026-03-13T07:00:10.391714Z [info ] meltano Running job with name 'tenant:tap-quickbooks-to-target-postgres:tenant-1' and run ID '019ce5fe-d99a-7c00-b323-91299e097860'\n2026-03-13T07:00:10.475767Z [info ] meltano Using systemdb state backend \n2026-03-13T07:00:10.477080Z [warning ] meltano No state was found, complete import.\n2026-03-13T07:00:10.769967Z [info ] tap-quickbooks INFO Instance URL :- https://sandbox-quickbooks.api.intuit.com/v3/company/9341456531142773\n2026-03-13T07:00:10.771061Z [info ] tap-quickbooks INFO Attempting login via OAuth2\n2026-03-13T07:00:10.771371Z [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-13T07:00:11.248168Z [info ] target-postgres target-postgres v0.6.3, Meltano SDK v0.53.5\n2026-03-13T07:00:11.248815Z [info ] target-postgres Skipping parse of env var settings...\n2026-03-13T07:00:15.396248Z [info ] tap-quickbooks INFO OAuth2 login successful \n2026-03-13T07:00:15.396920Z [info ] tap-quickbooks INFO REFRESH TOKEN: RT1-159-H0-1782095738zhk7s6lbkxsg4sacz4qp\n2026-03-13T07:00:15.397873Z [info ] tap-quickbooks INFO Starting new login timer \n2026-03-13T07:00:15.399053Z [info ] tap-quickbooks INFO Starting sync \n2026-03-13T07:00:15.399612Z [info ] tap-quickbooks INFO Account: Starting \n2026-03-13T07:00:15.404214Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Account\n2026-03-13T07:00:15.404474Z [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-13T07:00:15.784142Z [info ] target-postgres Hard delete: False \n2026-03-13T07:00:20.796954Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 89, \"tags\": {\"endpoint\": \"Account\"}}\n2026-03-13T07:00:20.797686Z [info ] tap-quickbooks INFO Account: Completed sync (89 rows)\n2026-03-13T07:00:20.798114Z [info ] tap-quickbooks INFO Bill: Starting \n2026-03-13T07:00:20.798620Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Bill\n2026-03-13T07:00:20.798958Z [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-13T07:00:20.810943Z [info ] target-postgres An activate version message for 'Account' was received. Draining...\n2026-03-13T07:00:20.887822Z [info ] target-postgres Inserting with SQL: INSERT INTO \"8c7b1471_50b7_4b10_9900_d58604680815\" (\"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-13T07:00:20.989360Z [info ] target-postgres Hard delete: False \n2026-03-13T07:00:21.169137Z [info ] target-postgres Hard delete: False \n2026-03-13T07:00:21.545412Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 15, \"tags\": {\"endpoint\": \"Bill\"}}\n2026-03-13T07:00:21.546012Z [info ] tap-quickbooks INFO Bill: Completed sync (15 rows)\n2026-03-13T07:00:21.546520Z [info ] tap-quickbooks INFO Class: Starting \n2026-03-13T07:00:21.547065Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Class\n2026-03-13T07:00:21.547429Z [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-13T07:00:21.551629Z [info ] target-postgres An activate version message for 'Bill' was received. Draining...\n2026-03-13T07:00:21.630088Z [info ] target-postgres Inserting with SQL: INSERT INTO bbe512a0_4855_478c_ab34_df74bf29dea6 (\"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-13T07:00:21.728377Z [info ] target-postgres Hard delete: False \n2026-03-13T07:00:21.774763Z [info ] tap-quickbooks INFO Response with no data {'QueryResponse': {}, 'time': '2026-03-13T00:00:21.650-07:00'}\n2026-03-13T07:00:21.775624Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 0, \"tags\": {\"endpoint\": \"Class\"}}\n2026-03-13T07:00:21.776012Z [info ] tap-quickbooks INFO Class: Completed sync (0 rows)\n2026-03-13T07:00:21.776421Z [info ] tap-quickbooks INFO CustomerType: Starting \n2026-03-13T07:00:21.778200Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream CustomerType\n2026-03-13T07:00:21.778701Z [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-13T07:00:21.899826Z [info ] target-postgres Hard delete: False \n2026-03-13T07:00:21.973415Z [info ] target-postgres Hard delete: False \n2026-03-13T07:00:22.085109Z [info ] tap-quickbooks INFO Response with no data {'QueryResponse': {}, 'time': '2026-03-13T00:00:21.927-07:00'}\n2026-03-13T07:00:22.085927Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 0, \"tags\": {\"endpoint\": \"CustomerType\"}}\n2026-03-13T07:00:22.086688Z [info ] tap-quickbooks INFO CustomerType: Completed sync (0 rows)\n2026-03-13T07:00:22.087349Z [info ] tap-quickbooks INFO PaymentMethod: Starting \n2026-03-13T07:00:22.089565Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream PaymentMethod\n2026-03-13T07:00:22.090098Z [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-13T07:00:22.134944Z [info ] target-postgres Hard delete: False \n2026-03-13T07:00:22.222166Z [info ] target-postgres Hard delete: False \n2026-03-13T07:00:22.402891Z [info ] target-postgres Hard delete: False \n2026-03-13T07:00:22.933528Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 7, \"tags\": {\"endpoint\": \"PaymentMethod\"}}\n2026-03-13T07:00:22.934225Z [info ] tap-quickbooks INFO PaymentMethod: Completed sync (7 rows)\n2026-03-13T07:00:22.934615Z [info ] tap-quickbooks INFO Payment: Starting \n2026-03-13T07:00:22.936197Z [info ] target-postgres An activate version message for 'PaymentMethod' was received. Draining...\n2026-03-13T07:00:22.937925Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Payment\n2026-03-13T07:00:22.938558Z [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-13T07:00:23.025761Z [info ] target-postgres Inserting with SQL: INSERT INTO \"961cacb9_7ac0_40ba_be66_595c28a7ef4b\" (\"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-13T07:00:23.116591Z [info ] target-postgres Hard delete: False \n2026-03-13T07:00:23.228881Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 16, \"tags\": {\"endpoint\": \"Payment\"}}\n2026-03-13T07:00:23.229634Z [info ] tap-quickbooks INFO Payment: Completed sync (16 rows)\n2026-03-13T07:00:23.230055Z [info ] tap-quickbooks INFO Transfer: Starting \n2026-03-13T07:00:23.230560Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Transfer\n2026-03-13T07:00:23.230899Z [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-13T07:00:23.285913Z [info ] target-postgres Hard delete: False \n2026-03-13T07:00:23.307123Z [info ] target-postgres An activate version message for 'Payment' was received. Draining...\n2026-03-13T07:00:23.389987Z [info ] target-postgres Inserting with SQL: INSERT INTO \"4d1f97b4_7404_47ff_84c6_1257ceb1e8d8\" (\"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-13T07:00:23.495735Z [info ] target-postgres Hard delete: False \n2026-03-13T07:00:23.622619Z [info ] tap-quickbooks INFO Response with no data {'QueryResponse': {}, 'time': '2026-03-13T00:00:23.529-07:00'}\n2026-03-13T07:00:23.623525Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 0, \"tags\": {\"endpoint\": \"Transfer\"}}\n2026-03-13T07:00:23.624061Z [info ] tap-quickbooks INFO Transfer: Completed sync (0 rows)\n2026-03-13T07:00:23.624627Z [info ] tap-quickbooks INFO CompanyInfo: Starting \n2026-03-13T07:00:23.625578Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream CompanyInfo\n2026-03-13T07:00:23.626166Z [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-13T07:00:23.660770Z [info ] target-postgres Hard delete: False \n2026-03-13T07:00:23.751338Z [info ] target-postgres Hard delete: False \n2026-03-13T07:00:23.948538Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 1, \"tags\": {\"endpoint\": \"CompanyInfo\"}}\n2026-03-13T07:00:23.949328Z [info ] target-postgres Hard delete: False \n2026-03-13T07:00:23.949901Z [info ] tap-quickbooks INFO CompanyInfo: Completed sync (1 rows)\n2026-03-13T07:00:23.950343Z [info ] tap-quickbooks INFO TaxRate: Starting \n2026-03-13T07:00:23.952318Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream TaxRate\n2026-03-13T07:00:23.952811Z [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-13T07:00:23.956555Z [info ] target-postgres An activate version message for 'CompanyInfo' was received. Draining...\n2026-03-13T07:00:24.047819Z [info ] target-postgres Inserting with SQL: INSERT INTO feb4e5b4_3fc4_4f2a_8214_b021be8b0126 (\"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-13T07:00:24.147371Z [info ] target-postgres Hard delete: False \n2026-03-13T07:00:24.199284Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 3, \"tags\": {\"endpoint\": \"TaxRate\"}}\n2026-03-13T07:00:24.199894Z [info ] tap-quickbooks INFO TaxRate: Completed sync (3 rows)\n2026-03-13T07:00:24.200380Z [info ] tap-quickbooks INFO TaxCode: Starting \n2026-03-13T07:00:24.200872Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream TaxCode\n2026-03-13T07:00:24.201261Z [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-13T07:00:24.313500Z [info ] target-postgres Hard delete: False \n2026-03-13T07:00:24.319450Z [info ] target-postgres An activate version message for 'TaxRate' was received. Draining...\n2026-03-13T07:00:24.397851Z [info ] target-postgres Inserting with SQL: INSERT INTO e0be73e1_83ac_48a0_818a_fc2b0f3f652d (\"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-13T07:00:24.460261Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 5, \"tags\": {\"endpoint\": \"TaxCode\"}}\n2026-03-13T07:00:24.460931Z [info ] tap-quickbooks INFO TaxCode: Completed sync (5 rows)\n2026-03-13T07:00:24.461355Z [info ] tap-quickbooks INFO Term: Starting \n2026-03-13T07:00:24.463880Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Term\n2026-03-13T07:00:24.464432Z [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-13T07:00:24.490749Z [info ] target-postgres Hard delete: False \n2026-03-13T07:00:24.698457Z [info ] target-postgres Hard delete: False \n2026-03-13T07:00:24.706206Z [info ] target-postgres An activate version message for 'TaxCode' was received. Draining...\n2026-03-13T07:00:24.783355Z [info ] target-postgres Inserting with SQL: INSERT INTO \"9b8c8ff4_4aca_4088_b391_a625b8530097\" (\"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-13T07:00:24.838562Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 5, \"tags\": {\"endpoint\": \"Term\"}}\n2026-03-13T07:00:24.839446Z [info ] tap-quickbooks INFO Term: Completed sync (5 rows)\n2026-03-13T07:00:24.840188Z [info ] tap-quickbooks INFO Department: Starting \n2026-03-13T07:00:24.840907Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Department\n2026-03-13T07:00:24.841329Z [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-13T07:00:24.878805Z [info ] target-postgres Hard delete: False \n2026-03-13T07:00:25.099389Z [info ] target-postgres Hard delete: False \n2026-03-13T07:00:25.109340Z [info ] target-postgres An activate version message for 'Term' was received. Draining...\n2026-03-13T07:00:25.197091Z [info ] target-postgres Inserting with SQL: INSERT INTO \"28b6e5f4_f269_4563_966d_314661a47b69\" (\"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-13T07:00:25.241256Z [info ] tap-quickbooks INFO Response with no data {'QueryResponse': {}, 'time': '2026-03-13T00:00:25.110-07:00'}\n2026-03-13T07:00:25.241859Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 0, \"tags\": {\"endpoint\": \"Department\"}}\n2026-03-13T07:00:25.242053Z [info ] tap-quickbooks INFO Department: Completed sync (0 rows)\n2026-03-13T07:00:25.242197Z [info ] tap-quickbooks INFO CreditMemo: Starting \n2026-03-13T07:00:25.246869Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream CreditMemo\n2026-03-13T07:00:25.247099Z [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-13T07:00:25.284191Z [info ] target-postgres Hard delete: False \n2026-03-13T07:00:25.424624Z [info ] target-postgres Hard delete: False \n2026-03-13T07:00:25.504351Z [info ] target-postgres Hard delete: False \n2026-03-13T07:00:25.566973Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 1, \"tags\": {\"endpoint\": \"CreditMemo\"}}\n2026-03-13T07:00:25.567712Z [info ] tap-quickbooks INFO CreditMemo: Completed sync (1 rows)\n2026-03-13T07:00:25.568156Z [info ] tap-quickbooks INFO Customer: Starting \n2026-03-13T07:00:25.571324Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Customer\n2026-03-13T07:00:25.571864Z [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-13T07:00:25.697096Z [info ] target-postgres Hard delete: False \n2026-03-13T07:00:25.705123Z [info ] target-postgres An activate version message for 'CreditMemo' was received. Draining...\n2026-03-13T07:00:25.795835Z [info ] target-postgres Inserting with SQL: INSERT INTO \"6c80c0f6_ac13_46d2_b5aa_6ca09d7f31eb\" (\"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-13T07:00:25.832012Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 29, \"tags\": {\"endpoint\": \"Customer\"}}\n2026-03-13T07:00:25.832708Z [info ] tap-quickbooks INFO Customer: Completed sync (29 rows)\n2026-03-13T07:00:25.833122Z [info ] tap-quickbooks INFO Employee: Starting \n2026-03-13T07:00:25.833660Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Employee\n2026-03-13T07:00:25.834010Z [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-13T07:00:25.891496Z [info ] target-postgres Hard delete: False \n2026-03-13T07:00:26.093899Z [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, 7, 0, 26, 11595, \ntzinfo=datetime.timezone.utc), 'version': 1773385225567}]\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-13T07:00:26.106306Z [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, 7, 0, 26, 11595, tzinfo=datetime.timezone.utc), \\'version\\': 1773385225567}]\\n(Background on this error at: https://sqlalche.me/e/20/f405)' plugin_exc_type=ProgrammingError\n2026-03-13T07:00:26.250499Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 2, \"tags\": {\"endpoint\": \"Employee\"}}\n2026-03-13T07:00:26.251194Z [info ] tap-quickbooks INFO Employee: Completed sync (2 rows)\n2026-03-13T07:00:26.251660Z [info ] tap-quickbooks INFO Invoice: Starting \n2026-03-13T07:00:26.255727Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Invoice\n2026-03-13T07:00:26.256445Z [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-13T07:00:26.304576Z [error ] meltano Loader failed \n2026-03-13T07:00:26.305427Z [error ] meltano Block run completed \n2026-03-13T07:00:26.310800Z [info ] meltano Run completed \n"}

+16ms Processing

Server:
cfd059752a2d:1
Worker:
3d83d50c

+7ms Enqueued

03/13/2026 07:00:09 Created