Hi all,

I am trying to create sequential dump of tiitm001 table through the bdbpre utility but getting error 'Can't lock table error 505'.

I am using following command :

bdbpre -dM -Ntiitm001 -C101

Can anybody help. It would be greate if anyone can post help on bdbpre and bdbpost with examples.

Thanks in advance,
Vishal Mistry

If you using this on windows you need to work on the console (or use the console flag for terminal server client).

Regards,
Han

Hi Han,

I am unable to get ur point. Could you please be more elaborate.

Vishal

We're on 5.0c but it should be pretty similar.
You might need to "set USER=baan" from the commandline before doing bdbpre.
You can run bdbpre -U for the usage information. Same for bdbpost.

The following works for us, let me know

C:\BaanIVc4\bin\bdbpre -p TPS2 -I C:\tableList -t "^I" -o C:\DataDump -E C:\errdn -C 100

errdn - error file
tablelist - contains list of tables to be exported
-t parameter for delimeter

If you want to connect to the console, use mstsc /v:<Baan server hostname or IP> /console, log in as baan super user

Vishal,

Check if the company is properly setup.

Also refer to the Tools Programmer's manual for the error codes.

SSA ERP LN 6.1 Programmers Guide

505 ENOSERVER - XXXXXXXX
--------------------------------------------------------------------------------
Description:
This error can indicate that:
The virtual machine cannot find information about a table's database.
The server cannot be started.
For more information, see the log file.
Solution:
Start the Tables by Database (ttaad4111m000) session to check whether the database is specified for the table that caused the problem. If the table is not specified for the database, add the table to the database and convert the table to the runtime datadictionary.

Why are you specifying "-d" in your command line?

Dave