Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




SQL Timeout / Custom Field Search via API

custom-fields
api
database

We are getting the following error occasionally when attempting to use the API to perform a search. The error is "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

We have "update statistics gemini_issues with fullscan" and this helped but has not eliminated the issue.

Here is a portion of the code used:

var oFilter = new IssuesFilterEN {
            ProjectID = string.Join("|", pProjectIds.Select(o => o.ToString()).ToArray()),
            SystemFilter = IssuesFilterEN.SystemFilterTypes.NoType,
            ExcludeClosed = false,
            CustomFields = new GenericEN[] {
                new GenericEN(VendorNumberFieldId, pVendorId)
            }
        };

        IssueEN[] foundIssues =  _COLTS.IssuesService.GetFilteredIssues(oFilter);
mmatos
· 1
mmatos
Replies (8)
helpful
0
not helpful

How many issues are coming back with that query? Can you post the exact error including stack trace?


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Number of issues is variable. Might be 20, might be 300.

Here are the errors (they always happen together):

ERROR 1:


Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. 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.ConsumeMetaData() 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) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) 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() at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd) at NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session) at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)

ERROR 2:


could not execute query [ SELECT this_.issueid as issueid38_9_, this_.projectid as projectid38_9_, this_.projectcode as projectc3_38_9_, this_.projectname as projectn4_38_9_, this_.typedesc as typedesc38_9_, this_.prioritydesc as priority6_38_9_, this_.severitydesc as severity7_38_9_, this_.statusdesc as statusdesc38_9_, this_.resdesc as resdesc38_9_, this_.reporteddesc as reporte10_38_9_, this_.versionname as version11_38_9_, this_.issuetypeid as issuety12_38_9_, this_.issuepriorityid as issuepr13_38_9_, this_.issueseverityid as issuese14_38_9_, this_.priorityseq as priorit15_38_9_, this_.severityseq as severit16_38_9_, this_.statusseq as statusseq38_9_, this_.issuestatusid as issuest18_38_9_, this_.issueresolutionid as issuere19_38_9_, this_.reportedby as reportedby38_9_, this_.fixedinversionid as fixedin21_38_9_, this_.summary as summary38_9_, this_.longdesc as longdesc38_9_, this_.created as created38_9_, this_.revised as revised38_9_, this_.issuekey as issuekey38_9_, this_.versionnumber as version27_38_9_, this_.versiondesc as version28_38_9_, this_.versionorder as version29_38_9_, this_.versionarchived as version30_38_9_, this_.versionreleased as version31_38_9_, this_.startdate as startdate38_9_, this_.duedate as duedate38_9_, this_.resolveddate as resolve34_38_9_, this_.closeddate as closeddate38_9_, this_.issuerisklevelid as issueri36_38_9_, this_.issuevotes as issuevotes38_9_, this_.userdata1 as userdata38_38_9_, this_.userdata2 as userdata39_38_9_, this_.userdata3 as userdata40_38_9_, this_.percentcomplete as percent41_38_9_, this_.estimatedays as estimat42_38_9_, this_.estimatehours as estimat43_38_9_, this_.estimateminutes as estimat44_38_9_, this_.riskdesc as riskdesc38_9_, this_.visibility as visibility38_9_, this_.visibilitymembertype as visibil47_38_9_, this_.parentissueid as parenti48_38_9_, this_.originatortype as origina49_38_9_, this_.originatorreply as origina50_38_9_, this_.originatordata as origina51_38_9_, this_.originatorprocessed as origina52_38_9_, this_.isparent as isparent38_9_, this_.hierarchykey as hierarc54_38_9_, this_.repeated as repeated38_9_, this_.tstamp as tstamp38_9_, (this_.estimatehours * 60 + this_.estimateminutes) as formula14_9_, comments1_.issueid as issueid11_, comments1_.commentid as commentid11_, comments1_.commentid as commentid39_0_, comments1_.userid as userid39_0_, comments1_.issueid as issueid39_0_, comments1_.projectid as projectid39_0_, comments1_.comment as comment39_0_, comments1_.username as username39_0_, comments1_.isclosing as isclosing39_0_, comments1_.visibility as visibility39_0_, comments1_.visibilitymembertype as visibili9_39_0_, comments1_.created as created39_0_, comments1_.tstamp as tstamp39_0_, customfiel2_.issueid as issueid12_, customfiel2_.customfielddataid as customfi1_12_, customfiel2_.customfielddataid as customfi1_14_1_, customfiel2_.customfieldid as customfi2_14_1_, customfiel2_.userid as userid14_1_, customfiel2_.projectid as projectid14_1_, customfiel2_.issueid as issueid14_1_, customfiel2_.fielddata as fielddata14_1_, customfiel2_.numericdata as numericd7_14_1_, customfiel2_.datedata as datedata14_1_, customfiel2_.created as created14_1_, customfiel2_.tstamp as tstamp14_1_, timeentrie3_.issueid as issueid13_, timeentrie3_.entryid as entryid13_, timeentrie3_.entryid as entryid44_2_, timeentrie3_.projectid as projectid44_2_, timeentrie3_.issueid as issueid44_2_, timeentrie3_.userid as userid44_2_, timeentrie3_.timetypeid as timetypeid44_2_, timeentrie3_.hours as hours44_2_, timeentrie3_.minutes as minutes44_2_, timeentrie3_.comment as comment44_2_, timeentrie3_.timeentrydate as timeentr9_44_2_, timeentrie3_.created as created44_2_, timeentrie3_.tstamp as tstamp44_2_, affectedve6_.issueid as issueid14_, affectedve6_.affectedversionid as affected1_14_, affectedve6_.affectedversionid as affected1_41_3_, affectedve6_.issueid as issueid41_3_, affectedve6_.versionid as versionid41_3_, affectedve6_.created as created41_3_, affectedve6_.tstamp as tstamp41_3_, versionen12_.versionid as versionid25_4_, versionen12_.projectid as projectid25_4_, versionen12_.versionnumber as versionn3_25_4_, versionen12_.versionname as versionn4_25_4_, versionen12_.versiondesc as versiond5_25_4_, versionen12_.versionreleased as versionr6_25_4_, versionen12_.versionorder as versiono7_25_4_, versionen12_.versionarchived as versiona8_25_4_, versionen12_.startdate as startdate25_4_, versionen12_.releasedate as release10_25_4_, versionen12_.parentversionid as parentv11_25_4_, versionen12_.created as created25_4_, versionen12_.tstamp as tstamp25_4_, resources4_.issueid as issueid15_, resources4_.issueresourceid as issueres1_15_, resources4_.issueresourceid as issueres1_42_5_, resources4_.issueid as issueid42_5_, resources4_.userid as userid42_5_, resources4_.created as created42_5_, resources4_.tstamp as tstamp42_5_, useren14_.userid as userid34_6_, useren14_.username as username34_6_, useren14_.firstname as firstname34_6_, useren14_.surname as surname34_6_, useren14_.pwd as pwd34_6_, useren14_.emailaddress as emailadd6_34_6_, useren14_.roles as roles34_6_, useren14_.created as created34_6_, useren14_.lastupdated as lastupda9_34_6_, useren14_.resetpwd as resetpwd34_6_, useren14_.active as active34_6_, useren14_.comment as comment34_6_, useren14_.apikey as apikey34_6_, useren14_.logindate as logindate34_6_, useren14_.previouslogindate as previou15_34_6_, useren14_.tstamp as tstamp34_6_, useren14_.firstname + ' ' + useren14_.surname as formula13_6_, components5_.issueid as issueid16_, components5_.issuecomponentid as issuecom1_16_, components5_.issuecomponentid as issuecom1_43_7_, components5_.issueid as issueid43_7_, components5_.componentid as componen3_43_7_, components5_.created as created43_7_, components5_.tstamp as tstamp43_7_, componente16_.componentid as componen1_31_8_, componente16_.projectid as projectid31_8_, componente16_.componentname as componen3_31_8_, componente16_.componentdesc as componen4_31_8_, componente16_.componentreadonly as componen5_31_8_, componente16_.userid as userid31_8_, componente16_.parentcomponentid as parentco7_31_8_, componente16_.componentorder as componen8_31_8_, componente16_.created as created31_8_, componente16_.tstamp as tstamp31_8_ FROM gemini_issuesview this_ left outer join gemini_issuecomments comments1_ on this_.issueid=comments1_.issueid left outer join gemini_customfielddata customfiel2_ on this_.issueid=customfiel2_.issueid left outer join gemini_timetracking timeentrie3_ on this_.issueid=timeentrie3_.issueid left outer join gemini_affectedversions affectedve6_ on this_.issueid=affectedve6_.issueid left outer join gemini_versions versionen12_ on affectedve6_.versionid=versionen12_.versionid left outer join gemini_issueresources resources4_ on this_.issueid=resources4_.issueid left outer join gemini_users useren14_ on resources4_.userid=useren14_.userid left outer join gemini_issuecomponents components5_ on this_.issueid=components5_.issueid left outer join gemini_components componente16_ on components5_.componentid=componente16_.componentid WHERE ((this_.visibilitymembertype=2 and @p286 in (select gg.userid from gemini_globalgroupmembership gg where gg.globalgroupid = this_.visibility)) or (this_.visibilitymembertype=3 and @p287 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, @p20, @p21, @p22, @p23, @p24, @p25, @p26) and this_.issueid in (@p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35, @p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47, @p48, @p49, @p50, @p51, @p52, @p53, @p54, @p55, @p56, @p57, @p58, @p59, @p60, @p61, @p62, @p63, @p64, @p65, @p66, @p67, @p68, @p69, @p70, @p71, @p72, @p73, @p74, @p75, @p76, @p77, @p78, @p79, @p80, @p81, @p82, @p83, @p84, @p85, @p86, @p87, @p88, @p89, @p90, @p91, @p92, @p93, @p94, @p95, @p96, @p97, @p98, @p99, @p100, @p101, @p102, @p103, @p104, @p105, @p106, @p107, @p108, @p109, @p110, @p111, @p112, @p113, @p114, @p115, @p116, @p117, @p118, @p119, @p120, @p121, @p122, @p123, @p124, @p125, @p126, @p127, @p128, @p129, @p130, @p131, @p132, @p133, @p134, @p135, @p136, @p137, @p138, @p139, @p140, @p141, @p142, @p143, @p144, @p145, @p146, @p147, @p148, @p149, @p150, @p151, @p152, @p153, @p154, @p155, @p156, @p157, @p158, @p159, @p160, @p161, @p162, @p163, @p164, @p165, @p166, @p167, @p168, @p169, @p170, @p171, @p172, @p173, @p174, @p175, @p176, @p177, @p178, @p179, @p180, @p181, @p182, @p183, @p184, @p185, @p186, @p187, @p188, @p189, @p190, @p191, @p192, @p193, @p194, @p195, @p196, @p197, @p198, @p199, @p200, @p201, @p202, @p203, @p204, @p205, @p206, @p207, @p208, @p209, @p210, @p211, @p212, @p213, @p214, @p215, @p216, @p217, @p218, @p219, @p220, @p221, @p222, @p223, @p224, @p225, @p226, @p227, @p228, @p229, @p230, @p231, @p232, @p233, @p234, @p235, @p236, @p237, @p238, @p239, @p240, @p241, @p242, @p243, @p244, @p245, @p246, @p247, @p248, @p249, @p250, @p251, @p252, @p253, @p254, @p255, @p256, @p257, @p258, @p259, @p260, @p261, @p262, @p263, @p264, @p265, @p266, @p267, @p268, @p269, @p270, @p271, @p272, @p273, @p274, @p275, @p276, @p277, @p278, @p279, @p280, @p281, @p282, @p283, @p284, @p285) ORDER BY this_.revised desc, this_.issueid desc ] Positional parameters: #0>62 #1>42 #2>64 #3>54 #4>36 #5>61 #6>60 #7>32 #8>55 #9>43 #10>57 #11>33 #12>41 #13>53 #14>44 #15>65 #16>18 #17>39 #18>51 #19>63 #20>50 #21>58 #22>37 #23>40 #24>34 #25>59 #26>49 #27>273142 #28>273141 #29>273139 #30>273137 #31>271854 #32>271238 #33>271776 #34>271773 #35>271770 #36>270839 #37>269860 #38>269861 #39>269862 #40>269863 #41>269864 #42>269865 #43>269866 #44>269867 #45>270812 #46>270986 #47>271143 #48>271140 #49>271133 #50>271132 #51>271131 #52>271128 #53>270164 #54>269779 #55>269784 #56>269774 #57>269776 #58>270004 #59>270007 #60>268882 #61>268881 #62>269663 #63>269542 #64>269541 #65>269538 #66>269523 #67>268985 #68>269292 #69>269127 #70>268618 #71>268522 #72>267891 #73>268467 #74>268466 #75>268073 #76>267217 #77>268244 #78>268245 #79>267378 #80>268107 #81>268103 #82>268101 #83>268100 #84>268098 #85>268096 #86>268094 #87>268092 #88>268091 #89>268089 #90>266491 #91>266341 #92>266533 #93>266343 #94>267212 #95>267108 #96>267110 #97>267107 #98>267111 #99>267158 #100>267106 #101>267104 #102>266849 #103>266495 #104>266848 #105>266847 #106>266579 #107>266557 #108>265233 #109>266072 #110>266492 #111>266494 #112>265558 #113>265591 #114>265504 #115>265550 #116>265547 #117>265507 #118>265511 #119>265515 #120>265516 #121>265519 #122>265520 #123>265557 #124>265502 #125>265498 #126>265497 #127>265494 #128>265493 #129>265492 #130>265491 #131>265489 #132>265537 #133>265151 #134>265602 #135>265404 #136>265402 #137>265400 #138>265399 #139>263643 #140>263617 #141>264068 #142>265112 #143>265016 #144>264842 #145>264840 #146>264838 #147>264837 #148>264836 #149>264834 #150>263610 #151>263766 #152>263725 #153>263564 #154>263198 #155>263665 #156>262935 #157>262040 #158>263430 #159>262128 #160>263309 #161>263380 #162>261577 #163>261442 #164>262129 #165>254413 #166>260913 #167>260911 #168>261866 #169>261512 #170>261054 #171>261053 #172>261826 #173>261469 #174>261279 #175>261280 #176>261055 #177>260951 #178>260956 #179>260647 #180>260648 #181>260650 #182>260651 #183>260652 #184>260654 #185>260617 #186>235177 #187>259889 #188>259581 #189>258309 #190>259076 #191>258998 #192>258912 #193>258911 #194>258910 #195>258909 #196>258786 #197>258385 #198>257764 #199>257763 #200>257637 #201>258121 #202>257184 #203>257182 #204>257183 #205>257028 #206>257029 #207>257290 #208>257291 #209>256878 #210>256876 #211>256874 #212>256872 #213>256333 #214>256332 #215>253945 #216>253947 #217>254486 #218>254490 #219>254492 #220>254493 #221>256103 #222>256102 #223>256101 #224>255744 #225>255849 #226>255847 #227>255854 #228>255741 #229>255740 #230>255851 #231>255846 #232>255256 #233>255257 #234>255543 #235>255392 #236>255179 #237>255259 #238>254412 #239>254702 #240>254705 #241>254500 #242>254398 #243>254399 #244>253899 #245>253511 #246>253510 #247>253404 #248>253405 #249>253395 #250>253394 #251>252973 #252>252979 #253>252980 #254>252981 #255>252986 #256>252972 #257>251706 #258>251205 #259>250959 #260>250750 #261>250575 #262>250573 #263>250572 #264>250154 #265>250072 #266>250071 #267>248314 #268>248106 #269>248104 #270>247842 #271>245500 #272>245501 #273>245502 #274>245503 #275>244865 #276>234078 #277>234079 #278>234080 #279>234082 #280>234083 #281>234084 #282>234085 #283>234086 #284>234087 #285>234077 [SQL: SELECT this_.issueid as issueid38_9_, this_.projectid as projectid38_9_, this_.projectcode as projectc3_38_9_, this_.projectname as projectn4_38_9_, this_.typedesc as typedesc38_9_, this_.prioritydesc as priority6_38_9_, this_.severitydesc as severity7_38_9_, this_.statusdesc as statusdesc38_9_, this_.resdesc as resdesc38_9_, this_.reporteddesc as reporte10_38_9_, this_.versionname as version11_38_9_, this_.issuetypeid as issuety12_38_9_, this_.issuepriorityid as issuepr13_38_9_, this_.issueseverityid as issuese14_38_9_, this_.priorityseq as priorit15_38_9_, this_.severityseq as severit16_38_9_, this_.statusseq as statusseq38_9_, this_.issuestatusid as issuest18_38_9_, this_.issueresolutionid as issuere19_38_9_, this_.reportedby as reportedby38_9_, this_.fixedinversionid as fixedin21_38_9_, this_.summary as summary38_9_, this_.longdesc as longdesc38_9_, this_.created as created38_9_, this_.revised as revised38_9_, this_.issuekey as issuekey38_9_, this_.versionnumber as version27_38_9_, this_.versiondesc as version28_38_9_, this_.versionorder as version29_38_9_, this_.versionarchived as version30_38_9_, this_.versionreleased as version31_38_9_, this_.startdate as startdate38_9_, this_.duedate as duedate38_9_, this_.resolveddate as resolve34_38_9_, this_.closeddate as closeddate38_9_, this_.issuerisklevelid as issueri36_38_9_, this_.issuevotes as issuevotes38_9_, this_.userdata1 as userdata38_38_9_, this_.userdata2 as userdata39_38_9_, this_.userdata3 as userdata40_38_9_, this_.percentcomplete as percent41_38_9_, this_.estimatedays as estimat42_38_9_, this_.estimatehours as estimat43_38_9_, this_.estimateminutes as estimat44_38_9_, this_.riskdesc as riskdesc38_9_, this_.visibility as visibility38_9_, this_.visibilitymembertype as visibil47_38_9_, this_.parentissueid as parenti48_38_9_, this_.originatortype as origina49_38_9_, this_.originatorreply as origina50_38_9_, this_.originatordata as origina51_38_9_, this_.originatorprocessed as origina52_38_9_, this_.isparent as isparent38_9_, this_.hierarchykey as hierarc54_38_9_, this_.repeated as repeated38_9_, this_.tstamp as tstamp38_9_, (this_.estimatehours * 60 + this_.estimateminutes) as formula14_9_, comments1_.issueid as issueid11_, comments1_.commentid as commentid11_, comments1_.commentid as commentid39_0_, comments1_.userid as userid39_0_, comments1_.issueid as issueid39_0_, comments1_.projectid as projectid39_0_, comments1_.comment as comment39_0_, comments1_.username as username39_0_, comments1_.isclosing as isclosing39_0_, comments1_.visibility as visibility39_0_, comments1_.visibilitymembertype as visibili9_39_0_, comments1_.created as created39_0_, comments1_.tstamp as tstamp39_0_, customfiel2_.issueid as issueid12_, customfiel2_.customfielddataid as customfi1_12_, customfiel2_.customfielddataid as customfi1_14_1_, customfiel2_.customfieldid as customfi2_14_1_, customfiel2_.userid as userid14_1_, customfiel2_.projectid as projectid14_1_, customfiel2_.issueid as issueid14_1_, customfiel2_.fielddata as fielddata14_1_, customfiel2_.numericdata as numericd7_14_1_, customfiel2_.datedata as datedata14_1_, customfiel2_.created as created14_1_, customfiel2_.tstamp as tstamp14_1_, timeentrie3_.issueid as issueid13_, timeentrie3_.entryid as entryid13_, timeentrie3_.entryid as entryid44_2_, timeentrie3_.projectid as projectid44_2_, timeentrie3_.issueid as issueid44_2_, timeentrie3_.userid as userid44_2_, timeentrie3_.timetypeid as timetypeid44_2_, timeentrie3_.hours as hours44_2_, timeentrie3_.minutes as minutes44_2_, timeentrie3_.comment as comment44_2_, timeentrie3_.timeentrydate as timeentr9_44_2_, timeentrie3_.created as created44_2_, timeentrie3_.tstamp as tstamp44_2_, affectedve6_.issueid as issueid14_, affectedve6_.affectedversionid as affected1_14_, affectedve6_.affectedversionid as affected1_41_3_, affectedve6_.issueid as issueid41_3_, affectedve6_.versionid as versionid41_3_, affectedve6_.created as created41_3_, affectedve6_.tstamp as tstamp41_3_, versionen12_.versionid as versionid25_4_, versionen12_.projectid as projectid25_4_, versionen12_.versionnumber as versionn3_25_4_, versionen12_.versionname as versionn4_25_4_, versionen12_.versiondesc as versiond5_25_4_, versionen12_.versionreleased as versionr6_25_4_, versionen12_.versionorder as versiono7_25_4_, versionen12_.versionarchived as versiona8_25_4_, versionen12_.startdate as startdate25_4_, versionen12_.releasedate as release10_25_4_, versionen12_.parentversionid as parentv11_25_4_, versionen12_.created as created25_4_, versionen12_.tstamp as tstamp25_4_, resources4_.issueid as issueid15_, resources4_.issueresourceid as issueres1_15_, resources4_.issueresourceid as issueres1_42_5_, resources4_.issueid as issueid42_5_, resources4_.userid as userid42_5_, resources4_.created as created42_5_, resources4_.tstamp as tstamp42_5_, useren14_.userid as userid34_6_, useren14_.username as username34_6_, useren14_.firstname as firstname34_6_, useren14_.surname as surname34_6_, useren14_.pwd as pwd34_6_, useren14_.emailaddress as emailadd6_34_6_, useren14_.roles as roles34_6_, useren14_.created as created34_6_, useren14_.lastupdated as lastupda9_34_6_, useren14_.resetpwd as resetpwd34_6_, useren14_.active as active34_6_, useren14_.comment as comment34_6_, useren14_.apikey as apikey34_6_, useren14_.logindate as logindate34_6_, useren14_.previouslogindate as previou15_34_6_, useren14_.tstamp as tstamp34_6_, useren14_.firstname + ' ' + useren14_.surname as formula13_6_, components5_.issueid as issueid16_, components5_.issuecomponentid as issuecom1_16_, components5_.issuecomponentid as issuecom1_43_7_, components5_.issueid as issueid43_7_, components5_.componentid as componen3_43_7_, components5_.created as created43_7_, components5_.tstamp as tstamp43_7_, componente16_.componentid as componen1_31_8_, componente16_.projectid as projectid31_8_, componente16_.componentname as componen3_31_8_, componente16_.componentdesc as componen4_31_8_, componente16_.componentreadonly as componen5_31_8_, componente16_.userid as userid31_8_, componente16_.parentcomponentid as parentco7_31_8_, componente16_.componentorder as componen8_31_8_, componente16_.created as created31_8_, componente16_.tstamp as tstamp31_8_ FROM gemini_issuesview this_ left outer join gemini_issuecomments comments1_ on this_.issueid=comments1_.issueid left outer join gemini_customfielddata customfiel2_ on this_.issueid=customfiel2_.issueid left outer join gemini_timetracking timeentrie3_ on this_.issueid=timeentrie3_.issueid left outer join gemini_affectedversions affectedve6_ on this_.issueid=affectedve6_.issueid left outer join gemini_versions versionen12_ on affectedve6_.versionid=versionen12_.versionid left outer join gemini_issueresources resources4_ on this_.issueid=resources4_.issueid left outer join gemini_users useren14_ on resources4_.userid=useren14_.userid left outer join gemini_issuecomponents components5_ on this_.issueid=components5_.issueid left outer join gemini_components componente16_ on components5_.componentid=componente16_.componentid WHERE ((this_.visibilitymembertype=2 and @p286 in (select gg.userid from gemini_globalgroupmembership gg where gg.globalgroupid = this_.visibility)) or (this_.visibilitymembertype=3 and @p287 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, @p20, @p21, @p22, @p23, @p24, @p25, @p26) and this_.issueid in (@p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35, @p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47, @p48, @p49, @p50, @p51, @p52, @p53, @p54, @p55, @p56, @p57, @p58, @p59, @p60, @p61, @p62, @p63, @p64, @p65, @p66, @p67, @p68, @p69, @p70, @p71, @p72, @p73, @p74, @p75, @p76, @p77, @p78, @p79, @p80, @p81, @p82, @p83, @p84, @p85, @p86, @p87, @p88, @p89, @p90, @p91, @p92, @p93, @p94, @p95, @p96, @p97, @p98, @p99, @p100, @p101, @p102, @p103, @p104, @p105, @p106, @p107, @p108, @p109, @p110, @p111, @p112, @p113, @p114, @p115, @p116, @p117, @p118, @p119, @p120, @p121, @p122, @p123, @p124, @p125, @p126, @p127, @p128, @p129, @p130, @p131, @p132, @p133, @p134, @p135, @p136, @p137, @p138, @p139, @p140, @p141, @p142, @p143, @p144, @p145, @p146, @p147, @p148, @p149, @p150, @p151, @p152, @p153, @p154, @p155, @p156, @p157, @p158, @p159, @p160, @p161, @p162, @p163, @p164, @p165, @p166, @p167, @p168, @p169, @p170, @p171, @p172, @p173, @p174, @p175, @p176, @p177, @p178, @p179, @p180, @p181, @p182, @p183, @p184, @p185, @p186, @p187, @p188, @p189, @p190, @p191, @p192, @p193, @p194, @p195, @p196, @p197, @p198, @p199, @p200, @p201, @p202, @p203, @p204, @p205, @p206, @p207, @p208, @p209, @p210, @p211, @p212, @p213, @p214, @p215, @p216, @p217, @p218, @p219, @p220, @p221, @p222, @p223, @p224, @p225, @p226, @p227, @p228, @p229, @p230, @p231, @p232, @p233, @p234, @p235, @p236, @p237, @p238, @p239, @p240, @p241, @p242, @p243, @p244, @p245, @p246, @p247, @p248, @p249, @p250, @p251, @p252, @p253, @p254, @p255, @p256, @p257, @p258, @p259, @p260, @p261, @p262, @p263, @p264, @p265, @p266, @p267, @p268, @p269, @p270, @p271, @p272, @p273, @p274, @p275, @p276, @p277, @p278, @p279, @p280, @p281, @p282, @p283, @p284, @p285) ORDER BY this_.revised desc, this_.issueid desc] at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes) at NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results) at NHibernate.Impl.CriteriaImpl.List(IList results) at NHibernate.Impl.CriteriaImpl.List() at CounterSoft.Gemini.DataProvider.xc0186e148e957052.GetFilteredIssues(IssuesFilterEN ifeFilter, Int32[] closedStatus, UserEN user, List`1 customFields, Object[] expressions) at CounterSoft.Gemini.Business.x95da312ae9372c2e.x3ea65f25dee0cd51(IssuesFilterEN x24b748b5be295dcb, List`1 x41ed9424bcef4dac, UserEN xfd92dbe2fa4bcb5a) at CounterSoft.Gemini.Business.x95da312ae9372c2e.x3ea65f25dee0cd51(IssuesFilterEN x24b748b5be295dcb, UserEN xfd92dbe2fa4bcb5a) at CounterSoft.Gemini.Presenter.IssuePresenter.GetFilteredIssues(IssuesFilterEN filter) at CounterSoft.Gemini.Web.Api.IssuesRestHandler.IssueFilter(RequestDetails rd)

mmatos
· 1
mmatos
helpful
0
not helpful

Does the error occur with a certain number of items (100+)? Try updating statistics on the gemini_customfielddata table.


Simran
· 1762
Simran
helpful
0
not helpful

Hello,

We tried updating statistics and it improved the issue for a while, however it has returned. In this case, we have a query that is returning 540 items when searching by custom field.

Please advise.


mmatos
· 1
mmatos
helpful
0
not helpful

Note: Gemini does not crash if I perform the search via UI / Item Filter. It only crashes when doing it via API.


mmatos
· 1
mmatos
helpful
0
not helpful

Which version of Gemini are you running? Try setting the optimization switches on in the web.config file.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

We are using Gemini v4.0.1 (Build 3038).

What optimization switches are you referring to? This is currently in the web.config:

    <add key="optimizeTime" value="no" />
    <add key="optimizeComments" value="no" />
    <add key="optimizeCustomFields" value="yes" />

mmatos
· 1
mmatos
helpful
0
not helpful

Have you altered your database? Run this command first: ALTER INDEX ALL ON gemini_issues REBUILD

Please change the optimizeTime, optimizeComments and the optimizeCustomFields value to yes.

Does this help?


Simran
· 1762
Simran