Data sync issues due to warehouse timeout in OOTB
Description description
Environment
Adobe 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 Adobe 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.
recommendation-more-help
3d58f420-19b5-47a0-a122-5c9dab55ec7f