Where does PI store detail info on communication channels?

[gopalkrishna_baliga]

Hi Experts,

    In which table PI stores detail info on communication channels like JMS queue name, JMS server, etc.

    I found table SSRVCHANNEL but it contains only basic info like Adapter type and channel name.

    Kindly help.

Thanks

Gopal

[vadimklimov · Accepted solution]

Hello Gopal and Ritu,

Actual configuration data of communication channels is stored in the table XI_DIRDATACHANNEL (Java schema of PI database) - precisely speaking, communication channels' attributes and their values are stored in the field ATTRBTS (that is a large object - LOB) of the mentioned table.

Please do not cofuse this with data stored in tables XI_AF_CPA_CHANNEL and SSRVCHANNEL and used by various PI caches, namely:

• The table XI_AF_CPA_CHANNEL (located in Java schema of PI database) is a part of Adapter Engine Cache (CPA cache);
• The table SSRVCHANNEL (located in ABAP schema of PI database) is a part of Integration Server Runtime Cache (ABAP cache).

It is also possible to retrieve some communication channel data from respective caches, but if the focus is to retrieve original communication channel configuration data, the table XI_DIRDATACHANNEL should be considered.

Regards,

Vadim

[former_member235681]

Here Is complete solution:

select * from XI_DIRKEYCHANNEL; --- Channel Name and Channel ID

select * from XI_DIRSYNCADMIN; --- Channel ID and Channel Date

select * from XI_DIRDATACHANNEL; -- Channel ID and Channel whole XML as field ATTRBTS

To decipher LOB data type ATTRBTS field of above table to get channel data.

use below string:

select cast(BINTOSTR(cast(ATTRBTS as binary)) as varchar) from XI_DIRDATACHANNEL;

Navdeep Swami

PI Expert

navdeep@indianoil.in

[Former Member]

This message was moderated.

[former_member194612]

Hi Gopal,

To my knowledge ,

you will not find a table in ABAP stack

Thanks,

Satish

[former_member518917]

Hi Gopal,

You can find channel info in table "XI_AF_CPA_CHANNEL" , column : ATTRIBS

Ritu