Issue Description
When you have a need to rebuild/reorganize the IX-SmartBroker_ServiceInstance_Guid the [Utility].[Maintain_IndexDefrag] stored procedure fails, and an error occurs.
Error Message:
The following error occurs: “[SQLSTATE 01000] (Message 50000) Incorrect syntax near '-'.”
Resolution
The fix is available in:
- K2 Five (5.3) November 2020 Cumulative Update Fix Pack 23.
- K2 Five (5.4) Fix Pack 47.
- Ensure you have the correct K2 version and/or Cumulative update installed. See KB001893 to see what Fix Pack level you have installed.
- Download the latest Fix Pack using the links in the table above for the version you require.
- Install the Fix Pack to apply the fix.