Server Error in '/' Application.

Conversion failed when converting the nvarchar value 'Nidau' to data type int.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Conversion failed when converting the nvarchar value 'Nidau' to data type int.

Source Error:


Line 204:        UserInfo ui = MembershipContext.AuthenticatedUser;
Line 205:        TreeProvider tree = new TreeProvider(ui);
Line 206:        InfoDataSet<CMS.DocumentEngine.TreeNode> ds = tree.SelectNodes(SiteContext.CurrentSiteName, "/%", TreeProvider.ALL_CULTURES, true, "CMS.Library", where, orderby, -1, true, 0, "Type,Name,ZIP,City,Region,DocumentCulture,NodeID,NodeGUID,NodeAlias,NodeAliasPath");
Line 207:        return ds;
Line 208:    }

Source File: e:\1PROD\BiblioBE\KenticoCMS_biblioBE\CMS\CMSTemplates\Controls\BibliothekenOverview.ascx.cs    Line: 206

Stack Trace:


[SqlException (0x80131904): Conversion failed when converting the nvarchar value 'Nidau' to data type int.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +3357524
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +334
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4679
   System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows) +255
   System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) +298
   System.Data.SqlClient.SqlDataReader.Read() +43
   System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) +166
   System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) +219
   System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) +492
   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +289
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +180
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +126
   CMS.DataEngine.AbstractDataConnection.ExecuteQuery(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, Boolean requiresTransaction) +254

[Exception: 
[DataConnection.HandleError]: 

Query: 
SELECT [Type], [Name], [ZIP], [City], [Region], [DocumentCulture], [NodeID], [NodeGUID], [NodeAlias], [NodeAliasPath]
FROM (
SELECT [Type], [Name], [ZIP], [City], [Region], [DocumentCulture], [NodeID], [NodeGUID], [NodeAlias], [NodeAliasPath], ROW_NUMBER() OVER (PARTITION BY NodeID ORDER BY CASE WHEN [DocumentCulture] = @DocumentCulture THEN 1 ELSE 2 END, DocumentCulture) AS [CMS_C], ROW_NUMBER() OVER (ORDER BY City%20ASC) AS [CMS_ORN]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CMS_Library AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[LibraryID] AND V.ClassName = N'CMS.Library' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE (LibraryID > 0 AND Type = 1) AND [NodeSiteID] = @NodeSiteID AND ([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now))
) AS SubData
WHERE [CMS_C] = @CMS_C
ORDER BY CMS_ORN

Caused exception: 
Conversion failed when converting the nvarchar value 'Nidau' to data type int.
]
   CMS.DataEngine.AbstractDataConnection.HandleError(String queryText, Exception ex) +229
   CMS.DataEngine.AbstractDataConnection.ExecuteQuery(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, Boolean requiresTransaction) +612
   CMS.DataEngine.GeneralConnection.RunQuery(QueryParameters query) +341
   CMS.DataEngine.GeneralConnection.RunQueryWithRetry(QueryParameters query, Int32 retryCount) +188
   CMS.DataEngine.GeneralConnection.ExecuteQuery(QueryParameters query, Int32& totalRecords) +67
   CMS.DataEngine.DataQueryBase`1.GetDataFromDBInternal() +128
   CMS.DataEngine.DataQueryBase`1.GetDataFromDB() +61
   CMS.DataEngine.DataQueryBase`1.GetData() +133
   CMS.DataEngine.DataQueryBase`1.get_Result() +118
   CMS.DataEngine.ObjectQueryBase`2.GetResults(IDataQuery query, Int32& totalRecords) +43
   CMS.DataEngine.DataQueryBase`1.GetDataFromDB() +97
   CMS.DocumentEngine.DocumentQueryBase`2.<GetDataFromDB>b__2() +9
   CMS.DocumentEngine.DocumentQueryProperties.GetDataInternal(IDocumentQuery query, Func`1 baseGetDataMethod, Action`1 setTotalRecords) +49
   CMS.DataEngine.DataQueryBase`1.GetData() +133
   CMS.DataEngine.ObjectQueryBase`2.GetData() +183
   CMS.DocumentEngine.DocumentQueryBase`2.GetData() +97
   CMS.DataEngine.DataQueryBase`1.get_Result() +118
   CMS.DataEngine.DataQueryBase`1.GetResults(IDataQuery query, Int32& totalRecords) +34
   CMS.DataEngine.DataQueryBase`1.GetDataFromDB() +97
   CMS.DocumentEngine.MultiDocumentQueryBase`3.<GetDataFromDB>b__4() +9
   CMS.DocumentEngine.DocumentQueryProperties.GetDataInternal(IDocumentQuery query, Func`1 baseGetDataMethod, Action`1 setTotalRecords) +49
   CMS.DataEngine.DataQueryBase`1.GetData() +133
   CMS.DataEngine.DataQueryBase`1.get_Result() +118
   CMS.DataEngine.MultiObjectQueryBase`3.EnsureTypedResult() +24
   CMS.DocumentEngine.Compatibility.NodesDataProvider.GetDataSet() +26
   CMSTemplates_Controls_BibliothekenOverview.Data(String orderby, String where) in e:\1PROD\BiblioBE\KenticoCMS_biblioBE\CMS\CMSTemplates\Controls\BibliothekenOverview.ascx.cs:206
   CMSTemplates_Controls_BibliothekenOverview.getData() in e:\1PROD\BiblioBE\KenticoCMS_biblioBE\CMS\CMSTemplates\Controls\BibliothekenOverview.ascx.cs:280
   CMSTemplates_Controls_BibliothekenOverview.Page_Load(Object sender, EventArgs e) in e:\1PROD\BiblioBE\KenticoCMS_biblioBE\CMS\CMSTemplates\Controls\BibliothekenOverview.ascx.cs:52
   System.Web.UI.Control.OnLoad(EventArgs e) +108
   System.Web.UI.Control.LoadRecursive() +90
   System.Web.UI.Control.LoadRecursive() +185
   System.Web.UI.Control.LoadRecursive() +185
   System.Web.UI.Control.LoadRecursive() +185
   System.Web.UI.Control.LoadRecursive() +185
   System.Web.UI.Control.LoadRecursive() +185
   System.Web.UI.Control.LoadRecursive() +185
   System.Web.UI.Control.LoadRecursive() +185
   System.Web.UI.Control.LoadRecursive() +185
   System.Web.UI.Control.LoadRecursive() +185
   System.Web.UI.Control.LoadRecursive() +185
   System.Web.UI.Control.LoadRecursive() +185
   System.Web.UI.Control.LoadRecursive() +185
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1602


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.9224.0