unable to view the WMPROCESSRECENT and WMPROCESSSTEP tables

Arun_Chollety · October 28, 2015, 8:42am

Hello Experts,

FOR webMethods 9.6 VERSION

I was trying to check the process audit schema for the tables WMPROCESSRECENT and WMPROCESSSTEP for some analysis.

But when i logged in to the database i’m unable to find the WMPROCESSRECENT and WMPROCESSSTEP tables.

These tables are actually have the data for process instances which were run.

I have run the sample process instance and i’m able to view the instance in MWS (The MWS which actually fetches the data from WMPROCESSRECENT and WMPROCESSSTEP)

So i’m wondering in which table the data is being logged into / or is it a problem with the user login.

I have already checked the follwoing.

Created “ALL” the tables using database component configurator.
The user used to login is master/DBA user.
Verified the tables in wM82 and they are visible.

Attached the image for reference.

Could anyone please suggest on this

Regards,
Arun Chollety.

Tong_Wang · October 28, 2015, 10:11pm

Those tables belongs to the processaudit DB.
I think they are only used for earlier version of WM, not the recent versions.

The corresponding table for WMPROCESSRECENT is PRA_PROCESS_RECENT,
and WMPROCESSSTEP → PRA_PROCESS_STEP
you can find the detail in file:
SoftwareAG\common\db\scripts\mssql\processaudit\migrate\70_to_71

Mahesh_K_Sreenivas · October 29, 2015, 5:55pm

Yes, there is a change of table names in v9 compared to v8 for BPM.

MR_as173d · October 29, 2015, 8:27pm

I agree with above comments, you can find those tables in ora_pra_m_runtime.sql

Thanks,

Arun_Chollety · October 31, 2015, 4:11am

Thanks Wang for the response.

I could see them.

I realized later that from wM9.6 the tables names have been changed.

wM9.5 has WMPROCESSRECENT and WMPROCESSSTEP