Skip to main content
Language Selector

  1. Other Languages

    (machine translation)

Planview Customer Success Center

Archive database creation fails with error

  1. Last updated
  2. Save as PDF

Symptoms:
The execution of GenerateEmptyArcDestDB.dtsx fails with the error below. GenerateEmptyArcDestDB.sql file is not created.

Error/warning messages:
[Execute SQL Task] Error: Executing the query "EXEC ARC_GenerateEmptyArcDestDB ?, 0x0" failed with the following error: "A semi colon character was expected.
". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

Reason:
The error is caused by having an ampersand character ( & ) in any of the URL fields configured in System Manager (such as the “Careers URL” configured in System Manager>>Recruitment Management>>Configuration). Once this character is removed from the URL the DTSX package will work as expected.

Resolution:
Clear out the URL fields having this character before executing the dtsx package (i.e. cut and paste into Notepad temporarily). Put the values back after the package execution is completed.