2015-01-03 22:42
Programinė įranga »
Nemokama apskaitos programa »
#1253354
Na, dar klaidelių:
1. Ilgalaikio turto kataloge pasirinkus turto poziciją ir atsidarius Operacijų su ilgalaikiu turtu suvestinę ir spaudžiant nauja op. išmeta:
Klaida vykdant SELECT sakinį (statement): [SELECT t.Turtas, t.Vnt, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='aqs' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.Saskaita) AS AccountAcquisition, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='amr' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountAmortization) AS AccountAmmortization, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='vld' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountValueDecrease) AS AccountValueDecrease, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='vli' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountValueIncrease) AS AccountValueIncrease, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='vam' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountRevaluedPortionAmmortization) AS AccountRevaluedPortionAmmortization, b.Op_data, t.Isigijimo_dok, t.Likutine, t.ContinuedUsage, t.Kiekis, t.Vnt_kaina, t.TotalValue, t.AcquisitionRevaluedPortionUnitValue, t.AcquisitionRevaluedPortionTotalValue, t.AccumulatedAmortizationPerUnit, t.S_Amort, t.AccumulatedAmortizationRevaluedPortionPerUnit, t.AccumulatedAmortizationRevaluedPortionTotal, IFNULL((SELECT d.NewAmortizationPeriod FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='alk' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.DefaultAmortPeriod) AS AmmortizationPeriodChanged, t.WasUsedMonths, l.AmmountChange, l.UnitValueChange, l.TotalValueChange, l.RevaluedPortionUnitValueChange, l.RevaluedPortionTotalValueChange, l.AcquisitionAccountChange, l.AcquisitionAccountChangePerUnit, l.AmortizationAccountChange, l.AmortizationAccountChangePerUnit, l.ValueDecreaseAccountChange, l.ValueDecreaseAccountChangePerUnit, l.ValueIncreaseAccountChange, l.ValueIncreaseAccountChangePerUnit, l.ValueIncreaseAmmortizationAccountChange, l.ValueIncreaseAmmortizationAccountChangePerUnit, l.AmortizationCalculatedForMonths, l.UsageStatus FROM turtas t LEFT JOIN bz b ON b.Op_ID=t.Isigijimo_dok LEFT JOIN (SELECT t.T_ID, -SUM(t.AmmountChange) AS AmmountChange, SUM(t.UnitValueChange) AS UnitValueChange, SUM(t.TotalValueChange) AS TotalValueChange, SUM(t.RevaluedPortionUnitValueChange) AS RevaluedPortionUnitValueChange, SUM(t.RevaluedPortionTotalValueChange) AS RevaluedPortionTotalValueChange, SUM(t.AcquisitionAccountChange) AS AcquisitionAccountChange, SUM(t.AcquisitionAccountChangePerUnit) AS AcquisitionAccountChangePerUnit, SUM(t.AmortizationAccountChange) AS AmortizationAccountChange, SUM(t.AmortizationAccountChangePerUnit) AS AmortizationAccountChangePerUnit, SUM(t.ValueDecreaseAccountChange) AS ValueDecreaseAccountChange, SUM(t.ValueDecreaseAccountChangePerUnit) AS ValueDecreaseAccountChangePerUnit, SUM(t.ValueIncreaseAccountChange) AS ValueIncreaseAccountChange, SUM(t.ValueIncreaseAccountChangePerUnit) AS ValueIncreaseAccountChangePerUnit, SUM(t.ValueIncreaseAmmortizationAccountChange) AS ValueIncreaseAmmortizationAccountChange, SUM(t.ValueIncreaseAmmortizationAccountChangePerUnit) AS ValueIncreaseAmmortizationAccountChangePerUnit, SUM(t.AmortizationCalculatedForMonths) AS AmortizationCalculatedForMonths, SUM(CASE WHEN t.OperationType='nau' THEN 1 ELSE 0 END) AS UsageStatus FROM turtas_op t WHERE t.ID<>$OD AND t.T_ID=$TD AND t.OperationDate<=$DT GROUP BY t.T_ID) AS l ON l.T_ID=t.ID WHERE t.ID=$TD ;=t.ID AND d.OperationType='aac' AND d.AccountOperationType='aqs' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.Saskaita) AS AccountAcquisition, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='amr' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountAmortization) AS AccountAmmortization, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='vld' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountValueDecrease) AS AccountValueDecrease, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='vli' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountValueIncrease) AS AccountValueIncrease, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='vam' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountRevaluedPortionAmmortization) AS AccountRevaluedPortionAmmortization, b.Op_data, t.Isigijimo_dok, t.Likutine, t.ContinuedUsage, t.Kiekis, t.Vnt_kaina, t.TotalValue, t.AcquisitionRevaluedPortionUnitValue, t.AcquisitionRevaluedPortionTotalValue, t.AccumulatedAmortizationPerUnit, t.S_Amort, t.AccumulatedAmortizationRevaluedPortionPerUnit, t.AccumulatedAmortizationRevaluedPortionTotal, IFNULL((SELECT d.NewAmortizationPeriod FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='alk' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.DefaultAmortPeriod) AS AmmortizationPeriodChanged, t.WasUsedMonths, l.AmmountChange, l.UnitValueChange, l.TotalValueChange, l.RevaluedPortionUnitValueChange, l.RevaluedPortionTotalValueChange, l.AcquisitionAccountChange, l.AcquisitionAccountChangePerUnit, l.AmortizationAccountChange, l.AmortizationAccountChangePerUnit, l.ValueDecreaseAccountChange, l.ValueDecreaseAccountChangePerUnit, l.ValueIncreaseAccountChange, l.ValueIncreaseAccountChangePerUnit, l.ValueIncreaseAmmortizationAccountChange, l.ValueIncreaseAmmortizationAccountChangePerUnit, l.AmortizationCalculatedForMonths, l.UsageStatus FROM turtas t LEFT JOIN bz b ON b.Op_ID=t.Isigijimo_dok LEFT JOIN (SELECT t.T_ID, -SUM(t.AmmountChange) AS AmmountChange, SUM(t.UnitValueChange) AS UnitValueChange, SUM(t.TotalValueChange) AS TotalValueChange, SUM(t.RevaluedPortionUnitValueChange) AS RevaluedPortionUnitValueChange, SUM(t.RevaluedPortionTotalValueChange) AS RevaluedPortionTotalValueChange, SUM(t.AcquisitionAccountChange) AS AcquisitionAccountChange, SUM(t.AcquisitionAccountChangePerUnit) AS AcquisitionAccountChangePerUnit, SUM(t.AmortizationAccountChange) AS AmortizationAccountChange, SUM(t.AmortizationAccountChangePerUnit) AS AmortizationAccountChangePerUnit, SUM(t.ValueDecreaseAccountChange) AS ValueDecreaseAccountChange, SUM(t.ValueDecreaseAccountChangePerUnit) AS ValueDecreaseAccountChangePerUnit, SUM(t.ValueIncreaseAccountChange) AS ValueIncreaseAccountChange, SUM(t.ValueIncreaseAccountChangePerUnit) AS ValueIncreaseAccountChangePerUnit, SUM(t.ValueIncreaseAmmortizationAccountChange) AS ValueIncreaseAmmortizationAccountChange, SUM(t.ValueIncreaseAmmortizationAccountChangePerUnit) AS ValueIncreaseAmmortizationAccountChangePerUnit, SUM(t.AmortizationCalculatedForMonths) AS AmortizationCalculatedForMonths, SUM(CASE WHEN t.OperationType='nau' THEN 1 ELSE 0 END) AS UsageStatus FROM turtas_op t WHERE t.ID<>$OD AND t.T_ID=$TD AND t.OperationDate<=$DT GROUP BY t.T_ID) AS l ON l.T_ID=t.ID WHERE t.ID=$TD ;], Params: ?TD=1; ?OD=-1; ?DT=2115-01-03;
Klaidos turinys: 'SQLite error
no such column: l.T_ID'.
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 ApskaitaWUI.BOMapper.LoadObject[T](T ObjectInstance, String MethodName, Boolean AllowCancel, Object[] Params)
at ApskaitaWUI.F_LongTermAssetOperation.F_LongTermAssetOperation_Load(Object sender, EventArgs e)
----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
DataPortal.Create failed (System.Exception: Klaida vykdant SELECT sakinį (statement): [SELECT t.Turtas, t.Vnt, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='aqs' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.Saskaita) AS AccountAcquisition, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='amr' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountAmortization) AS AccountAmmortization, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='vld' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountValueDecrease) AS AccountValueDecrease, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='vli' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountValueIncrease) AS AccountValueIncrease, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='vam' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountRevaluedPortionAmmortization) AS AccountRevaluedPortionAmmortization, b.Op_data, t.Isigijimo_dok, t.Likutine, t.ContinuedUsage, t.Kiekis, t.Vnt_kaina, t.TotalValue, t.AcquisitionRevaluedPortionUnitValue, t.AcquisitionRevaluedPortionTotalValue, t.AccumulatedAmortizationPerUnit, t.S_Amort, t.AccumulatedAmortizationRevaluedPortionPerUnit, t.AccumulatedAmortizationRevaluedPortionTotal, IFNULL((SELECT d.NewAmortizationPeriod FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='alk' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.DefaultAmortPeriod) AS AmmortizationPeriodChanged, t.WasUsedMonths, l.AmmountChange, l.UnitValueChange, l.TotalValueChange, l.RevaluedPortionUnitValueChange, l.RevaluedPortionTotalValueChange, l.AcquisitionAccountChange, l.AcquisitionAccountChangePerUnit, l.AmortizationAccountChange, l.AmortizationAccountChangePerUnit, l.ValueDecreaseAccountChange, l.ValueDecreaseAccountChangePerUnit, l.ValueIncreaseAccountChange, l.ValueIncreaseAccountChangePerUnit, l.ValueIncreaseAmmortizationAccountChange, l.ValueIncreaseAmmortizationAccountChangePerUnit, l.AmortizationCalculatedForMonths, l.UsageStatus FROM turtas t LEFT JOIN bz b ON b.Op_ID=t.Isigijimo_dok LEFT JOIN (SELECT t.T_ID, -SUM(t.AmmountChange) AS AmmountChange, SUM(t.UnitValueChange) AS UnitValueChange, SUM(t.TotalValueChange) AS TotalValueChange, SUM(t.RevaluedPortionUnitValueChange) AS RevaluedPortionUnitValueChange, SUM(t.RevaluedPortionTotalValueChange) AS RevaluedPortionTotalValueChange, SUM(t.AcquisitionAccountChange) AS AcquisitionAccountChange, SUM(t.AcquisitionAccountChangePerUnit) AS AcquisitionAccountChangePerUnit, SUM(t.AmortizationAccountChange) AS AmortizationAccountChange, SUM(t.AmortizationAccountChangePerUnit) AS AmortizationAccountChangePerUnit, SUM(t.ValueDecreaseAccountChange) AS ValueDecreaseAccountChange, SUM(t.ValueDecreaseAccountChangePerUnit) AS ValueDecreaseAccountChangePerUnit, SUM(t.ValueIncreaseAccountChange) AS ValueIncreaseAccountChange, SUM(t.ValueIncreaseAccountChangePerUnit) AS ValueIncreaseAccountChangePerUnit, SUM(t.ValueIncreaseAmmortizationAccountChange) AS ValueIncreaseAmmortizationAccountChange, SUM(t.ValueIncreaseAmmortizationAccountChangePerUnit) AS ValueIncreaseAmmortizationAccountChangePerUnit, SUM(t.AmortizationCalculatedForMonths) AS AmortizationCalculatedForMonths, SUM(CASE WHEN t.OperationType='nau' THEN 1 ELSE 0 END) AS UsageStatus FROM turtas_op t WHERE t.ID<>$OD AND t.T_ID=$TD AND t.OperationDate<=$DT GROUP BY t.T_ID) AS l ON l.T_ID=t.ID WHERE t.ID=$TD ;=t.ID AND d.OperationType='aac' AND d.AccountOperationType='aqs' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.Saskaita) AS AccountAcquisition, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='amr' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountAmortization) AS AccountAmmortization, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='vld' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountValueDecrease) AS AccountValueDecrease, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='vli' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountValueIncrease) AS AccountValueIncrease, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='vam' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountRevaluedPortionAmmortization) AS AccountRevaluedPortionAmmortization, b.Op_data, t.Isigijimo_dok, t.Likutine, t.ContinuedUsage, t.Kiekis, t.Vnt_kaina, t.TotalValue, t.AcquisitionRevaluedPortionUnitValue, t.AcquisitionRevaluedPortionTotalValue, t.AccumulatedAmortizationPerUnit, t.S_Amort, t.AccumulatedAmortizationRevaluedPortionPerUnit, t.AccumulatedAmortizationRevaluedPortionTotal, IFNULL((SELECT d.NewAmortizationPeriod FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='alk' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.DefaultAmortPeriod) AS AmmortizationPeriodChanged, t.WasUsedMonths, l.AmmountChange, l.UnitValueChange, l.TotalValueChange, l.RevaluedPortionUnitValueChange, l.RevaluedPortionTotalValueChange, l.AcquisitionAccountChange, l.AcquisitionAccountChangePerUnit, l.AmortizationAccountChange, l.AmortizationAccountChangePerUnit, l.ValueDecreaseAccountChange, l.ValueDecreaseAccountChangePerUnit, l.ValueIncreaseAccountChange, l.ValueIncreaseAccountChangePerUnit, l.ValueIncreaseAmmortizationAccountChange, l.ValueIncreaseAmmortizationAccountChangePerUnit, l.AmortizationCalculatedForMonths, l.UsageStatus FROM turtas t LEFT JOIN bz b ON b.Op_ID=t.Isigijimo_dok LEFT JOIN (SELECT t.T_ID, -SUM(t.AmmountChange) AS AmmountChange, SUM(t.UnitValueChange) AS UnitValueChange, SUM(t.TotalValueChange) AS TotalValueChange, SUM(t.RevaluedPortionUnitValueChange) AS RevaluedPortionUnitValueChange, SUM(t.RevaluedPortionTotalValueChange) AS RevaluedPortionTotalValueChange, SUM(t.AcquisitionAccountChange) AS AcquisitionAccountChange, SUM(t.AcquisitionAccountChangePerUnit) AS AcquisitionAccountChangePerUnit, SUM(t.AmortizationAccountChange) AS AmortizationAccountChange, SUM(t.AmortizationAccountChangePerUnit) AS AmortizationAccountChangePerUnit, SUM(t.ValueDecreaseAccountChange) AS ValueDecreaseAccountChange, SUM(t.ValueDecreaseAccountChangePerUnit) AS ValueDecreaseAccountChangePerUnit, SUM(t.ValueIncreaseAccountChange) AS ValueIncreaseAccountChange, SUM(t.ValueIncreaseAccountChangePerUnit) AS ValueIncreaseAccountChangePerUnit, SUM(t.ValueIncreaseAmmortizationAccountChange) AS ValueIncreaseAmmortizationAccountChange, SUM(t.ValueIncreaseAmmortizationAccountChangePerUnit) AS ValueIncreaseAmmortizationAccountChangePerUnit, SUM(t.AmortizationCalculatedForMonths) AS AmortizationCalculatedForMonths, SUM(CASE WHEN t.OperationType='nau' THEN 1 ELSE 0 END) AS UsageStatus FROM turtas_op t WHERE t.ID<>$OD AND t.T_ID=$TD AND t.OperationDate<=$DT GROUP BY t.T_ID) AS l ON l.T_ID=t.ID WHERE t.ID=$TD ;], Params: ?TD=1; ?OD=-1; ?DT=2115-01-03;
Klaidos turinys: 'SQLite error
no such column: l.T_ID'. ---> System.Data.SQLite.SQLiteException: SQLite error
no such column: l.T_ID
at System.Data.SQLite.SQLite3.Prepare(String strSql, SQLiteStatement previous, String& strRemain)
at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
at System.Data.SQLite.SQLiteDataReader.NextResult()
at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SQLite.SQLiteCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
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.Assets.LongTermAssetOperation.GetOperationBackgroundInfo(Int32 nAssetId, Int32 nOperationID, DateTime nOperationDate)
at ApskaitaObjects.Assets.LongTermAssetOperation.Create(Int32 AssetId, LtaOperationType nNewOperationType, IChronologicValidator parentValidator)
at ApskaitaObjects.Assets.LongTermAssetOperation.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.Assets.LongTermAssetOperation.GetOperationBackgroundInfo(Int32 nAssetId, Int32 nOperationID, DateTime nOperationDate)
at ApskaitaObjects.Assets.LongTermAssetOperation.Create(Int32 AssetId, LtaOperationType nNewOperationType, IChronologicValidator parentValidator)
at ApskaitaObjects.Assets.LongTermAssetOperation.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.Assets.LongTermAssetOperation.NewLongTermAssetOperation(Int32 AssetId)
----------------------------
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.Assets.LongTermAssetOperation.GetOperationBackgroundInfo(Int32 nAssetId, Int32 nOperationID, DateTime nOperationDate)
at ApskaitaObjects.Assets.LongTermAssetOperation.Create(Int32 AssetId, LtaOperationType nNewOperationType, IChronologicValidator parentValidator)
at ApskaitaObjects.Assets.LongTermAssetOperation.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 t.Turtas, t.Vnt, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='aqs' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.Saskaita) AS AccountAcquisition, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='amr' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountAmortization) AS AccountAmmortization, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='vld' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountValueDecrease) AS AccountValueDecrease, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='vli' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountValueIncrease) AS AccountValueIncrease, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='vam' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountRevaluedPortionAmmortization) AS AccountRevaluedPortionAmmortization, b.Op_data, t.Isigijimo_dok, t.Likutine, t.ContinuedUsage, t.Kiekis, t.Vnt_kaina, t.TotalValue, t.AcquisitionRevaluedPortionUnitValue, t.AcquisitionRevaluedPortionTotalValue, t.AccumulatedAmortizationPerUnit, t.S_Amort, t.AccumulatedAmortizationRevaluedPortionPerUnit, t.AccumulatedAmortizationRevaluedPortionTotal, IFNULL((SELECT d.NewAmortizationPeriod FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='alk' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.DefaultAmortPeriod) AS AmmortizationPeriodChanged, t.WasUsedMonths, l.AmmountChange, l.UnitValueChange, l.TotalValueChange, l.RevaluedPortionUnitValueChange, l.RevaluedPortionTotalValueChange, l.AcquisitionAccountChange, l.AcquisitionAccountChangePerUnit, l.AmortizationAccountChange, l.AmortizationAccountChangePerUnit, l.ValueDecreaseAccountChange, l.ValueDecreaseAccountChangePerUnit, l.ValueIncreaseAccountChange, l.ValueIncreaseAccountChangePerUnit, l.ValueIncreaseAmmortizationAccountChange, l.ValueIncreaseAmmortizationAccountChangePerUnit, l.AmortizationCalculatedForMonths, l.UsageStatus FROM turtas t LEFT JOIN bz b ON b.Op_ID=t.Isigijimo_dok LEFT JOIN (SELECT t.T_ID, -SUM(t.AmmountChange) AS AmmountChange, SUM(t.UnitValueChange) AS UnitValueChange, SUM(t.TotalValueChange) AS TotalValueChange, SUM(t.RevaluedPortionUnitValueChange) AS RevaluedPortionUnitValueChange, SUM(t.RevaluedPortionTotalValueChange) AS RevaluedPortionTotalValueChange, SUM(t.AcquisitionAccountChange) AS AcquisitionAccountChange, SUM(t.AcquisitionAccountChangePerUnit) AS AcquisitionAccountChangePerUnit, SUM(t.AmortizationAccountChange) AS AmortizationAccountChange, SUM(t.AmortizationAccountChangePerUnit) AS AmortizationAccountChangePerUnit, SUM(t.ValueDecreaseAccountChange) AS ValueDecreaseAccountChange, SUM(t.ValueDecreaseAccountChangePerUnit) AS ValueDecreaseAccountChangePerUnit, SUM(t.ValueIncreaseAccountChange) AS ValueIncreaseAccountChange, SUM(t.ValueIncreaseAccountChangePerUnit) AS ValueIncreaseAccountChangePerUnit, SUM(t.ValueIncreaseAmmortizationAccountChange) AS ValueIncreaseAmmortizationAccountChange, SUM(t.ValueIncreaseAmmortizationAccountChangePerUnit) AS ValueIncreaseAmmortizationAccountChangePerUnit, SUM(t.AmortizationCalculatedForMonths) AS AmortizationCalculatedForMonths, SUM(CASE WHEN t.OperationType='nau' THEN 1 ELSE 0 END) AS UsageStatus FROM turtas_op t WHERE t.ID<>$OD AND t.T_ID=$TD AND t.OperationDate<=$DT GROUP BY t.T_ID) AS l ON l.T_ID=t.ID WHERE t.ID=$TD ;=t.ID AND d.OperationType='aac' AND d.AccountOperationType='aqs' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.Saskaita) AS AccountAcquisition, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='amr' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountAmortization) AS AccountAmmortization, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='vld' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountValueDecrease) AS AccountValueDecrease, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='vli' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountValueIncrease) AS AccountValueIncrease, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='vam' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountRevaluedPortionAmmortization) AS AccountRevaluedPortionAmmortization, b.Op_data, t.Isigijimo_dok, t.Likutine, t.ContinuedUsage, t.Kiekis, t.Vnt_kaina, t.TotalValue, t.AcquisitionRevaluedPortionUnitValue, t.AcquisitionRevaluedPortionTotalValue, t.AccumulatedAmortizationPerUnit, t.S_Amort, t.AccumulatedAmortizationRevaluedPortionPerUnit, t.AccumulatedAmortizationRevaluedPortionTotal, IFNULL((SELECT d.NewAmortizationPeriod FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='alk' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.DefaultAmortPeriod) AS AmmortizationPeriodChanged, t.WasUsedMonths, l.AmmountChange, l.UnitValueChange, l.TotalValueChange, l.RevaluedPortionUnitValueChange, l.RevaluedPortionTotalValueChange, l.AcquisitionAccountChange, l.AcquisitionAccountChangePerUnit, l.AmortizationAccountChange, l.AmortizationAccountChangePerUnit, l.ValueDecreaseAccountChange, l.ValueDecreaseAccountChangePerUnit, l.ValueIncreaseAccountChange, l.ValueIncreaseAccountChangePerUnit, l.ValueIncreaseAmmortizationAccountChange, l.ValueIncreaseAmmortizationAccountChangePerUnit, l.AmortizationCalculatedForMonths, l.UsageStatus FROM turtas t LEFT JOIN bz b ON b.Op_ID=t.Isigijimo_dok LEFT JOIN (SELECT t.T_ID, -SUM(t.AmmountChange) AS AmmountChange, SUM(t.UnitValueChange) AS UnitValueChange, SUM(t.TotalValueChange) AS TotalValueChange, SUM(t.RevaluedPortionUnitValueChange) AS RevaluedPortionUnitValueChange, SUM(t.RevaluedPortionTotalValueChange) AS RevaluedPortionTotalValueChange, SUM(t.AcquisitionAccountChange) AS AcquisitionAccountChange, SUM(t.AcquisitionAccountChangePerUnit) AS AcquisitionAccountChangePerUnit, SUM(t.AmortizationAccountChange) AS AmortizationAccountChange, SUM(t.AmortizationAccountChangePerUnit) AS AmortizationAccountChangePerUnit, SUM(t.ValueDecreaseAccountChange) AS ValueDecreaseAccountChange, SUM(t.ValueDecreaseAccountChangePerUnit) AS ValueDecreaseAccountChangePerUnit, SUM(t.ValueIncreaseAccountChange) AS ValueIncreaseAccountChange, SUM(t.ValueIncreaseAccountChangePerUnit) AS ValueIncreaseAccountChangePerUnit, SUM(t.ValueIncreaseAmmortizationAccountChange) AS ValueIncreaseAmmortizationAccountChange, SUM(t.ValueIncreaseAmmortizationAccountChangePerUnit) AS ValueIncreaseAmmortizationAccountChangePerUnit, SUM(t.AmortizationCalculatedForMonths) AS AmortizationCalculatedForMonths, SUM(CASE WHEN t.OperationType='nau' THEN 1 ELSE 0 END) AS UsageStatus FROM turtas_op t WHERE t.ID<>$OD AND t.T_ID=$TD AND t.OperationDate<=$DT GROUP BY t.T_ID) AS l ON l.T_ID=t.ID WHERE t.ID=$TD ;], Params: ?TD=1; ?OD=-1; ?DT=2115-01-03;
Klaidos turinys: 'SQLite error
no such column: l.T_ID'.
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.Assets.LongTermAssetOperation.GetOperationBackgroundInfo(Int32 nAssetId, Int32 nOperationID, DateTime nOperationDate)
at ApskaitaObjects.Assets.LongTermAssetOperation.Create(Int32 AssetId, LtaOperationType nNewOperationType, IChronologicValidator parentValidator)
at ApskaitaObjects.Assets.LongTermAssetOperation.DataPortal_Create(Criteria criteria)
----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
SQLite error
no such column: l.T_ID
Klaidos šaltinis(Ex.Source):
System.Data.SQLite
Klaidos metodas (Ex.TargetSite):
Prepare
Klaidos stekas:
at System.Data.SQLite.SQLite3.Prepare(String strSql, SQLiteStatement previous, String& strRemain)
at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
at System.Data.SQLite.SQLiteDataReader.NextResult()
at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SQLite.SQLiteCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
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)
na o Kompleksiniai operacijų su ilgalaikiu turtu dokumentai iš viso neiššaukia ilgalaikio turto sąrašo.