Lessons Learned working on audit-consolidator

I have Audit consolidator deployed in AWS where I scheduled Audit Export task to run daily.

Xml files are stored in mgr directory because the task runs in %SYS namespace.

/usr/irissys/mgr

-rwxrw-r--. 1 irisowner irisowner 249080 Apr  9 21:48 8eedba82d0ee_2023-04-09_auditexport.xml*

-rwxrw-r--. 1 irisowner irisowner  19487 Apr 10 00:02 8eedba82d0ee_2023-04-10_auditexport.xml*

-rwxrw-r--. 1 irisowner irisowner  23554 Apr 11 00:02 8eedba82d0ee_2023-04-11_auditexport.xml*

-rwxrw-r--. 1 irisowner irisowner  27624 Apr 12 00:02 8eedba82d0ee_2023-04-12_auditexport.xml*

-rwxrw-r--. 1 irisowner irisowner  31695 Apr 13 00:02 8eedba82d0ee_2023-04-13_auditexport.xml*

-rwxrw-r--. 1 irisowner irisowner  35766 Apr 14 00:02 8eedba82d0ee_2023-04-14_auditexport.xml*

-rwxrw-r--. 1 irisowner irisowner  39842 Apr 15 00:02 8eedba82d0ee_2023-04-15_auditexport.xml*

-rwxrw-r--. 1 irisowner irisowner  43922 Apr 16 00:02 8eedba82d0ee_2023-04-16_auditexport.xml*

-rwxrw-r--. 1 irisowner irisowner  48002 Apr 17 00:02 8eedba82d0ee_2023-04-17_auditexport.xml*

-rwxrw-r--. 1 irisowner irisowner  52082 Apr 18 00:02 8eedba82d0ee_2023-04-18_auditexport.xml*

-rwxrw-r--. 1 irisowner irisowner  61741 Apr 19 00:05 8eedba82d0ee_2023-04-19_auditexport.xml*

I tried to import files into consolidator class while I used Storage definition with a map to a global.

Error: Cannot INSERT into ReadOnly table

I removed Storage Strategy and recompiled consolidator class.

I created ClassMethod ImportAll() and I got data into SQL table.

I verified data was saved by running query:

Select * from otw_audit.consolidator

Next lesson will be copying data into IRIS Cloud SQL.