GEL scripts: The server failed to resume the transaction

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

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: 

1. Create an object in Clarity as "z_test_object" 
2. For the Code attribute enable AutoNumbering 
3. Create a Process using the attached gel script 
4. Create a table z_test as "create table z_test (ID NUMBER(20), CODE VARCHAR(20)) 
5. Run the GEL Script 

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. 

Environment

Release: 16.0.1, 16.0.2  

Cause

DE64616 

Resolution

This issue has been fixed in Clarity 16.0.3.

Additional Information

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