Hi,

While installing BaaN IV c4 with Oracle 8i on Windows NT, during the final step, i.e, when the installer starts importing tools tables' we are encountering the error:

Can't lock table (error 1000)

and the loading of all the tables have been failed.

the user through which installation was done : baan which was created in Oracle database.

Can somebody through some light on this. How to avoid this error.

Thanks in advance.

Two things to check.

i) Is the logged in user authorised to use the database not only the baan user

ii) Does event manager give you any more information or even the log files.

RavensX,

Thanks for your reply.
This is the message in the event viewer:

Prog bdbpost file bdb_bdbpost.c $ $Revision: /main/bugfix6.1c/13 $ # 671
Keyword db_lock
Username baan type S language 2
Process 0xf1
Lasterror 0
Errno 0
bdberrno 1000 (bdb_errno 1000)
Message Can't lock table (error 1000)

Prog ora7_srv file ora_native.c $ $Revision: /main/bugfix6.1c/12 $ # 2084
Keyword Oracle Error
Username baan type S language 2
Process 0xcd
Lasterror 127 (The specified procedure could not be found.)
Errno 0
bdberrno 0
Message
dbs_errno = 0 Error 1000 occurred:
Error ORA-0 occurred during logon.

Error BDB-1000 returned.
Logon 'baan' as 'baan' failed; errno 0
Flushed at ora_driver.c $ $Revision: /main/bugfix6.1c/10 $ : #422.

To your first point:
The logged in user in NT is also baan who has full (dba) access to the underlying database.

As you observe in the event viewer message, this part:
Error BDB-1000 returned.
Logon 'baan' as 'baan' failed; errno 0

I dont clear get...whats wrong with it.

I've checked up the tabledef6.1 for tables assigning to the database.
All seem to be okay..

user 'baan' has DBA privilege with Admin option in the Oracle database.

Any suggestions ?!

Thanks in advance and have a good one!

One thing.. Check that the Oracle user / NT user / Baan user all have the same passwords!

All have same password.

I noticed that the error message is comming from
Prog ora7_srv file ora_native.c $ $Revision: /main/bugfix6.1c/12 $ # 2084

What Oracle version was selected during the installation of Baan? Seems like Baan is using the ora7_srv instead of the ora8_srv [?] to connect and this may explain your problems.

See the thread http://www.baanboard.com/baanboard/showthread.php?s=&threadid=9 for Oracle8 installations on NT/w2k

Warans,

Are you using the normal install wizard from the master cd?
Everything I read about supported Oracle versions (including on BaanBoard) is saying you cannot install 8i directly:

You first have to install Oracle8 and then upgrade to 8i.

Or am I wrong?
(Are there any (really) fresh new on this subject?)

Hi buddies...

Thanks all of you for your help...I've almost tried maximum my best to solve this problem...could not really crack it out.

Actually thinking of changing the database itself...

If anyone, meanwhile come across any solution...please do let me know.

Thanks,
Warans

Have a good one!

According to the error message it seems that the baan user has problems accessing the oracle db. Normally that means that the crypted password in ora_users is wrong.

A way to check that is by using qptool and try to retrieve some data that's already in the baan database (so in oracle)
I would suggest that you set the env. variable BDB_DEBUG also in order to have a trace file which gives you some more detailed info.

If the password is wrong than you have a problem because on NT you don't have the encrypt executable.

If it's related to Oracle8(i) you should check which driver is used an maybe the driver for the other version will work.

On the other hand, if it only an installation you can probably start fresh as well.

Han

Hi,

I think you need to check the version of the master cd. You might need the latest version.