Help get this topic noticed by sharing it on Twitter, Facebook, or email.
I’m confused

Timeout issues

I am trying to refresh 2 tables every 2 hours. There are little to no updates happening as of yet, but we get failures here and there.

Here is my error code from SQL Server Std 2008:

Executed as user: BAKERTILLY\btsql. The OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE" reported an error. The provider reported an unexpected catastrophic failure. [SQLSTATE 42000] (Error 7399) Cannot fetch a row from OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE". [SQLSTATE 42000] (Error 7330) --- Starting SF_Refresh for Account [SQLSTATE 01000] (Error 0) 11:15:00: Using Schema Error Action of yes [SQLSTATE 01000] (Error 0) OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE" returned message "INVALID_SESSION_ID: Invalid Session ID found in SessionHeader: Session timed out". [SQLSTATE 01000] (Error 7412). The step failed.
1 person has
this problem
+1
Reply