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 , 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=937) left join classement_detail_data d1 on (d1.id_classement_data=cdta.id and d1.id_config=938) left join classement_detail_data d2 on (d2.id_classement_data=cdta.id and d2.id_config=939) where isnull(cdta.state,'')<>'DNS' and cdta.id_Classement=7793 and (N'0' is null or cdta.idx-1>=N'0') and (N'499' is null or cdta.idx-1<=N'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, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
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.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 C:\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 C:\ChronoRace\git\chronorace-git\Modules\Infrastructure\Legacy\ChronoRace.Utilities.Sql\SqlTools.cs:line 572
ClientConnectionId:42535915-6e68-45d4-a1dc-f80d7d357143
Error Number:209,State:1,Class:16
ClientConnectionId before routing:6528af97-1417-4d3e-8f83-79724baefe31
Routing Destination:b36d11dc9a4e.tr16811.northeurope1-a.worker.database.windows.net,11043
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, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
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.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 C:\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 C:\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 C:\ChronoRace\git\chronorace-git\Modules\Infrastructure\Legacy\ChronoRace.Utilities.Sql\SqlTools.cs:line 596
at ChronoRace.Common.Sql.SqlTools.GetDataSet(DbConnectionProvider provider, IDbConnection conn, String qry) in C:\ChronoRace\git\chronorace-git\Modules\Infrastructure\Legacy\ChronoRace.Utilities.Sql\SqlTools.cs:line 612
at ChronoRace.Print.Report.PagingData.PerformPaging(ReportGeneratorConfig cfg, PagingConfig paging, CCQuery ccq, Boolean pageable, Int32 firstPage, Int32 lastPage) in C:\ChronoRace\git\chronorace-git\Modules\Legacy\ChronoRace.Print\Report\PagingTools.cs:line 107
at ReportGeneratorGadget.get_PagingList() in C:\ChronoRace\git\chronorace-git\Web\Registration\ChronoRace.WEB.Azure\Classements\Controls\ReportGeneratorControl.ascx.cs:line 57
at ReportGeneratorGadget.get_MasterRenderer() in C:\ChronoRace\git\chronorace-git\Web\Registration\ChronoRace.WEB.Azure\Classements\Controls\ReportGeneratorControl.ascx.cs:line 33
at ClassementsClassement.GenereRapport() in C:\ChronoRace\git\chronorace-git\Web\Registration\ChronoRace.WEB.Azure\Classements\Classement.aspx.cs:line 1012
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 , 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=937) left join classement_detail_data d1 on (d1.id_classement_data=cdta.id and d1.id_config=938) left join classement_detail_data d2 on (d2.id_classement_data=cdta.id and d2.id_config=939) where isnull(cdta.state,'')<>'DNS' and cdta.id_Classement=7793 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