Lors de l'exécution de [select cdta.id_Classement as sH_IdClassement, case when isnull(state,'')='' then cast(pos_categ as varchar)+'.' else state end as [sR_#RANG] , dossard as [sI_#NR] , case when sexe<>'M' then sexe else '' end as sC_ ,case when isnull(privacy,0)&8192!=0 then 'ANONYMOUS' else isnull(nom,'')+' '+isnull(prenom,'') end as [sB_#NAME] , case when year(naissance)>1900 then cast(2018-year(naissance) as varchar) else '' end as [sC_#AGE] , isnull(nationalite,pays) as [sC_#NAT] , left(club_open,25) as [#OPEN] , officiel as [sB_t_#OFFICIEL] , case when pos>0 then officiel/(cast(isnull(distance,0) as float)/1000.0) else 0 end as [t_#TKM] , case when pos>0 and isnull(officiel,0)>0 then str(cast(isnull(distance,0) as float)/cast(officiel as float)*3600.0,6,2) else '' end as [sI_#MOYENNE] , pos as [sIL_#SCRATCH] , ville as [sI_#LOCALITE] from classement_data cdta where isnull(state,'')<>'DNS' and id_Classement=17171 and (null is null or idx-1>=null) and (null is null or idx-1<=null) and (null is null or ville like null) and (null is null or club_ligue like null) and (null is null or club_open like null) and ('DAM' is null or categ = 'DAM') and (null is null or (dossard=null) or (isnull(nom,prenom) like null) ) order by idx ]: System.Data.SqlClient.SqlException (0x80131904): Divide by zero error encountered. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 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.TryHasMoreRows(Boolean& moreRows) at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) at System.Data.SqlClient.SqlDataReader.Read() 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(DataSet dataSet, String srcTable, 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(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at ChronoRace.Common.Sql.SqlTools.<>c__DisplayClass34_0.b__1() in D:\ChronoRace\git\chronorace-git\Modules\Infrastructure\Legacy\ChronoRace.Utilities.Sql\SqlTools.cs:line 579 at Microsoft.Practices.EnterpriseLibrary.TransientFaultHandling.RetryPolicy.<>c__DisplayClass1.b__0() at Microsoft.Practices.EnterpriseLibrary.TransientFaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func) at ChronoRace.Common.Sql.SqlTools.GetDataSet(DbConnectionProvider provider, IDbConnection conn, String qry, DataSet ds) in D:\ChronoRace\git\chronorace-git\Modules\Infrastructure\Legacy\ChronoRace.Utilities.Sql\SqlTools.cs:line 572 ClientConnectionId:d3698b3e-09ef-4815-bf9d-9e3f0e796e1e Error Number:8134,State:1,Class:16 ClientConnectionId before routing:86ebb7d5-ce25-4554-803d-ffc446f98742 Routing Destination:b2c9a3bf24fa.tr642.northeurope1-a.worker.database.windows.net,11042 at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 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.TryHasMoreRows(Boolean& moreRows) at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) at System.Data.SqlClient.SqlDataReader.Read() 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(DataSet dataSet, String srcTable, 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(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at ChronoRace.Common.Sql.SqlTools.<>c__DisplayClass34_0.b__1() in D:\ChronoRace\git\chronorace-git\Modules\Infrastructure\Legacy\ChronoRace.Utilities.Sql\SqlTools.cs:line 579 at Microsoft.Practices.EnterpriseLibrary.TransientFaultHandling.RetryPolicy.<>c__DisplayClass1.b__0() at Microsoft.Practices.EnterpriseLibrary.TransientFaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func) at ChronoRace.Common.Sql.SqlTools.GetDataSet(DbConnectionProvider provider, IDbConnection conn, String qry, DataSet ds) in D:\ChronoRace\git\chronorace-git\Modules\Infrastructure\Legacy\ChronoRace.Utilities.Sql\SqlTools.cs:line 572
at ChronoRace.Common.Sql.SqlTools.GetDataSet(DbConnectionProvider provider, IDbConnection conn, String qry, DataSet ds) in D:\ChronoRace\git\chronorace-git\Modules\Infrastructure\Legacy\ChronoRace.Utilities.Sql\SqlTools.cs:line 601
at ChronoRace.Common.Sql.SqlTools.GetDataSet(DbConnectionProvider provider, IDbConnection conn, String qry) in D:\ChronoRace\git\chronorace-git\Modules\Infrastructure\Legacy\ChronoRace.Utilities.Sql\SqlTools.cs:line 612
at ChronoRace.Common.Sql.DataSetCache.GetDataSet(DbConnectionProvider provider, String qry) in D:\ChronoRace\git\chronorace-git\Modules\Infrastructure\Legacy\ChronoRace.Utilities.Sql\DataSetCache.cs:line 53
at ChronoRace.Print.Report.ReportGeneratorConfig.BuildGeneratorConfig(CCQuery ccq, Boolean pageable) in D:\ChronoRace\git\chronorace-git\Modules\Legacy\ChronoRace.Print\Report\ReportGeneratorConfig.cs:line 123
at ReportGeneratorGadget.get_Config() in D:\ChronoRace\git\chronorace-git\Web\Registration\ChronoRace.WEB.Azure\Classements\Controls\ReportGeneratorControl.ascx.cs:line 89
at ClassementsClassement.GenereRapport() in D:\ChronoRace\git\chronorace-git\Web\Registration\ChronoRace.WEB.Azure\Classements\Classement.aspx.cs:line 974

Query: select cdta.id_Classement as sH_IdClassement, case when isnull(state,'')='' then cast(pos_categ as varchar)+'.' else state end as [sR_#RANG] , dossard as [sI_#NR] , case when sexe<>'M' then sexe else '' end as sC_ ,case when isnull(privacy,0)&8192!=0 then 'ANONYMOUS' else isnull(nom,'')+' '+isnull(prenom,'') end as [sB_#NAME] , case when year(naissance)>1900 then cast(2018-year(naissance) as varchar) else '' end as [sC_#AGE] , isnull(nationalite,pays) as [sC_#NAT] , left(club_open,25) as [#OPEN] , officiel as [sB_t_#OFFICIEL] , case when pos>0 then officiel/(cast(isnull(distance,0) as float)/1000.0) else 0 end as [t_#TKM] , case when pos>0 and isnull(officiel,0)>0 then str(cast(isnull(distance,0) as float)/cast(officiel as float)*3600.0,6,2) else '' end as [sI_#MOYENNE] , pos as [sIL_#SCRATCH] , ville as [sI_#LOCALITE] from classement_data cdta where isnull(state,'')<>'DNS' and id_Classement=17171 and (null is null or idx-1>=null) and (null is null or idx-1<=null) and (null is null or ville like null) and (null is null or club_ligue like null) and (null is null or club_open like null) and ('DAM' is null or categ = 'DAM') and (null is null or (dossard=null) or (isnull(nom,prenom) like null) ) order by idx