Java Stack Tables: XI_AF_MSG

[Senthilprakash1]

Hi Experts,

I know that inorder to get count of the messages in Java Stack XI_AF_MSG we perform SELECT COUNT (*) FROM XI_AF_MSG

Note: 872388 as this cannot be viewed via SE16.

I want to develop a tool which will access this XI_AF_MSG table and periodically display status of the messages in a Display monitor. using ODBC connectivity to the DB directly.

Q1. Is it ok to build up the Scripting tool to access the table and display information in READ ONLY MODE (like: Number of System error messages, total messages in a day..etc).

Q2. is it like we are not supposed to access this table manually as its SAP system table. (which i doubt as in the note 872388 they have specifically asked us to connect to table using external DB clients).

Q3. will it breach contract with SAP if we do this scripting/Stored procedure.

Q4. Is there a alternate solution for this.

Waiting for your suggestions. Hope PI experts help me on this.

Regards,

Senthilprakash.

[prateek · Accepted solution]

1. Yes, it should be ok.

2. Not recommended of course.

3. This should not be a contract breach. I would like to know if anyone think otherwise.

4. If it is read only and the use is what you mentioned, why not use RWB

Regards,

Prateek

[Senthilprakash1 · Accepted solution]

>

> 1. Yes, it should be ok.
> 2. Not recommended of course.
> 3. This should not be a contract breach. I would like to know if anyone think otherwise.
> 4. If it is read only and the use is what you mentioned, why not use RWB 
> 
> Regards,
> Prateek

Hi Prateek,

Thanks for your reply.

the main purpose of this is to not to open RWB manually everytime and check the status. this API script can be scheduled say for every 30 min and the output will be constantly displayed on a dedicated screen as a HTML page. hence on need to basis (if anything abnormal) we login to system to rectify it say like system error or somethin.

The main thing is I want to know weather it will breach the SAP contract if i have a API which will talk to the table direclty and display the status on a screen. if no i shall proceed ahead. if yes what should be done. as i need readonly access to the java stack table

Regards,

Senthilprakash

[Senthilprakash1]

Hi All,

Just to update on this.

I had raised a OSS message for this legality issue.

SAP came up with below reply and its not a problem unless the queries are optimal and check DB load on it. thats all

+SAP REPLY ---+
Hello Senthilprakash!

Besides the possibility of having performance issues if the database is
too large, there is no problem to query the database directly in order
to retrieve this information. However, this information can be accessed
already using a RWB servlet (it returns a XML document with the messagesoverview), as per note below:
#1400785 - Message Overview: automatic query of data with a servlet

Please let me know in case you have any further questions.

Cheers- Senthilprakash

[Former Member]

Hello Prakash,

i noted your requirnment. My Suggestion as a developer:

If you can make an abap program for the same requirement and query the message queue of the PI on a periodical interval THAN you can convert the abap program to a Web Denpro program AND see/Monitor the Output on a a Browser or Handheld or mobile.

* To give you a heads up on the Abap Program: Use the table in PI - SXMSPMAST - Integration Engine: Message Queue (Master). this table will give you all the details of the messages in PI. Again you have to see the performance feasibility.

let me know what you think.

Regards,

Tarik Parkar

[Senthilprakash1]

>

> h5. Hello Prakash,
> h5. i noted your requirnment. My Suggestion as a developer:
> h5. If you can make an abap program for the same requirement and query the message queue of the PI on a periodical interval THAN you can convert the abap program to a Web Denpro program AND see/Monitor the Output on a a Browser or Handheld or mobile. 
> h5. * To give you a heads up on the Abap Program: Use the table in PI - SXMSPMAST -  Integration Engine: Message Queue (Master). this table will give you all the details of the messages in PI. Again you have to see the performance feasibility.
> 
> h5. let me know what you think.
> 
> h5. Regards,
> Tarik Parkar

hi Tarik,

Thx for the info but this is not what i am looking for.

Probably you would be already knowing, SXMPMAST table will contain only abap stack entries. and i am trying to retrieve Java stack entries for monitoring.

Also for ABAP and JAva stack the DB Schemas are different so you cannot access XI_AF_MSG via SE16 reports.

one way to access java stack table from abap stack is by using DBCO connection which again uses ODBC connectivity to connect to the Java stack table.

Question is, whether it is ok to connect to XI_AF_MSG table via ODBC connectivity to retrieve status say every 1hr. will it not breach SAP contract.

I have developed a API which will do the same. I need to make sure weather connecting to the system table wont have any SAP legal issues.

Regards,

Prakash

Edited by: senthilprakash selvaraj on Jan 24, 2011 5:34 AM

[former_member200962]

will it not breach SAP contract

it will not.

AFAIK...Any negative impact on the system performance due to such an access is not covered by SAP support

Edited by: abhishek salvi on Jan 24, 2011 10:17 AM

[Senthilprakash1]

Thanks a lot Prateek and Abhishek,

I am also thinking the same. i will go ahead with this API.

Cheers Guys,

Prakash

[Senthilprakash1]

Hi Guys,

Any help here..!

-Prakash