[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
|