SAP PI Java Stack Tables

[rasjoshi]

Hi,

I want to fetch my payload from SAP PI DB Tables. How to achieve this??

I can see some table inside NWA --> Open SQL Monitors

Inside queries tab I can see some SQL statements. How to define my SQL queries to get the payload from DB?

Regards,

Rashmi Joshi

[manoj_khavatkopp]

try to execute SQL query on table SXMSPMAST using your any particular message id or any other parameter

[rasjoshi]

Thats what I am looking for, how and where to execute query, which software I can use, how can I connect it with my PI DB

Also, pls confirm if this is table from Single stack.

[manoj_khavatkopp]

you need to use DBVisualizer to execute sql statmentsHow to connect DBVisualizer to your PI system - Process Integration - SCN Wiki

[rasjoshi]

Thanks Manoj, I will try this. Seems needs lots of details to use this

BR,

Rashmi

[rasjoshi]

By any chance can you help me with SQL query to fetch my payload from table?

BR,

Rashmi

[manoj_khavatkopp]

well currenlty i dont have access to PI system to try this out , but check if below link would be helpful

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

[former_member186851]

Hello Rashmi,

What is the purpose ?as you can get the XMLs from monitoring.

[rasjoshi]

Just want to explore other ways too

[former_member186851]

I dont think you can extract directly from the tables as such.

Try the below approach