Installer Errors When Creating New Site using the XMWorkspace Installer

How Can We Help?

< Back

When attempting to create a new site using the XMWorkspace installer it fails returning an error and the following is within the EventLog on the server:

DatabaseFunctions.ExecuteSqlScripts [File: ‘C:\Program Files (x86)\XMPro Pty Ltd\XMWorkspace\\Data\stored_procs\fc_Core_Pending ActivitiesSearch_MyGroups.sql’]: Incorrect syntax near the keyword ‘SELECT’.

DatabaseFunctions.ExecuteSqlScripts [File: ‘C:\Program Files (x86)\XMPro Pty Ltd\XMWorkspace\\Data\stored_procs\fc_Core_Pending ActivitiesSearch_RolesRoutingToMe.sql’]: Incorrect syntax near the keyword ‘AND’.

Incorrect syntax near ‘)’.

Resolution

Once the installer has successfully installed and prior to the wizard running navigate to C:\Program Files (x86)\XMPro Pty Ltd\XMWorkspace\Data

  • Unzip the attached file
  • Copy the attached language file into that directory (here)
  • Copy the two .sql files into the stored_procs directory
  • Run the installer wizard for the site

Files

This has been updated and resolved within Service Release v6.0.1.

For more details, see the release notes.

Comments are closed.

This is the legacy version of the XMPro Documentation site. For the latest XMPro documentation, please visit documentation.xmpro.com

X