ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

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