sulong
17th April 2008, 04:23
Hope somebody could help us to this error. It resulted user session hang and locked. We as administrator have to remove it from aplication lock session.
It happened more than 20 times a day and initiated from diferent number of sessions.
The example of error written in log.bshell file is as follows :
Log message called from /BAAN/view/port.8.4a.02/vobs/tt/mir/mir/mul_fun.c: #472 keyword: Process state:
Pid 745704 Uid 232 Euid 31 Gid 32 Egid 32 Pset ZARINA@INA:1148
user_type N language 2 user_name sai_acc2 tty ote locale ISO88591/NULL
session: "ottstpstdlib ";object: "ottstpstdlib"; company number: 0
query: "select ttadv998.*
from ttadv998 for update
where ttadv998._index1 =
{:ttadv998.name, -1, :applid, :receive.from}
"
Errno 0 bdb_errno 2460 (database error 1460)
FATAL ERROR: Error 2460 (database error 1460) on select
Can not continue in ottstpstdlib (appl.del)[sql.fetch]
Our current db_resource parameters are :
dbsinit:01
ora_init:0101000
ora_max_array_fetch:5
ora_max_array_insert:1
rds_full:2
nls_lang:american_america.we8iso8859p1
nls_sort:binary
oracle_home:/usr1/oracle/product/9.2.0
ora_temporary_tablespace:TEMP
ora_default_tablespace:TOOLSDAT
lock_retry:0
baan_oracle_prefetch:0
ora_timeout:{999,999,999,999,999}
Really hope someone could help us.
Regards,
Sulong
It happened more than 20 times a day and initiated from diferent number of sessions.
The example of error written in log.bshell file is as follows :
Log message called from /BAAN/view/port.8.4a.02/vobs/tt/mir/mir/mul_fun.c: #472 keyword: Process state:
Pid 745704 Uid 232 Euid 31 Gid 32 Egid 32 Pset ZARINA@INA:1148
user_type N language 2 user_name sai_acc2 tty ote locale ISO88591/NULL
session: "ottstpstdlib ";object: "ottstpstdlib"; company number: 0
query: "select ttadv998.*
from ttadv998 for update
where ttadv998._index1 =
{:ttadv998.name, -1, :applid, :receive.from}
"
Errno 0 bdb_errno 2460 (database error 1460)
FATAL ERROR: Error 2460 (database error 1460) on select
Can not continue in ottstpstdlib (appl.del)[sql.fetch]
Our current db_resource parameters are :
dbsinit:01
ora_init:0101000
ora_max_array_fetch:5
ora_max_array_insert:1
rds_full:2
nls_lang:american_america.we8iso8859p1
nls_sort:binary
oracle_home:/usr1/oracle/product/9.2.0
ora_temporary_tablespace:TEMP
ora_default_tablespace:TOOLSDAT
lock_retry:0
baan_oracle_prefetch:0
ora_timeout:{999,999,999,999,999}
Really hope someone could help us.
Regards,
Sulong