How Can We Help?
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
This has been updated and resolved within Service Release v6.0.1.
For more details, see the release notes.
Comments are closed.