Reading,viewing and accessing Java Tables

[former_member186851]

Dear SCN Users,

Is there any way/tool to access Java table XI_AF_MSG which stores the message status in PI system.

[Former Member · Accepted solution]

Hello Raghuraman ,

Please check SAP Note : 872388. You have to use some external SQL tool for accessing and reading the table.

<The master table for persistence of messages on the Java side is table BC_MSG (XI_AF_MSG for PI 7.0x and lower). Since this is a table on the Java DB schema it cannot be monitored via transaction SE16. Starting from 7.1 it is possible to check the number of entries in these tables using the NWA OpenSQL monitors. For older releases you have to use database tools. To analyze the overall number of messages based on their status you could use the following SQL statement: SELECT COUNT(*), STATUS FROM <Java Schema name>.BC_MSG GROUP BY STATUS;(XI_AF_MSG for older releases).>

The below link can be useful :

Java Stack Tables: XI_AF_MSG | SCN

Thanks

Gaurav

[former_member186851 · Accepted solution]

Thanks Gaurav,

Is there any way to read the contents of these tables.

[former_member184720 · Accepted solution]

Did you try open SQL browser in NWA? URL : http:// host:port nwa/databrowser

For external access, It depends on your database..What is your database?

For ex : you can use Oracle SQL developer for Oracle.

You need to have authorization to connect though

[former_member186851 · Accepted solution]

Hello Hareesh,

In open SQL browser I am just seeing the number of entries in the table.

Oracle is the data base,Is there any possibility to query from external ECC system and access these tables

[former_member184720 · Accepted solution]

I'm not sure of older version but i can access the table data as well from Open SQL browser.

Of course you need specific authorization : SAP_XI_READ_BCMSG_PAYLOAD_TABLES.

>>>Is there any possibility to query from external ECC system and access these tables

Not sure of accessing it from ECC but as i said you can make use of Oracle SQL developer/toad etc.

[former_member186851 · Accepted solution]

Thanks Hareesh For your valuable inputs.Let me try it.

[former_member186851 · Accepted solution]

Hareesh I am able to view the tables.is there any table from where I can download XMLs?

[former_member184720 · Accepted solution]

I'm not sure what you are trying to do here, but i don't think it is legal(as per the licensing agreement with SAP) to access these DB tables directly from external sources.

If your requirement is to extract the xml messages then why don't you make use of available webservices?

[former_member186851 · Accepted solution]

Hareesh My requirement is to update ECC tables from BC_MSG.Incase of any particular failure need to get that particular XML message.I will try to access the BC_MSG table from SAP ECC BAPI.