Progress® datadirect seems to have an issue when using BEING TRANSACTION and END TRANSACTION in the PROCEDURE CMN_AUTONUM_GET_NEXT_SP. Any transaction after this procedure will generate an error because the transaction was closed in Procedure. This can also happen with other stored procedures like CMN_ID_SP as well.
Steps to Reproduce:
Expected Results: Gel Script completes successfully.
Actual Results: Throws an error saying java.sql.SQLException: [CA Clarity][SQLServer JDBC Driver][SQLServer]The server failed to resume the transaction. Desc:4200000026.
Release: 16.0.1, 16.0.2
DE64616
This issue has been fixed in Clarity 16.0.3.
Progress® datadirect seems to have an issue when using BEING TRANSACTION and END TRANSACTION in the PROCEDURE CMN_AUTONUM_GET_NEXT_SP. Any transaction after this procedure will generate an error because the transaction was closed in Procedure.
Reference this external article from Progress® : Exception "The server failed to resume the transaction" occurs when using explicit transactions with the JDBC SQL Server driver