Solved

Error: Entity 'WorkStepStatus' is not supported by the Bulk API.

  • 29 August 2023
  • 1 reply
  • 54 views

Userlevel 1
Badge

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]

icon

Best answer by RonMoo 29 August 2023, 21:59

View original

1 reply

Userlevel 1
Badge
MISSION ACCOMPLISHED and the job executed successfully!!

 

Reply