Error Code: -1116 Error Message: Unable to end SQL transaction
Product Query :
Unable to connect the iVend Add-on with SAP Business One after restoring the SAP Business One databases.
Error Code: -1116
Error Message: Unable to end SQL transaction
iVend version :
6.6 8567
Symptoms:
The iVend Add-on fails to connect with SAP Business One.
During add-on initialization, the following error is displayed:
Error Code: -1116
Error Message: Unable to end SQL transaction
The issue was observed after restoring the SAP Business One databases in the Test environment.
Resolution / work around :
Log in to SAP Business One using the Manager user account.
Navigate to:
Administration → System Initialization → General Settings → Services
Uncheck the Enable Transaction Notification option.
Enable it again and click Update.
SAP Business One displayed a red status line in the Message Log; however, no specific error message was generated.
Since SAP Business One did not report any detailed error, connect to the SAP HANA Database for further investigation.
Open the Stored Procedures folder for the SAP Business One (SBO) database.
Apply filters to review the stored procedures belonging to:
SBO
iVend
Compare the stored procedures in the Test environment against the corresponding Production databases.
During the comparison, it was identified that several SBO and iVend stored procedures were missing in the Test environment.
The missing stored procedures indicate that the database restoration was incomplete.
Restore the following databases again from a complete and verified backup:
SAP Business One (SBO)
CXSIntegration
After the restoration, verify that all required database objects, including tables, stored procedures, and other dependent objects, are present and synchronized across the following databases:
SAP Business One (SBO)
iVend
CXSIntegration
Once all database objects are verified, reconnect the iVend Add-on and confirm that the issue is resolved.
Related Articles
Getting integration error "System.Exception: DI:To generate this document, first define the number
Problem Statement Integration error "generate this document, first define the numbering series in the Administration module" Issue in detail Getting integration error "System.Exception: DI:To generate this document, first define the numbering series ...Email showing error message through schedule "Failure sending mail"
Environment: iVend Version 6.6 with SAPB1 10 Problem Statement: Email showing error message through schedule "Failure sending mail" Symptoms: Email showing error message through schedule "Failure sending mail". The error is displayed in schedule log ...Not able to do End Of Day and showing error message 'Till Session not available'
Environment : iVend 6.5 Update 5 with SAPB1 Problem Statement : Customer has informed that unable to do EOD while selecting the assigned till showing error message ‘Till Session is not available’. Symptoms : Some tills were in assigned status and not ...Unable to Disable Transaction Roll-Up Functionality
Problem Statement: Unable to disable transaction roll up functionality at iVend Enterprise Management Console. Error: While trying to disable Transaction Roll-Up functionality at Enterprise Management Console it is giving the below error message. ...Unable to re-initializing the store on store machine and Error message as "Scripts.xml" missing.
Environment: iVend 6.5 update 6 Problem Statement: Unable to re-initializing the store on store machine and it showing an error message as "Scripts.xml” missing. Issue Details: When generating database backup from MC (HO) then it showing an error ...