cancel
Showing results for 
Search instead for 
Did you mean: 

Table count in JAVA Stack PI7.3 ?

Former Member
0 Kudos

Hi All,

We are using PI 7.3 (dual stack) and want to find the number of messages in Adapter Framework...

Where can i see the table XI_AF_MSG in the JAVA stack and also want see the count on these table...

To analyze the overall number of messages some blog suggested to use the following SQL statement:

"SELECT COUNT (*) FROM XI_AF_MSG." but iam not aware where should i use it ?

Thanks in Advance.

Accepted Solutions (1)

Accepted Solutions (1)

vadimklimov
Active Contributor
0 Kudos

Hi Kumar,

The table XI_AF_MSG doesn't exist in PI 7.3 - most likely, you need the table BC_MSG that is a successor of XI_AF_MSG in 7.1x / 7.3x releases.

You can check amount of records in tables that are located in Java schema of PI database as well as browse their contents using SQL Data Browser (available in NetWeaver Administrator): in NWA, go to Troubleshooting -> Database -> Open SQL Data Browser.


Regards,

Vadim

Former Member
0 Kudos

Thanks Klim. Problem solved.

Answers (0)