I just had another report of the same error while a user was just 'clicking around'.  This time there was an entry in the log:

SendToHome() invoked

Cheers

The sendtohome message can be ignored.
Can you please check windows application log (event viewer) for errors?

Also, what is the size of your database? what are the inrement settings?

Hi,

First of all, our database is currently 411Mb in size.  I did notice that our space available is shown as 0.52Mb.  Both GeminiData and GeminiLog have autogrowth enabled.  Data increments by 1Mb with unrestricted growth and log increments by 10% with a maximum of 2Gb. 

I checked the server log and sure enough there were a several unhandled exception errors similar to the following:

Exception information:
    Exception type: ADOException
    Exception message: could not execute query
[ SELECT this.projectid as projectid220, this.projectcode as projectc2220, this.projectname as projectn3220, this.projectdesc as projectd4220, this.projectreadonly as projectr5220, this.projectarchived as projecta6220, this.schemeid as schemeid220, this.globalschemeid as globalsc8220, this.issuetypeschemeid as issuetyp9220, this.issuepriorityschemeid as issuepr10220, this.issueseverityschemeid as issuese11220, this.issueworkflowid as issuewo12220, this.fieldvisibilityschemeid as fieldvi13220, this.resourcemode as resourc14220, this.componentmode as compone15220, this.userid as userid220, this.created as created220, this.tstamp as tstamp220, this.projectlabelid as project19220, (select geminiusers.firstname + ' ' + geminiusers.surname from geminiusers where geminiusers.userid = this.userid) as formula80, (select count() from gemini_components where gemini_components.projectid = this_.projectid) as formula9_0_, (select count() from geminiversions where geminiversions.projectid = this.projectid and geminiversions.versionarchived = 0) as formula100, (select count() from gemini_projectresources where gemini_projectresources.projectid = this_.projectid) as formula11_0_, (select gemini_projectlabels.labelname from gemini_projectlabels where gemini_projectlabels.labelid = this_.projectlabelid) as formula12_0_ FROM gemini_projects this_ WHERE this_.projectarchived = ? ORDER BY this_.projectname asc ]
Positional parameters:  #0>N
[SQL: SELECT this_.projectid as projectid22_0_, this_.projectcode as projectc2_22_0_, this_.projectname as projectn3_22_0_, this_.projectdesc as projectd4_22_0_, this_.projectreadonly as projectr5_22_0_, this_.projectarchived as projecta6_22_0_, this_.schemeid as schemeid22_0_, this_.globalschemeid as globalsc8_22_0_, this_.issuetypeschemeid as issuetyp9_22_0_, this_.issuepriorityschemeid as issuepr10_22_0_, this_.issueseverityschemeid as issuese11_22_0_, this_.issueworkflowid as issuewo12_22_0_, this_.fieldvisibilityschemeid as fieldvi13_22_0_, this_.resourcemode as resourc14_22_0_, this_.componentmode as compone15_22_0_, this_.userid as userid22_0_, this_.created as created22_0_, this_.tstamp as tstamp22_0_, this_.projectlabelid as project19_22_0_, (select gemini_users.firstname + ' ' + gemini_users.surname from gemini_users where gemini_users.userid = this_.userid) as formula8_0_, (select count() from geminicomponents where geminicomponents.projectid = this.projectid) as formula90, (select count(*) from geminiversions where geminiversions.projectid = this.projectid and geminiversions.versionarchived = 0) as formula100, (select count(*) from geminiprojectresources where geminiprojectresources.projectid = this.projectid) as formula110, (select geminiprojectlabels.labelname from geminiprojectlabels where geminiprojectlabels.labelid = this.projectlabelid) as formula120 FROM geminiprojects this WHERE this.projectarchived = ? ORDER BY this.projectname asc]

Thanks

Ok, this might point to the problem. Your database inrements are tiny. 1mb will cause huge overhead in SQL and will cause data fragmentation.

Can you please change it to 100mb for data and 50mb for log?
Run the following SQL afterwards: update statistics gemini_issues with fullscan

Hi Mark,

Thanks for the suggestions.  I've updated everything as you mentioned and will keep an eye on things to see if anything comes up.

Once again, thanks for great support.

Cheers,

Chris