When running session tuxch4663m000 "Print Range of Audit Files" I get the error "Error reading transaction 0 table tiitm001 (company 100, sequence number 1)".
A few weeks ago I used the cleanup session to cleanup all files up to august 2004. The cleanup session didn't give any errors.
Is there anything I can do to get things working again without removing ALL the audit files for this table ?

I know that the audit files for this table are kept in $BSE/tables/audit/100/atiitm.
There is also a directory called $BSE/tables/audit/100/aTiitm. What is that for ?

thanks,

Walter

When running session tuxch4663m000
Walter

I could not find such a session.....

Do you have a lot of activity on this table so that all the sequence numbers for this table are used ? (I mean 999 audit files for this table )

There is also a directory called $BSE/tables/audit/100/aTiitm. What is that for ?

I think, the directory name is changed from atiitm to aTtiitm when there is a table change in the ti package and itm module. This was sometime ago and this caused some other issues. So one of the recent solutions actually fixes this issue and the capitalized "T" would not be appearing anymore for any table changes.

PS - This based on my tools version. I am not sure if the fixes are in place for your version.

Thanks for your response,

The program tuxch4463 is a copy of ttaad446 but we have the ability to create our own reports for it.

Currently the seq number range is 630 to 908.
What happens when I reach 999 + 1 ? The range is from 000 to 999.
As far as the activity goes, the audit creates 3 to 4 seq files of 2Mb per day. Most of the changes are done by some night processing that we need.

I'll see what I can do with the aTiitm directory.


Walter

What happens when I reach 999 + 1 ? The range is from 000 to 999.
When it reaches 999 then it goes back to 000.

The Audit sequence numbers are specified by the settings in - $BSE/lib/audit_spec

You can refer to the Audit Management in the Tools Administration Guides.

If you reach 999 and did not delete old sequence files (ie. seq 000 is still lying on disk), then actually you will get lots of nice errors, while updating/inserting on the referenced table.

Does anybody have experience with manipulating actually the entries in audit_spec?

What does "security 28" mean?

Regards

Markus

Does anybody have experience with manipulating actually the entries in audit_spec?
Yes.
What does "security 28" mean?
You can refer to the Audit Management in the Tools Administration Guides.
The different security levels and their codes are as follows:
Security Value
Print 4
Clean 8
Maintain 16
Application defined 32
The combination of these is explained in the section"Authorizations''.
To specify clean and maintain, security is specified as security 24
(the sum of 8 + 16).
Application-defined cannot be combined with print and clean. It can be
combined with maintain permissions only.