We receive following error messege for the reprinting manual invoices.

2007-08-17[21:48:39(UTC-08:00)]:E:wathare: Pid 1330 Uid 300 Euid 300 Gid 125 Egid 125 Pset Administrator@HPTECHNICAL:948
2007-08-17[21:48:39(UTC-08:00)]:E:wathare: user_type S language 2 user_name wathare tty ote locale ISO88591/NULL
2007-08-17[21:48:39(UTC-08:00)]:E:wathare: Errno 0 bdb_errno 506 (Table does not exist)
2007-08-17[21:48:39(UTC-08:00)]:E:wathare: Log_mesg: Error 506 (Table does not exist) on select
2007-08-17[21:48:39(UTC-08:00)]:E:wathare: ******* E N D of Error message *******
2007-08-17[21:48:39(UTC-08:00)]:E:wathare:
2007-08-17[21:48:39(UTC-08:00)]:E:wathare: ******* S T A R T of Error message *******
2007-08-17[21:48:39(UTC-08:00)]:E:wathare: Log message called from /view/port.7.1d.05/vobs/tt/mir/mir/mul_fun.c: #461 keyword: Proce
ss state:


Please can anyone explain more regarding this error.

The error message as such is pretty clear:

The session is trying to access a tables, which does not exist. This might have several reasons:

a) You are working in the wrong company
b) Yopu are working with the wrong package combination
c) Somebody changed the session, but did not create the table.

The annoying bit is, that the log does not tell you which table is missing. This is getting already on my nerves for many years. To find out, which table is missing, you might find something in log.oracle8 or log.ora.sql , if you are lucky. Otherwise you have to enable some tracing. Search for DBSLOG here on the forum to find out how.

Regards

Markus