on 10-16-2012 10:11 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.