Installer Errors When Creating New Site using the XMWorkspace Installer

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.