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 [SQLSTATE 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 [SQLSTATE 01000]
01:53:04: Using settings from Registry. [SQLSTATE 01000]
01:53:05: Using FullCopy because the WorkStepStatus table does not exist. [SQLSTATE 01000]
01:53:05: Server: WUIT-S-14261, Database: MedARCH_SF_FULL, Linked Server: SALESFORCE_Med_ARCH_FULL [SQLSTATE 01000]
01:53:05: Using the Salesforce BulkAPI. [SQLSTATE 01000]
01:53:06: Create WorkStepStatus_Previous20230828015305925 with new structure. [SQLSTATE 01000]
01:53:06: Error: Entity 'WorkStepStatus' is not supported by the Bulk API. [SQLSTATE 01000]
01:53:06: Error: Unable to create job. [SQLSTATE 01000]
01:53:06: System.Net.WebException: The remote server returned an error: (400) Bad Request. [SQLSTATE 01000]
at System.Net.HttpWebRequest.GetResponse() [SQLSTATE 01000]
at afo220l.z.A() [SQLSTATE 01000]
01:53:06: Drop WorkStepStatus_Previous20230828015305925 if it exists. [SQLSTATE 01000]
01:53:06: DBAmpAZ Operation FAILED. [SQLSTATE 01000]
01:53:07: Error: MirrorCopy program was unsuccessful. [SQLSTATE 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" "" [SQLSTATE 01000]
--- Ending SF_Mirror. Operation FAILED. [SQLSTATE 01000]
Error: SF_Mirror failed for table WorkStepStatus [SQLSTATE 01000]
Error 50000, Severity 16, State 1, Line 173 [SQLSTATE 01000]
--- Ending SF_Mirror. Operation FAILED. [SQLSTATE 01000]
Best answer by RonMoo
View original