News. Culture. Débats. Genève.
Erreur de rendu non gérée dans 'HomeNewsByCategory' part: System.Exception: System.Data.SqlClient.SqlException: Transaction (Process ID 55) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.HasMoreRows()
at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)
at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
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(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at IceCube.Common.GetDataViewByQuery(String strQuery, SqlParameter[] prms) in C:\Repository\Core\IceCube_Business35\Common.cs:line 1689
;WITH C AS (SELECT o.ID, d.Title_Documents, ROW_NUMBER() OVER(ORDER BY d.CreateDate_Documents DESC) AS RN, COUNT(*) OVER() AS TotalCount FROM Document d INNER JOIN Object o ON o.ID = d.ObjectID WHERE d.IDNavigation = @IDNavigation AND d.Available_Document = 1 AND d.Visible_Document = 1 AND d.Published = 1 AND o.ID NOT IN (317916,317908,317907,317379,317377,317376,317355)) SELECT * FROM C WHERE RN > 0 AND RN < @MaxNews
at IceCube.Common.GetDataViewByQuery(String strQuery, SqlParameter[] prms) in C:\Repository\Core\IceCube_Business35\Common.cs:line 1716
at ASP.htdocs_modules_news_templates_homenewsbycategory_ascx.GetNews(Int32 navigationId, Int32 maxNews, String strNewsIdToExclude)
at ASP.htdocs_modules_news_templates_homenewsbycategory_ascx.__Render__control1(HtmlTextWriter __w, Control parameterContainer)
at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
at IceCube.Web.UI.StatelessControlContainerPage.RenderControl(Control ctl) in C:\Repository\Core\IceCube_Business35\Web\StatelessControlContainerPage.cs:line 71
at IceCube.Rendering.CallPartBlockInfo.ToString() in C:\Repository\Core\IceCube_Business35\Rendering\CallPartBlockInfo.cs:line 68