Hello team,
I’m using My webMethods server 10.11

I have a question while running Archive Audit Data.

I tried running archive audit data archive and deleted but the record of table are not truncated/deleted and also not archived even though Archive History return success such as “Processes have been successfully archived into archive tables and deleted from ProcessAudit runtime tables”

https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/1e2f723d8cd227817798faca2c30250183234b5c_2_1035x249.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/1e2f723d8cd227817798faca2c30250183234b5c_2_1380x332.png 2x" data-dominant-color="DBE7EC">

image1601×387 26.5 KB

below the archive history result

https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/9962da90a701dc4fa7aafd06892f07c52d715b25_2_1035x235.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/9962da90a701dc4fa7aafd06892f07c52d715b25_2_1380x314.png 2x" data-dominant-color="D5E3ED">

image1593×364 54.3 KB

and also I separate archive table and process audit table as shown below

https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/965e87f08dc7be24472220c73afd7b4d2504c536_2_1035x498.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/965e87f08dc7be24472220c73afd7b4d2504c536_2_1380x664.png 2x" data-dominant-color="EBEBEC">

image1620×781 77.4 KB

is there any config i missed, so archive audit data doesn’t work even though it returns success ?

really appreciate for the help!

Thanks,
Dimas

Hi Dimas,

please follow the steps mentioned in the Monitor Users Guide for how to configure Monitor for archiving.

Remember to grant the proper rights in the IS Core Audit and Process Audit schema to the Archive schema user.

Can you share the content of the CONFIG-table from the archive schema?
It should look similar to the properties shown in your second screenshot.

I am not sure how this needs to be configured for DB2, but for Oracle database it was sufficient to point the database schema variables to the proper audit database schema and leaving the DB link empty when they were hosted on the same database instance.

Instead of using the function in MWS (which will not work properly when you have multiple IS instances monitored by one MWS instance as it does not have an IS server selector box) you can go to IS Admin directly, select Packages → Management → click on WmMonitor and select “Browse services in …”. From there you can select the desired archiving service and “Test service …”. Here you can fill the form and “Test with Inputs”.

Regards,
Holger

Hi Holger,
Thanks for reply.

can you give details where the config-table refers?

i also already set the config in pub.monitor.archive:setOperationParameters, is this correct?

image1011×843 34.4 KB

Thanks,
Dimas

Hi Dimas,

in the Archive-Schema there is a table called “OPERATION_PARAMETERS” which hold the configurations shown above.
The parameters PROCESS_SCHEMA and ISCORE_SCHEMA need to point to the live schema where IS and/or PRT are storing their audit data. I doubt that “SQL Server” will be the right value for that.

I assume that SAG-H8SV753 is the name of your SQL-Server instance instead of the schema name, is this right?
If not, the value SAG-H8SV753 might be uses as the Schema name then.

To verify this I would like to ask you to share the pool alias definitions for IS Pool and Archive Pool from IS Admin.

Regards,
Holger

Hi Holger,

Thank you for the advice,
I’ve changed the parameters PROCESS_SCHEMA and ISCORE_SCHEMA with database name are currently used to store the audit data and to changes those parameters i’m use services pub.monitor.archive:setOperationParameters. and then it works!

Table OPERATION_PARAMETER

image1419×346 18.5 KB

Audit History

https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/15f8e574b47d0c25fe9a1c4c1f698c3b9541a423_2_1035x216.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/15f8e574b47d0c25fe9a1c4c1f698c3b9541a423_2_1380x288.png 2x" data-dominant-color="D8E6F0">

image1607×337 52.5 KB