Transaction Rollup/Consolidation "Could not save the business Object"
Environment:
iVend Version 6.6 7747 with SAPB1 9.2
Problem Statement:
While enabling transaction Roll-up in the iVend Enterprise. It displays the error message on screen
“Could not save the business Object”.
iVend Enterprise MC Log file displayed the detailed error message :
<Event> <Version>6.6.7747.25931</Version>
<Category>ERROR</Category>
<Time>03:47:39 a. m.</Time>
<Message>Transaction not connected, or was disconnected</Message>
<ExceptionInfo>
<Type>NHibernate.TransactionException</Type>
<Message>Transaction not connected, or was disconnected</Message>
<Source>NHibernate</Source>
<TargetSite>Void CheckNotZombied()</TargetSite>
<StackTrace> at NHibernate.Transaction.AdoTransaction.CheckNotZombied()
at NHibernate.Transaction.AdoTransaction.Rollback()
at CXS.Platform.Data.SessionManager.RollbackTransaction()</StackTrace>
</ExceptionInfo>
</Event>
</DATE-20210615>
</CXSLog>
Symptoms:
While enabling transaction Roll-up in the iVend Enterprise. It displays the error message on screen
“Could not save the business Object”.
Resolution/Work Around:
Suggest to check below points
1) What is the SQL Server Version i.e. Express edition, Standard edition, and Enterprise edition if we got the express edition it means express edition has not the functionality of SQL server jobs. Standard edition and Enterprise edition have the functionality of the SQL server jobs.
2) If SQL Job is already created in SQL Server with Enterprise database name and it is configured correctly
3) Database user id with which iVend connection is made under iVend Configuration Manager , has rights in SQL Server to create SQL Job or not.
Recommendations /Suggestion:
It is recommended to make iVend Connection Manager with user id "sa" or similar user id which has complete rights in SQL Server.