UCS archive via USM failing

Anyone else had issues with records not archiving? I’m getting the below error in logs. Records meet the desired archive/prune criteria, however will not archive, scans them a leaves them in current schema.

UCS is v8.1.200.03 DB is Oracle 11G

09:46:30.172 Std 20145 [uningTask-9] Recover insertion of ‘PhoneCall’ with Id (xxxxxxxxxxxxxxx) failed with error Invalid IxnMedia ‘Voice’ for PhoneCall object, cannot recover
com.genesyslab.icc.api.contactserver.PersistentException: Invalid IxnMedia ‘Voice’ for PhoneCall object
at com.genesyslab.icc.contactserver.persistent.PhoneCallManager.insert(PhoneCallManager.java:212)

Also, USM randomly crashes with below error;

16:58:10.128 Dbg 29999 [7.82:207797] task-38 2 MANUAL 1369747178812 ERROR 27637/111486 1-1 error:-1-Exception counting thread id to process : com.genesyslab.icc.api.contactserver.PersistentException: Recoverable error ‘com.genesyslab.sql.exception.RecoverableException: IO Error: Connection reset’ occured in database server transaction - Vendor Code=17002, SQLSate=08006

The error is clear, your DB Server (not genesys) is closing the connection. Maybe can’t handle all that info and has a timeout?
Check with your DBA to analyze the DB Server behavior in that moment

Thanks, so that would explain why the task is failing on the large number of records to archive. However, the process is still ignoring records that meet the 3 archive criteria specified by Genesys support documentation. Which means that the number of records to scan is not reducing and the db is closing the connection.

Any ideas?

Again…check with your DBA…he must analyze the server behavior and configuration. Probably also do some indexation and fine tuning.