Code Fix: An error occurs when you rebuild/reorganize the IX-SmartBroker_ServiceInstance_Guid

  • 30 September 2021
  • 0 replies
  • 1 view

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:





 





  1. Ensure you have the correct K2 version and/or Cumulative update installed. See KB001893 to see what Fix Pack level you have installed.


  2. Download the latest Fix Pack using the links in the table above for the version you require.


  3. Install the Fix Pack to apply the fix.



0 replies

Be the first to reply!

Reply