hi all
when i maintain job for 'any update session' in my baan it gives error
"error 506 (table does not exist) on ttaad502000 in db_insert"
any solutions....
how to create table...
regards
gaurav

Gaurav,

from the screen shot it seems like you are trying to add process/update session for non-tt package in the company-000 and naturally those packages's tables are not created in the company-000 hence you are getting the error.

The jobs are company specific so you need to change to the appropriate company, then open the job data sessions and add those functional sessions into the job.

I hope you have created tables related to those packages in that company.

hi Prashanth

i am automating the backup procedure. i am making job for "create sequential dump of tables".that time i am getting this error.
regards
Gaurav

If you want to create a backup job, perhaps you find it helpful to know what we do here:
1) Create a List of all Tables (of all companies),
bdbpre6.1 -Nttadv130 -o. -t"|" -C000 should give you a file that you can extract the names from (use for example awk, then sort -u [field5="3" ==> field1+field5=tablename])
Now you have a file (let's call it tabnam) that contains every possible tablename)
2) for each company do the following:
bdbpre6.1 -Itabnam -ODESTINATIONFILE -pPACKAGECOMB -CCOMPANYNUMBER
This is very fast, can be parallized plus you can even build subsets of the tables that you create seq. Files for.

Feel free to ask me more
(now@niederrhein.de)

hth

Norbert

I seem to remember this table being introduced in one of the service packs maybe 7 or 8. Part of the sp install was to create this table in each company as the tt tables for jobs are stored in each company. use the create table session or GTM to create the table and the problem should go away.

Norwim

I think you mean ttadv420 not ttadv130.

If you are using NT the following scripts can be used


bdbpre -Nttadv420 -t"|" -C000


for /f "skip=2 tokens=1,2,3 delims=|. " %%i in (d:\baan\bin\tttadv420000.S) do echo %%i%%j%%k>> c:\temp.txt
d:\baan\bin\sort.exe -u c:\temp.txt > c:\backup\tables.100



bdbpre -I c:\backup\tables.100 -E c:\backup\backup.err -p OPER_001 -C 100 > c:\backup\comp100.100