search cancel

GEL scripts: The server failed to resume the transaction

book

Article ID: 238565

calendar_today

Updated On:

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. 

Cause

DE64616 

Environment

Release: 16.0.1, 16.0.2  

Resolution

Targeted Fix in Release 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