Time-out when trying to edit Field Visibility Scheme
I have seen that others also have this problem, but I have yet to see a resolution.
In the past two days, we upgraded from 2.2.4 to 2.2.7 and then to 3.0.4. All went quite (seemingly) well, though we did need to remove some (dead) records from the projectversionattributevalues table before the update scripts would execute cleanly.
Now, having checked things out, we have created a couple of Field Visibility Schemes, and when we try to edit these, we get a time-out error.
Looking in the system log, we have:
Request timed out.12/09/2008 10:49:48
Thread was being aborted.12/09/2008 10:49:48
at SNINativeMethodWrapper.SNIPacketGetConnection(IntPtr packet) at
System.Data.SqlClient.TdsParserStateObject.ProcessSniPacket(IntPtr
packet, UInt32 error) at
System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult
asyncResult, TdsParserStateObject stateObj) at
System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32
bytesExpected) at
System.Data.SqlClient.TdsParserStateObject.ReadBuffer() at
System.Data.SqlClient.TdsParserStateObject.ReadByte() 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.getMetaData() at
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
RunBehavior runBehavior, String resetOptionsString) at
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cSystem.Data
and also:
could not execute query
[ SELECT this.projectgroupid as projectg1131,
this.projectgroupname as projectg2131, this.projectgroupdesc as
projectg3131, (select count(*) from geminiissues where
geminiissues.visibility = this.projectgroupid and
geminiissues.visibilitymembertype=3) as formula51,
members1.ProjectGroupID as ProjectG5_3,
members1.projectgroupmembershipid as projectg13,
members1.projectgroupmembershipid as projectg1140,
members1.projectid as projectid140, members1.projectgroupid as
projectg3140, members1.userid as userid140, (select
geminiprojectgroups.ProjectGroupName from geminiprojectgroups where
geminiprojectgroups.ProjectGroupID = members1.ProjectGroupID) as
formula60, (select geminiprojects.ProjectName from geminiprojects
where geminiprojects.projectid = members1.ProjectID) as formula70
FROM geminiprojectgroups this left outer join
geminiprojectgroupmembership members1 on
this.projectgroupid=members1.ProjectGroupID O12/09/2008 10:49:48 at CounterSoft.Gemini.DataProvider.xfbd3a0fcab576fc2.x647bdfcf07719618()
at CounterSoft.Gemini.Business.x41b05a9a96fad695.x647bdfcf07719618()
at CounterSoft.Gemini.Presenter.GroupsPresenter.GetAllProjectGroups()CounterSoft.Gemini.DataProvider
Please, can you let both myself, and the others with the same issue know what to do about it? It seems to me that an exception is happening in your asp.net application, and this is resulting in the time-out.
Thanks
|
mintGem
· 1 |
|
| Friday, September 12, 2008, 3:07:06 AM | |




