2016-11-24 10:48
rasitaelz
Sveiki, per BŽ noriu ištrinti užskaitos dokumentą, bet meta klaidą. Vakar parsisiunčiau programos atnaujinimą, kai bandau tikrinti per DB struktūrą rašo nepavyko prisijungti prie duomenų bazės. Prašau padėkite, galvojau gal po atnaujinimo susitvarkys savaime, bet jau nuo vakar vis tas pats.
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.Delete failed (System.Exception: Klaida vykdant SELECT sakinį (statement): [SELECT 0, D.ID, B.Op_data, B.Op_Dok, B.Op_turinys, null FROM d_kitos D LEFT JOIN bz B ON B.Op_ID=D.BZ_ID WHERE D.BZ_ID=$JD UNION SELECT 2, T.ID, B.Op_data, B.Op_Dok, T.Turtas, null FROM turtas T LEFT JOIN bz B ON B.Op_ID=T.Isigijimo_dok LEFT JOIN sfd I ON I.SF_ID=T.Isigijimo_dok AND I.Rusis=4 AND I.P_ID=T.ID LEFT JOIN sfg G ON G.BZ_ID=T.Isigijimo_dok AND G.Rus=4 AND G.P_ID=T.ID WHERE T.Isigijimo_dok=$JD AND I.ID IS NULL AND G.ID IS NULL UNION SELECT 1, T.ID, T.OperationDate, B.Op_Dok, CONCAT(D.Turtas, ' - ', T.Content), CAST(T.OperationType AS CHAR) FROM turtas_op T LEFT JOIN turtas D ON D.ID=T.T_ID LEFT JOIN bz B ON B.Op_ID=T.JE_ID LEFT JOIN sfd I ON I.SF_ID=T.JE_ID AND (I.Rusis=3 OR I.Rusis=6) AND I.P_ID=T.ID LEFT JOIN sfg G ON G.BZ_ID=T.JE_ID AND (G.Rus=3 OR G.Rus=6) AND G.P_ID=T.ID WHERE T.OperationType<>'aac' AND T.OperationType<>'amo' AND T.OperationType<>'nur' AND T.JE_ID=$JD AND I.ID IS NULL AND G.ID IS NULL UNION SELECT 3, T.ID, T.OperationDate, T.DocNo, T.Content, CAST(T.OperationType AS CHAR) FROM goodsoperations T LEFT JOIN goodscomplexoperations C ON C.ID=T.ComplexOperationID LEFT JOIN sfd I ON I.SF_ID=T.JournalEntryID AND I.Rusis IN (1, 5, 7, 8) AND I.P_ID=T.ID LEFT JOIN sfg G ON G.BZ_ID=T.JournalEntryID AND G.Rus IN (1, 5, 7, 8) AND G.P_ID=T.ID WHERE C.OperationType IS NULL AND NOT T.OperationType IN (3, 4, 7, 9, 10, 11, 12) AND T.JournalEntryID=$JD AND I.ID IS NULL AND G.ID IS NULL UNION SELECT 4, A.BZ_ID, B.Op_data, B.Op_Dok, B.Op_turinys, null FROM apyskaitos A LEFT JOIN bz B ON B.Op_ID=A.BZ_ID WHERE A.SG=$JD UNION SELECT 5, p.ID, b.Op_data, b.Op_Dok, b.Op_turinys, null FROM payoutnaturalpersonwithouttaxes p LEFT JOIN bz b ON b.Op_ID=p.JournalEntryID WHERE p.JournalEntryID=$JD;=D.BZ_ID WHERE D.BZ_ID=$JD UNION SELECT 2, T.ID, B.Op_data, B.Op_Dok, T.Turtas, null FROM turtas T LEFT JOIN bz B ON B.Op_ID=T.Isigijimo_dok LEFT JOIN sfd I ON I.SF_ID=T.Isigijimo_dok AND I.Rusis=4 AND I.P_ID=T.ID LEFT JOIN sfg G ON G.BZ_ID=T.Isigijimo_dok AND G.Rus=4 AND G.P_ID=T.ID WHERE T.Isigijimo_dok=$JD AND I.ID IS NULL AND G.ID IS NULL UNION SELECT 1, T.ID, T.OperationDate, B.Op_Dok, CONCAT(D.Turtas, ' - ', T.Content), CAST(T.OperationType AS CHAR) FROM turtas_op T LEFT JOIN turtas D ON D.ID=T.T_ID LEFT JOIN bz B ON B.Op_ID=T.JE_ID LEFT JOIN sfd I ON I.SF_ID=T.JE_ID AND (I.Rusis=3 OR I.Rusis=6) AND I.P_ID=T.ID LEFT JOIN sfg G ON G.BZ_ID=T.JE_ID AND (G.Rus=3 OR G.Rus=6) AND G.P_ID=T.ID WHERE T.OperationType<>'aac' AND T.OperationType<>'amo' AND T.OperationType<>'nur' AND T.JE_ID=$JD AND I.ID IS NULL AND G.ID IS NULL UNION SELECT 3, T.ID, T.OperationDate, T.DocNo, T.Content, CAST(T.OperationType AS CHAR) FROM goodsoperations T LEFT JOIN goodscomplexoperations C ON C.ID=T.ComplexOperationID LEFT JOIN sfd I ON I.SF_ID=T.JournalEntryID AND I.Rusis IN (1, 5, 7, 8) AND I.P_ID=T.ID LEFT JOIN sfg G ON G.BZ_ID=T.JournalEntryID AND G.Rus IN (1, 5, 7, 8) AND G.P_ID=T.ID WHERE C.OperationType IS NULL AND NOT T.OperationType IN (3, 4, 7, 9, 10, 11, 12) AND T.JournalEntryID=$JD AND I.ID IS NULL AND G.ID IS NULL UNION SELECT 4, A.BZ_ID, B.Op_data, B.Op_Dok, B.Op_turinys, null FROM apyskaitos A LEFT JOIN bz B ON B.Op_ID=A.BZ_ID WHERE A.SG=$JD UNION SELECT 5, p.ID, b.Op_data, b.Op_Dok, b.Op_turinys, null FROM payoutnaturalpersonwithouttaxes p LEFT JOIN bz b ON b.Op_ID=p.JournalEntryID WHERE p.JournalEntryID=$JD;], Params: ?JD=828;
Klaidos turinys: 'SQLite error
no such table: payoutnaturalpersonwithouttaxes'. ---> System.Data.SQLite.SQLiteException: SQLite error
no such table: payoutnaturalpersonwithouttaxes
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.HelperLists.IndirectRelationInfoList.DoFetch(Int32 journalEntryID)
at ApskaitaObjects.HelperLists.IndirectRelationInfoList.GetIndirectRelationInfoListChild(Int32 journalEntryID)
at ApskaitaObjects.Documents.Offset.DataPortal_Delete(Object criteria))
Klaidos šaltinis(Ex.Source):
Csla
Klaidos metodas (Ex.TargetSite):
Delete
Klaidos stekas:
at AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLCommand.Fetch()
at ApskaitaObjects.HelperLists.IndirectRelationInfoList.DoFetch(Int32 journalEntryID)
at ApskaitaObjects.HelperLists.IndirectRelationInfoList.GetIndirectRelationInfoListChild(Int32 journalEntryID)
at ApskaitaObjects.Documents.Offset.DataPortal_Delete(Object criteria)
at Csla.MethodCaller.CallMethod(Object obj, MethodInfo info, Object[] parameters)
at Csla.MethodCaller.CallMethod(Object obj, String method, Object[] parameters)
at Csla.Server.SimpleDataPortal.Delete(Object criteria, DataPortalContext context)
at Csla.DataPortal.Delete(Object criteria)
at ApskaitaObjects.Documents.Offset.DeleteOffset(Int32 id)
----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
DataPortal_Delete 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.HelperLists.IndirectRelationInfoList.DoFetch(Int32 journalEntryID)
at ApskaitaObjects.HelperLists.IndirectRelationInfoList.GetIndirectRelationInfoListChild(Int32 journalEntryID)
at ApskaitaObjects.Documents.Offset.DataPortal_Delete(Object criteria)
at Csla.MethodCaller.CallMethod(Object obj, MethodInfo info, Object[] parameters)
at Csla.MethodCaller.CallMethod(Object obj, String method, Object[] parameters)
at Csla.Server.SimpleDataPortal.Delete(Object criteria, DataPortalContext context)
----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
Klaida vykdant SELECT sakinį (statement): [SELECT 0, D.ID, B.Op_data, B.Op_Dok, B.Op_turinys, null FROM d_kitos D LEFT JOIN bz B ON B.Op_ID=D.BZ_ID WHERE D.BZ_ID=$JD UNION SELECT 2, T.ID, B.Op_data, B.Op_Dok, T.Turtas, null FROM turtas T LEFT JOIN bz B ON B.Op_ID=T.Isigijimo_dok LEFT JOIN sfd I ON I.SF_ID=T.Isigijimo_dok AND I.Rusis=4 AND I.P_ID=T.ID LEFT JOIN sfg G ON G.BZ_ID=T.Isigijimo_dok AND G.Rus=4 AND G.P_ID=T.ID WHERE T.Isigijimo_dok=$JD AND I.ID IS NULL AND G.ID IS NULL UNION SELECT 1, T.ID, T.OperationDate, B.Op_Dok, CONCAT(D.Turtas, ' - ', T.Content), CAST(T.OperationType AS CHAR) FROM turtas_op T LEFT JOIN turtas D ON D.ID=T.T_ID LEFT JOIN bz B ON B.Op_ID=T.JE_ID LEFT JOIN sfd I ON I.SF_ID=T.JE_ID AND (I.Rusis=3 OR I.Rusis=6) AND I.P_ID=T.ID LEFT JOIN sfg G ON G.BZ_ID=T.JE_ID AND (G.Rus=3 OR G.Rus=6) AND G.P_ID=T.ID WHERE T.OperationType<>'aac' AND T.OperationType<>'amo' AND T.OperationType<>'nur' AND T.JE_ID=$JD AND I.ID IS NULL AND G.ID IS NULL UNION SELECT 3, T.ID, T.OperationDate, T.DocNo, T.Content, CAST(T.OperationType AS CHAR) FROM goodsoperations T LEFT JOIN goodscomplexoperations C ON C.ID=T.ComplexOperationID LEFT JOIN sfd I ON I.SF_ID=T.JournalEntryID AND I.Rusis IN (1, 5, 7, 8) AND I.P_ID=T.ID LEFT JOIN sfg G ON G.BZ_ID=T.JournalEntryID AND G.Rus IN (1, 5, 7, 8) AND G.P_ID=T.ID WHERE C.OperationType IS NULL AND NOT T.OperationType IN (3, 4, 7, 9, 10, 11, 12) AND T.JournalEntryID=$JD AND I.ID IS NULL AND G.ID IS NULL UNION SELECT 4, A.BZ_ID, B.Op_data, B.Op_Dok, B.Op_turinys, null FROM apyskaitos A LEFT JOIN bz B ON B.Op_ID=A.BZ_ID WHERE A.SG=$JD UNION SELECT 5, p.ID, b.Op_data, b.Op_Dok, b.Op_turinys, null FROM payoutnaturalpersonwithouttaxes p LEFT JOIN bz b ON b.Op_ID=p.JournalEntryID WHERE p.JournalEntryID=$JD;=D.BZ_ID WHERE D.BZ_ID=$JD UNION SELECT 2, T.ID, B.Op_data, B.Op_Dok, T.Turtas, null FROM turtas T LEFT JOIN bz B ON B.Op_ID=T.Isigijimo_dok LEFT JOIN sfd I ON I.SF_ID=T.Isigijimo_dok AND I.Rusis=4 AND I.P_ID=T.ID LEFT JOIN sfg G ON G.BZ_ID=T.Isigijimo_dok AND G.Rus=4 AND G.P_ID=T.ID WHERE T.Isigijimo_dok=$JD AND I.ID IS NULL AND G.ID IS NULL UNION SELECT 1, T.ID, T.OperationDate, B.Op_Dok, CONCAT(D.Turtas, ' - ', T.Content), CAST(T.OperationType AS CHAR) FROM turtas_op T LEFT JOIN turtas D ON D.ID=T.T_ID LEFT JOIN bz B ON B.Op_ID=T.JE_ID LEFT JOIN sfd I ON I.SF_ID=T.JE_ID AND (I.Rusis=3 OR I.Rusis=6) AND I.P_ID=T.ID LEFT JOIN sfg G ON G.BZ_ID=T.JE_ID AND (G.Rus=3 OR G.Rus=6) AND G.P_ID=T.ID WHERE T.OperationType<>'aac' AND T.OperationType<>'amo' AND T.OperationType<>'nur' AND T.JE_ID=$JD AND I.ID IS NULL AND G.ID IS NULL UNION SELECT 3, T.ID, T.OperationDate, T.DocNo, T.Content, CAST(T.OperationType AS CHAR) FROM goodsoperations T LEFT JOIN goodscomplexoperations C ON C.ID=T.ComplexOperationID LEFT JOIN sfd I ON I.SF_ID=T.JournalEntryID AND I.Rusis IN (1, 5, 7, 8) AND I.P_ID=T.ID LEFT JOIN sfg G ON G.BZ_ID=T.JournalEntryID AND G.Rus IN (1, 5, 7, 8) AND G.P_ID=T.ID WHERE C.OperationType IS NULL AND NOT T.OperationType IN (3, 4, 7, 9, 10, 11, 12) AND T.JournalEntryID=$JD AND I.ID IS NULL AND G.ID IS NULL UNION SELECT 4, A.BZ_ID, B.Op_data, B.Op_Dok, B.Op_turinys, null FROM apyskaitos A LEFT JOIN bz B ON B.Op_ID=A.BZ_ID WHERE A.SG=$JD UNION SELECT 5, p.ID, b.Op_data, b.Op_Dok, b.Op_turinys, null FROM payoutnaturalpersonwithouttaxes p LEFT JOIN bz b ON b.Op_ID=p.JournalEntryID WHERE p.JournalEntryID=$JD;], Params: ?JD=828;
Klaidos turinys: 'SQLite error
no such table: payoutnaturalpersonwithouttaxes'.
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.HelperLists.IndirectRelationInfoList.DoFetch(Int32 journalEntryID)
at ApskaitaObjects.HelperLists.IndirectRelationInfoList.GetIndirectRelationInfoListChild(Int32 journalEntryID)
at ApskaitaObjects.Documents.Offset.DataPortal_Delete(Object criteria)
----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
SQLite error
no such table: payoutnaturalpersonwithouttaxes
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)