cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC Adapter configuration not initialized: null

Former Member
0 Kudos

Hello Experts,

<b>1.</b> I am using Proxy to JDBC scenario.

<b>2.</b> I am having PI 7.0 with SP13.

<b>Problem:</b>

Data from proxy is coming in MONI successfully, but in RWB under communication channel monitoring I am getting these errors.

<b>i.</b> Configuration error: com.sap.aii.af.service.util.configuration.MandatoryParameterMissingException: Value missing for mandatory configuration attribute tableEOColumnNameId

<b>ii.</b> Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: JDBC Adapter configuration not initialized: null

<b>3.</b> Receiver JDBC adapter has been configured as below:

<b>Note:</b> At receiver side SQL Server 2005 is being used.

<b>JDBC Driver:</b> com.microsoft.sqlserver.jdbc.SQLServerDriver

<b>Connection:</b> jdbc:sqlserver://<server>:1433;databaseName=<db_Name>

<b>Under Processing Tab.</b>

<b>Under XML Schema Interpreter:</b>

Checkbox: Key Tags Mandator is unchecked

Interpretation of Emptyp String Values "Empty String"

<b>Under Exactly-Once-Handling:</b>

Persistence "Local"

Conflict Resolution "Redo"

<b>Under Advanced TAB.</b>

I am checking the box "<b>Disconnect from Database After Processing Each Message</b>"

I have gone through almost all the threads on sdn but still no help. Any help/clue in this regard will be appriciated with marks.

Regards,

Sarvesh

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi

Is the JDBC Adapter active??are you able to connect to the DB??

Thanks

Former Member
0 Kudos

Yes, adapter is <b>Active</b>.

Since no data has been updated in the DB, therefore i guess i am not able to connect to DB.

Is there any other way to check the DB connection?

Former Member
0 Kudos

Hi

Try connecting to the DB by other means like SQL studio etc..

Thanks

Former Member
0 Kudos

Hi,

Problem has been solved.

There was a problem from client side.

1. Firewall was not open from client side.

2. The password used to connect the Database was wrong.

Now it is working fine without any fail.

Thanks for your reply.

Sarvesh