Hi,
We're currently using Kentico 10.0.23.
I'm hoping that someone has seen this issue before and can assist.
No workflows have been changed from the default installation and adding a new workflow causes the same error.
Steps to reproduce:
From Dashboard; select Workflows -> Default workflow -> Steps
When the 'Steps' link is clicked, the following error is shown "[UniGrid] : Error during reloading data."
From the event log:
Source: UniGrid
Event code: RELOADDATA
Message:
WITH AllData AS
(
SELECT [StepID], [StepDisplayName], [StepType], [StepDefinition], ROW_NUMBER() OVER (ORDER BY [StepOrder]) AS [CMS_RN]
FROM CMS_WorkflowStep
WHERE ([StepWorkflowType] <> 3 OR [StepWorkflowType] IS NULL) AND (StepWorkflowID = )
)
SELECT , (SELECT COUNT() FROM AllData) AS [CMS_TOT]
FROM AllData
WHERE CMS_RN BETWEEN 1 AND 25
ORDER BY CMS_RN
Caused exception:
Incorrect syntax near ')'.
Exception type: System.Exception
Stack trace:
at CMS.DataEngine.AbstractDataConnection.HandleError(String queryText, Exception ex)
at CMS.DataEngine.AbstractDataConnection.ExecuteQuery(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, Boolean requiresTransaction)
at CMS.DataEngine.GeneralConnection.RunQuery(QueryParameters query)
at CMS.DataEngine.GeneralConnection.RunQueryWithRetry(QueryParameters query, Int32 retryCount)
at CMS.DataEngine.GeneralConnection.ExecuteQuery(QueryParameters query, Int32& totalRecords)
at CMS.DataEngine.DataQueryBase1.GetDataFromDBInternal()
at CMS.DataEngine.DataQueryBase1.GetDataFromDB()
at CMS.DataEngine.DataQueryBase1.GetData()
at CMS.DataEngine.DataQueryBase1.get_Result()
at CMS.DataEngine.ObjectQueryBase2.GetResults(IDataQuery query, Int32& totalRecords)
at CMS.DataEngine.DataQueryBase1.GetDataFromDB()
at CMS.DataEngine.DataQueryBase1.GetData()
at CMS.DataEngine.ObjectQueryBase2.GetData()
at CMS.DataEngine.DataQueryBase`1.get_Result()
at CMS.UIControls.UniGrid.LoadDataFromDataQuery(IDataQuery q, Boolean applySettings)
at CMS.UIControls.UniGrid.RetrieveData()
at CMS.UIControls.UniGrid.ReloadData()
Message: Incorrect syntax near ')'.