finding out java schema of adapter and decetral adapter engine.

[nirmalkumar_v]

Hi Everyone,

I want to find out the java schema of adapter engine and decentral adapter engine in XI 7.0 and PI 7.1.  I want to use it like it is mentioned in the below blog.

PI Adapter Engine Troubleshooting SQL Statements - Process Integration - SCN Wiki

can you also tell me if the table names of decentral adapter engines will vary from the adapter engine table names.

Also let me know if there is any other way to view this table than the above blog.

for example :

SXMSPMAST
SXMSPEMAS

SXMSMSTATT

SXMSMSTAT

these tables can be viewed in the data browser in abap stack.

thanks in advance.

[AnilDandi · Accepted solution]

Hi Nirmal,

The JAVA schema will be SAP<SID>DB or SAPSR3DB. You can check the schema name from Visual Admin or NWA by looking into JDBC Connector service. You will have datasources connecting to the above mentioned schema IDs

If your DB is Oracle, you can find the schema IDs by running the following SQL

select USERNAME, USER_ID from ALL_USERS;

Table name vary by PI release version (XI_AF_MSG for older PI release and BC_MSG for newer ones). If DAE and AE are on same release, the table names will be same.

There are tools like TOAD, where you can run these commands.

If you are looking to simplify monitoring of PI, setup PI Monitoring feature on Solution Manager 7.1.

regards

AKD

[nirmalkumar_v · Accepted solution]

Hi AKD,

WOW!!! . Thanks.  this is what I was expecting.  Ultra correct answer.

unable to use solution manager because the system is XI 7.0.

and I was able to find the SID of the AE and DAEs.