Integration Server Archive

Nipin_Manikkara · November 22, 2013, 11:27pm

I am trying to archive my IS core database (wmsysdb). I am using SQL Server 2012,

I had created archive database (wmarchivedb).
I had updated OPERATION_PARAMETER table with IS core DB and Archive DB name in PARAMETER_VALUE column.
Created a JDBC pool alias in IS pointing to archive DB.
Run two services pub.monitor.archive:serverArchive, pub.monitor.archive:serviceArchive.
I got an output as “Services have been successfully archived into archive tables and deleted from ISCoreAudit tables”.
But when I checked in archive data base I couldn’t found any data archived from IS core DB .

Please suggest me a solution… Thanks in advance

Hukam_Bairwa · December 3, 2013, 12:01pm

There should be a table in your DB with name OPERATION_LOG which holds the archiving logs. Have a look in that table data, hopefully you will get the exact error. If still it doesn’t help, share the data of this table for recent execution.

Holger_von_Thomsen · December 3, 2013, 1:48pm

Please make sure that the archive DB user has the rights to select and delete data from the regular schema.
Is the pool associated to the Archiving function in IS?

The grant statements need to be executed on the regular schema and is formatted like this:
Grant on

to ;

For my latest installation (wM 7.1.3) I used the following (Oracle-)Statements:
grant SELECT, DELETE on WMCONTROL to ;
grant SELECT, DELETE on WMCUSTOMDATA4X to ;
grant SELECT, DELETE on WMCUSTOMFIELDDEFINITION to ;
grant SELECT, DELETE on WMCUSTOMPROCESSDATA to ;
grant SELECT, DELETE on WMDOCUMENT to ;
grant SELECT, DELETE on WMERROR to ;
grant SELECT, DELETE on WMPROCESS to ;
grant SELECT, DELETE on WMPROCESSASSOC to ;
grant SELECT, DELETE on WMPROCESSDEFINITION to ;
grant SELECT, DELETE on WMPROCESSIMAGE to ;
grant SELECT, DELETE on WMPROCESSRECENT to ;
grant SELECT, DELETE on WMPROCESSSTEP to ;
grant SELECT, DELETE on WMPROCESSTRANSITION to ;
grant SELECT, DELETE on WMSECURITY to ;
grant SELECT, DELETE on WMSERVICE to ;
grant SELECT, DELETE on WMSERVICE4X to ;
grant SELECT, DELETE on WMSERVICEACTIVITYLOG to ;
grant SELECT, DELETE on WMSERVICEASSOC to ;
grant SELECT, DELETE on WMSERVICE_MIN_MAX to ;
grant SELECT, DELETE on WMSESSION to ;
grant SELECT, DELETE on WMSTEPDEFINITION to ;
grant SELECT, DELETE on WMSTEPTRANSITIONDEFINITION to ;
grant SELECT, DELETE on WMTXIN to ;
grant SELECT, DELETE on WMTXOUT to ;

Please check for the correct format for SQL-Server.
There might be more tables to be considered on newer versions of wM.

Did you run serviceArchive with the correct settings?
If Action is DELETE, there will be no archived data at all.
retainDays should be smaller than the total amount of days stored in the schema, otherwise the data is not considered for Archiving.

Nipin_Manikkara · December 3, 2013, 6:43pm

Thank you Hukam Bairwa and Holger von Thomsen, this issue got resolved by installing recent Monitor Fix. I run the update manager for installing Fix. I am attaching the screen shot of Monitor Fix which i installed.