Solved

Error when making changes in Project Deliverables Design

  • 28 October 2021
  • 1 reply
  • 103 views

Userlevel 5
Badge +8

Hello,

  1. Open Project Deliverables Design window from Aurena.
  2. Go to Components tab.
  3. Select a record and edit it.
  4. Save the changes.

I receive below error when updating a record or saving a new record in the above mentioned window.

(Server Error) savepoint 'ORACLE_SVPT_93' never established in this session or is invalid.

 

Customer is in APP10 UPD10.

Any help would be greatly appreciated.

 

Best regards,

Devni

icon

Best answer by Manoj Ruwanhewa 15 November 2021, 23:43

View original

This topic has been closed for comments

1 reply

Badge +15

Hi @Devni Panduwawala ,

As per the oracle community post , when you do insert or update into the associated table for this screen, if there any implicit commit statements in the business logic, it is possible to  avoid reaching a savepoint and oracle will automatically raise this error.

https://community.oracle.com/tech/developers/discussion/4279679/why-a-savepoint-gets-invalid

(check the best answer in this post)

So in your case, please find the connected, table and and the package for page “Project Deliverables” and search for ‘COMMIT’ statements and compare with APP10 UPD10 core file whether  your plsql package has any extra commit statements.

Hope this will assist you to troubleshoot the issue.

Regards

Manoj