We have been running a query every night for ages without any problems until 2 days ago. The query suddenly runs for a long time and in the log bshell file the following message is logged. Any ideas ?
Everybody has read/write access on /bse_tmp and there's more than enough space left.

Walter

2007-07-14[02:08:46]:E:jobDBR: ******* S T A R T of Error message *******
2007-07-14[02:08:46]:E:jobDBR: Log message called from /view/port.6.1c.07.06/vobs/tt/lib/al_1/al_fpath.c: #191 keyword:sopen
2007-07-14[02:08:46]:E:jobDBR: Pid 173752 Uid 0 Euid 0 Gid 0 Egid 0
2007-07-14[02:08:46]:E:jobDBR: user_type S language 1 user_name jobDBR tty locale ISO88591/NULL
2007-07-14[02:08:46]:E:jobDBR: Errno 2 (No such file or directory) bdb_errno 213 (Transaction is started but not updated)
2007-07-14[02:08:46]:E:jobDBR: Log_mesg:
2007-07-14[02:08:46]:E:jobDBR: No definition in definition file for sopen(F_SRC:/bse_tmp/tmp004972818;/bse_tmp/tmp004972818;/bse_tmp//bse_tmp/tmp004972818, /bse_tmp//bse_tmp/tmp004972818)
2007-07-14[02:08:46]:E:jobDBR: ******* E N D of Error message *******

Some changes at database / application level has caused the query to run into loops resulting in this error .

There is no relation with permissions (error 213 and not 13)

hi Walter,

you can allways post the script :D
maybe that can give us a clue

(or mail it.....if you run the query for ages, I might have seen it before :rolleyes: )

Thanks for your response but it has been solved now.
It had something to do with rebuilding the Oracle statistics and some index beiing out of order. We managed to get hold of a consultant who managed to solve this.

(cbr of xjs ?)

xjs :D
cbr ?