Skip to Content

JDBC communication channel error

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

8 Answers

  • Best Answer
    Sep 16, 2013 at 08:57 AM

    Issue Resolved by basis team.

    it because of patch level of abap stack and java stack is not equal of sap pi 7.31.

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 16, 2013 at 12:17 PM

    Can you check mapping out matching with data base field names? any other JDBC receiver scenario working?

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 16, 2013 at 12:21 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 16, 2013 at 12:55 PM

    Hi Dipak,

    • Try to test the highlevel connectivity from your PI server to DB Server with the same user you are trying to connect.

    • Check the schema provided is correct and also the user has permissions to the schema you are trying to access.

    • check if the JDBC Drivers are correctly deployed.

    Thanks,

    Naveen

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 17, 2013 at 11:41 AM

    Hi

    @Raja Sekhar Reddy i have checked mapping with database fields it is perfect .no other JDBC scenario wokring.

      Former Member  SQL Query is working on database.we are using Microsoft SQL Server 2008 database.payload is error free.

    Former Member  i m able to access dbserver form pi server.driver is installed.

    issue is still there 😔

    thanks

    Add comment
    10|10000 characters needed characters exceeded

    • 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.

      sqljdbc.png (10.7 kB)
  • Jul 17, 2013 at 01:37 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 17, 2013 at 09:40 PM

    Hi Dipak,

    Maybe does a field called 'dsrPassportBytes' exists in target tables?

    Wich DB motor and version are you using?

    Regards,

      Juan.

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 25, 2013 at 10:36 AM

    Hi

    Does we required java install at Databse server box?

    Thanks

    Add comment
    10|10000 characters needed characters exceeded