ORA-01013 - Weblogic configuration error?

Question

I am running a banking program encoded in Oracle PL / SQL. This program runs for 2-3 hours every day, as part of the end-of-day treatment.

Until yesterday, it worked fine. Today, when I start it today, after about 30 minutes, the program ends with error ORA-01013: user requested cancel of current operation . I do not end the program manually.

I believe this may be a problem with installing weblogic (where the application is deployed). I do not own weblogic and do not know which parameter can be changed to stop this error. Please, help!!!

Oracle Version: 11.2.0.3
Oracle weblogic server: 11g

Answer 1

It sounds like a JDBC timeout. In the WebLogic console, go to Services-> Data Sources and click the name of the data source to view its settings. Click the Connection Pool tab and expand the Advanced section at the bottom of the page. Locate Report Timeout Job .

From the documentation :

If Runtime is set to -1, (default), no timeout occurs.

The behavior that you see indicates that the timeout is set to 1800 if it turns off after 30 minutes.

However, this will not change on its own, and if it was already installed, it was previously ignored, which would require some kind of investigation - has something else changed?

Another possibility is that your code makes several calls within a 3-4-hour window, and one of them now exceeds the timeout on its own, which can occur if the timeout is below 1800. Without viewing the code or the current value the timeout that I’m just guessing is obvious.