Pabandyk Bendras - DB struktūra - taisyti klaidas. Man ir šitą klaidą metė, išsitaisiau klaidas ir viskas ok.

Norint peržiūrėti ankstesnes išrašytas sąskaitas neleidžia ir meta klaidą. Tai ką dabar daryt ???

Klaida vykdant SELECT sakinį (statement): [SELECT O.ID, O.Preke, O.NameAltLng, O.Kiekis, O.Kaina, O.SumOriginal, O.Tar, O.SumVatOriginal, O.UnitValueLTL, O.SumLTL, O.SumVatLTL, O.Discount, O.DiscountLTL, O.DiscountVat, O.DiscountVatLTL, O.Rusis, O.P_ID, O.Vnt, O.MeasureUnitAltLng, O.P_Sas, O.A_Sas, O.AccountDiscount, O.IncludeVatInObject, O.VatIsVirtual FROM sfd O WHERE O.SF_ID=$MD GROUP BY O.ID;=$MD GROUP BY O.ID;], Params: ?MD=2855;
Klaidos turinys: 'SQLite error
no such column: O.VatIsVirtual'

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_InvoiceMade.F_InvoiceMade_Load(Object sender, EventArgs e)

----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
DataPortal.Fetch failed (System.Exception: Klaida vykdant SELECT sakinį (statement): [SELECT O.ID, O.Preke, O.NameAltLng, O.Kiekis, O.Kaina, O.SumOriginal, O.Tar, O.SumVatOriginal, O.UnitValueLTL, O.SumLTL, O.SumVatLTL, O.Discount, O.DiscountLTL, O.DiscountVat, O.DiscountVatLTL, O.Rusis, O.P_ID, O.Vnt, O.MeasureUnitAltLng, O.P_Sas, O.A_Sas, O.AccountDiscount, O.IncludeVatInObject, O.VatIsVirtual FROM sfd O WHERE O.SF_ID=$MD GROUP BY O.ID;=$MD GROUP BY O.ID;], Params: ?MD=2855;
Klaidos turinys: 'SQLite error
no such column: O.VatIsVirtual'. ---> System.Data.SQLite.SQLiteException: SQLite error
no such column: O.VatIsVirtual
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.Documents.InvoiceMadeItemList.Fetch(InvoiceMade parentInvoice, SimpleChronologicValidator baseChronologyValidator)
at ApskaitaObjects.Documents.InvoiceMadeItemList..ctor(InvoiceMade parentInvoice, SimpleChronologicValidator baseChronologyValidator)
at ApskaitaObjects.Documents.InvoiceMade.DoFetch(Int32 invoiceID, Boolean skipValidationAndMarkOld)
at ApskaitaObjects.Documents.InvoiceMade.DataPortal_Fetch(Criteria criteria))
Klaidos šaltinis(Ex.Source):
Csla
Klaidos metodas (Ex.TargetSite):
Fetch
Klaidos stekas:
at AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLCommand.Fetch()
at ApskaitaObjects.Documents.InvoiceMadeItemList.Fetch(InvoiceMade parentInvoice, SimpleChronologicValidator baseChronologyValidator)
at ApskaitaObjects.Documents.InvoiceMadeItemList..ctor(InvoiceMade parentInvoice, SimpleChronologicValidator baseChronologyValidator)
at ApskaitaObjects.Documents.InvoiceMade.DoFetch(Int32 invoiceID, Boolean skipValidationAndMarkOld)
at ApskaitaObjects.Documents.InvoiceMade.DataPortal_Fetch(Criteria criteria)
at Csla.MethodCaller.CallMethod(Object obj, MethodInfo info, Object[] parameters)
at Csla.Server.SimpleDataPortal.Fetch(Type objectType, Object criteria, DataPortalContext context)
at Csla.DataPortal.Fetch(Type objectType, Object criteria)
at Csla.DataPortal.Fetch[T](Object criteria)
at ApskaitaObjects.Documents.InvoiceMade.GetInvoiceMade(Int32 nID)

----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
DataPortal_Fetch 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.Documents.InvoiceMadeItemList.Fetch(InvoiceMade parentInvoice, SimpleChronologicValidator baseChronologyValidator)
at ApskaitaObjects.Documents.InvoiceMadeItemList..ctor(InvoiceMade parentInvoice, SimpleChronologicValidator baseChronologyValidator)
at ApskaitaObjects.Documents.InvoiceMade.DoFetch(Int32 invoiceID, Boolean skipValidationAndMarkOld)
at ApskaitaObjects.Documents.InvoiceMade.DataPortal_Fetch(Criteria criteria)
at Csla.MethodCaller.CallMethod(Object obj, MethodInfo info, Object[] parameters)
at Csla.Server.SimpleDataPortal.Fetch(Type objectType, Object criteria, DataPortalContext context)

----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
Klaida vykdant SELECT sakinį (statement): [SELECT O.ID, O.Preke, O.NameAltLng, O.Kiekis, O.Kaina, O.SumOriginal, O.Tar, O.SumVatOriginal, O.UnitValueLTL, O.SumLTL, O.SumVatLTL, O.Discount, O.DiscountLTL, O.DiscountVat, O.DiscountVatLTL, O.Rusis, O.P_ID, O.Vnt, O.MeasureUnitAltLng, O.P_Sas, O.A_Sas, O.AccountDiscount, O.IncludeVatInObject, O.VatIsVirtual FROM sfd O WHERE O.SF_ID=$MD GROUP BY O.ID;=$MD GROUP BY O.ID;], Params: ?MD=2855;
Klaidos turinys: 'SQLite error
no such column: O.VatIsVirtual'.
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.Documents.InvoiceMadeItemList.Fetch(InvoiceMade parentInvoice, SimpleChronologicValidator baseChronologyValidator)
at ApskaitaObjects.Documents.InvoiceMadeItemList..ctor(InvoiceMade parentInvoice, SimpleChronologicValidator baseChronologyValidator)
at ApskaitaObjects.Documents.InvoiceMade.DoFetch(Int32 invoiceID, Boolean skipValidationAndMarkOld)
at ApskaitaObjects.Documents.InvoiceMade.DataPortal_Fetch(Criteria criteria)

----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
SQLite error
no such column: O.VatIsVirtual
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)

GPM sumokėtas. :) Norėjau galutinai atsiskaityt su SODRA už atleistą darbuotoją, galvojau, kad vakarykštė diena yra paskutinė ir po to delspiningiai skaičiuojas. :) Ačiū labai už info, šiandien ramiau gyvensiu. :)

Labas. :) Esu dar nauja buhalterės kėdėj ir iškilo toks klausimėlis. Vakar buvo paskutinė diena apmokėjimui už atleistą darbuotoją, bet gavosi taip, kad neišėjo apmokėti, nes įmonės sąskaitoj nebuvo reikiamo pinigų kiekio 78,14 eur. Šiandien ryte apmokėjimą padariau, gavosi, kad už vieną dieną reiks mokėti delspinigius. Ar man būtina pačiai tuos delspinigius apsiskaičiuoti ir apmokėti SODRAI? Ar gruodį deklaruojant pažymas man kokius papildomus laukelius reiks užpildyt ir viskas susivienodins ?