2016-10-04 23:45
Irmantukas1
Labas vakaras Niemand. Prekių nurašymo akte, kažkodėl vienai prekei iš 9 išmeta klaidą ir neleidžia jos įkelti. Kame gali būti problemos?
Klaidos duomenys:
Klaidos tekstas:
Exception has been thrown by the target of an invocation.
Klaidos šaltinis(Ex.Source):
mscorlib
Klaidos metodas (Ex.TargetSite):
_InvokeMethodFast
Klaidos stekas:
at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at AccControlsWinForms.MethodInvoker`1.Invoke(T instance, String methodName, Object[] methodParams)
at AccControlsWinForms.CommonMethods.InvokeMethod[T](T instance, String methodName, Object[] params)
at AccDataBindingsWinForms.CslaActionExtenderQueryObject.InvokeQuery[T](T instance, String methodName, Boolean allowCancel, QueryObjectFetched callBackDelegate, Object[] params)
----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
DataPortal.Create failed (System.Exception: Klaida vykdant SELECT sakinį (statement): [SELECT GoodsID, OperationType, WarehouseID, MAX(OperationDate), 0 FROM goodsoperations WHERE GoodsID=$GD GROUP BY GoodsID, OperationType, WareHouseID UNION SELECT GoodsID, 13, 0, MAX(ChangeDate), 0 FROM goodsvaluationmethods WHERE GoodsID=$GD GROUP BY GoodsID UNION SELECT GoodsID, AccountType, 0, MAX(ChangeDate), 0 FROM goodsaccounts WHERE GoodsID=$GD GROUP BY GoodsID;=$GD GROUP BY GoodsID, OperationType, WareHouseID UNION SELECT GoodsID, 13, 0, MAX(ChangeDate), 0 FROM goodsvaluationmethods WHERE GoodsID=$GD GROUP BY GoodsID UNION SELECT GoodsID, AccountType, 0, MAX(ChangeDate), 0 FROM goodsaccounts WHERE GoodsID=$GD GROUP BY GoodsID;], Params: ?GD=11;
Klaidos turinys: 'Input string was not in a correct format.Couldn't store <2016-01-29 00:00:00> in MAX(OperationDate) Column. Expected type is Double.'. ---> System.ArgumentException: Input string was not in a correct format.Couldn't store <2016-01-29 00:00:00> in MAX(OperationDate) Column. Expected type is Double. ---> System.FormatException: Input string was not in a correct format.
at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
at System.Number.ParseDouble(String value, NumberStyles options, NumberFormatInfo numfmt)
at System.Double.Parse(String s, NumberStyles style, NumberFormatInfo info)
at System.Convert.ToDouble(String value, IFormatProvider provider)
at System.String.System.IConvertible.ToDouble(IFormatProvider provider)
at System.Data.Common.DoubleStorage.Set(Int32 record, Object value)
at System.Data.DataColumn.set_Item(Int32 record, Object value)
--- End of inner exception stack trace ---
at System.Data.DataColumn.set_Item(Int32 record, Object value)
at System.Data.DataTable.NewRecordFromArray(Object[] value)
at System.Data.DataTable.LoadDataRow(Object[] values, Boolean fAcceptChanges)
at System.Data.ProviderBase.SchemaMapping.LoadDataRow()
at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.FetchCommand(SQLCommand SelectCommand)
--- End of inner exception stack trace ---
at AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLCommand.Fetch()
at ApskaitaObjects.Goods.OperationalLimitList.GetDataSource()
at ApskaitaObjects.Goods.OperationalLimitList.Create(GoodsSummary goodsSummary, GoodsOperationType operationType, Int32 warehouseID, IChronologicValidator parentValidator)
at ApskaitaObjects.Goods.OperationalLimitList..ctor(GoodsSummary goodsSummary, GoodsOperationType operationType, Int32 warehouseID, IChronologicValidator parentValidator)
at ApskaitaObjects.Goods.GoodsOperationDiscard.Create(GoodsSummary summary, WarehouseInfo parentWarehouse, IChronologicValidator parentValidator)
at ApskaitaObjects.Goods.GoodsOperationDiscard.Create(Int32 goodsID, WarehouseInfo parentWarehouse, IChronologicValidator parentValidator)
at ApskaitaObjects.Goods.GoodsOperationDiscard..ctor(Int32 goodsID, WarehouseInfo parentWarehouse, IChronologicValidator parentValidator)
at ApskaitaObjects.Goods.GoodsDiscardItemList.DataPortal_Create(Criteria criteria))
Klaidos šaltinis(Ex.Source):
Csla
Klaidos metodas (Ex.TargetSite):
Create
Klaidos stekas:
at AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLCommand.Fetch()
at ApskaitaObjects.Goods.OperationalLimitList.GetDataSource()
at ApskaitaObjects.Goods.OperationalLimitList.Create(GoodsSummary goodsSummary, GoodsOperationType operationType, Int32 warehouseID, IChronologicValidator parentValidator)
at ApskaitaObjects.Goods.OperationalLimitList..ctor(GoodsSummary goodsSummary, GoodsOperationType operationType, Int32 warehouseID, IChronologicValidator parentValidator)
at ApskaitaObjects.Goods.GoodsOperationDiscard.Create(GoodsSummary summary, WarehouseInfo parentWarehouse, IChronologicValidator parentValidator)
at ApskaitaObjects.Goods.GoodsOperationDiscard.Create(Int32 goodsID, WarehouseInfo parentWarehouse, IChronologicValidator parentValidator)
at ApskaitaObjects.Goods.GoodsOperationDiscard..ctor(Int32 goodsID, WarehouseInfo parentWarehouse, IChronologicValidator parentValidator)
at ApskaitaObjects.Goods.GoodsDiscardItemList.DataPortal_Create(Criteria criteria)
at Csla.MethodCaller.CallMethod(Object obj, MethodInfo info, Object[] parameters)
at Csla.Server.SimpleDataPortal.Create(Type objectType, Object criteria, DataPortalContext context)
at Csla.DataPortal.Create(Type objectType, Object criteria)
at Csla.DataPortal.Create[T](Object criteria)
at ApskaitaObjects.Goods.GoodsDiscardItemList.NewGoodsDiscardItemList(Int32[] goodsIDs, Int32 warehouseID, IChronologicValidator parentValidator)
----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
DataPortal_Create method call failed
Klaidos šaltinis(Ex.Source):
Csla
Klaidos metodas (Ex.TargetSite):
CallMethod
Klaidos stekas:
at AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLCommand.Fetch()
at ApskaitaObjects.Goods.OperationalLimitList.GetDataSource()
at ApskaitaObjects.Goods.OperationalLimitList.Create(GoodsSummary goodsSummary, GoodsOperationType operationType, Int32 warehouseID, IChronologicValidator parentValidator)
at ApskaitaObjects.Goods.OperationalLimitList..ctor(GoodsSummary goodsSummary, GoodsOperationType operationType, Int32 warehouseID, IChronologicValidator parentValidator)
at ApskaitaObjects.Goods.GoodsOperationDiscard.Create(GoodsSummary summary, WarehouseInfo parentWarehouse, IChronologicValidator parentValidator)
at ApskaitaObjects.Goods.GoodsOperationDiscard.Create(Int32 goodsID, WarehouseInfo parentWarehouse, IChronologicValidator parentValidator)
at ApskaitaObjects.Goods.GoodsOperationDiscard..ctor(Int32 goodsID, WarehouseInfo parentWarehouse, IChronologicValidator parentValidator)
at ApskaitaObjects.Goods.GoodsDiscardItemList.DataPortal_Create(Criteria criteria)
at Csla.MethodCaller.CallMethod(Object obj, MethodInfo info, Object[] parameters)
at Csla.Server.SimpleDataPortal.Create(Type objectType, Object criteria, DataPortalContext context)
----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
Klaida vykdant SELECT sakinį (statement): [SELECT GoodsID, OperationType, WarehouseID, MAX(OperationDate), 0 FROM goodsoperations WHERE GoodsID=$GD GROUP BY GoodsID, OperationType, WareHouseID UNION SELECT GoodsID, 13, 0, MAX(ChangeDate), 0 FROM goodsvaluationmethods WHERE GoodsID=$GD GROUP BY GoodsID UNION SELECT GoodsID, AccountType, 0, MAX(ChangeDate), 0 FROM goodsaccounts WHERE GoodsID=$GD GROUP BY GoodsID;=$GD GROUP BY GoodsID, OperationType, WareHouseID UNION SELECT GoodsID, 13, 0, MAX(ChangeDate), 0 FROM goodsvaluationmethods WHERE GoodsID=$GD GROUP BY GoodsID UNION SELECT GoodsID, AccountType, 0, MAX(ChangeDate), 0 FROM goodsaccounts WHERE GoodsID=$GD GROUP BY GoodsID;], Params: ?GD=11;
Klaidos turinys: 'Input string was not in a correct format.Couldn't store <2016-01-29 00:00:00> in MAX(OperationDate) Column. Expected type is Double.'.
Klaidos šaltinis(Ex.Source):
AccDataAccessLayer
Klaidos metodas (Ex.TargetSite):
FetchCommand
Klaidos stekas:
at AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLCommand.Fetch()
at ApskaitaObjects.Goods.OperationalLimitList.GetDataSource()
at ApskaitaObjects.Goods.OperationalLimitList.Create(GoodsSummary goodsSummary, GoodsOperationType operationType, Int32 warehouseID, IChronologicValidator parentValidator)
at ApskaitaObjects.Goods.OperationalLimitList..ctor(GoodsSummary goodsSummary, GoodsOperationType operationType, Int32 warehouseID, IChronologicValidator parentValidator)
at ApskaitaObjects.Goods.GoodsOperationDiscard.Create(GoodsSummary summary, WarehouseInfo parentWarehouse, IChronologicValidator parentValidator)
at ApskaitaObjects.Goods.GoodsOperationDiscard.Create(Int32 goodsID, WarehouseInfo parentWarehouse, IChronologicValidator parentValidator)
at ApskaitaObjects.Goods.GoodsOperationDiscard..ctor(Int32 goodsID, WarehouseInfo parentWarehouse, IChronologicValidator parentValidator)
at ApskaitaObjects.Goods.GoodsDiscardItemList.DataPortal_Create(Criteria criteria)
----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
Input string was not in a correct format.Couldn't store <2016-01-29 00:00:00> in MAX(OperationDate) Column. Expected type is Double.
Klaidos šaltinis(Ex.Source):
System.Data
Klaidos metodas (Ex.TargetSite):
set_Item
Klaidos stekas:
at System.Data.DataColumn.set_Item(Int32 record, Object value)
at System.Data.DataTable.NewRecordFromArray(Object[] value)
at System.Data.DataTable.LoadDataRow(Object[] values, Boolean fAcceptChanges)
at System.Data.ProviderBase.SchemaMapping.LoadDataRow()
at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.FetchCommand(SQLCommand SelectCommand)
----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
Input string was not in a correct format.
Klaidos šaltinis(Ex.Source):
mscorlib
Klaidos metodas (Ex.TargetSite):
StringToNumber
Klaidos stekas:
at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
at System.Number.ParseDouble(String value, NumberStyles options, NumberFormatInfo numfmt)
at System.Double.Parse(String s, NumberStyles style, NumberFormatInfo info)
at System.Convert.ToDouble(String value, IFormatProvider provider)
at System.String.System.IConvertible.ToDouble(IFormatProvider provider)
at System.Data.Common.DoubleStorage.Set(Int32 record, Object value)
at System.Data.DataColumn.set_Item(Int32 record, Object value)