Home Home
  login

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.




Gemini 5: Error Message in Email

usage
projects
emails

Receiving the follow error message and I unable to establish what the cause is.

Unhandled exception: could not insert: [Countersoft.Gemini.Commons.Entity.IssueTimeTracking][SQL: INSERT INTO geminitimetracking (projectid, issueid, userid, hours, minutes, timetypeid, timeentrydate, comment) VALUES (?, ?, ?, ?, ?, ?, ?, ?); select SCOPEIDENTITY()]. Stack trace: at NHibernate.Id.Insert.AbstractReturningDelegate.PerformInsert(SqlCommandInfo insertSQL, ISessionImplementor session, IBinder binder) at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object[] fields, Object obj, ISessionImplementor session) at NHibernate.Action.EntityIdentityInsertAction.Execute() at NHibernate.Engine.ActionQueue.Execute(IExecutable executable) at NHibernate.Event.Default.AbstractSaveEventListener.PerformSaveOrReplicate(Object entity, EntityKey key, IEntityPersister persister, Boolean useIdentityColumn, Object anything, IEventSource source, Boolean requiresImmediateIdAccess) at NHibernate.Event.Default.AbstractSaveEventListener.SaveWithGeneratedId(Object entity, String entityName, Object anything, IEventSource source, Boolean requiresImmediateIdAccess) at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.SaveWithGeneratedOrRequestedId(SaveOrUpdateEvent event) at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.EntityIsTransient(SaveOrUpdateEvent event) at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.OnSaveOrUpdate(SaveOrUpdateEvent event) at NHibernate.Impl.SessionImpl.FireSave(SaveOrUpdateEvent event) at NHibernate.Impl.SessionImpl.Save(Object obj) at Countersoft.Foundation.Data.Repository2.Save(T entity) at Countersoft.Gemini.Business.Issues.CreateIssueTimeTracking(IssueTimeTracking timeTracking) at Countersoft.Gemini.Infrastructure.Managers.TimeTrackingManager.Create(IssueTimeTracking entity) at Countersoft.Gemini.Controllers.AjaxItemController.AddTimeEntry() at lambda_method(Closure , ControllerBase , Object[] ) at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary2 parameters) at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>cDisplayClass37.<>cDisplayClass39.b33() at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>cDisplayClass4f.b49() at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>cDisplayClass4f.b49() at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>cDisplayClass37.b36(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>cDisplayClass25.<>cDisplayClass2a.b20() at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>cDisplayClass25.b22(IAsyncResult asyncResult) at System.Web.Mvc.Controller.<>cDisplayClass1d.b18(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncResultWrapper.<>cDisplayClass4.b3(IAsyncResult ar) at System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncResultWrapper.<>cDisplayClass4.b3(IAsyncResult ar) at System.Web.Mvc.MvcHandler.<>cDisplayClass8.b3(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncResultWrapper.<>cDisplayClass4.b3(IAsyncResult ar) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Any help much appreciated.

Kind regards, Nico Kearns
Nico A. Kearns
· 12 		Nico A. Kearns
Thursday, November 29, 2012, 12:12:00 PM
Replies (5)
helpful
0
not helpful

Is this an upgrade? Can you check Gemini's system log to see if there are more errors around the same time?
Mark Wing
· 9108 		Mark Wing
Thursday, November 29, 2012, 1:15:15 PM
helpful
0
not helpful

This is an upgrade and there do seem to be more errors reported around the same time.

[28 Nov 2012 14:37:35,012] [ERROR] Could not execute query: INSERT INTO geminitimetracking (projectid, issueid, userid, hours, minutes, timetypeid, timeentrydate, comment) VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7); select SCOPEIDENTITY() System.Data.SqlClient.SqlException (0x80131904): String or binary data would be truncated. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() 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) [28 Nov 2012 14:37:35,049] [ERROR] String or binary data would be truncated. The statement has been terminated.
Nico A. Kearns
· 12 		Nico A. Kearns
Thursday, November 29, 2012, 1:48:04 PM
helpful
0
not helpful

Can you check if you have a trigger in SQL on the gemini_timetracking table?
Mark Wing
· 9108 		Mark Wing
Thursday, November 29, 2012, 1:56:19 PM
helpful
0
not helpful

Where do I check for that?

Kind regards, Nico Kearns
Nico A. Kearns
· 12 		Nico A. Kearns
Thursday, November 29, 2012, 1:58:08 PM
helpful
0
not helpful

You need to login to SQL management studio and connect to the Gemini database.
Mark Wing
· 9108 		Mark Wing
Thursday, November 29, 2012, 2:00:34 PM