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.
This is caused by DE64616
This can not be reproduced in 16.0.1
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.