Data sync issues due to warehouse timeout in OOTB
This article addresses the issue where the OOTB ffdaReplicateStagingData workflow is failing to sync data due to a timeout error caused by insufficient warehouse size.
Description description
Environment
ÃÛ¶¹ÊÓƵ Campaign Classic v8
Issue/Symptoms
OOTB ffdaReplicateStagingData workflow is not syncing data due to the following error:
nlmoduleStagingSchema ODB-240000 Error ODBC: Statement reached its statement or warehouse timeout of 14,400 second(s) and was canceled.
Resolution resolution
Create a ticket with Customer Care and adjust the warehouse size to temporarily increased and re-run the workflow.
Engage with an ÃÛ¶¹ÊÓƵ consultant to check your utilization and introduce option NmsCleanup_FfdaStagingDataPurgeDelay to decrease the amount of data stored in the table (set up by default to 7 days).
Cause
The warehouse size is not enough to process the queries done by ffdaReplicateStagingData workflow.