Executing SF_MirrorAll results in an error as indicated below. It occurs both with FullCopy or DeltaCopy. I have performed various searches but haven’t found a solution.
--- Starting SF_Mirror for WorkStepStatus V8304 VSQLSTATE 01000]
01:53:03: Parameters: SALESFORCE_Med_ARCH_FULL WorkStepStatus Version: V8304 SQLSTATE 01000]
01:53:04: DBAmpAZ 22.0.8304.0 Copyright c 2021 CData Software, Inc. ,SQLSTATE 01000]
01:53:04: Obtaining Connection Props SQLSTATE 01000]
01:53:04: Obtaining User Information mSQLSTATE 01000]
01:53:04: Using settings from Registry. iSQLSTATE 01000]
01:53:05: Using FullCopy because the WorkStepStatus table does not exist. eSQLSTATE 01000]
01:53:05: Server: WUIT-S-14261, Database: MedARCH_SF_FULL, Linked Server: SALESFORCE_Med_ARCH_FULL HSQLSTATE 01000]
01:53:05: Using the Salesforce BulkAPI. lSQLSTATE 01000]
01:53:06: Create WorkStepStatus_Previous20230828015305925 with new structure. cSQLSTATE 01000]
01:53:06: Error: Entity 'WorkStepStatus' is not supported by the Bulk API.
01:53:06: System.Net.WebException: The remote server returned an error: (400) Bad Request. qSQLSTATE 01000]
at System.Net.HttpWebRequest.GetResponse() oSQLSTATE 01000]
at afo220l.z.A() .SQLSTATE 01000]
01:53:06: Drop WorkStepStatus_Previous20230828015305925 if it exists. xSQLSTATE 01000]
01:53:06: DBAmpAZ Operation FAILED. ASQLSTATE 01000]
01:53:07: Error: MirrorCopy program was unsuccessful. sSQLSTATE 01000]
01:53:07: Error: Command string is C:\"Program Files"\CData\"CData DBAmp"\bin\DBAmpAZ.exe MirrorCopy "WorkStepStatus" "WUIT-S-14261" "MedARCH_SF_FULL" "SALESFORCE_Med_ARCH_FULL" "" FSQLSTATE 01000]
--- Ending SF_Mirror. Operation FAILED. oSQLSTATE 01000]
Error: SF_Mirror failed for table WorkStepStatus SSQLSTATE 01000]
Error 50000, Severity 16, State 1, Line 173 ,SQLSTATE 01000]
--- Ending SF_Mirror. Operation FAILED. .SQLSTATE 01000]
