DB locks using API in custom application

eB version: 15.6.1
DB Version: Oracle 11g r2
I am working on a PlugIn. I've got a page that inherits from eB.Library.Web.UI.AuthenticatedPage. When I click on Save button I invoke Api.begin_trx() method, then use Api method such as Api.chg_document, Api.add_char_data, Api.set_perm_gb and add_relationship among others. And finally invoke Api.commit_trx();
Api.silent_mode Api.disconnect_on_dispose are using default values.
I'm having two issues.
1- when page already loaded, if I wait 5 or 6 minutes without doing anything and then click on Save, sometimes, application hangs. After 10/15 minutes it returns with this error (and of course, data is not saved in the Data base):
Server encountered an internal error. For more information, turn off customErrors in the server's .config file. 
  Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 
 Exception Details: System.Exception: Server encountered an internal error. For more information, turn off customErrors in the server's .config file.
Source Error: 
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.  
customErrors is set Off.
2- sometimes, without waiting, when click on Save button, application hangs as well. After 10/15 minutes it returns with the error mentioned above.
Any help would be much appreciated. Thanks.
After doing some research in database I have found that there is a procedure executed that seem to be the problem:
1) EBP_SET_AUTORELEASE_MUTEX, and it fails in line 46 with following Query:
 SELECT LAST_NUMBER
FROM ID_NUMBER_REGISTER
WHERE ID_TYPE IN ( N'document_id', N'copy_id', N'pdm_file_id', N'checkout_id' ) FOR UPDATE
We don´t know why this is called from API.
Please we need help, thanks  a lot !!
Parents Reply Children
No Data