Help get this topic noticed by sharing it on Twitter, Facebook, or email.

QUERY_TIMEOUT: Your query request was running for too long.

Team,

I am representing a company and a Legal user of DBAmp. We are synchronizing all our sandboxes and production environment and lately we are facing some challenge in refreshing our production environment for the past few months.

I am trying to replicate one large object (8,239,482 records) using SF_REPLICATE and I am continuously getting QUERY_TIMEOUT: Your query request was running for too long.

--- Starting SF_Replicate for RESPONSE__C
17:35:13: Drop RESPONSE__C_Previous if it exists.
17:35:13: Create RESPONSE__C_Previous with new structure.
17:35:13: Run the DBAmp.exe program.
17:35:13: DBAmp Bulk Operations. V2.19.4 (c) Copyright 2006-2014 forceAmp.com LLC
17:35:13: Populating local table RESPONSE__C_Previous , dbcomp / PRD .
17:35:13: DBAmp is using the SQL Native Client.
17:35:13: Opening SQL Server rowset
18:05:19: Error: RunQuery failed with com_error.
18:05:19: QUERY_TIMEOUT: Your query request was running for too long.
18:05:19: Error: DBAmp.exe was unsuccessful.
18:05:19: Error: Command string is C:\"Program Files"\DBAmp\DBAmp.exe Export "RESPONSE__C_Previous" "DBCOMP" "PRD" "PRD"
--- Ending SF_Replicate. Operation FAILED.
Msg 50000, Level 16, State 1, Procedure SF_Replicate, Line 244
--- Ending SF_Replicate. Operation FAILED.

Can you help us to resolve this issue, please let us know if you need me to raise any ticket officially.
2 people have
this question
+1
Reply