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


Article ID: 238565


Updated On:


Clarity PPM On Premise Clarity PPM SaaS


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.
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.


This is caused by DE64616


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