version: 4.1.6.0
Description: All of my sql jobs pulling variations of sf_refresh are failing as of 10/11/2025. Currently not bring any data down in our production environment
ERROR:
10/11/2025 5:02:02 AM
Log Job History (SF_Refresh Salesforce - ChargentBase__Gateway__c)
Step ID 1
Server AZSQL02
Job Name SF_Refresh Salesforce - ChargentBase__Gateway__c
Step Name 1
Duration 00:00:00
Sql Severity 16
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 1
Message
Executed as user: NT SERVICE\SQLSERVERAGENT. --- Ending SF_Refresh. Operation FAILED. [SQLSTATE 42000] (Error 50000) --- Starting SF_Refresh for ChargentBase__Gateway__c V4.1.4 [SQLSTATE 01000] (Error 0) 05:02:02: Using Schema Error Action of yes [SQLSTATE 01000] (Error 0) OLE DB provider "DBAmp.DBAmp" for linked server "Salesforce" returned message "Error 5103 : Error: Zipped response from salesforce was missing valid zip header.". [SQLSTATE 01000] (Error 7412) 05:02:02: Error: Unable to validate object: Cannot initialize the data source object of OLE DB provider "DBAmp.DBAmp" for linked server "Salesforce". [SQLSTATE 01000] (Error 0) --- Ending SF_Refresh. Operation FAILED. [SQLSTATE 01000] (Error 0)
