2023-06-16 23:17
topus
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)