TenantSyncCoordinator.RunTenantSyncAsync

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

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

Parameters

CurrentCulture
""
CurrentUICulture
""

State

03/13/2026 09:00:29 (+20.849s) Succeeded

Latency:
25ms
Duration:
20.833s
Result:
{"$type":"RmsQboIntegration.Web.Infrastructure.Dtos.MeltanoRunResult, web","ExitCode":1,"StdOut":"","StdErr":"2026-03-13T09:00:09.490304Z [info ] meltano Environment 'tenant' is active\n2026-03-13T09:00:09.763727Z [info ] meltano Running job with name 'tenant:tap-quickbooks-to-target-postgres:tenant-1' and run ID '019ce66c-b42c-7c8f-9e7c-77f8883c738a'\n2026-03-13T09:00:09.869783Z [info ] meltano Using systemdb state backend \n2026-03-13T09:00:09.871118Z [warning ] meltano No state was found, complete import.\n2026-03-13T09:00:10.160600Z [info ] tap-quickbooks INFO Instance URL :- https://sandbox-quickbooks.api.intuit.com/v3/company/9341456531142773\n2026-03-13T09:00:10.161656Z [info ] tap-quickbooks INFO Attempting login via OAuth2\n2026-03-13T09:00:10.162094Z [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-13T09:00:10.621452Z [info ] target-postgres target-postgres v0.6.3, Meltano SDK v0.53.5\n2026-03-13T09:00:10.622168Z [info ] target-postgres Skipping parse of env var settings...\n2026-03-13T09:00:14.817496Z [info ] tap-quickbooks INFO OAuth2 login successful \n2026-03-13T09:00:14.817844Z [info ] tap-quickbooks INFO REFRESH TOKEN: RT1-159-H0-1782095738zhk7s6lbkxsg4sacz4qp\n2026-03-13T09:00:14.819474Z [info ] tap-quickbooks INFO Starting new login timer \n2026-03-13T09:00:14.820685Z [info ] tap-quickbooks INFO Starting sync \n2026-03-13T09:00:14.821255Z [info ] tap-quickbooks INFO Account: Starting \n2026-03-13T09:00:14.823785Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Account\n2026-03-13T09:00:14.824080Z [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-13T09:00:15.170442Z [info ] target-postgres Hard delete: False \n2026-03-13T09:00:19.701902Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 89, \"tags\": {\"endpoint\": \"Account\"}}\n2026-03-13T09:00:19.702660Z [info ] tap-quickbooks INFO Account: Completed sync (89 rows)\n2026-03-13T09:00:19.703121Z [info ] tap-quickbooks INFO Bill: Starting \n2026-03-13T09:00:19.703678Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Bill\n2026-03-13T09:00:19.704089Z [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-13T09:00:19.714122Z [info ] target-postgres An activate version message for 'Account' was received. Draining...\n2026-03-13T09:00:19.806155Z [info ] target-postgres Inserting with SQL: INSERT INTO dbff68cd_621c_40df_aa67_0e9ad92558d7 (\"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-13T09:00:19.900868Z [info ] target-postgres Hard delete: False \n2026-03-13T09:00:20.063570Z [info ] target-postgres Hard delete: False \n2026-03-13T09:00:20.683381Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 15, \"tags\": {\"endpoint\": \"Bill\"}}\n2026-03-13T09:00:20.684375Z [info ] tap-quickbooks INFO Bill: Completed sync (15 rows)\n2026-03-13T09:00:20.684764Z [info ] tap-quickbooks INFO Class: Starting \n2026-03-13T09:00:20.685383Z [info ] target-postgres An activate version message for 'Bill' was received. Draining...\n2026-03-13T09:00:20.685829Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Class\n2026-03-13T09:00:20.686222Z [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-13T09:00:20.772732Z [info ] target-postgres Inserting with SQL: INSERT INTO ecb604aa_ce42_4dd4_8b9c_5d0db04a5b7e (\"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-13T09:00:20.863096Z [info ] target-postgres Hard delete: False \n2026-03-13T09:00:20.940536Z [info ] tap-quickbooks INFO Response with no data {'QueryResponse': {}, 'time': '2026-03-13T02:00:20.836-07:00'}\n2026-03-13T09:00:20.941292Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 0, \"tags\": {\"endpoint\": \"Class\"}}\n2026-03-13T09:00:20.941758Z [info ] tap-quickbooks INFO Class: Completed sync (0 rows)\n2026-03-13T09:00:20.942153Z [info ] tap-quickbooks INFO CustomerType: Starting \n2026-03-13T09:00:20.944761Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream CustomerType\n2026-03-13T09:00:20.945231Z [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-13T09:00:21.010226Z [info ] target-postgres Hard delete: False \n2026-03-13T09:00:21.111436Z [info ] target-postgres Hard delete: False \n2026-03-13T09:00:21.279141Z [info ] tap-quickbooks INFO Response with no data {'QueryResponse': {}, 'time': '2026-03-13T02:00:21.119-07:00'}\n2026-03-13T09:00:21.279962Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 0, \"tags\": {\"endpoint\": \"CustomerType\"}}\n2026-03-13T09:00:21.280477Z [info ] tap-quickbooks INFO CustomerType: Completed sync (0 rows)\n2026-03-13T09:00:21.280824Z [info ] tap-quickbooks INFO PaymentMethod: Starting \n2026-03-13T09:00:21.281476Z [info ] target-postgres Hard delete: False \n2026-03-13T09:00:21.283165Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream PaymentMethod\n2026-03-13T09:00:21.283656Z [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-13T09:00:21.364864Z [info ] target-postgres Hard delete: False \n2026-03-13T09:00:21.528186Z [info ] target-postgres Hard delete: False \n2026-03-13T09:00:22.042899Z [info ] target-postgres An activate version message for 'PaymentMethod' was received. Draining...\n2026-03-13T09:00:22.043490Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 7, \"tags\": {\"endpoint\": \"PaymentMethod\"}}\n2026-03-13T09:00:22.043794Z [info ] tap-quickbooks INFO PaymentMethod: Completed sync (7 rows)\n2026-03-13T09:00:22.044094Z [info ] tap-quickbooks INFO Payment: Starting \n2026-03-13T09:00:22.047096Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Payment\n2026-03-13T09:00:22.047559Z [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-13T09:00:22.119804Z [info ] target-postgres Inserting with SQL: INSERT INTO d3fd550f_9312_479a_a5d0_ae06541b80b3 (\"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-13T09:00:22.206680Z [info ] target-postgres Hard delete: False \n2026-03-13T09:00:22.350643Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 16, \"tags\": {\"endpoint\": \"Payment\"}}\n2026-03-13T09:00:22.351756Z [info ] tap-quickbooks INFO Payment: Completed sync (16 rows)\n2026-03-13T09:00:22.352325Z [info ] tap-quickbooks INFO Transfer: Starting \n2026-03-13T09:00:22.352876Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Transfer\n2026-03-13T09:00:22.353299Z [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-13T09:00:22.374565Z [info ] target-postgres Hard delete: False \n2026-03-13T09:00:22.394111Z [info ] target-postgres An activate version message for 'Payment' was received. Draining...\n2026-03-13T09:00:22.472011Z [info ] target-postgres Inserting with SQL: INSERT INTO \"41d81010_78d0_499c_8239_99b609efbbcc\" (\"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-13T09:00:22.569987Z [info ] target-postgres Hard delete: False \n2026-03-13T09:00:22.701484Z [info ] tap-quickbooks INFO Response with no data {'QueryResponse': {}, 'time': '2026-03-13T02:00:22.627-07:00'}\n2026-03-13T09:00:22.702245Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 0, \"tags\": {\"endpoint\": \"Transfer\"}}\n2026-03-13T09:00:22.702630Z [info ] tap-quickbooks INFO Transfer: Completed sync (0 rows)\n2026-03-13T09:00:22.702951Z [info ] tap-quickbooks INFO CompanyInfo: Starting \n2026-03-13T09:00:22.706639Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream CompanyInfo\n2026-03-13T09:00:22.707237Z [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-13T09:00:22.728337Z [info ] target-postgres Hard delete: False \n2026-03-13T09:00:22.811480Z [info ] target-postgres Hard delete: False \n2026-03-13T09:00:22.984923Z [info ] target-postgres Hard delete: False \n2026-03-13T09:00:23.010331Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 1, \"tags\": {\"endpoint\": \"CompanyInfo\"}}\n2026-03-13T09:00:23.010988Z [info ] tap-quickbooks INFO CompanyInfo: Completed sync (1 rows)\n2026-03-13T09:00:23.011432Z [info ] tap-quickbooks INFO TaxRate: Starting \n2026-03-13T09:00:23.012091Z [info ] target-postgres An activate version message for 'CompanyInfo' was received. Draining...\n2026-03-13T09:00:23.013938Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream TaxRate\n2026-03-13T09:00:23.014525Z [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-13T09:00:23.085104Z [info ] target-postgres Inserting with SQL: INSERT INTO f1514079_c919_404a_8ee7_dc6dd1e75c1c (\"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-13T09:00:23.178236Z [info ] target-postgres Hard delete: False \n2026-03-13T09:00:23.258107Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 3, \"tags\": {\"endpoint\": \"TaxRate\"}}\n2026-03-13T09:00:23.258616Z [info ] tap-quickbooks INFO TaxRate: Completed sync (3 rows)\n2026-03-13T09:00:23.258902Z [info ] tap-quickbooks INFO TaxCode: Starting \n2026-03-13T09:00:23.261761Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream TaxCode\n2026-03-13T09:00:23.262187Z [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-13T09:00:23.323783Z [info ] target-postgres Hard delete: False \n2026-03-13T09:00:23.332459Z [info ] target-postgres An activate version message for 'TaxRate' was received. Draining...\n2026-03-13T09:00:23.411676Z [info ] target-postgres Inserting with SQL: INSERT INTO \"716b173f_f74b_4376_81b0_895486703ecc\" (\"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-13T09:00:23.500496Z [info ] target-postgres Hard delete: False \n2026-03-13T09:00:23.504970Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 5, \"tags\": {\"endpoint\": \"TaxCode\"}}\n2026-03-13T09:00:23.505597Z [info ] tap-quickbooks INFO TaxCode: Completed sync (5 rows)\n2026-03-13T09:00:23.505965Z [info ] tap-quickbooks INFO Term: Starting \n2026-03-13T09:00:23.508657Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Term\n2026-03-13T09:00:23.509161Z [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-13T09:00:23.691832Z [info ] target-postgres Hard delete: False \n2026-03-13T09:00:23.700075Z [info ] target-postgres An activate version message for 'TaxCode' was received. Draining...\n2026-03-13T09:00:23.769056Z [info ] target-postgres Inserting with SQL: INSERT INTO ad7154f7_05cc_4f58_9201_8f7e7476651a (\"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-13T09:00:23.857922Z [info ] target-postgres Hard delete: False \n2026-03-13T09:00:23.883231Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 5, \"tags\": {\"endpoint\": \"Term\"}}\n2026-03-13T09:00:23.883750Z [info ] tap-quickbooks INFO Term: Completed sync (5 rows)\n2026-03-13T09:00:23.884294Z [info ] tap-quickbooks INFO Department: Starting \n2026-03-13T09:00:23.884826Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Department\n2026-03-13T09:00:23.885233Z [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-13T09:00:24.025878Z [info ] target-postgres Hard delete: False \n2026-03-13T09:00:24.040957Z [info ] target-postgres An activate version message for 'Term' was received. Draining...\n2026-03-13T09:00:24.126644Z [info ] target-postgres Inserting with SQL: INSERT INTO a7286ae5_43ee_4541_9bd7_df4d5ce777a0 (\"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-13T09:00:24.226619Z [info ] target-postgres Hard delete: False \n2026-03-13T09:00:24.230975Z [info ] tap-quickbooks INFO Response with no data {'QueryResponse': {}, 'time': '2026-03-13T02:00:24.125-07:00'}\n2026-03-13T09:00:24.231687Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 0, \"tags\": {\"endpoint\": \"Department\"}}\n2026-03-13T09:00:24.232148Z [info ] tap-quickbooks INFO Department: Completed sync (0 rows)\n2026-03-13T09:00:24.232493Z [info ] tap-quickbooks INFO CreditMemo: Starting \n2026-03-13T09:00:24.236838Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream CreditMemo\n2026-03-13T09:00:24.237379Z [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-13T09:00:24.376375Z [info ] target-postgres Hard delete: False \n2026-03-13T09:00:24.463371Z [info ] target-postgres Hard delete: False \n2026-03-13T09:00:24.533801Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 1, \"tags\": {\"endpoint\": \"CreditMemo\"}}\n2026-03-13T09:00:24.534496Z [info ] tap-quickbooks INFO CreditMemo: Completed sync (1 rows)\n2026-03-13T09:00:24.534944Z [info ] tap-quickbooks INFO Customer: Starting \n2026-03-13T09:00:24.537910Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Customer\n2026-03-13T09:00:24.538426Z [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-13T09:00:24.621986Z [info ] target-postgres Hard delete: False \n2026-03-13T09:00:24.629853Z [info ] target-postgres An activate version message for 'CreditMemo' was received. Draining...\n2026-03-13T09:00:24.717016Z [info ] target-postgres Inserting with SQL: INSERT INTO \"346cdf88_9a15_4077_8482_360df4ce8917\" (\"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-13T09:00:24.808111Z [info ] target-postgres Hard delete: False \n2026-03-13T09:00:24.812654Z [info ] tap-quickbooks INFO METRIC: {\"type\": \"counter\", \"metric\": \"record_count\", \"value\": 29, \"tags\": {\"endpoint\": \"Customer\"}}\n2026-03-13T09:00:24.813097Z [info ] tap-quickbooks INFO Customer: Completed sync (29 rows)\n2026-03-13T09:00:24.813511Z [info ] tap-quickbooks INFO Employee: Starting \n2026-03-13T09:00:24.814012Z [info ] tap-quickbooks INFO Syncing Quickbooks data for stream Employee\n2026-03-13T09:00:24.814343Z [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-13T09:00:24.976545Z [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, 9, 0, 24, 900353, \ntzinfo=datetime.timezone.utc), 'version': 1773392424533}]\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-13T09:00:24.990420Z [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, 9, 0, 24, 900353, tzinfo=datetime.timezone.utc), \\'version\\': 1773392424533}]\\n(Background on this error at: https://sqlalche.me/e/20/f405)' plugin_exc_type=ProgrammingError\n2026-03-13T09:00:25.178242Z [error ] meltano Loader failed \n2026-03-13T09:00:25.178948Z [error ] meltano Block run completed \n2026-03-13T09:00:25.184341Z [info ] meltano Run completed \n"}

+14ms Processing

Server:
cfd059752a2d:1
Worker:
89491c54

+5ms Enqueued

03/13/2026 09:00:08 Created