Web ADI Upload Failed With BneSQLException Message "The Connection To The Server Is Unavailable"
(Doc ID 1071275.1)
Last updated on AUGUST 03, 2024
Applies to:
Oracle Web Applications Desktop Integrator - Version 11.5.10.2 to 12.1.3 [Release 11.5 to 12.1]Information in this document applies to any platform.
Symptoms
Web ADI upload failed with message "The connection to the server is unavailable"
3/4/10 7:45 PM CRITICAL ERROR BneAbstractXMLServlet.doRequest(), fatal exception: oracle.apps.bne.exception.BneSQLException: Cannot execute SQL Statement.
3/4/10 7:45 PM CRITICAL ERROR Nested Exception, Level 0:
Cause: A low level API call failed.
Action: Please note this error to your support representative.
Statement: INSERT INTO BNE_ASYNC_UPLOAD_JOBS_H ( JOB_ID, ACTION_NUM, OBJECT_VERSION_NUMBER, ACTION_CODE, UPLOAD_STATE, TRANSACTION_REFERENCE1, TRANSACTION_REFERENCE2, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN ) VALUES ( ?, NVL((SELECT MAX(ACTION_NUM) + 1 FROM BNE_ASYNC_UPLOAD_JOBS_H WHERE JOB_ID = ?), 1), 1, ?, ?, ?, ?, ?, SYSDATE, ?, SYSDATE, 0 )
Statement Bind Values: 19281, 19281, STATE_BEGIN, SCHEDULED, null, null, 1063, 1063
Stack Trace:
oracle.apps.bne.exception.BneSQLException: Cannot execute SQL Statement.
at oracle.apps.bne.utilities.sql.BneBaseSQL.executeUpdate(BneBaseSQL.java:574)
at oracle.apps.bne.integrator.upload.async.BneAsyncUploadJobHistory.save(BneAsyncUploadJobHistory.java:211)
at oracle.apps.bne.integrator.upload.async.BneAsyncUploadJob.createAsyncUploadJob(BneAsyncUploadJob.java:390)
at oracle.apps.bne.integrator.upload.async.BneAsyncUploadJob.<init>(BneAsyncUploadJob.java:230)
at oracle.apps.bne.integrator.upload.async.BneAsyncUploadManager.startUploadThread(BneAsyncUploadManager.java:154)
at oracle.apps.bne.integrator.upload.BneUploaderService.handleUploadRequest(BneUploaderService.java:409)
at oracle.apps.bne.integrator.upload.BneUploaderService.handleRequest(BneUploaderService.java:179)
at oracle.apps.bne.framework.BneAbstractXMLServlet.doRequest(BneAbstractXMLServlet.java:557)
at oracle.apps.bne.framework.BneAbstractXMLServlet.doPost(BneAbstractXMLServlet.java:166)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:521)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
at org.apache.jserv.JServConnection.run(JServConnection.java:294)
at java.lang.Thread.run(Thread.java:534)
3/4/10 7:45 PM CRITICAL ERROR Nested Exception, Level 0:
Cause: A low level API call failed.
Action: Please note this error to your support representative.
Statement: INSERT INTO BNE_ASYNC_UPLOAD_JOBS_H ( JOB_ID, ACTION_NUM, OBJECT_VERSION_NUMBER, ACTION_CODE, UPLOAD_STATE, TRANSACTION_REFERENCE1, TRANSACTION_REFERENCE2, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN ) VALUES ( ?, NVL((SELECT MAX(ACTION_NUM) + 1 FROM BNE_ASYNC_UPLOAD_JOBS_H WHERE JOB_ID = ?), 1), 1, ?, ?, ?, ?, ?, SYSDATE, ?, SYSDATE, 0 )
Statement Bind Values: 19281, 19281, STATE_BEGIN, SCHEDULED, null, null, 1063, 1063
Stack Trace:
oracle.apps.bne.exception.BneSQLException: Cannot execute SQL Statement.
at oracle.apps.bne.utilities.sql.BneBaseSQL.executeUpdate(BneBaseSQL.java:574)
at oracle.apps.bne.integrator.upload.async.BneAsyncUploadJobHistory.save(BneAsyncUploadJobHistory.java:211)
at oracle.apps.bne.integrator.upload.async.BneAsyncUploadJob.createAsyncUploadJob(BneAsyncUploadJob.java:390)
at oracle.apps.bne.integrator.upload.async.BneAsyncUploadJob.<init>(BneAsyncUploadJob.java:230)
at oracle.apps.bne.integrator.upload.async.BneAsyncUploadManager.startUploadThread(BneAsyncUploadManager.java:154)
at oracle.apps.bne.integrator.upload.BneUploaderService.handleUploadRequest(BneUploaderService.java:409)
at oracle.apps.bne.integrator.upload.BneUploaderService.handleRequest(BneUploaderService.java:179)
at oracle.apps.bne.framework.BneAbstractXMLServlet.doRequest(BneAbstractXMLServlet.java:557)
at oracle.apps.bne.framework.BneAbstractXMLServlet.doPost(BneAbstractXMLServlet.java:166)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:521)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
at org.apache.jserv.JServConnection.run(JServConnection.java:294)
at java.lang.Thread.run(Thread.java:534)
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |