on 07-16-2013 12:59 PM
Hi Experts,
I working on SAP PI 7.31 proxy -> jdbc asynchronous scenario.
when checking comm channel in rwb it showing in green status. but when ping JDBC comm channel it showing below error.
and when checking rwb->message monitoring->message component->Adapter Engine<Host> -> select scenario ->audit log it showing following error.
JDBC driver was installed.
Thanks,
Dipak
Issue Resolved by basis team.
it because of patch level of abap stack and java stack is not equal of sap pi 7.31.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Does we required java install at Databse server box?
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Dipak,
Maybe does a field called 'dsrPassportBytes' exists in target tables?
Wich DB motor and version are you using?
Regards,
Juan.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Dipak,
this seems like a adapter level issue. I would suggest to redeploy the driver and look at the services related to JDBC adapter in NWA. take basis help.
this is not related to connectivity to the target or field level mapping.
Ambrish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Anurag,
What is the driver version you are using : JDBC version 3.0 (Which Deployed in PI Sever for connection SQL Server 2008 database).
can you provide the JDBC Driver you have mentioned in the channel configuration. :
Transport Protocol : JDBC 2.0
Message Protocol : XML SQL Format
Adapter Engine : Central Adapter Engine
JDBC Driver :com.microsoft.sqlserver.jdbc.SQLServerDriver
I tried with com.microsoft.jdbc.sqlserver.SQLServerDriver
Connection : jdbc:microsoft:sqlserver://XXXXXXX:1433;DatabaseName=XXXXXX
Thanks,
Dipak.
Hi Dipak,
Thanks,
Naveen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Dipak,
Have you tried to do the SQL sentence in the DB directly with the same user?, in this way you can check if you are putting a right db schema, user grants, etc.
What is the DB vendor?, you can check if there are any restriction or the driver installation is correct.
Have you checked that you are tipyng correctly all your parameters in the XML payload?.
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Can you check mapping out matching with data base field names? any other JDBC receiver scenario working?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.