Ajesh
15th June 2009, 16:30
Hi

I am trying to use bdbpost to import certain User and Authorizations related data. But i am getting this following error

ttaad200000 5 Can't lock table (error 505)
ttaad220000 2 Can't lock table (error 505)
ttaad230000 2 Can't lock table (error 505)
ttaad231000 2 Can't lock table (error 505)
ttaad430000 1 Can't lock table (error 505)
ttaad431000 1 Can't lock table (error 505)
ttaad432000 1 Can't lock table (error 505)
ttaad433000 1 Can't lock table (error 505)
ttaad434000 1 Can't lock table (error 505)
ttaad435000 1 Can't lock table (error 505)
tuxch910000 1 Can't lock table (error 505)

I have used the command

/eubaan02/app/bse/bin/bdbpost6.1 -t"^a" -I"/temp/tablist2" -O"/temp/output_501" -doracle -D/temp/dump501

Because of this above problem i used the export rows functionality, export from the source and import into the target. I later came to know that Convert to Run-time wouldnt work because there is a supposedly hidden flag in User Data which needs to be ticked and in case of populating records from the Back end that flag remains unticked.

Anybody has a solution how can i ensure that convert to run-time is done successfully?

ungerm
13th May 2010, 14:35
Hello,

i have the same problem - how did you resolved it? I tried all possible solutions and now I am gonna reinstal the server. :-(

Thanks

M.

shah_bs
14th May 2010, 03:14
Upload into Company 000 tables cannot be done when BAAN is running.

Never done this myself, so not sure if there is a procedure document somewhere that would explain how to do this.

I would first try by having EVERYBODY exit out of BAAN and then do the bdbpost. That should release locks on the tables you are trying to upload.

Should not be necessary to re-install BAAN - reinstallation will create its own new issues like getting the license key again and all related procedure.

Ajesh
14th May 2010, 05:16
I simply removed the Input parameters and rearranged the input variables.
It worked for me.

Something like this.

/eubaan01/app/bse/bin/bdbpost6.1 -pB40Uc4 -t"^a" -c000 -D/temp/custo_bdb_sp16 -O"/temp/err_bdb" -R -n