TenantSyncCoordinator.RunTenantSyncAsync

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

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

Parameters

CurrentCulture
""
CurrentUICulture
""

State

03/13/2026 12:00:28 (+21.081s) Succeeded

Latency:
18ms
Duration:
21.063s
Result:
{"$type":"RmsQboIntegration.Web.Infrastructure.Dtos.MeltanoRunResult, web","ExitCode":1,"StdOut":"","StdErr":"2026-03-13T12:00:08.595044Z [info ] meltano Environment 'tenant' is active\n2026-03-13T12:00:08.917490Z [info ] meltano Running job with name 'tenant:tap-quickbooks-to-target-postgres:tenant-1' and run ID '019ce711-7c5a-7f45-9f70-9da70a60e5f9'\n2026-03-13T12:00:09.002710Z [info ] meltano Using systemdb state backend \n2026-03-13T12:00:09.004146Z [warning ] meltano No state was found, complete import.\n2026-03-13T12:00:09.296313Z [info ] tap-quickbooks INFO Instance URL :- https://sandbox-quickbooks.api.intuit.com/v3/company/9341456531142773\n2026-03-13T12:00:09.297272Z [info ] tap-quickbooks INFO Attempting login via OAuth2\n2026-03-13T12:00:09.297665Z [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-13T12:00:09.822126Z [info ] target-postgres target-postgres v0.6.3, Meltano SDK v0.53.5\n2026-03-13T12:00:09.822790Z [info ] target-postgres Skipping parse of env var settings...\n2026-03-13T12:00:13.928294Z [info ] tap-quickbooks INFO OAuth2 login successful \n2026-03-13T12:00:13.929087Z [info ] tap-quickbooks INFO REFRESH TOKEN: RT1-159-H0-1782095738zhk7s6lbkxsg4sacz4qp\n2026-03-13T12:00:13.930926Z [info ] tap-quickbooks INFO Starting new login timer \n2026-03-13T12:00:13.932479Z [info ] tap-quickbooks INFO Starting sync \n2026-03-13T12:00:13.933173Z [info ] tap-quickbooks INFO Account: Starting \n2026-03-13T12:00:13.936310Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Account\n2026-03-13T12:00:13.936972Z [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-13T12:00:14.346320Z [info ] target-postgres Hard delete: False \n2026-03-13T12:00:18.854425Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 89, \"tags\": {\"endpoint\": \"Account\"}}\n2026-03-13T12:00:18.855242Z [info ] tap-quickbooks INFO Account: Completed sync (89 rows)\n2026-03-13T12:00:18.855595Z [info ] tap-quickbooks INFO Bill: Starting \n2026-03-13T12:00:18.856096Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Bill\n2026-03-13T12:00:18.856417Z [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-13T12:00:18.867701Z [info ] target-postgres An activate version message for 'Account' was received. Draining...\n2026-03-13T12:00:18.953678Z [info ] target-postgres Inserting with SQL: INSERT INTO \"23487027_29d6_47b2_be16_12be4292d1b2\" (\"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-13T12:00:19.045412Z [info ] target-postgres Hard delete: False \n2026-03-13T12:00:19.204197Z [info ] target-postgres Hard delete: False \n2026-03-13T12:00:19.546530Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 15, \"tags\": {\"endpoint\": \"Bill\"}}\n2026-03-13T12:00:19.547456Z [info ] tap-quickbooks INFO Bill: Completed sync (15 rows)\n2026-03-13T12:00:19.548254Z [info ] tap-quickbooks INFO Class: Starting \n2026-03-13T12:00:19.548898Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Class\n2026-03-13T12:00:19.549538Z [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-13T12:00:19.550769Z [info ] target-postgres An activate version message for 'Bill' was received. Draining...\n2026-03-13T12:00:19.625535Z [info ] target-postgres Inserting with SQL: INSERT INTO fd0e51e7_78c9_4e37_bf0b_286ff42211e2 (\"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-13T12:00:19.716200Z [info ] target-postgres Hard delete: False \n2026-03-13T12:00:19.814956Z [info ] tap-quickbooks INFO Response with no data {'QueryResponse': {}, 'time': '2026-03-13T05:00:19.671-07:00'}\n2026-03-13T12:00:19.815721Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 0, \"tags\": {\"endpoint\": \"Class\"}}\n2026-03-13T12:00:19.816138Z [info ] tap-quickbooks INFO Class: Completed sync (0 rows)\n2026-03-13T12:00:19.816471Z [info ] tap-quickbooks INFO CustomerType: Starting \n2026-03-13T12:00:19.818605Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream CustomerType\n2026-03-13T12:00:19.819112Z [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-13T12:00:19.859714Z [info ] target-postgres Hard delete: False \n2026-03-13T12:00:19.935493Z [info ] target-postgres Hard delete: False \n2026-03-13T12:00:20.076657Z [info ] target-postgres Hard delete: False \n2026-03-13T12:00:20.145307Z [info ] tap-quickbooks INFO Response with no data {'QueryResponse': {}, 'time': '2026-03-13T05:00:19.986-07:00'}\n2026-03-13T12:00:20.146273Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 0, \"tags\": {\"endpoint\": \"CustomerType\"}}\n2026-03-13T12:00:20.146831Z [info ] tap-quickbooks INFO CustomerType: Completed sync (0 rows)\n2026-03-13T12:00:20.147252Z [info ] tap-quickbooks INFO PaymentMethod: Starting \n2026-03-13T12:00:20.149571Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream PaymentMethod\n2026-03-13T12:00:20.150050Z [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-13T12:00:20.229418Z [info ] target-postgres Hard delete: False \n2026-03-13T12:00:20.383297Z [info ] target-postgres Hard delete: False \n2026-03-13T12:00:20.893801Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 7, \"tags\": {\"endpoint\": \"PaymentMethod\"}}\n2026-03-13T12:00:20.894609Z [info ] tap-quickbooks INFO PaymentMethod: Completed sync (7 rows)\n2026-03-13T12:00:20.895070Z [info ] tap-quickbooks INFO Payment: Starting \n2026-03-13T12:00:20.895767Z [info ] target-postgres An activate version message for 'PaymentMethod' was received. Draining...\n2026-03-13T12:00:20.897318Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Payment\n2026-03-13T12:00:20.897860Z [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-13T12:00:20.984187Z [info ] target-postgres Inserting with SQL: INSERT INTO f3b61e41_80c8_4c3f_8cec_045af5fb8d4a (\"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-13T12:00:21.067098Z [info ] target-postgres Hard delete: False \n2026-03-13T12:00:21.207230Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 16, \"tags\": {\"endpoint\": \"Payment\"}}\n2026-03-13T12:00:21.207785Z [info ] tap-quickbooks INFO Payment: Completed sync (16 rows)\n2026-03-13T12:00:21.208311Z [info ] tap-quickbooks INFO Transfer: Starting \n2026-03-13T12:00:21.208818Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Transfer\n2026-03-13T12:00:21.209197Z [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-13T12:00:21.214340Z [info ] target-postgres Hard delete: False \n2026-03-13T12:00:21.234292Z [info ] target-postgres An activate version message for 'Payment' was received. Draining...\n2026-03-13T12:00:21.296953Z [info ] target-postgres Inserting with SQL: INSERT INTO \"2fed607e_721f_42dc_92a2_b16e4fc56621\" (\"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-13T12:00:21.395096Z [info ] target-postgres Hard delete: False \n2026-03-13T12:00:21.557858Z [info ] tap-quickbooks INFO Response with no data {'QueryResponse': {}, 'time': '2026-03-13T05:00:21.480-07:00'}\n2026-03-13T12:00:21.558636Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 0, \"tags\": {\"endpoint\": \"Transfer\"}}\n2026-03-13T12:00:21.559015Z [info ] tap-quickbooks INFO Transfer: Completed sync (0 rows)\n2026-03-13T12:00:21.559429Z [info ] tap-quickbooks INFO CompanyInfo: Starting \n2026-03-13T12:00:21.562265Z [info ] target-postgres Hard delete: False \n2026-03-13T12:00:21.562844Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream CompanyInfo\n2026-03-13T12:00:21.563288Z [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-13T12:00:21.633500Z [info ] target-postgres Hard delete: False \n2026-03-13T12:00:21.791789Z [info ] target-postgres Hard delete: False \n2026-03-13T12:00:21.915268Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 1, \"tags\": {\"endpoint\": \"CompanyInfo\"}}\n2026-03-13T12:00:21.915923Z [info ] tap-quickbooks INFO CompanyInfo: Completed sync (1 rows)\n2026-03-13T12:00:21.916439Z [info ] tap-quickbooks INFO TaxRate: Starting \n2026-03-13T12:00:21.917217Z [info ] target-postgres An activate version message for 'CompanyInfo' was received. Draining...\n2026-03-13T12:00:21.918912Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream TaxRate\n2026-03-13T12:00:21.919422Z [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-13T12:00:21.987458Z [info ] target-postgres Inserting with SQL: INSERT INTO \"044f6607_3899_4bee_887f_0d3701ecd6a2\" (\"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-13T12:00:22.081946Z [info ] target-postgres Hard delete: False \n2026-03-13T12:00:22.167226Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 3, \"tags\": {\"endpoint\": \"TaxRate\"}}\n2026-03-13T12:00:22.167887Z [info ] tap-quickbooks INFO TaxRate: Completed sync (3 rows)\n2026-03-13T12:00:22.168375Z [info ] tap-quickbooks INFO TaxCode: Starting \n2026-03-13T12:00:22.171100Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream TaxCode\n2026-03-13T12:00:22.171616Z [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-13T12:00:22.260380Z [info ] target-postgres Hard delete: False \n2026-03-13T12:00:22.267809Z [info ] target-postgres An activate version message for 'TaxRate' was received. Draining...\n2026-03-13T12:00:22.342281Z [info ] target-postgres Inserting with SQL: INSERT INTO a04684e4_b648_4648_a012_0f2eec9c1a83 (\"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-13T12:00:22.434141Z [info ] target-postgres Hard delete: False \n2026-03-13T12:00:22.629107Z [info ] target-postgres Hard delete: False \n2026-03-13T12:00:22.693147Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 5, \"tags\": {\"endpoint\": \"TaxCode\"}}\n2026-03-13T12:00:22.694237Z [info ] tap-quickbooks INFO TaxCode: Completed sync (5 rows)\n2026-03-13T12:00:22.694855Z [info ] tap-quickbooks INFO Term: Starting \n2026-03-13T12:00:22.695706Z [info ] target-postgres An activate version message for 'TaxCode' was received. Draining...\n2026-03-13T12:00:22.698331Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Term\n2026-03-13T12:00:22.698673Z [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-13T12:00:22.764944Z [info ] target-postgres Inserting with SQL: INSERT INTO \"14a3ac27_4291_4948_ad06_2f2ea24ba9cd\" (\"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-13T12:00:22.850202Z [info ] target-postgres Hard delete: False \n2026-03-13T12:00:23.021305Z [info ] target-postgres Hard delete: False \n2026-03-13T12:00:23.168846Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 5, \"tags\": {\"endpoint\": \"Term\"}}\n2026-03-13T12:00:23.169344Z [info ] tap-quickbooks INFO Term: Completed sync (5 rows)\n2026-03-13T12:00:23.169629Z [info ] tap-quickbooks INFO Department: Starting \n2026-03-13T12:00:23.170541Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Department\n2026-03-13T12:00:23.170927Z [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-13T12:00:23.172373Z [info ] target-postgres An activate version message for 'Term' was received. Draining...\n2026-03-13T12:00:23.249068Z [info ] target-postgres Inserting with SQL: INSERT INTO c60c4008_ac40_4fe2_b87a_d680ff2bdb90 (\"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-13T12:00:23.330420Z [info ] target-postgres Hard delete: False \n2026-03-13T12:00:23.498584Z [info ] target-postgres Hard delete: False \n2026-03-13T12:00:23.604311Z [info ] tap-quickbooks INFO Response with no data {'QueryResponse': {}, 'time': '2026-03-13T05:00:23.417-07:00'}\n2026-03-13T12:00:23.605206Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 0, \"tags\": {\"endpoint\": \"Department\"}}\n2026-03-13T12:00:23.605680Z [info ] tap-quickbooks INFO Department: Completed sync (0 rows)\n2026-03-13T12:00:23.606182Z [info ] tap-quickbooks INFO CreditMemo: Starting \n2026-03-13T12:00:23.610384Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream CreditMemo\n2026-03-13T12:00:23.610948Z [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-13T12:00:23.693137Z [info ] target-postgres Hard delete: False \n2026-03-13T12:00:23.862994Z [info ] target-postgres Hard delete: False \n2026-03-13T12:00:23.934154Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 1, \"tags\": {\"endpoint\": \"CreditMemo\"}}\n2026-03-13T12:00:23.934853Z [info ] tap-quickbooks INFO CreditMemo: Completed sync (1 rows)\n2026-03-13T12:00:23.935297Z [info ] tap-quickbooks INFO Customer: Starting \n2026-03-13T12:00:23.935991Z [info ] target-postgres An activate version message for 'CreditMemo' was received. Draining...\n2026-03-13T12:00:23.937487Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Customer\n2026-03-13T12:00:23.937963Z [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-13T12:00:24.034843Z [info ] target-postgres Inserting with SQL: INSERT INTO d2cdcdda_fcaa_462a_8fc2_8a43efa2959d (\"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-13T12:00:24.133713Z [info ] target-postgres Hard delete: False \n2026-03-13T12:00:24.204649Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 29, \"tags\": {\"endpoint\": \"Customer\"}}\n2026-03-13T12:00:24.205364Z [info ] tap-quickbooks INFO Customer: Completed sync (29 rows)\n2026-03-13T12:00:24.205870Z [info ] tap-quickbooks INFO Employee: Starting \n2026-03-13T12:00:24.206448Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Employee\n2026-03-13T12:00:24.206801Z [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-13T12:00:24.297287Z [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, 12, 0, 24, 235572, \ntzinfo=datetime.timezone.utc), 'version': 1773403223934}]\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-13T12:00:24.308480Z [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, 12, 0, 24, 235572, tzinfo=datetime.timezone.utc), \\'version\\': 1773403223934}]\\n(Background on this error at: https://sqlalche.me/e/20/f405)' plugin_exc_type=ProgrammingError\n2026-03-13T12:00:24.497639Z [error ] meltano Loader failed \n2026-03-13T12:00:24.498300Z [error ] meltano Block run completed \n2026-03-13T12:00:24.501665Z [info ] meltano Run completed \n"}

+10ms Processing

Server:
cfd059752a2d:1
Worker:
a625499e

+4ms Enqueued

03/13/2026 12:00:07 Created