on 08-08-2007 7:34 AM
Hi,
I am trying FILE-XI-JDBC Scenario to get data loaded in Oracle. I have configured the reciever adapter in Communication Channel but while sending the message i am getting the following error:
<b>com.sap.aii.af.ra.ms.api.DeliveryException: JDBC Adapter configuration not initialized: null</b>
Can anyone guide me what needs to be done here?
Below are the settings that i am using:
JDBC Adapter: jdbc:oracle:thin:@<ipaddress>:<port>
Connection: oracle.jdbc.driver.OracleDriver
Thanks,
Rajneesh
Hi Rajneesh,
After looking at your Target message structure the node <access> should be at the same level as <table>.
Thanks,
Krishna
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
We had similar problem with PI7.0. Our issue was solved by clicking advanced parameter "Disconnect From Database after processing each message".
This can have performance overhead.
Or Refer to sap note 831162
Regards,
Dipali
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You have given wrong Driver and connection.
JDBC driver: oracle.jdbc.driver.oracledriver
connection: jdbc:oracle:thin:@hostipaddress:port:dbname
Regards,
S.RamNarender
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I have changed the Driver and Connection parameters, Oracle is running, I am able to connect to Oracle with that userid and passwrd.
I have another question, probably that might be causing the issue. In sxmb_moni, i see two kinds of messages, Original Messageid and message id. When i clicked on Original Message ID, i can see an error
<b>" <Trace level="2" type="T">no header mapping defined</Trace> "</b>
I wanted to check the mappings that i have done are correct or not. I was not sure where to put the table name where data needs to be inserted, so I put it as a constant pointed to TABLE element (not sure if this is the correct way). If this is not correct, please let us know what exactly is the correct way of denoting the table name.
Thanks,
Rajneesh
Raj,
Here is the link showing message mapping for this scenario. Please review and let me know if there is an issue in it.
http://rapidshare.com/files/47758991/XI.JPG.html
Thanks,
Rajneesh
One more link (in case the above one is not working)
Link : http://www.MegaShare.com/250669
Password : xi
Thanks,
Rajneesh
Rajneesh,
None of them is going through. Could you please upload them on my favourite www.flickr.com :-)- you can directly login with yahoo id.
Best regards,
raj.
i am getting the following error:
>>>>com.sap.aii.af.ra.ms.api.DeliveryException: JDBC Adapter configuration not initialized: null
means connection to ORACLE DATABASE is not established.....check whethere oracle database is working or not...
2) check DATABASE CONNECTION fields....
jdbc driver and connection....
JDBC receiver
/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step
/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30 - <u><i><b>File to JDBC</b></i></u>
How to use SELECT statement in JDBC scenario's.
Ref : https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/1725 [original link is broken] [original link is broken] [original link is broken]
stored procedures
/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures by siva
Best Regards,
Srikanth
Reward the useful answers and you will get one point yourself
/people/baris.buyuktanir2/blog/2007/04/04/point-for-points-reward-yourself ---onepoint blog
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
did you install oracle driver?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Make sure ur communiation channel is active.
Regards,
Prateek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.