GEL scripts: The server failed to resume the transaction

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Server Failed to Resume Error when using CMN_AUTONUM_GET_NEXT_SP in Gel Script on SQL Server DB

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.

Cause

This is caused by DE64616

Resolution

This can not be reproduced in 16.0.1

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.

Exception "The server failed to resume the transaction" occurs when using explicit transactions with the JDBC SQL Server driver