This discussion is archived
5 Replies Latest reply: Aug 22, 2013 7:01 AM by Trey RSS

Unhandled Error on Formulation

Trey Explorer
Currently Being Moderated

A formulation spec user was adding steps to the process and received this error. It appears it is trying to update a float field Price with value NaN. Should we report this on an SR, or did the user do something wrong?

We dont use the Cost Item library. This is 6.1.0.2

 

The following information is part of the event:'ErrorType: Primary| ErrorCount: 6| App: GSM| SessionId: ac75925d-ff7a-8968-ebad-3d4722ce35bf| UserId: mccallda| IsNewSession: False| ServerID: 10.31.11.20| Misc: Spec 5282289-001 ; Cavanaugh Smoked Sausage ; EditMode| Exception: System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> Xeno.Data.DataObjectException: Error executing sql command 'update Costs set fkCurrency = '214551109425-0F5C-47CF-BBDC-F12136728D91', fkPerValueUOM = '21251C1A1522-134D-45a4-BC6B-6E3DEA51F740', PerValueQuantity = '1000', Price = 'NaN' where pkid = '1173f46e6aa6-2b59-45c3-9068-ce7744bb615a'' ---> Xeno.Data.DataObjectException: Error executing sql command 'update Costs set fkCurrency = '214551109425-0F5C-47CF-BBDC-F12136728D91', fkPerValueUOM = '21251C1A1522-134D-45a4-BC6B-6E3DEA51F740', PerValueQuantity = '1000', Price = 'NaN' where pkid = '1173f46e6aa6-2b59-45c3-9068-ce7744bb615a'' ---> Xeno.Data.DataObjectException: Error executing sql command 'update Costs set fkCurrency = '214551109425-0F5C-47CF-BBDC-F12136728D91', fkPerValueUOM = '21251C1A1522-134D-45a4-BC6B-6E3DEA51F740', PerValueQuantity = '1000', Price = 'NaN' where pkid = '1173f46e6aa6-2b59-45c3-9068-ce7744bb615a'' ---> Xeno.Data.DataObjectException: Error executing sql command 'update Costs set fkCurrency = '214551109425-0F5C-47CF-BBDC-F12136728D91', fkPerValueUOM = '21251C1A1522-134D-45a4-BC6B-6E3DEA51F740', PerValueQuantity = '1000', Price = 'NaN' where pkid = '1173f46e6aa6-2b59-45c3-9068-ce7744bb615a'' ---> Xeno.Data.DataObjectException: Error executing sql command 'update Costs set fkCurrency = '214551109425-0F5C-47CF-BBDC-F12136728D91', fkPerValueUOM = '21251C1A1522-134D-45a4-BC6B-6E3DEA51F740', PerValueQuantity = '1000', Price = 'NaN' where pkid = '1173f46e6aa6-2b59-45c3-9068-ce7744bb615a'' ---> Xeno.Data.DataObjectException: Error executing sql command 'update Costs set fkCurrency = '214551109425-0F5C-47CF-BBDC-F12136728D91', fkPerValueUOM = '21251C1A1522-134D-45a4-BC6B-6E3DEA51F740', PerValueQuantity = '1000', Price = 'NaN' where pkid = '1173f46e6aa6-2b59-45c3-9068-ce7744bb615a'' ---> Xeno.Data.DataObjectException: Error executing sql command 'update Costs set fkCurrency = '214551109425-0F5C-47CF-BBDC-F12136728D91', fkPerValueUOM = '21251C1A1522-134D-45a4-BC6B-6E3DEA51F740', PerValueQuantity = '1000', Price = 'NaN' where pkid = '1173f46e6aa6-2b59-45c3-9068-ce7744bb615a'' ---> System.Data.SqlClient.SqlException: Error converting data type varchar to float. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Xeno.Data.XDataObjectBaseLight.internal_save(IDbCommand command) --- End of inner exception stack trace --- at Xeno.Data.XDataObjectBaseLight.internal_save(IDbCommand command) at Xeno.Data.XDataObjectBaseLight.internal_save(IDbCommand[] commandList) at Xeno.Data.XDataObjectBaseLight.Internal_Save() at Xeno.Data.XDataObjectBase.Internal_Save() at Xeno.Data.XDataObjectBaseLight.Internal_ExistingTransSave() --- End of inner exception stack trace --- at Xeno.Data.XDataObjectBaseLight.Internal_ExistingTransSave() at Xeno.Data.XDataObjectBaseLight.Save(IXDataObjectConnection connection) at Xeno.Data.XDataObjectBase.saveCollection(ICollection collection) at Xeno.Data.XDataObjectBase.postSave() at Xeno.Data.XDataObjectBaseLight.Internal_Save() at Xeno.Data.XDataObjectBase.Internal_Save() at Xeno.Data.XDataObjectBaseLight.Internal_ExistingTransSave() --- End of inner exception stack trace --- at Xeno.Data.XDataObjectBaseLight.Internal_ExistingTransSave() at Xeno.Data.XDataObjectBaseLight.Save(IXDataObjectConnection connection) at Xeno.Data.XDataObjectCollectionBase.Save(IXDataObjectConnection connection) at Xeno.Data.XDataObjectBase.saveCollection(ICollection collection) at Xeno.Data.XDataObjectBase.postSave() at Xeno.Data.XDataObjectBaseLight.Internal_Save() at Xeno.Data.XDataObjectBase.Internal_Save() at Xeno.Data.XDataObjectBaseLight.Internal_ExistingTransSave() --- End of inner exception stack trace --- at Xeno.Data.XDataObjectBaseLight.Internal_ExistingTransSave() at Xeno.Data.XDataObjectBaseLight.Save(IXDataObjectConnection connection) at Xeno.Data.XDataObjectCollectionBase.Save(IXDataObjectConnection connection) at Xeno.Data.XDataObjectBase.saveCollection(ICollection collection) at Xeno.Data.XDataObjectBase.postSave() at Xeno.Data.XDataObjectBaseLight.Internal_Save() at Xeno.Data.XDataObjectBase.Internal_Save() at Xeno.Data.XDataObjectBaseLight.Internal_ExistingTransSave() --- End of inner exception stack trace --- at Xeno.Data.XDataObjectBaseLight.Internal_ExistingTransSave() at Xeno.Data.XDataObjectBaseLight.Save(IXDataObjectConnection connection) at Xeno.Data.XDataObjectBase.saveCollection(ICollection collection) at Xeno.Data.XDataObjectBase.postSave() at Xeno.Data.XDataObjectBaseLight.Internal_Save() at Xeno.Data.XDataObjectBase.Internal_Save() at Xeno.Data.XDataObjectBaseLight.Internal_ExistingTransSave() --- End of inner exception stack trace --- at Xeno.Data.XDataObjectBaseLight.Internal_ExistingTransSave() at Xeno.Data.XDataObjectBaseLight.Save(IXDataObjectConnection connection) at Xeno.Data.XDataObjectBase.saveCollection(ICollection collection) at Xeno.Data.XDataObjectBase.postSave() at Xeno.Data.XDataObjectBaseLight.Internal_Save() at Xeno.Data.XDataObjectBase.Internal_Save() at Xeno.Data.XDataObjectBaseLight.Internal_ExistingTransSave() --- End of inner exception stack trace --- at Xeno.Data.XDataObjectBaseLight.Internal_ExistingTransSave() at Xeno.Data.XDataObjectBaseLight.Save(IXDataObjectConnection connection) at Xeno.Prodika.Services.Specification.SpecificationService.Save(Boolean bStayInEditMode, Boolean bDelayWorkflowResolution) at Xeno.Prodika.Services.Specification.SpecificationService.Save(Boolean bStayInEditMode) at prodika.XManagedSpecBaseForm.SaveSpec(Boolean stayInEditMode, Boolean reResolveWorkflow) at prodika.frmFormulation.OnSave() at prodika.ctlActionMenu.OnSave() at prodika.ctlActionMenu.ExcuteByEventName(String eventName) at prodika.ctlActionMenu.hdnCommand_Click(Object sender, EventArgs e) at System.Web.UI.HtmlControls.HtmlInputHidden.OnServerChange(EventArgs e) at System.Web.UI.HtmlControls.HtmlInputHidden.RaisePostDataChangedEvent() at System.Web.UI.HtmlControls.HtmlInputHidden.System.Web.UI.IPostBackDataHandler.RaisePostDataChangedEvent() at System.Web.UI.Page.RaiseChangedEvents() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace --- at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) at System.Web.UI.Page.ProcessRequest(HttpContext context) at ASP.baseforms_frmformulation_aspx.ProcessRequest(HttpContext context) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)'

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points