Problem with Archiving TN DB using built in service wm.tn.archive:archive

Hello All,

I’m trying to archive the TN DB which are 30 days old using built in service wm.tn.archive:archive . i gave input “archiveAfterDays” as 30. But instead archiving iam getting below error.could any one help me regarding this aspect

ERROR:
Could not run ‘archive’.

com.wm.app.tn.db.DatastoreException: Could not archive documents.
(0) java.sql.SQLSyntaxErrorException: [sag-cjdbc42-0011][Oracle JDBC Driver][Oracle]ORA-00904: “SERVICENAME”: invalid identifier

(1) java.sql.SQLSyntaxErrorException: [sag-cjdbc42-0011][Oracle JDBC Driver][Oracle]ORA-00904: "SERVICENAME": invalid identifier

ArchiveError.bmp (396 KB)

It’s issue with your archive schemas missing some definitions most likely.

So can you drop the archive tables and rerun the scripts and make sure all the Archive tables installed and also check with your DBA another set of eye to check every thing fine on the DB side.

Then try to run the archive service (Note this will take longer if you have huge data sitting in the DB and running first time)

HTH,
RMG