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

Time Out Causes Job to Hang

I am running a SQL job to pull tables from SFDC.

I run a refresh against a 25M row table and if that step fails in the SQL job, I call a replicate.

We are having issues with the job hanging when it goes to do the replicate.

Below is what we are logging as the Error in SQL.

Job 'SFDCProd_Replicate' : Step 47, 'Refresh Publish_Pricebook_Entry' : Began Executing 2018-02-25 21:28:58

Msg 7320, Sev 16, State 2, Line 1 : Cannot execute the query "Select Count(Id) from Publish_PriceBook_Entry__c " against OLE DB provider "DBAmp.DBAmp" for linked server "SalesForce_Prod". [SQLSTATE 42000]
Msg 0, Sev 16, State 1, Line 47 : --- Starting SF_Refresh for Publish_PriceBook_Entry__c V3.5.6 [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 269 : 21:28:58: Using last run time of 2018-02-25 19:55:00 [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 392 : 21:28:58: Identified 0 updated/inserted rows. [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 687 : 21:28:58: Identified 0 deleted rows. [SQLSTATE 01000]
Msg 7412, Sev 16, State 1, Line 1 : OLE DB provider "DBAmp.DBAmp" for linked server "SalesForce_Prod" returned message "Error: QUERY_TIMEOUT: Your query request was running for too long.". [SQLSTATE 01000]
Job 'SFDCProd_Replicate' : Step 48, 'Replicate Publish_PriceBook_Entry__c' : Began Executing 2018-02-25 21:31:01

Date 2/25/2018 9:28:58 PM
Log Job History (SFDCProd_Replicate)

Step ID 47
Server RWSSSIS
Job Name SFDCProd_Replicate
Step Name Refresh Publish_Pricebook_Entry
Duration 00:02:03
Sql Severity 16
Sql Message ID 7412
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: RWSC\SQLSSIS. Cannot execute the query "Select Count(Id) from Publish_PriceBook_Entry__c " against OLE DB provider "DBAmp.DBAmp" for linked server "SalesForce_Prod". [SQLSTATE 42000] (Error 7320) --- Starting SF_Refresh for Publish_PriceBook_Entry__c V3.5.6 [SQLSTATE 01000] (Error 0) 21:28:58: Using last run time of 2018-02-25 19:55:00 [SQLSTATE 01000] (Error 0) 21:28:58: Identified 0 updated/inserted rows. [SQLSTATE 01000] (Error 0) 21:28:58: Identified 0 deleted rows. [SQLSTATE 01000] (Error 0) OLE DB provider "DBAmp.DBAmp" for linked server "SalesForce_Prod" returned message "Error: QUERY_TIMEOUT: Your query request was running for too long.". [SQLSTATE 01000] (Error 7412). The step failed.
1 person has
this problem
+1
Reply