When I am trying to update the Supplier Master table (tccom020) through the Maintain Suppliers session, it gives an error message that "ERROR 254(Commit Transaction has failed on the Audit server) on commit transaction". The table tccom020 is having audit trail.

What could be the possible reasons for the error?? How can it be rectified ?

Hi,

I think first you may search on site for the error number, there are lot of such points.

May be this link can help you:
http://www.baanboard.com/baanboard/showthread.php?t=25461&highlight=error+254

and also can run ttstperrlog & view log.audit in $BSE/log for detail information.

Regards,
MRF

Thanks for your suggestion. I am sending the part of error log of log.audit file. Please look into it and reply.


2006-05-24[10:48:44]:E:bsp: ******* S T A R T of Error message *******
2006-05-24[10:48:44]:E:bsp: Log message called from /view/port.6.1c.07.03/vobs/tt/servers/AUDIT/audit_file.c: #602 keyword: write_audit_data
2006-05-24[10:48:44]:E:bsp: Pid 10726 Uid 125 Euid 125 Gid 125 Egid 125
2006-05-24[10:48:44]:E:bsp: user_type S language 2 user_name bsp tty ote locale ISO88591/NULL
2006-05-24[10:48:44]:E:bsp: Errno 0 bdb_errno 0
2006-05-24[10:48:44]:E:bsp: Log_mesg: write mem to seq. failed. Sess tccom2101m000 table tccom020450 Seq 3
2006-05-24[10:48:44]:E:bsp: ******* E N D of Error message *******
2006-05-24[10:48:44]:E:bsp:
2006-05-24[10:48:44]:E:bsp: ******* S T A R T of Error message *******
2006-05-24[10:48:44]:E:bsp: Log message called from /view/port.6.1c.07.03/vobs/tt/servers/AUDIT/audit_file.c: #434 keyword: flush_to_file
2006-05-24[10:48:44]:E:bsp: Pid 10726 Uid 125 Euid 125 Gid 125 Egid 125
2006-05-24[10:48:44]:E:bsp: user_type S language 2 user_name bsp tty ote locale ISO88591/NULL
2006-05-24[10:48:44]:E:bsp: Errno 0 bdb_errno 0
2006-05-24[10:48:44]:E:bsp: Log_mesg: write_audit_data() failed. Table tccom020450. Seq 003
2006-05-24[10:48:44]:E:bsp: ******* E N D of Error message *******
2006-05-24[10:48:44]:E:bsp:
2006-05-24[10:48:44]:E:bsp: ******* S T A R T of Error message *******
2006-05-24[10:48:44]:E:bsp: Log message called from /view/port.6.1c.07.03/vobs/tt/servers/AUDIT/serv_db.c: #370 keyword: Prepare Commit
2006-05-24[10:48:44]:E:bsp: Pid 10726 Uid 125 Euid 125 Gid 125 Egid 125
2006-05-24[10:48:44]:E:bsp: user_type S language 2 user_name bsp tty ote locale ISO88591/NULL
2006-05-24[10:48:44]:E:bsp: Errno 0 bdb_errno 0
2006-05-24[10:48:44]:E:bsp: Log_mesg: Sess tccom2101m000 : flush_to_file failed for table tccom020450. ABORT !!
2006-05-24[10:48:44]:E:bsp: ******* E N D of Error message *******

Thanks & Regards,
Sumit

Thanks for your suggestion. I am sending the part of error log of log.audit file. Please look into it and reply.


2006-05-24[10:48:44]:E:bsp: ******* S T A R T of Error message *******
2006-05-24[10:48:44]:E:bsp: Log message called from /view/port.6.1c.07.03/vobs/tt/servers/AUDIT/audit_file.c: #602 keyword: write_audit_data
2006-05-24[10:48:44]:E:bsp: Pid 10726 Uid 125 Euid 125 Gid 125 Egid 125
2006-05-24[10:48:44]:E:bsp: user_type S language 2 user_name bsp tty ote locale ISO88591/NULL
2006-05-24[10:48:44]:E:bsp: Errno 0 bdb_errno 0
2006-05-24[10:48:44]:E:bsp: Log_mesg: write mem to seq. failed. Sess tccom2101m000 table tccom020450 Seq 3
2006-05-24[10:48:44]:E:bsp: ******* E N D of Error message *******
2006-05-24[10:48:44]:E:bsp:
2006-05-24[10:48:44]:E:bsp: ******* S T A R T of Error message *******
2006-05-24[10:48:44]:E:bsp: Log message called from /view/port.6.1c.07.03/vobs/tt/servers/AUDIT/audit_file.c: #434 keyword: flush_to_file
2006-05-24[10:48:44]:E:bsp: Pid 10726 Uid 125 Euid 125 Gid 125 Egid 125
2006-05-24[10:48:44]:E:bsp: user_type S language 2 user_name bsp tty ote locale ISO88591/NULL
2006-05-24[10:48:44]:E:bsp: Errno 0 bdb_errno 0
2006-05-24[10:48:44]:E:bsp: Log_mesg: write_audit_data() failed. Table tccom020450. Seq 003
2006-05-24[10:48:44]:E:bsp: ******* E N D of Error message *******
2006-05-24[10:48:44]:E:bsp:
2006-05-24[10:48:44]:E:bsp: ******* S T A R T of Error message *******
2006-05-24[10:48:44]:E:bsp: Log message called from /view/port.6.1c.07.03/vobs/tt/servers/AUDIT/serv_db.c: #370 keyword: Prepare Commit
2006-05-24[10:48:44]:E:bsp: Pid 10726 Uid 125 Euid 125 Gid 125 Egid 125
2006-05-24[10:48:44]:E:bsp: user_type S language 2 user_name bsp tty ote locale ISO88591/NULL
2006-05-24[10:48:44]:E:bsp: Errno 0 bdb_errno 0
2006-05-24[10:48:44]:E:bsp: Log_mesg: Sess tccom2101m000 : flush_to_file failed for table tccom020450. ABORT !!
2006-05-24[10:48:44]:E:bsp: ******* E N D of Error message *******

Thanks & Regards,
Sumit

Hello,

there may be some reasons.
1 st - Is there enough space left in AUDIT directiory ?
2 nd - Check user permissions for this space.
3 rd - Check audit table size of tccom020 (or table space).

Regards