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

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.