Symptoms

Archive stored procedure
 

Diagnoses

The definition for the archive stored procedure is attached to the ticket. See "mArchive_v1.3.zip".

Output
On creation of the procedure we got this error
The module 'mArchive' depends on the missing object 'mArchiveBackupLog'. The module will still be created however, it cannot run successfully until the object exists.






 

Resolution

Resolution:

From what I understand is that when you archive you have to archive to a new Database, you can not archive to an existing ArchiveSet.
http://help.k2.com/kb000322

Our documentation also shows that you have to create a new Database. I think this also has a factor when you need to restore archived data.

This is why is errors out from the script and from workspace when using an existing archive database.

Supplied new version of mArchive_v1.6.zip