Solved: JDBC adapter error

Hi,

we are getting the following error for the JDBC adapter in RWB: (we have installed the classes12.zip drivers)

Processing Error: Accessing database connection 'jdbc:oracle:oci:@LOGISTICA' failed: java.lang.UnsatisfiedLinkError: no ocijdbc9 in java.library.path

Addtional information: JDBC driver 'oracle.jdbc.driver.OracleDriver' loaded successfully, additional driver information:

Available JDBC drivers:

oracle.jdbc.driver.OracleDriver, 1.0 JDBC compliant

XI is running on HP-UX 11/Oracle 9, I never had this error on our previous Windows platforms.

I really appreciate help on this one as we are approaching go-live!

Cheers,

Mattias

SAP Managed Tags:
SAP Process Integration

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (1)

Hi Mattias

You will have to add oracle client library path to the LD_LIBRARY_PATH variable and restart the SAP instance.

All the best with your go-live.

cheers

sameer

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Answers (1)

Hi Sameer,

thanks, but I already set the LD_LIBRARY_PATH variable for ora<sid> user and restarted. If I add to <sid>adm I have problems starting the instance. For what user did you add it?

Cheers,

Mattias

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Mattias

Have a look at the following thread, where couple of other settings have been discussed. Maybe this could help resolve your problem.

cheers

Sameer

Hi,

I have gotten past the first error message by creating soft links:

/usr/lib/libclntsh.so.9.0 -> /oracle/EXP/920_64/lib/libclntsh.so.9.0

/usr/lib/libocijdbc9.so -> /oracle/EXP/920_64/lib/libocijdbc9.so

/usr/lib/libwtc9.so -> /oracle/EXP/920_64/lib/libwtc9.so

Now I'm getting the following error in RWB:

Receiver Adapter v1402 for Party '', Service 'IC_2005':

Configured at 19:02:07 2005-09-24

Last message processing started 14:21:17 2005-09-25, Error: Accessing database connection 'jdbc:oracle:oci:@kis' failed: java.sql.SQLException:

Closed Connection

Addtional information: JDBC driver 'oracle.jdbc.driver.OracleDriver' loaded successfully, additional driver information:

Available JDBC drivers:

oracle.jdbc.driver.OracleDriver, 1.0 JDBC compliant

Please also look at errors in server.0.log below:

</pre>)].The error is: The stream is closed.#

#1.5#0012799555A000210000001000002E5F00040195E0F4DABE#1127643144241#/System/Server##com.sap.engine.services.httpserver######ddf6ba102dac11dac7700012799555a0#SAPEngine_System_Thread[impl:5]_57##0#0#Error#1#com.sap.engine.services.httpserver#Plain###User <system thread>, IP address

Illegal internal http message received. A response body callback received for unknown client. Probably an internal synchronization error has occurred.#

#1.5#0012799555A0003A0000007600002E5F0004019600BBA5B9#1127643677373#/System/Server#sap.com/com.sap.aii.af.ms.app#com.sap.engine.services.jndi#XIISUSER#1799##prsysapl_EXP_13065450#Guest#1bb09e102dae11dac02f0012799555a0#output##0#0#Info#1#com.sap.engine.services.jndi#Plain###Path to object does not exist at localejbs, the whole lookup name is webContainer/applications/sap.com/com.sap.aii.af.ms.app/MessagingSystem/localejbs/AFWListener.#

#1.5#0012799555A0003A0000007A00002E5F0004019600BBD266#1127643677385#/System/Server#sap.com/com.sap.aii.af.ms.app#com.sap.pmi.Agent#XIISUSER#1799##prsysapl_EXP_13065450#Guest#1bb09e102dae11dac02f0012799555a0#output##0#0#Warning#1#com.sap.pmi.Agent#Plain###PMI agent configuration missing,

most likely because no PMI process is activ.#

#1.5#0012799555A0004F0000002300002E5F0004019600BBDC17#1127643677387#/System/Server##com.sap.pmi.Agent#J2EE_GUEST#0####4c88c1302d0811da81e40012799555a0#SAPEngine_Application_Thread[impl:3]_13##0#0#Warning#1#com.sap.pmi.Agent#Plain###PMI agent configuration missing, most likely because no

PMI process is activ.#

#1.5#0012799555A0004F0000002400002E5F0004019600BBE476#1127643677390#/System/Server#sap.com/com.sap.aii.af.app#com.sap.pmi.Agent#J2EE_GUEST#0####4c88c1302d0811da81e40012799555a0#SAPEngine_Application_Thread[impl:3]_13##0#0#Warning#1#com.sap.pmi.Agent#Plain###PMI agent configuration missing, most likely because no PMI process is activ.#

#1.5#0012799555A0004F0000002500002E5F0004019600BBE7B8#1127643677390#/System/Server#sap.com/com.sap.aii.af.app#com.sap.engine.services.jndi#J2EE_GUEST#0####4c88c1302d0811da81e40012799555a0#SAPEngine_Application_Thread[impl:3]_13##0#0#Info#1#com.sap.engine.services.jndi#Plain###Path to object does not exist at localejbs, the whole lookup name is ejbContexts/sap.com/com.sap.aii.af.app/ModuleProcessorBean/localejbs/CallSapAdapter.#

#1.5#0012799555A0004F0000002A00002E5F0004019600BC23FC#1127643677406#/System/Server##com.sap.pmi.Agent#J2EE_GUEST#0####4c88c1302d0811da81e40012799555a0#SAPEngine_Application_Thread[impl:3]_13##0#0#Warning#1#com.sap.pmi.Agent#Plain###PMI agent configuration missing, most likely because no

PMI process is activ.#

#1.5#0012799555A0005F0000008600002E5F0004019605C56DB7#1127643761902#/System/Server/WebRequests#sap.com/com.sap.lcr#com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl#XIAPPLUSER#1800####415eeb302dae11daa9c00012799555a0#SAPEngine_Application_Thread[impl:3]_0##0#0#Error#1#com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl#Plain###Processing an http request to servlet [cimomservlet] finished with error.The error is: Write timeout. HTTP client read timeout or callback from dispatcher not received for 10000 milliseconds.#

#1.5#0012799555A0005F0000008900002E5F0004019605C57BB5#1127643761906#/System/Server/WebRequests#sap.com/com.sap.lcr#com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl#XIAPPLUSER#1800####415eeb302dae11daa9c00012799555a0#SAPEngine_Application_Thread[impl:3]_0##0#0#Error#1#com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl#Plain###Cannot send an http error response [500 Application error occurs during processing the request. (details: <pre>com.sap.engine.services.httpserver.exceptions.HttpIOException: Write timeout. HTTP client read timeout or callback from dispatcher not received for 10000 milliseconds.

at com.sap.engine.services.httpserver.server.ResponseImpl.sendResponse&\#40;ResponseImpl.java:275&\#41;

at com.sap.engine.services.servlets_jsp.server.runtime.client.ServletOutputStreamImpl.flush&\#40;ServletOutputStreamImpl.java:369&\#41;

at com.sap.engine.services.servlets_jsp.server.runtime.client.ServletOutputStreamImpl.write&\#40;ServletOutputStreamImpl.java:166&\#41;

at java.io.FilterOutputStream.write&\#40;FilterOutputStream.java:60&\#41;

at java.io.FilterOutputStream.write&\#40;FilterOutputStream.java:108&\#41;

at java.util.zip.DeflaterOutputStream.deflate&\#40;DeflaterOutputStream.java:156&\#41;

at java.util.zip.DeflaterOutputStream.write&\#40;DeflaterOutputStream.java:114&\#41;

at sun.nio.cs.StreamEncoder$CharsetSE.writeBytes&\#40;StreamEncoder.java:336&\#41;

at sun.nio.cs.StreamEncoder$CharsetSE.implWrite&\#40;StreamEncoder.java:395&\#41;

at sun.nio.cs.StreamEncoder.write&\#40;StreamEncoder.java:136&\#41;

at java.io.OutputStreamWriter.write&\#40;OutputStreamWriter.java:191&\#41;

at java.io.BufferedWriter.flushBuffer&\#40;BufferedWriter.java:111&\#41;

at java.io.BufferedWriter.write&\#40;BufferedWriter.java:206&\#41;

at java.io.Writer.write&\#40;Writer.java:126&\#41;

at com.sap.lcr.api.cim.CIMItem.appendXml&\#40;CIMItem.java:118&\#41;

at com.sap.lcr.api.cim.CIMItem.appendXml&\#40;CIMItem.java:201&\#41;

at com.sap.lcr.api.cim.CIMKeyValue.appendXml&\#40;CIMKeyValue.java:145&\#41;