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.




No-one able to post Screendump - Error while trying to communicate with the server

add-ons

Hello,

We have started getting this error when people try to upload screenshots using Gemini Screen Capture. I have not been able to determine what causes the initial failure but the only way we can fix this is by bouncing the server. Is there any thoughts what could be causing this:

If you need any extra information please let me know :)

---------------------------------------------------------------------------------------------------
Error while trying to communicate with the server:
System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> NHibernate.ADOException: could not insert: [CounterSoft.Gemini.Commons.FileEN][SQL: INSERT INTO issueattachments (issueid, projid, commentid, contenttype, contentlength, thefilename, filecontent) VALUES (?, ?, ?, ?, ?, ?, ?)] ---> System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

The statement has been terminated.

   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

   at System.Data.SqlClient.SqlInternalConnection.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.Impl.BatcherImpl.ExecuteReader(IDbCommand cmd)

   at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object[] fields, Boolean[] notNull, SqlCommandInfo sql, Object obj, ISessionImplementor session)

   --- End of inner exception stack trace ---

   at CounterSoft.Gemini.DataProvider.x73a34067f4cd229a.xf606eb5e1032d933(BaseEN x6fcb9c1c812a0558, Boolean x8b15d0e18e6888d9)

   at CounterSoft.Gemini.DataProvider.x73a34067f4cd229a.xf606eb5e1032d933(BaseEN x6fcb9c1c812a0558)

   at CounterSoft.Gemini.DataProvider.xc0186e148e957052.xc554864bca640c48(FileEN x36f36c4ee8dd56a7)

   at CounterSoft.Gemini.Business.x95da312ae9372c2e.x062830ee083f0f7e(FileEN xfd903d9a9c51751c, Byte[]& xc8f9c583b3d9c0cf)

   at Gemini.IssuesWS.CreateComment(IssueCommentEN data)

   --- End of inner exception stack trace ---

Lanterns9
· 1
Lanterns9
Replies (6)
helpful
0
not helpful

Does it work and stops after a while? Can it be that the database is full?

What version of SQL and Gemini?


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful


Sorry for taking so long to reply!

Does it stop after a while? Yes, I reboot the server and everything is fine, then it will eventually crash (just the screen shot side of things, everything else is working ok!). I've found since the crashing is random from being quick (less than a day) to long (over a week). I accept things can go wrong over time so I've set the server to reboot once a week to help with the problem but any pointers or suggestions would be appreciated

Anyway versions if this makes sense.
Gemini 2.2
Database - MS SQL 2000 (SP4)
The database is about 4GB in size (transaction log is trunc each day so its small)
Plenty of HD space left and the database is set to grow by 10% when it reaches its limit (has 400MB free at the moment), Transaction log is set to grow too


Lanterns9
· 1
Lanterns9
helpful
0
not helpful

Is that MSDE or standard edition of SQL? Please note that MSDE has a limit of 4GB database size, which seems similar to your DB size!


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

Its MS-SQL Server 2000 (Not MSDE) and as I believe I said there is around 400 MB Available in the database file (100GB of HD availble on the server so no HD Space issue) so I don't think its a size issue.

Also normal issues keep running when screen dumps die and when we reboot the server everything works happily.




Lanterns9
· 1
Lanterns9
helpful
0
not helpful

Is it possible to run SQL Profiler to see what is going on?


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

I've managed to run a profile when it crashed again but I can't seem to upload the files here.

I've found some other issues/errors on the DB Server pointing to a autogrowth time out. I have changed the autogrowth of the database from 10% to 100MB as the database is 4.3GB. I suspect this might help solve the problem.




Lanterns9
· 1
Lanterns9