While running an extract rule through command line in PRODUCTION we are facing below issues :

1. 23:59:37,634 [egaRULES UsageDaemon] (nitor.internal.UsageDaemonImpl) ERROR - Unable to save usage data to the database; verify that the table for Log-Usage has the correct schema
23:59:37,634 [egaRULES UsageDaemon] (nitor.internal.UsageDaemonImpl) ERROR - Error occurred while attempting to commit
23:59:37,634 [egaRULES UsageDaemon] (nitor.internal.UsageDaemonImpl) ERROR - Usage Failure Reason 1: Database-Saver-Insertfail
23:59:37,634 [egaRULES UsageDaemon] (nitor.internal.UsageDaemonImpl) ERROR - Usage Failure Reason 2: ORA-01438: value larger than specified precision allowed for this column
How can we identify the column(property) is causing the issue ?

2. 23:59:37,634 [egaRULES UsageDaemon] (nitor.internal.UsageDaemonImpl) ERROR - Usage data discarded
Exception in thread "Dispatcher-Thread-2" java.lang.OutOfMemoryError: Java heap space04:12:20,893 [egaRULES UsageDaemon] (oard.PropertyReferencePoolImpl) INFO - Exception Java heap space

We are having the -xmx value as 3072 MB ?
How should we define the max heap size value ?
Please suggest .

***Updated by Moderator: Marissa to move from Applications to Product Support Community; update categories***