Hello,

I added a filed to an existing table. This table has audit ON (from before).

I did a Convert to Runtime Data Dictionary with Reconfigure Option selected!

The problem is that I am no longer able to access the past audit data. My audit query DOES NOT include the new field that I just added.

It give me the following error: ttstpnetl00020
Error in getting field values from sequence file!!

My understanding is that as long as I don't query on the new field I should be able to query past data!!

Where am I going wrong?

Thanks in advance for your replies!!

Regards!!

Check your audit specification settings-


>cat audit_spec
*:*:TOSEQ 999 SECURITY 28 MAXSEQSIZE 2048K
[DEV:bsp]/app/baan/opt/bse/lib
>cat auditdef6.2
*:*:${BSE}/audit
[DEV:bsp]/app/baan/opt/bse/lib
>


Also, try to use the session - ttaad4460m000 - Check Audit Files Integrity.