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

Session Timeout

Good Morning,
I have a job scheduled that seems to be timming out alot. Do you have any ideas?
This job doesn't time out everyday but it does time out multiple times in a week.

When it fails I can manually run it right after with no problems.

Here is the Job error

Date 2/5/2014 3:00:00 PM
Log Job History (UltiPro to CRM)

Step ID 1
Server ETL-CERT
Job Name UltiPro to CRM
Step Name Update SFDC Departments
Duration 00:00:04
Sql Severity 16
Sql Message ID 7412
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: EUR-DOMAIN1\sqlagent. Cannot execute the query "SELECT "Tbl1006"."ANSR_Department_ID__c" "Col1017","Tbl1006"."Id" "Col1018","Tbl1006"."Name" "Col1019","Tbl1006"."RecordTypeId" "Col1020" FROM "Lab__c" "Tbl1006"" against OLE DB provider "DBAmp.DBAmp" for linked server "Salesforce". [SQLSTATE 42000] (Error 7320) OLE DB provider "DBAmp.DBAmp" for linked server "Salesforce" returned message "Error 1 : 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