Current Position:Home > SAP XI/PI JDBC Receiver communication channel

SAP XI/PI JDBC Receiver communication channel

Update:10-11Source: network consolidation
Advertisement
Dear Expert,
    We had few DAE running in company, recently I had below problem, need expert to advise how to overcome this problem.
   Try to execute below JDBC statement in our few AE and DAE,
=============================================================================================
<?xml version="1.0" encoding="UTF-8" ?>
<ns0:MT_OSPEN_TEST_DATA_JDBC2JDBC_COMMIT_T1 xmlns:ns0="http://testing/pen/test/jdbc2jdbc_commit">
<STATEMENT_UPDATE_INSERT_MYTESTTABLE>
<dbTableName action="UPDATE_INSERT">
  <TABLE>TMDB_DATA.MYTESTTABLE</TABLE>
<access>
  <COLUMN_VARCHAR1>Constant001</COLUMN_VARCHAR1>
  <COLUMN_VARCHAR2>Constant002</COLUMN_VARCHAR2>
  <COLUMN_FLAG>Y</COLUMN_FLAG>
  </access>
<key>
  <COLUMN_VARCHAR1>Constant001</COLUMN_VARCHAR1>
  </key>
  </dbTableName>
  </STATEMENT_UPDATE_INSERT_MYTESTTABLE>
<STATEMENT_COMMIT>
<dbTableName action="SQL_DML">
  <access>COMMIT</access>
  </dbTableName>
  </STATEMENT_COMMIT>
  </ns0:MT_OSPEN_TEST_DATA_JDBC2JDBC_COMMIT_T1>
=============================================================================================
DAE with MSSQL DB, can execute above statement successfully but
DAE wit Oracle DB had below error:
My question is, why DAE with MSSQL DB can execute the above statement without any error and DAE with ORACLE DB cannot execute the above statement correctly ? How to overcome this problem if I need to execute this statement in DAE ORACLE  ?

The Best Answer

Advertisement
Hi,
For XI,RFC and Idoc when it's pointing to one SAP system you don't need any further comm channels.
For JDBC , if you are pointing to only one database you can use the same channel, if the target/databse changes you need more comm channels.
Your Design is as per the standards.
Regards,
Sainath Chutke
  • SAP XI/PI JDBC Receiver communication channel Update:10-11

    Dear Expert,     We had few DAE running in company, recently I had below problem, need expert to advise how to overcome this problem.    Try to execute below JDBC statement in our few AE and DAE, ======================================================

  • Regarding the JDBC Receiver Communication Channel error Update:10-11

    Hi All, While executing Jdbc to Jdbc interface, i am getting error in jdbc receiver communication channel. please see below message for error description.. Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Channel 'JDBC

  • What to be given in JDBC receiver comm channel? Update:10-11

    Hi I have given JDBC driver:com.sap.aii.messaging.adapter.ModuleXMB2DB Connection:jdbc:microsoft:sqlserver://sapep:1433;DatabaseName=SAPXI am i giving correct params? please help me where and how to check whether iam using correct params in my JDBC r

  • RFC , IDoc , XI and JDBC receiver communication channel--- Good Design Update:10-11

    Hi Experts, We have developed around 60+ interfaces on PI7.1 EHP1, in that 20 interfaces sending data to Data Base using JDBC receiver communication channel, 15 interfaces ABAP inbound proxy using XI adapter,10 Scenarios using IDoc receiver channel a

  • Error in JDBC receiver Communication Channel Update:10-11

    Hi, I am facing a problem at receiver communication channel of JDBC adapter. I am gettting the error as, "com.sap.aii.af.ra.ms.api.RecoverableException: Channel has reached maximum concurrency(5,000 concurrent Messages) and no free resourse found wit

  • What to specify in my JDBC receiver communication channel Update:10-11

    Hi! In my Receiver comm channel I have selected Adapter Type:JDBC     Receiver Transport protocol: JDBC 2.0 Message Protocol: XML SQL Format Adapter Engine: Integration server JDBC driver:?????? Connection: ?????? I dont have any idea as what to give

  • JDBC Receiver Communication channel Error Update:10-11

    Hi Friends, I am facing below error in JDBC Receiver Communication chnnel. Please shared your views. Message processing failed. Cause: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error

  • JDBC Receiver Comm Channel Issue Update:10-11

    Hi Team, We have around 77 interfaces inserting/updating information into a database. Q1) Should we creating 77 different receiver JDBC communication channels for the same receiver? Q2) Or would a single JDBC communication channel suffice? Currently,

  • Escape character for apostrophe ' in JDBC receiver channel Update:11-30

    Hi all, We have Proxy to JDBC scenario in our project. This interface is working fine with unicode data but when there is an apostrophe( ' ) coming in any of the field values ( ex: DOWTHERM 'J' MODEL19QAGB1G ) , the message is failing in receiver JDB

  • JDBC Receiver does not convert empty string to NULL Update:10-11

    Hello experts, I am facing a problem with an INSERT statement to ORACLE DB where some of the fields are empty, for example: - <STATEMENT_VLP_CONT_DETAILS> - <TABLE_VLP_CONT_DETAILS ACTION="INSERT">   <TABLE>VLP_CONT_DETAILS<