We are using Informix 7.23 on BaaN IV.

Process MRP was fail/ aborted by system.

Db Log message: Long transaction aborted.

Any body know how to solve this problem?

Thanks.

Nanggala

Hello,

Can you post the db error number from the db log.

Cheers
Neal

Thanks Neal,
Currently I have to partially run the MRP process.
this is the db log number. I copied all the log message related with the process.

105-05-07[19:52:28]ferry: ******* S T A R T of Log message *******
105-05-07[19:52:28]ferry: Log message called from inf_error.c $ $Revision:
/main/bugfix6.1c/9 $: #418 keyword: EXECUTE_IMMEDIATE
105-05-07[19:52:28]ferry: Pid 3626 Uid 147 Euid 147 Gid 125 Egid 125
105-05-07[19:52:28]ferry: user_type S language 2 user_name ferry tty ote locale
ISO88591/NULL
105-05-07[19:52:28]ferry: Errno 0 bdb_errno 0
105-05-07[19:52:28]ferry: Log_mesg: Code -458 ISAM err 0 #rows 0 Lrow 0 Offset 0
105-05-07[19:52:28]ferry: ********** E N D of Log message **********
105-05-07[19:52:28]ferry:
105-05-07[19:52:28]ferry: ******* S T A R T of Log message *******
105-05-07[19:52:28]ferry: Log message called from inf_error.c $ $Revision:
/main/bugfix6.1c/9 $: #426 keyword: INFORMIX_ERROR_MESSAE
105-05-07[19:52:28]ferry: Pid 3626 Uid 147 Euid 147 Gid 125 Egid 125
105-05-07[19:52:28]ferry: user_type S language 2 user_name ferry tty ote locale
ISO88591/NULL
105-05-07[19:52:28]ferry: Errno 0 bdb_errno 0
105-05-07[19:52:28]ferry: Log_mesg: Long transaction aborted.
105-05-07[19:52:28]ferry:
105-05-07[19:52:28]ferry: ********** E N D of Log message **********
105-05-07[19:52:28]ferry:
105-05-07[19:52:28]ferry: ******* S T A R T of Log message *******
105-05-07[19:52:28]ferry: Log message called from inf_error.c $ $Revision:
/main/bugfix6.1c/9 $: #418 keyword: EXECUTE_STMT
105-05-07[19:52:28]ferry: Pid 3626 Uid 147 Euid 147 Gid 125 Egid 125
105-05-07[19:52:28]ferry: user_type S language 2 user_name ferry tty ote locale
ISO88591/NULL
105-05-07[19:52:28]ferry: Errno 0 bdb_errno 0
105-05-07[19:52:28]ferry: Log_mesg: Code -255 ISAM err 0 #rows 0 Lrow 0 Offset 14
105-05-07[19:52:28]ferry: ********** E N D of Log message **********
105-05-07[19:52:28]ferry:
105-05-07[19:52:28]ferry: ******* S T A R T of Log message *******
105-05-07[19:52:28]ferry: Log message called from inf_error.c $ $Revision:
/main/bugfix6.1c/9 $: #426 keyword: INFORMIX_ERROR_MESSAE
105-05-07[19:52:28]ferry: Pid 3626 Uid 147 Euid 147 Gid 125 Egid 125
105-05-07[19:52:28]ferry: user_type S language 2 user_name ferry tty ote locale
ISO88591/NULL
105-05-07[19:52:28]ferry: Errno 0 bdb_errno 0
105-05-07[19:52:28]ferry: Log_mesg: Not in transaction.
105-05-07[19:52:28]ferry:

Thanks
Nanggala

Hello,

Long transaction problems are normally caused by a lack of logical logs. It may be worth trying to increase your number of logical logs. Just as a guide in our setup we have 30 logs of 500k.

Do a search on the board for logical logs to look for more info.

Also check out the IDS admin manual chapter 18.

http://www.informix.com.ua/answers/english/docs/73ids/4354.pdf

Good luck
Neal