when trying to save a record in the sesson ttaad4111m000:Assign Tables to Database
with the values as
Table Selection:Speified Table,
Table/Module:tdpur000,
All companies:Yes,
Database : 001-informix
I get the following error
Fatal error: Error 251 (The audit server setup is not correct) on ttaad411000 in db_insert(51)
Fatal error: Can not continue in ttaad4111m000 in DLL: ottstpstandard ()
Error: ttaad4111m000: A not terminated transaction is aborted

ALSO, when excuting session Maintain Audit File Directories I get the following error:
Fatal error: Error 2 (bdb_errno 2) on ttaad416000 in db_insert(51)
Fatal error: Can not continue in ttaad4116m000 in DLL: ottstpstandard ()
Error: ttaad4116m000: A not terminated transaction is aborted

Early help would be highly appreciated.
Thanks in advance

$BSE =/baan/bse

the $BSE/audit directory has the below permissions:
drwxrws--- 2 bsp bsp 512 Dec 02 12:33 audit
and

/baan/audit directory has the below permissions:
drwxrws--x 2 bsp bsp 512 Dec 02 12:15 audit

The contents of $BSE/lib/audit_spec is :
*:*:TOSEQ 999 SECURITY 28 MAXSEQSIZE 2048K

and the $BSE/lib/tables_audit has all the parameter tables name only no Y or N on either side. There are 87 lines
e.g.
cpcom000
cprpd000

and there is no file named tabledef6.1 in $BSE directory

An early reply would be highly appreciated

Thanks

Hi there,

your profile shows, you are running windows, but your "ls" output indicates you are on unix?

Let's assume, you are on Unix.

I would be completly stunned to hear, that you have no tabledef6.1 file in $BSE/lib. You should not be able to do anything in your DB or see anything!!!!


Can not be!!!

If so, go to "Assign tables to databases" and do a create runtime. This will create the tabledef6.1

Then log in again. maybe your problem is already gone.

If not check the entries in tabledef6.1 for the "tt" tables in company 000. They do not need any auditing. So switch it off.

Also check the audit6.1 file in $BSE/lib to be on the save side.

Regards

Markus

i was on windows..long back...and have not updated my profile...i will do it soon!! right now i am 4c4/Unix/Informix.

yes u r right, the tabledef6.1 file is there with the entry:
*:*:informix(INFORMIXDIR=/iconnect2.8,INFORMIXSERVER=baanc4,INF_LEVEL1=1):Y

how do i exclude the tools tables from this?

Also, bot the problems are still there.

the file $BSE/lib/auditdef6.1 is empty.

Also, i realised that during the installation of c4 there is a step in which the manual says
Insert a new database named AUDIT. As a description, use AUDIT Database. The type of database depends on the running RDBMS. Select the Audit Trail check box. Clear the Force to Read and Copies Present check boxes.

i did not do that step...i have uploaded the data ..can i do it now?

thanks for that quick reply..

Awaiting

hmmm, ok.

First of all, the entry in your tabledef is strange or wrong.
The last "Y" indicates, that these tables shall be audited, which is definitely not what you want for all your tables.

For starters I would change in tabledef6.1 the last "Y" to a "N".
Then your initial error is gone!

Second, you should define as described in the installation manual, one database without audit and one database with audit on. then you assign all normal tables to the database without audit and the parameter tables to the database with audit. If you loading of data was successfull and the two database are essentially the same (apart fom the audit), then you can do this any time.

Third you have to define your audit directory in "Maintain audit dirs" or so to get a auditdef6.1.

That should clean up your setup mostly.

If you do not install Baan frequently, then it pays to follow the installation manual (mostly :-)

Enjoy

Markus

ur problem was due to the wrong info given in tabledef6.1 file. There u r defining the tables with audit on and the location of the audit files are not given in auditdef6.1 file. If u see ur log, it was giving error 2(means not able to read the required files). Pls create two database with one "audit on" and another with "audit off". Assign the tables, which r required to be audited with database "audit on" and other without audit. Before doing that, u can make the entry of tabledef6.1 file with the below text

*:*:informix(INFORMIXDIR=/iconnect2.8,INFORMIXSERVER=baanc4,INF_LEVEL1=1):N and can start working.