Adding new server to Staging app => [UniGrid] : Error during reloading data

Have you checked the event log in Kentico?

Have you checked the documentation to see if you have configured your servers correctly?

Was Content Staging setup before and just stopped working or was it never setup?

The event log has the following event after I create a new server using the Staging app:

Event ID: 1260 Event type: Information Event time: 8/17/2015 2:44:41 PM Source: Staging server Event code: CREATEOBJ User ID: 53 User name: administrator IP address: ::1 Description: Create Staging server 'scg2015dev'

It says it's saved successfully, but then if I go to the All Tasks page, and then back to the Staging->Servers page, it shows the Unigrid error.

From the log:

Error Event time: 8/17/2015 2:49:30 PM Source: UniGrid Event code: RELOADDATA User ID: 53 User name: administrator IP address: ::1 Description: Message:

WITH AllData AS ( SELECT [ServerID], [ServerDisplayName], [ServerEnabled], ROW_NUMBER() OVER (ORDER BY ServerDisplayName) AS [CMS_RN] FROM Staging_Server WHERE (ServerSiteID = ) ) 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 ')'.

Also, this is a new set up for us, and we are just starting with Kentico because it's the system our client wants to use. We haven't been able to get any Staging to work, and we're currently just trying to get our environment and work flow up and working so our team can get started on our client's website.

I notice that the SQL syntax error is in the '(ServerSiteID = )' clause. I exported the site from our dev server and then imported it onto my local dev box. Is it possible the import process missed something?

I've also noticed that all of my attempts to create a Server are stored in the Kentico database. The error shows up when trying to see the list of servers, and when trying to get Staging to work.

I have also encountered this error. I have staging working from our dev to staging servers. I get this error when i try to view the servers that are added to the staging environment. You can find the information from the event log below.

Message:

WITH AllData AS ( SELECT [ServerID], [ServerDisplayName], [ServerEnabled], ROW_NUMBER() OVER (ORDER BY ServerDisplayName) AS [CMS_RN] FROM Staging_Server WHERE (ServerSiteID = ) ) 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.ExecuteQuery(QueryParameters query) at CMS.DataEngine.GeneralConnection.ExecuteQuery(QueryParameters query, Int32& totalRecords) 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.ObjectQueryBase2.GetDataFromDB() at CMS.DataEngine.DataQueryBase1.GetData() at CMS.DataEngine.ObjectQueryBase2.GetData() at CMS.DataEngine.DataQueryBase1.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 ')'.

Exception type: System.Data.SqlClient.SqlException Stack Trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at CMS.DataEngine.AbstractDataConnection.ExecuteQuery(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, Boolean requiresTransaction)

Message: DataConnection.HandleError: