Pavyko susitvarkyti :)

Sveiki,
gal galite padėti įvedant į sąskaitų planą naują sąskaitą neina jos išsaugoti ir išmeta tokią klaidą.ir (klaida detaliau žemiau.)



Klaida transakcijoje vykdant SQL sakinį [INSERT INTO saskaitupl(Saskaitosnr, Saskaita, Rusis, fs_id) VALUES($SN, $SP, $CM, $FD);], Params: ?SN=2435; ?SP=atskaitingi asmenys; ?CM=; ?FD=15;
Klaidos turinys: 'Klaida vykdant SQL komandą: [INSERT INTO saskaitupl(Saskaitosnr, Saskaita, Rusis, fs_id) VALUES($SN, $SP, $CM, $FD);], Params: ?SN=2435; ?SP=atskaitingi asmenys; ?CM=; ?FD=15;
Klaidos turinys: 'Abort due to constraint violation
saskaitupl.SaftCode may not be NULL'.'.

Paspaudus detaliau.

Klaidos duomenys:
Klaidos tekstas:
DataPortal.Update failed (System.Exception: Klaida transakcijoje vykdant SQL sakinį [INSERT INTO saskaitupl(Saskaitosnr, Saskaita, Rusis, fs_id) VALUES($SN, $SP, $CM, $FD);], Params: ?SN=2435; ?SP=atskaitingi asmenys; ?CM=; ?FD=15;
Klaidos turinys: 'Klaida vykdant SQL komandą: [INSERT INTO saskaitupl(Saskaitosnr, Saskaita, Rusis, fs_id) VALUES($SN, $SP, $CM, $FD);], Params: ?SN=2435; ?SP=atskaitingi asmenys; ?CM=; ?FD=15;
Klaidos turinys: 'Abort due to constraint violation
saskaitupl.SaftCode may not be NULL'.'. ---> System.Exception: Klaida vykdant SQL komandą: [INSERT INTO saskaitupl(Saskaitosnr, Saskaita, Rusis, fs_id) VALUES($SN, $SP, $CM, $FD);], Params: ?SN=2435; ?SP=atskaitingi asmenys; ?CM=; ?FD=15;
Klaidos turinys: 'Abort due to constraint violation
saskaitupl.SaftCode may not be NULL'. ---> System.Data.SQLite.SQLiteException: Abort due to constraint violation
saskaitupl.SaftCode may not be NULL
at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
at System.Data.SQLite.SQLiteCommand.ExecuteScalar()
at AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.ExecuteCommand(SQLCommand CommandToExecute, Int32& RowsAffected)
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
at AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.TransactionRollBack(Exception e)
at AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.ExecuteCommand(SQLCommand CommandToExecute, Int32& RowsAffected)
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.ExecuteCommand(SQLCommand CommandToExecute, Int32& RowsAffected)
at AccDataAccessLayer.DatabaseAccess.SQLCommand.Execute()
at ApskaitaObjects.General.Account.Insert(AccountList parent)
at ApskaitaObjects.General.AccountList.DoUpdate()
at ApskaitaObjects.General.AccountList.DataPortal_Update())
Klaidos šaltinis(Ex.Source):
Microsoft.VisualBasic
Klaidos metodas (Ex.TargetSite):
InvokeMethod
Klaidos stekas:
at AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.TransactionRollBack(Exception e)
at AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.ExecuteCommand(SQLCommand CommandToExecute, Int32& RowsAffected)
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.ExecuteCommand(SQLCommand CommandToExecute, Int32& RowsAffected)
at AccDataAccessLayer.DatabaseAccess.SQLCommand.Execute()
at ApskaitaObjects.General.Account.Insert(AccountList parent)
at ApskaitaObjects.General.AccountList.DoUpdate()
at ApskaitaObjects.General.AccountList.DataPortal_Update()
at Csla.MethodCaller.CallMethod(Object obj, MethodInfo info, Object[] parameters)
at Csla.MethodCaller.CallMethod(Object obj, String method, Object[] parameters)
at Csla.Server.SimpleDataPortal.Update(Object obj, DataPortalContext context)
at Microsoft.VisualBasic.CompilerServices.Symbols.Container.InvokeMethod(Method TargetProcedure, Object[] Arguments, Boolean[] CopyBack, BindingFlags Flags)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack)
at AccDataBindingsWinForms.CslaActionExtenderEditForm`1.Save(Boolean closeFormAfterSave)

----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
DataPortal_Update method call failed
Klaidos šaltinis(Ex.Source):
Csla
Klaidos metodas (Ex.TargetSite):
CallMethod
Klaidos stekas:
at AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.TransactionRollBack(Exception e)
at AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.ExecuteCommand(SQLCommand CommandToExecute, Int32& RowsAffected)
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.ExecuteCommand(SQLCommand CommandToExecute, Int32& RowsAffected)
at AccDataAccessLayer.DatabaseAccess.SQLCommand.Execute()
at ApskaitaObjects.General.Account.Insert(AccountList parent)
at ApskaitaObjects.General.AccountList.DoUpdate()
at ApskaitaObjects.General.AccountList.DataPortal_Update()
at Csla.MethodCaller.CallMethod(Object obj, MethodInfo info, Object[] parameters)
at Csla.MethodCaller.CallMethod(Object obj, String method, Object[] parameters)
at Csla.Server.SimpleDataPortal.Update(Object obj, DataPortalContext context)

----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
Klaida transakcijoje vykdant SQL sakinį [INSERT INTO saskaitupl(Saskaitosnr, Saskaita, Rusis, fs_id) VALUES($SN, $SP, $CM, $FD);], Params: ?SN=2435; ?SP=atskaitingi asmenys; ?CM=; ?FD=15;
Klaidos turinys: 'Klaida vykdant SQL komandą: [INSERT INTO saskaitupl(Saskaitosnr, Saskaita, Rusis, fs_id) VALUES($SN, $SP, $CM, $FD);], Params: ?SN=2435; ?SP=atskaitingi asmenys; ?CM=; ?FD=15;
Klaidos turinys: 'Abort due to constraint violation
saskaitupl.SaftCode may not be NULL'.'.
Klaidos šaltinis(Ex.Source):
AccDataAccessLayer
Klaidos metodas (Ex.TargetSite):
TransactionRollBack
Klaidos stekas:
at AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.TransactionRollBack(Exception e)
at AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.ExecuteCommand(SQLCommand CommandToExecute, Int32& RowsAffected)
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.ExecuteCommand(SQLCommand CommandToExecute, Int32& RowsAffected)
at AccDataAccessLayer.DatabaseAccess.SQLCommand.Execute()
at ApskaitaObjects.General.Account.Insert(AccountList parent)
at ApskaitaObjects.General.AccountList.DoUpdate()
at ApskaitaObjects.General.AccountList.DataPortal_Update()

----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
Klaida vykdant SQL komandą: [INSERT INTO saskaitupl(Saskaitosnr, Saskaita, Rusis, fs_id) VALUES($SN, $SP, $CM, $FD);], Params: ?SN=2435; ?SP=atskaitingi asmenys; ?CM=; ?FD=15;
Klaidos turinys: 'Abort due to constraint violation
saskaitupl.SaftCode may not be NULL'.

----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
Abort due to constraint violation
saskaitupl.SaftCode may not be NULL
Klaidos šaltinis(Ex.Source):
System.Data.SQLite
Klaidos metodas (Ex.TargetSite):
Reset
Klaidos stekas:
at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
at System.Data.SQLite.SQLiteCommand.ExecuteScalar()
at AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.ExecuteCommand(SQLCommand CommandToExecute, Int32& RowsAffected)

dar kartą pamėginau ir išmeta klaidą

Klaida. Nepavyko konvertuoti duomenų į naują versiją: LostAssets


Paspaudus detaliau

Klaidos duomenys:
Klaidos tekstas:
DataPortal.Update failed (System.Exception: Klaida. Nepavyko konvertuoti duomenų į naują versiją: LostAssets
at ApskaitaObjects.CustomDatabaseStructureErrorManager.RepairCustomError(DatabaseStructureErrorList& StructureErrorList, DatabaseStructureError CustomError)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureError.Update(DatabaseStructureErrorList& parent)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureErrorList.DataPortal_Update())
Klaidos šaltinis(Ex.Source):
Csla
Klaidos metodas (Ex.TargetSite):
Update
Klaidos stekas:
at ApskaitaObjects.CustomDatabaseStructureErrorManager.RepairCustomError(DatabaseStructureErrorList& StructureErrorList, DatabaseStructureError CustomError)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureError.Update(DatabaseStructureErrorList& parent)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureErrorList.DataPortal_Update()
at Csla.MethodCaller.CallMethod(Object obj, MethodInfo info, Object[] parameters)
at Csla.MethodCaller.CallMethod(Object obj, String method, Object[] parameters)
at Csla.Server.SimpleDataPortal.Update(Object obj, DataPortalContext context)
at Csla.DataPortal.Update(Object obj)
at Csla.DataPortal.Update[T](T obj)
at Csla.BusinessListBase`2.Save()
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureErrorList.Save()
at ApskaitaWUI.F_DatabaseStructureError.RepairErrorsButton_Click(Object sender, EventArgs e)

----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
DataPortal_Update method call failed
Klaidos šaltinis(Ex.Source):
Csla
Klaidos metodas (Ex.TargetSite):
CallMethod
Klaidos stekas:
at ApskaitaObjects.CustomDatabaseStructureErrorManager.RepairCustomError(DatabaseStructureErrorList& StructureErrorList, DatabaseStructureError CustomError)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureError.Update(DatabaseStructureErrorList& parent)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureErrorList.DataPortal_Update()
at Csla.MethodCaller.CallMethod(Object obj, MethodInfo info, Object[] parameters)
at Csla.MethodCaller.CallMethod(Object obj, String method, Object[] parameters)
at Csla.Server.SimpleDataPortal.Update(Object obj, DataPortalContext context)

----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
Klaida. Nepavyko konvertuoti duomenų į naują versiją: LostAssets
Klaidos šaltinis(Ex.Source):
ApskaitaObjects
Klaidos metodas (Ex.TargetSite):
RepairCustomError
Klaidos stekas:
at ApskaitaObjects.CustomDatabaseStructureErrorManager.RepairCustomError(DatabaseStructureErrorList& StructureErrorList, DatabaseStructureError CustomError)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureError.Update(DatabaseStructureErrorList& parent)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureErrorList.DataPortal_Update()

paspaudus detaliau

Klaidos duomenys:
Klaidos tekstas:
DataPortal.Update failed (System.Exception: Klaida vykdant SELECT sakinį (statement): [SELECT (SELECT COUNT(*) FROM apyskaitos a LEFT JOIN asmenys b ON b.ID=a.Analit WHERE b.ID IS NULL and a.Analit>0) AS LostPersonApysk, (SELECT COUNT(*) FROM bz a LEFT JOIN asmenys b ON b.ID=a.Op_analitika WHERE b.ID IS NULL and a.Op_analitika>0) AS LostPersonBZ, (SELECT COUNT(*) FROM bzdata a LEFT JOIN asmenys b ON b.ID=a.Op_ana WHERE b.ID IS NULL and a.Op_ana>0) AS LostPersonBZDATA, (SELECT COUNT(*) FROM d_avansai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonAvansai, (SELECT COUNT(*) FROM darbuotojai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDarbuotojai, (SELECT COUNT(*) FROM du_ziniarastis_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDUZ, (SELECT COUNT(*) FROM offsetitems a LEFT JOIN asmenys b ON b.ID=a.PersonID WHERE b.ID IS NULL and a.PersonID>0) AS LostPersonOffsets, (SELECT COUNT(*) FROM advancereports a WHERE NOT a.Account>0) AS AdvanceReportsWithoutAccount, (SELECT COUNT(*) FROM kio k WHERE NOT k.CashAccountID>0) AS KioWithoutCashAccount, (SELECT COUNT(*) FROM kpo k WHERE NOT k.CashAccountID>0) AS KpoWithoutCashAccount, (SELECT COUNT(*) FROM bankoperations b WHERE NOT b.CashAccountID>0) AS BankWithoutCashAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN kio d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kio' AND d.BZ_ID IS NULL) AS LostKio, (SELECT COUNT(*) FROM bz b LEFT JOIN kpo d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kpo' AND d.BZ_ID IS NULL) AS LostKpo, (SELECT COUNT(*) FROM bz b LEFT JOIN bankoperations d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='b' AND d.ParentID IS NULL) AS LostBank, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesmade d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sf' AND d.ID IS NULL) AS LostInvoicesMade, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesreceived d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sg' AND d.ID IS NULL) AS LostInvoicesReceived, (SELECT COUNT(*) FROM bz b LEFT JOIN offsetitems d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='sk' AND d.ParentID IS NULL) AS LostOffsets, (SELECT COUNT(*) FROM invoicesmade i WHERE NOT i.InvoiceNumber>0 OR TRIM(i.InvoiceSerial)='') AS InvoicesWithoutNumber, (SELECT COUNT(*) FROM invoicesreceived i WHERE NOT i.AccountSupplier>0) AS InvoicesReceivedWithoutAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN turtas_op d ON d.JE_ID=b.Op_ID WHERE (b.Op_dok_rusis='amo' OR b.Op_dok_rusis='t' OR b.Op_dok_rusis='tsp') AND d.JE_ID IS NULL) AS LostAssetOperations, (SELECT COUNT(*) FROM turtas_op d LEFT JOIN bz b ON b.Op_ID=d.JE_ID WHERE (d.OperationType='aac' OR d.OperationType='amo' OR d.OperationType='nur' OR d.OperationType='per') AND b.Op_ID IS NULL) AS LostAssetOperations2, (SELECT COUNT(*) FROM turtas t LEFT JOIN bz b ON b.OP_ID=t.ID WHERE b.Op_ID IS NULL) AS LostAssets;=a.Analit WHERE b.ID IS NULL and a.Analit>0) AS LostPersonApysk, (SELECT COUNT(*) FROM bz a LEFT JOIN asmenys b ON b.ID=a.Op_analitika WHERE b.ID IS NULL and a.Op_analitika>0) AS LostPersonBZ, (SELECT COUNT(*) FROM bzdata a LEFT JOIN asmenys b ON b.ID=a.Op_ana WHERE b.ID IS NULL and a.Op_ana>0) AS LostPersonBZDATA, (SELECT COUNT(*) FROM d_avansai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonAvansai, (SELECT COUNT(*) FROM darbuotojai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDarbuotojai, (SELECT COUNT(*) FROM du_ziniarastis_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDUZ, (SELECT COUNT(*) FROM offsetitems a LEFT JOIN asmenys b ON b.ID=a.PersonID WHERE b.ID IS NULL and a.PersonID>0) AS LostPersonOffsets, (SELECT COUNT(*) FROM advancereports a WHERE NOT a.Account>0) AS AdvanceReportsWithoutAccount, (SELECT COUNT(*) FROM kio k WHERE NOT k.CashAccountID>0) AS KioWithoutCashAccount, (SELECT COUNT(*) FROM kpo k WHERE NOT k.CashAccountID>0) AS KpoWithoutCashAccount, (SELECT COUNT(*) FROM bankoperations b WHERE NOT b.CashAccountID>0) AS BankWithoutCashAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN kio d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kio' AND d.BZ_ID IS NULL) AS LostKio, (SELECT COUNT(*) FROM bz b LEFT JOIN kpo d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kpo' AND d.BZ_ID IS NULL) AS LostKpo, (SELECT COUNT(*) FROM bz b LEFT JOIN bankoperations d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='b' AND d.ParentID IS NULL) AS LostBank, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesmade d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sf' AND d.ID IS NULL) AS LostInvoicesMade, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesreceived d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sg' AND d.ID IS NULL) AS LostInvoicesReceived, (SELECT COUNT(*) FROM bz b LEFT JOIN offsetitems d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='sk' AND d.ParentID IS NULL) AS LostOffsets, (SELECT COUNT(*) FROM invoicesmade i WHERE NOT i.InvoiceNumber>0 OR TRIM(i.InvoiceSerial)='') AS InvoicesWithoutNumber, (SELECT COUNT(*) FROM invoicesreceived i WHERE NOT i.AccountSupplier>0) AS InvoicesReceivedWithoutAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN turtas_op d ON d.JE_ID=b.Op_ID WHERE (b.Op_dok_rusis='amo' OR b.Op_dok_rusis='t' OR b.Op_dok_rusis='tsp') AND d.JE_ID IS NULL) AS LostAssetOperations, (SELECT COUNT(*) FROM turtas_op d LEFT JOIN bz b ON b.Op_ID=d.JE_ID WHERE (d.OperationType='aac' OR d.OperationType='amo' OR d.OperationType='nur' OR d.OperationType='per') AND b.Op_ID IS NULL) AS LostAssetOperations2, (SELECT COUNT(*) FROM turtas t LEFT JOIN bz b ON b.OP_ID=t.ID WHERE b.Op_ID IS NULL) AS LostAssets;], Params:
Klaidos turinys: 'Unknown column 'k.CashAccountID' in 'where clause''. ---> MySql.Data.MySqlClient.MySqlException: Unknown column 'k.CashAccountID' in 'where clause'
at MySql.Data.MySqlClient.MySqlStream.OpenPacket()
at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId)
at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.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.MySqlCommandManager.FetchCommand(SQLCommand SelectCommand)
--- End of inner exception stack trace ---
at AccDataAccessLayer.SqlServerSpecificMethods.MySqlCommandManager.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLCommand.Fetch()
at ApskaitaObjects.CustomDatabaseStructureErrorManager.RepairCustomError(DatabaseStructureErrorList& StructureErrorList, DatabaseStructureError CustomError)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureError.Update(DatabaseStructureErrorList& parent)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureErrorList.DataPortal_Update())
Klaidos šaltinis(Ex.Source):
Csla
Klaidos metodas (Ex.TargetSite):
Update
Klaidos stekas:
at AccDataAccessLayer.SqlServerSpecificMethods.MySqlCommandManager.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLCommand.Fetch()
at ApskaitaObjects.CustomDatabaseStructureErrorManager.RepairCustomError(DatabaseStructureErrorList& StructureErrorList, DatabaseStructureError CustomError)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureError.Update(DatabaseStructureErrorList& parent)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureErrorList.DataPortal_Update()
at Csla.MethodCaller.CallMethod(Object obj, MethodInfo info, Object[] parameters)
at Csla.MethodCaller.CallMethod(Object obj, String method, Object[] parameters)
at Csla.Server.SimpleDataPortal.Update(Object obj, DataPortalContext context)
at Csla.DataPortal.Update(Object obj)
at Csla.DataPortal.Update[T](T obj)
at Csla.BusinessListBase`2.Save()
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureErrorList.Save()
at ApskaitaWUI.F_DatabaseStructureError.RepairErrorsButton_Click(Object sender, EventArgs e)

----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
DataPortal_Update method call failed
Klaidos šaltinis(Ex.Source):
Csla
Klaidos metodas (Ex.TargetSite):
CallMethod
Klaidos stekas:
at AccDataAccessLayer.SqlServerSpecificMethods.MySqlCommandManager.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLCommand.Fetch()
at ApskaitaObjects.CustomDatabaseStructureErrorManager.RepairCustomError(DatabaseStructureErrorList& StructureErrorList, DatabaseStructureError CustomError)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureError.Update(DatabaseStructureErrorList& parent)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureErrorList.DataPortal_Update()
at Csla.MethodCaller.CallMethod(Object obj, MethodInfo info, Object[] parameters)
at Csla.MethodCaller.CallMethod(Object obj, String method, Object[] parameters)
at Csla.Server.SimpleDataPortal.Update(Object obj, DataPortalContext context)

----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
Klaida vykdant SELECT sakinį (statement): [SELECT (SELECT COUNT(*) FROM apyskaitos a LEFT JOIN asmenys b ON b.ID=a.Analit WHERE b.ID IS NULL and a.Analit>0) AS LostPersonApysk, (SELECT COUNT(*) FROM bz a LEFT JOIN asmenys b ON b.ID=a.Op_analitika WHERE b.ID IS NULL and a.Op_analitika>0) AS LostPersonBZ, (SELECT COUNT(*) FROM bzdata a LEFT JOIN asmenys b ON b.ID=a.Op_ana WHERE b.ID IS NULL and a.Op_ana>0) AS LostPersonBZDATA, (SELECT COUNT(*) FROM d_avansai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonAvansai, (SELECT COUNT(*) FROM darbuotojai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDarbuotojai, (SELECT COUNT(*) FROM du_ziniarastis_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDUZ, (SELECT COUNT(*) FROM offsetitems a LEFT JOIN asmenys b ON b.ID=a.PersonID WHERE b.ID IS NULL and a.PersonID>0) AS LostPersonOffsets, (SELECT COUNT(*) FROM advancereports a WHERE NOT a.Account>0) AS AdvanceReportsWithoutAccount, (SELECT COUNT(*) FROM kio k WHERE NOT k.CashAccountID>0) AS KioWithoutCashAccount, (SELECT COUNT(*) FROM kpo k WHERE NOT k.CashAccountID>0) AS KpoWithoutCashAccount, (SELECT COUNT(*) FROM bankoperations b WHERE NOT b.CashAccountID>0) AS BankWithoutCashAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN kio d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kio' AND d.BZ_ID IS NULL) AS LostKio, (SELECT COUNT(*) FROM bz b LEFT JOIN kpo d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kpo' AND d.BZ_ID IS NULL) AS LostKpo, (SELECT COUNT(*) FROM bz b LEFT JOIN bankoperations d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='b' AND d.ParentID IS NULL) AS LostBank, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesmade d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sf' AND d.ID IS NULL) AS LostInvoicesMade, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesreceived d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sg' AND d.ID IS NULL) AS LostInvoicesReceived, (SELECT COUNT(*) FROM bz b LEFT JOIN offsetitems d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='sk' AND d.ParentID IS NULL) AS LostOffsets, (SELECT COUNT(*) FROM invoicesmade i WHERE NOT i.InvoiceNumber>0 OR TRIM(i.InvoiceSerial)='') AS InvoicesWithoutNumber, (SELECT COUNT(*) FROM invoicesreceived i WHERE NOT i.AccountSupplier>0) AS InvoicesReceivedWithoutAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN turtas_op d ON d.JE_ID=b.Op_ID WHERE (b.Op_dok_rusis='amo' OR b.Op_dok_rusis='t' OR b.Op_dok_rusis='tsp') AND d.JE_ID IS NULL) AS LostAssetOperations, (SELECT COUNT(*) FROM turtas_op d LEFT JOIN bz b ON b.Op_ID=d.JE_ID WHERE (d.OperationType='aac' OR d.OperationType='amo' OR d.OperationType='nur' OR d.OperationType='per') AND b.Op_ID IS NULL) AS LostAssetOperations2, (SELECT COUNT(*) FROM turtas t LEFT JOIN bz b ON b.OP_ID=t.ID WHERE b.Op_ID IS NULL) AS LostAssets;=a.Analit WHERE b.ID IS NULL and a.Analit>0) AS LostPersonApysk, (SELECT COUNT(*) FROM bz a LEFT JOIN asmenys b ON b.ID=a.Op_analitika WHERE b.ID IS NULL and a.Op_analitika>0) AS LostPersonBZ, (SELECT COUNT(*) FROM bzdata a LEFT JOIN asmenys b ON b.ID=a.Op_ana WHERE b.ID IS NULL and a.Op_ana>0) AS LostPersonBZDATA, (SELECT COUNT(*) FROM d_avansai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonAvansai, (SELECT COUNT(*) FROM darbuotojai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDarbuotojai, (SELECT COUNT(*) FROM du_ziniarastis_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDUZ, (SELECT COUNT(*) FROM offsetitems a LEFT JOIN asmenys b ON b.ID=a.PersonID WHERE b.ID IS NULL and a.PersonID>0) AS LostPersonOffsets, (SELECT COUNT(*) FROM advancereports a WHERE NOT a.Account>0) AS AdvanceReportsWithoutAccount, (SELECT COUNT(*) FROM kio k WHERE NOT k.CashAccountID>0) AS KioWithoutCashAccount, (SELECT COUNT(*) FROM kpo k WHERE NOT k.CashAccountID>0) AS KpoWithoutCashAccount, (SELECT COUNT(*) FROM bankoperations b WHERE NOT b.CashAccountID>0) AS BankWithoutCashAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN kio d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kio' AND d.BZ_ID IS NULL) AS LostKio, (SELECT COUNT(*) FROM bz b LEFT JOIN kpo d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kpo' AND d.BZ_ID IS NULL) AS LostKpo, (SELECT COUNT(*) FROM bz b LEFT JOIN bankoperations d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='b' AND d.ParentID IS NULL) AS LostBank, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesmade d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sf' AND d.ID IS NULL) AS LostInvoicesMade, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesreceived d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sg' AND d.ID IS NULL) AS LostInvoicesReceived, (SELECT COUNT(*) FROM bz b LEFT JOIN offsetitems d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='sk' AND d.ParentID IS NULL) AS LostOffsets, (SELECT COUNT(*) FROM invoicesmade i WHERE NOT i.InvoiceNumber>0 OR TRIM(i.InvoiceSerial)='') AS InvoicesWithoutNumber, (SELECT COUNT(*) FROM invoicesreceived i WHERE NOT i.AccountSupplier>0) AS InvoicesReceivedWithoutAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN turtas_op d ON d.JE_ID=b.Op_ID WHERE (b.Op_dok_rusis='amo' OR b.Op_dok_rusis='t' OR b.Op_dok_rusis='tsp') AND d.JE_ID IS NULL) AS LostAssetOperations, (SELECT COUNT(*) FROM turtas_op d LEFT JOIN bz b ON b.Op_ID=d.JE_ID WHERE (d.OperationType='aac' OR d.OperationType='amo' OR d.OperationType='nur' OR d.OperationType='per') AND b.Op_ID IS NULL) AS LostAssetOperations2, (SELECT COUNT(*) FROM turtas t LEFT JOIN bz b ON b.OP_ID=t.ID WHERE b.Op_ID IS NULL) AS LostAssets;], Params:
Klaidos turinys: 'Unknown column 'k.CashAccountID' in 'where clause''.
Klaidos šaltinis(Ex.Source):
AccDataAccessLayer
Klaidos metodas (Ex.TargetSite):
FetchCommand
Klaidos stekas:
at AccDataAccessLayer.SqlServerSpecificMethods.MySqlCommandManager.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLCommand.Fetch()
at ApskaitaObjects.CustomDatabaseStructureErrorManager.RepairCustomError(DatabaseStructureErrorList& StructureErrorList, DatabaseStructureError CustomError)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureError.Update(DatabaseStructureErrorList& parent)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureErrorList.DataPortal_Update()

----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
Unknown column 'k.CashAccountID' in 'where clause'
Klaidos šaltinis(Ex.Source):
MySql.Data
Klaidos metodas (Ex.TargetSite):
OpenPacket
Klaidos stekas:
at MySql.Data.MySqlClient.MySqlStream.OpenPacket()
at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId)
at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.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.MySqlCommandManager.FetchCommand(SQLCommand SelectCommand)

Sveiki, gal galite padėti. perkeliant duomenis is senos i nauja versija, užstringu ties 4 punktu atliekant šį veiksmą Bendras\DB struktūra -> Tikrinti -> Taisyti; išmeta tokią klaida Klaida vykdant SELECT sakinį (statement): [SELECT (SELECT COUNT(*) FROM apyskaitos a LEFT JOIN asmenys b ON b.ID=a.Analit WHERE b.ID IS NULL and a.Analit>0) AS LostPersonApysk, (SELECT COUNT(*) FROM bz a LEFT JOIN asmenys b ON b.ID=a.Op_analitika WHERE b.ID IS NULL and a.Op_analitika>0) AS LostPersonBZ, (SELECT COUNT(*) FROM bzdata a LEFT JOIN asmenys b ON b.ID=a.Op_ana WHERE b.ID IS NULL and a.Op_ana>0) AS LostPersonBZDATA, (SELECT COUNT(*) FROM d_avansai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonAvansai, (SELECT COUNT(*) FROM darbuotojai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDarbuotojai, (SELECT COUNT(*) FROM du_ziniarastis_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDUZ, (SELECT COUNT(*) FROM offsetitems a LEFT JOIN asmenys b ON b.ID=a.PersonID WHERE b.ID IS NULL and a.PersonID>0) AS LostPersonOffsets, (SELECT COUNT(*) FROM advancereports a WHERE NOT a.Account>0) AS AdvanceReportsWithoutAccount, (SELECT COUNT(*) FROM kio k WHERE NOT k.CashAccountID>0) AS KioWithoutCashAccount, (SELECT COUNT(*) FROM kpo k WHERE NOT k.CashAccountID>0) AS KpoWithoutCashAccount, (SELECT COUNT(*) FROM bankoperations b WHERE NOT b.CashAccountID>0) AS BankWithoutCashAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN kio d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kio' AND d.BZ_ID IS NULL) AS LostKio, (SELECT COUNT(*) FROM bz b LEFT JOIN kpo d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kpo' AND d.BZ_ID IS NULL) AS LostKpo, (SELECT COUNT(*) FROM bz b LEFT JOIN bankoperations d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='b' AND d.ParentID IS NULL) AS LostBank, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesmade d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sf' AND d.ID IS NULL) AS LostInvoicesMade, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesreceived d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sg' AND d.ID IS NULL) AS LostInvoicesReceived, (SELECT COUNT(*) FROM bz b LEFT JOIN offsetitems d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='sk' AND d.ParentID IS NULL) AS LostOffsets, (SELECT COUNT(*) FROM invoicesmade i WHERE NOT i.InvoiceNumber>0 OR TRIM(i.InvoiceSerial)='') AS InvoicesWithoutNumber, (SELECT COUNT(*) FROM invoicesreceived i WHERE NOT i.AccountSupplier>0) AS InvoicesReceivedWithoutAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN turtas_op d ON d.JE_ID=b.Op_ID WHERE (b.Op_dok_rusis='amo' OR b.Op_dok_rusis='t' OR b.Op_dok_rusis='tsp') AND d.JE_ID IS NULL) AS LostAssetOperations, (SELECT COUNT(*) FROM turtas_op d LEFT JOIN bz b ON b.Op_ID=d.JE_ID WHERE (d.OperationType='aac' OR d.OperationType='amo' OR d.OperationType='nur' OR d.OperationType='per') AND b.Op_ID IS NULL) AS LostAssetOperations2, (SELECT COUNT(*) FROM turtas t LEFT JOIN bz b ON b.OP_ID=t.ID WHERE b.Op_ID IS NULL) AS LostAssets;=a.Analit WHERE b.ID IS NULL and a.Analit>0) AS LostPersonApysk, (SELECT COUNT(*) FROM bz a LEFT JOIN asmenys b ON b.ID=a.Op_analitika WHERE b.ID IS NULL and a.Op_analitika>0) AS LostPersonBZ, (SELECT COUNT(*) FROM bzdata a LEFT JOIN asmenys b ON b.ID=a.Op_ana WHERE b.ID IS NULL and a.Op_ana>0) AS LostPersonBZDATA, (SELECT COUNT(*) FROM d_avansai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonAvansai, (SELECT COUNT(*) FROM darbuotojai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDarbuotojai, (SELECT COUNT(*) FROM du_ziniarastis_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDUZ, (SELECT COUNT(*) FROM offsetitems a LEFT JOIN asmenys b ON b.ID=a.PersonID WHERE b.ID IS NULL and a.PersonID>0) AS LostPersonOffsets, (SELECT COUNT(*) FROM advancereports a WHERE NOT a.Account>0) AS AdvanceReportsWithoutAccount, (SELECT COUNT(*) FROM kio k WHERE NOT k.CashAccountID>0) AS KioWithoutCashAccount, (SELECT COUNT(*) FROM kpo k WHERE NOT k.CashAccountID>0) AS KpoWithoutCashAccount, (SELECT COUNT(*) FROM bankoperations b WHERE NOT b.CashAccountID>0) AS BankWithoutCashAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN kio d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kio' AND d.BZ_ID IS NULL) AS LostKio, (SELECT COUNT(*) FROM bz b LEFT JOIN kpo d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kpo' AND d.BZ_ID IS NULL) AS LostKpo, (SELECT COUNT(*) FROM bz b LEFT JOIN bankoperations d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='b' AND d.ParentID IS NULL) AS LostBank, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesmade d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sf' AND d.ID IS NULL) AS LostInvoicesMade, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesreceived d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sg' AND d.ID IS NULL) AS LostInvoicesReceived, (SELECT COUNT(*) FROM bz b LEFT JOIN offsetitems d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='sk' AND d.ParentID IS NULL) AS LostOffsets, (SELECT COUNT(*) FROM invoicesmade i WHERE NOT i.InvoiceNumber>0 OR TRIM(i.InvoiceSerial)='') AS InvoicesWithoutNumber, (SELECT COUNT(*) FROM invoicesreceived i WHERE NOT i.AccountSupplier>0) AS InvoicesReceivedWithoutAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN turtas_op d ON d.JE_ID=b.Op_ID WHERE (b.Op_dok_rusis='amo' OR b.Op_dok_rusis='t' OR b.Op_dok_rusis='tsp') AND d.JE_ID IS NULL) AS LostAssetOperations, (SELECT COUNT(*) FROM turtas_op d LEFT JOIN bz b ON b.Op_ID=d.JE_ID WHERE (d.OperationType='aac' OR d.OperationType='amo' OR d.OperationType='nur' OR d.OperationType='per') AND b.Op_ID IS NULL) AS LostAssetOperations2, (SELECT COUNT(*) FROM turtas t LEFT JOIN bz b ON b.OP_ID=t.ID WHERE b.Op_ID IS NULL) AS LostAssets;], Params:
Klaidos turinys: 'Unknown column 'k.CashAccountID' in 'where clause''.

Sveiki, gal galite padėti. perkeliant duomenis is senos i nauja versija, užstringu ties 4 punktu atliekant šį veiksmą Bendras\DB struktūra -> Tikrinti -> Taisyti; išmeta tokią klaida Klaida vykdant SELECT sakinį (statement): [SELECT (SELECT COUNT(*) FROM apyskaitos a LEFT JOIN asmenys b ON b.ID=a.Analit WHERE b.ID IS NULL and a.Analit>0) AS LostPersonApysk, (SELECT COUNT(*) FROM bz a LEFT JOIN asmenys b ON b.ID=a.Op_analitika WHERE b.ID IS NULL and a.Op_analitika>0) AS LostPersonBZ, (SELECT COUNT(*) FROM bzdata a LEFT JOIN asmenys b ON b.ID=a.Op_ana WHERE b.ID IS NULL and a.Op_ana>0) AS LostPersonBZDATA, (SELECT COUNT(*) FROM d_avansai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonAvansai, (SELECT COUNT(*) FROM darbuotojai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDarbuotojai, (SELECT COUNT(*) FROM du_ziniarastis_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDUZ, (SELECT COUNT(*) FROM offsetitems a LEFT JOIN asmenys b ON b.ID=a.PersonID WHERE b.ID IS NULL and a.PersonID>0) AS LostPersonOffsets, (SELECT COUNT(*) FROM advancereports a WHERE NOT a.Account>0) AS AdvanceReportsWithoutAccount, (SELECT COUNT(*) FROM kio k WHERE NOT k.CashAccountID>0) AS KioWithoutCashAccount, (SELECT COUNT(*) FROM kpo k WHERE NOT k.CashAccountID>0) AS KpoWithoutCashAccount, (SELECT COUNT(*) FROM bankoperations b WHERE NOT b.CashAccountID>0) AS BankWithoutCashAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN kio d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kio' AND d.BZ_ID IS NULL) AS LostKio, (SELECT COUNT(*) FROM bz b LEFT JOIN kpo d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kpo' AND d.BZ_ID IS NULL) AS LostKpo, (SELECT COUNT(*) FROM bz b LEFT JOIN bankoperations d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='b' AND d.ParentID IS NULL) AS LostBank, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesmade d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sf' AND d.ID IS NULL) AS LostInvoicesMade, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesreceived d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sg' AND d.ID IS NULL) AS LostInvoicesReceived, (SELECT COUNT(*) FROM bz b LEFT JOIN offsetitems d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='sk' AND d.ParentID IS NULL) AS LostOffsets, (SELECT COUNT(*) FROM invoicesmade i WHERE NOT i.InvoiceNumber>0 OR TRIM(i.InvoiceSerial)='') AS InvoicesWithoutNumber, (SELECT COUNT(*) FROM invoicesreceived i WHERE NOT i.AccountSupplier>0) AS InvoicesReceivedWithoutAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN turtas_op d ON d.JE_ID=b.Op_ID WHERE (b.Op_dok_rusis='amo' OR b.Op_dok_rusis='t' OR b.Op_dok_rusis='tsp') AND d.JE_ID IS NULL) AS LostAssetOperations, (SELECT COUNT(*) FROM turtas_op d LEFT JOIN bz b ON b.Op_ID=d.JE_ID WHERE (d.OperationType='aac' OR d.OperationType='amo' OR d.OperationType='nur' OR d.OperationType='per') AND b.Op_ID IS NULL) AS LostAssetOperations2, (SELECT COUNT(*) FROM turtas t LEFT JOIN bz b ON b.OP_ID=t.ID WHERE b.Op_ID IS NULL) AS LostAssets;=a.Analit WHERE b.ID IS NULL and a.Analit>0) AS LostPersonApysk, (SELECT COUNT(*) FROM bz a LEFT JOIN asmenys b ON b.ID=a.Op_analitika WHERE b.ID IS NULL and a.Op_analitika>0) AS LostPersonBZ, (SELECT COUNT(*) FROM bzdata a LEFT JOIN asmenys b ON b.ID=a.Op_ana WHERE b.ID IS NULL and a.Op_ana>0) AS LostPersonBZDATA, (SELECT COUNT(*) FROM d_avansai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonAvansai, (SELECT COUNT(*) FROM darbuotojai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDarbuotojai, (SELECT COUNT(*) FROM du_ziniarastis_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDUZ, (SELECT COUNT(*) FROM offsetitems a LEFT JOIN asmenys b ON b.ID=a.PersonID WHERE b.ID IS NULL and a.PersonID>0) AS LostPersonOffsets, (SELECT COUNT(*) FROM advancereports a WHERE NOT a.Account>0) AS AdvanceReportsWithoutAccount, (SELECT COUNT(*) FROM kio k WHERE NOT k.CashAccountID>0) AS KioWithoutCashAccount, (SELECT COUNT(*) FROM kpo k WHERE NOT k.CashAccountID>0) AS KpoWithoutCashAccount, (SELECT COUNT(*) FROM bankoperations b WHERE NOT b.CashAccountID>0) AS BankWithoutCashAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN kio d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kio' AND d.BZ_ID IS NULL) AS LostKio, (SELECT COUNT(*) FROM bz b LEFT JOIN kpo d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kpo' AND d.BZ_ID IS NULL) AS LostKpo, (SELECT COUNT(*) FROM bz b LEFT JOIN bankoperations d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='b' AND d.ParentID IS NULL) AS LostBank, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesmade d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sf' AND d.ID IS NULL) AS LostInvoicesMade, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesreceived d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sg' AND d.ID IS NULL) AS LostInvoicesReceived, (SELECT COUNT(*) FROM bz b LEFT JOIN offsetitems d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='sk' AND d.ParentID IS NULL) AS LostOffsets, (SELECT COUNT(*) FROM invoicesmade i WHERE NOT i.InvoiceNumber>0 OR TRIM(i.InvoiceSerial)='') AS InvoicesWithoutNumber, (SELECT COUNT(*) FROM invoicesreceived i WHERE NOT i.AccountSupplier>0) AS InvoicesReceivedWithoutAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN turtas_op d ON d.JE_ID=b.Op_ID WHERE (b.Op_dok_rusis='amo' OR b.Op_dok_rusis='t' OR b.Op_dok_rusis='tsp') AND d.JE_ID IS NULL) AS LostAssetOperations, (SELECT COUNT(*) FROM turtas_op d LEFT JOIN bz b ON b.Op_ID=d.JE_ID WHERE (d.OperationType='aac' OR d.OperationType='amo' OR d.OperationType='nur' OR d.OperationType='per') AND b.Op_ID IS NULL) AS LostAssetOperations2, (SELECT COUNT(*) FROM turtas t LEFT JOIN bz b ON b.OP_ID=t.ID WHERE b.Op_ID IS NULL) AS LostAssets;], Params:
Klaidos turinys: 'Unknown column 'k.CashAccountID' in 'where clause''.