abattoir
31st August 2009, 15:00
Hi

The Problem that i am facing is that i am unable to log into Server with none of the users with the following error getting captured in the Event Viewer.

Error Captured With "Baan" as User.

BdbErrno : 506 (Table does not exist)
ExtraInfo : session: "ottstpstdlib ";object: "ottstpstdlib"; company number: 90
query: "select ttadv112._index1, ttadv450.mess, ttadv450.expi,
ttadv450.za_mtyp, ttadv450.txtc, ttadv450.zb_mqst
from ttadv112, ttadv450
where ttadv112._index1 = {:curr.pacc$, :1} and
ttadv450._index1 = {:clan, :1, :2, ttadv112.vers,
ttadv112.rele, ttadv112.cust}
order by ttadv112._index1
as set with 1 rows
"
Message : FATAL ERROR: Error 506 (Table does not exist) on select
Can not continue in ottstpstdlib (find.message.new)[sql.exec]

All the Above Tables are 000 Companies table So I am not able to figure out why is it asking for these tables to be present in Company 090 or for that matter in the Company Attached To the User.

AnyHelp Whatsoever Will Be highly Appreciated.

DSchneider
1st September 2009, 09:47
What exact Version of ERP LN are you using? Is it a new installation, that means, was it running some times before?

Regards
Daniel

wiggum
1st September 2009, 14:22
Baan always reads data from your current company if you don't give another company number to read from. If you want to read from company 000 add "and ttadv112._compnr = 000 and ttadv450._compnr = 000" to the where-clause of your select-statement.