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

Job has started failing. I am not geting much unformation from the error.

Starting Yesterday morning, one of our jobs is failing (In cert), it is failing on the refresh step. I any ideas on how to troubleshoot this?

Date 4/15/2014 2:03:26 PM
Log Job History (SFDC to ANS Integration)

Step ID 1
Server ETL-CERT
Job Name SFDC to ANS Integration
Step Name Refresh SFDC Tables
Duration 00:00:34
Sql Severity 16
Sql Message ID 50000
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: EUR-DOMAIN1\CRMADMIN. --- Starting SF_Replicate for Account [SQLSTATE 01000] (Message 0) 14:03:26: Drop Account_Previous if it exists. [SQLSTATE 01000] (Message 0) 14:03:26: Create Account_Previous with new structure. [SQLSTATE 01000] (Message 0) 14:03:28: Run the DBAmp.exe program. [SQLSTATE 01000] (Message 0) 14:03:28: DBAmp Bulk Operations. V2.17.7 (c) Copyright 2006-2013 forceAmp.com LLC [SQLSTATE 01000] (Message 0) 14:03:28: Populating local table Account_Previous , ETL-CERT / dbCRMStage_Cert . [SQLSTATE 01000] (Message 0) 14:03:28: DBAmp is using the SQL Native Client. [SQLSTATE 01000] (Message 0) 14:03:28: Opening SQL Server rowset [SQLSTATE 01000] (Message 0) 14:03:53: 7860 rows copied. [SQLSTATE 01000] (Message 0) 14:03:53: Drop Account if it exists. [SQLSTATE 01000] (Message 0) 14:03:53: Rename previous table from Account_Previous to Account [SQLSTATE 01000] (Message 0) Caution: Changing any part of an object name could break scripts and stored procedures. [SQLSTATE 01000] (Message 15477) 14:03:53: Create primary key on Account [SQLSTATE 01000] (Message 0) --- Ending SF_Replicate. Operation successful. [SQLSTATE 01000] (Message 0) --- Starting SF_Replicate for Contact [SQLSTATE 01000] (Message 0) 14:03:53: Drop Contact_Previous if it exists. [SQLSTATE 01000] (Message 0) 14:03:53: Create Contact_Previous with new structure. [SQLSTATE 01000] (Message 0) 14:03:53: Run the DBAmp.exe program. [SQLSTATE 01000] (Message 0) 14:03:53: DBAmp Bulk Operations. V2.17.7 (c) Copyright 2006-2013 forceAmp.com LLC [SQLSTATE 01000] (Message 0) 14:03:53: Populating local table Contact_Previous , ETL-CERT / dbCRMStage_Cert . [SQLSTATE 01000] (Message 0) 14:03:53: DBAmp is using the SQL Native Client. [SQLSTATE 01000] (Message 0) 14:03:53: Opening SQL Server rowset [SQLSTATE 01000] (Message 0) 14:03:55: Error: RunQuery failed with com_error. [SQLSTATE 01000] (Message 0) 14:03:55: Failed to read from reply. [SQLSTATE 01000] (Message 0) Win32Error:: [SQLSTATE 01000] (Message 0) A security error occurred [SQLSTATE 01000] (Message 0) 14:03:55: Error: DBAmp.exe was unsuccessful. [SQLSTATE 01000] (Message 0) 14:03:55: Error: Command string is C:\"Program Files"\DBAmp\DBAmp.exe Export "Contact_Previous" "ETL-CERT" "dbCRMStage_Cert" "SALESFORCE" [SQLSTATE 01000] (Message 0) --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000] (Message 0) --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 42000] (Error 50000). The step failed.
1 person has
this question
+1
Reply