Lors de l'exécution de [select cdta.id_Classement as sH_IdClassement, case when isnull(cdta.state,'')='' then cast(cdta.pos as varchar)+'.' else cdta.state end as [sR_#POS] , cdta.dossard as [sI_#NR] , cdta.licence as [sC_#LICENCE] ,case when isnull(privacy,0)&8192!=0 then 'ANONYMOUS' else isnull(nom,'')+' '+isnull(prenom,'') end as [sB_#NAME] , case when year(cdta.naissance)>1900 then cast(2012-year(cdta.naissance) as varchar) else '' end as [sC_#AGE] , isnull(cdta.nationalite,cdta.pays) as [sC_#NAT] , left(cdta.club_open,15) as [#OPEN] , cdta.tours as [sR_##] ,d0.temps as gDetails_t_t1,d1.temps as gDetails_t_t2,d2.temps as gDetails_t_t3,d3.temps as gDetails_t_t4 , cdta.officiel as [sB_t_#OFFICIEL] , cdta.categ as [g#CATEGORIE_#NOMCATEG] , cdta.ville as [sI_#LOCALITE] from classement_data cdta left join classement_detail_data d0 on (d0.id_classement_data=cdta.id and d0.id_config=974) left join classement_detail_data d1 on (d1.id_classement_data=cdta.id and d1.id_config=975) left join classement_detail_data d2 on (d2.id_classement_data=cdta.id and d2.id_config=976) left join classement_detail_data d3 on (d3.id_classement_data=cdta.id and d3.id_config=977) where isnull(cdta.state,'')<>'DNS' and cdta.id_Classement=7803 and ('0' is null or cdta.idx-1>='0') and ('499' is null or cdta.idx-1<='499') and (null is null or cdta.ville like null) and (null is null or cdta.club_ligue like null) and (null is null or cdta.club_open like null) and (null is null or cdta.categ = null) and (null is null or (cdta.dossard=null) or (isnull(cdta.nom,cdta.prenom) like null) ) order by cdta.idx ]: System.Data.SqlClient.SqlException (0x80131904): Ambiguous column name 'nom'. 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.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, TaskCompletionSource`1 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 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:de9e8e64-2a39-4883-b3a8-8dace2523a82 Error Number:209,State:1,Class:16 ClientConnectionId before routing:b013476d-3df5-494b-bd52-985ce0ba21eb Routing Destination:b2c289c1c6f9.tr22.northeurope1-a.worker.database.windows.net,11144 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.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, TaskCompletionSource`1 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 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.PagingData.PerformPaging(ReportGeneratorConfig cfg, PagingConfig paging, CCQuery ccq, Boolean pageable, Int32 firstPage, Int32 lastPage) in D:\ChronoRace\git\chronorace-git\Modules\Legacy\ChronoRace.Print\Report\PagingTools.cs:line 107
at ReportGeneratorGadget.get_PagingList() in D:\ChronoRace\git\chronorace-git\Web\Registration\ChronoRace.WEB.Azure\Classements\Controls\ReportGeneratorControl.ascx.cs:line 59
at ReportGeneratorGadget.get_MasterRenderer() in D:\ChronoRace\git\chronorace-git\Web\Registration\ChronoRace.WEB.Azure\Classements\Controls\ReportGeneratorControl.ascx.cs:line 34
at ClassementsClassement.GenereRapport() in D:\ChronoRace\git\chronorace-git\Web\Registration\ChronoRace.WEB.Azure\Classements\Classement.aspx.cs:line 975

Query: select cdta.id_Classement as sH_IdClassement, case when isnull(cdta.state,'')='' then cast(cdta.pos as varchar)+'.' else cdta.state end as [sR_#POS] , cdta.dossard as [sI_#NR] , cdta.licence as [sC_#LICENCE] ,case when isnull(privacy,0)&8192!=0 then 'ANONYMOUS' else isnull(nom,'')+' '+isnull(prenom,'') end as [sB_#NAME] , case when year(cdta.naissance)>1900 then cast(2012-year(cdta.naissance) as varchar) else '' end as [sC_#AGE] , isnull(cdta.nationalite,cdta.pays) as [sC_#NAT] , left(cdta.club_open,15) as [#OPEN] , cdta.tours as [sR_##] ,d0.temps as gDetails_t_t1,d1.temps as gDetails_t_t2,d2.temps as gDetails_t_t3,d3.temps as gDetails_t_t4 , cdta.officiel as [sB_t_#OFFICIEL] , cdta.categ as [g#CATEGORIE_#NOMCATEG] , cdta.ville as [sI_#LOCALITE] from classement_data cdta left join classement_detail_data d0 on (d0.id_classement_data=cdta.id and d0.id_config=974) left join classement_detail_data d1 on (d1.id_classement_data=cdta.id and d1.id_config=975) left join classement_detail_data d2 on (d2.id_classement_data=cdta.id and d2.id_config=976) left join classement_detail_data d3 on (d3.id_classement_data=cdta.id and d3.id_config=977) where isnull(cdta.state,'')<>'DNS' and cdta.id_Classement=7803 and ($first is null or cdta.idx-1>=$first) and ($last is null or cdta.idx-1<=$last) and ($Localite is null or cdta.ville like $LocaliteLike) and ($Ligue is null or cdta.club_ligue like $LigueLike) and ($Open is null or cdta.club_open like $OpenLike) and ($Categ is null or cdta.categ = $Categ) and ($All is null or (cdta.dossard=$All) or (isnull(cdta.nom,cdta.prenom) like $AllLike) ) order by cdta.idx