Web ADI Upload Failed With BneSQLException Message "The Connection To The Server Is Unavailable" (Doc ID 1071275.1)

Last updated on JANUARY 18, 2017

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.
Checked for relevance on 18-Jan-2017

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)

 

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms