[SqlException (0x80131904): Der Argumentdatentyp ntext ist für das 1-Argument der lower-Funktion ungültig.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1950890
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846875
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
System.Data.SqlClient.SqlDataReader.get_MetaData() +83
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141
System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() +12
NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd) +229
NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session) +243
NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +201
NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +70
NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +102
[GenericADOException: could not execute query
[ SELECT distinct this_.issueid as y0_, this_.revised as y1_ FROM gemini_issuesview this_ left outer join gemini_affectedversions affectedve3_ on this_.issueid=affectedve3_.issueid left outer join gemini_issueresources resources1_ on this_.issueid=resources1_.issueid left outer join gemini_issuecomponents components2_ on this_.issueid=components2_.issueid WHERE ((this_.visibilitymembertype=2 and @p67 in (select gg.userid from gemini_globalgroupmembership gg where gg.globalgroupid = this_.visibility)) or (this_.visibilitymembertype=3 and @p68 in (select pg.userid from gemini_projectgroupmembership pg where pg.projectgroupid = this_.visibility))) AND this_.projectid in (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15, @p16, @p17, @p18, @p19) and not (this_.issuestatusid in (@p20, @p21, @p22)) and ((((lower(this_.summary) like @p23 or lower(this_.longdesc) like @p24))) or this_.issueid in (SELECT distinct this_0_.issueid as y0_ FROM gemini_issuecomments this_0_ WHERE this_0_.projectid in (@p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35, @p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44) and (((lower(this_0_.comment) like @p45)))) or this_.issueid in (SELECT distinct this_0_.issueid as y0_ FROM gemini_customfielddata this_0_ WHERE this_0_.projectid in (@p46, @p47, @p48, @p49, @p50, @p51, @p52, @p53, @p54, @p55, @p56, @p57, @p58, @p59, @p60, @p61, @p62, @p63, @p64, @p65) and (((lower(this_0_.fielddata) like @p66))))) ORDER BY this_.revised desc, this_.issueid desc ]
Positional parameters: #0>25 #1>14 #2>18 #3>11 #4>30 #5>26 #6>19 #7>22 #8>13 #9>28 #10>15 #11>21 #12>23 #13>20 #14>12 #15>17 #16>24 #17>29 #18>16 #19>27 #20>13 #21>8 #22>4 #23>%lsls% #24>%lsls% #25>25 #26>14 #27>18 #28>11 #29>30 #30>26 #31>19 #32>22 #33>13 #34>28 #35>15 #36>21 #37>23 #38>20 #39>12 #40>17 #41>24 #42>29 #43>16 #44>27 #45>%lsls% #46>25 #47>14 #48>18 #49>11 #50>30 #51>26 #52>19 #53>22 #54>13 #55>28 #56>15 #57>21 #58>23 #59>20 #60>12 #61>17 #62>24 #63>29 #64>16 #65>27 #66>%lsls%
[SQL: SELECT distinct this_.issueid as y0_, this_.revised as y1_ FROM gemini_issuesview this_ left outer join gemini_affectedversions affectedve3_ on this_.issueid=affectedve3_.issueid left outer join gemini_issueresources resources1_ on this_.issueid=resources1_.issueid left outer join gemini_issuecomponents components2_ on this_.issueid=components2_.issueid WHERE ((this_.visibilitymembertype=2 and @p67 in (select gg.userid from gemini_globalgroupmembership gg where gg.globalgroupid = this_.visibility)) or (this_.visibilitymembertype=3 and @p68 in (select pg.userid from gemini_projectgroupmembership pg where pg.projectgroupid = this_.visibility))) AND this_.projectid in (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15, @p16, @p17, @p18, @p19) and not (this_.issuestatusid in (@p20, @p21, @p22)) and ((((lower(this_.summary) like @p23 or lower(this_.longdesc) like @p24))) or this_.issueid in (SELECT distinct this_0_.issueid as y0_ FROM gemini_issuecomments this_0_ WHERE this_0_.projectid in (@p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35, @p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44) and (((lower(this_0_.comment) like @p45)))) or this_.issueid in (SELECT distinct this_0_.issueid as y0_ FROM gemini_customfielddata this_0_ WHERE this_0_.projectid in (@p46, @p47, @p48, @p49, @p50, @p51, @p52, @p53, @p54, @p55, @p56, @p57, @p58, @p59, @p60, @p61, @p62, @p63, @p64, @p65) and (((lower(this_0_.fielddata) like @p66))))) ORDER BY this_.revised desc, this_.issueid desc]]
NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +196
NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) +18
NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes) +79
NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results) +406
NHibernate.Impl.CriteriaImpl.List(IList results) +41
NHibernate.Impl.CriteriaImpl.List() +35
CounterSoft.Gemini.DataProvider.xc0186e148e957052.GetFilteredIssuesID(IssuesFilterEN ifeFilter, Int32[] closedStatus, UserEN user, List`1 customFields) +4361
CounterSoft.Gemini.Business.x95da312ae9372c2e.GetFilteredIssuesID(IssuesFilterEN ifeFilter, List`1 allCustomFields, UserEN user) +143
CounterSoft.Gemini.Business.x95da312ae9372c2e.xa91f976c95cc24f6(IssuesFilterEN x24b748b5be295dcb, Int32 x6085dd2d6dae9673, Int32 x870a8f396af517a1, Int32& x42a948eff01be1b6, Int32& x8c5725b36c3fef30, Int32& x93a2c901eb10cf80, UserEN xfd92dbe2fa4bcb5a) +97
CounterSoft.Gemini.Web.Controls.IssuesGridUC.BindData() +773
CounterSoft.Gemini.Web.Controls.IssuesGridUC.Page_Load(Object sender, EventArgs e) +50
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +50
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627
|