We are on Baan IVc4 NT SQL SErver 7

I am getting error 506 (table doesn't exist) on ttadv002000 and unable to login. What can be the reason?

how to use bdbpost on NT

I gave bdbpost -m -n -I -c000 E:\baandump\comp00.pre but this is not working

Regards,
Srinivas

Hi Srinivas,

The table ttadv002 is the table for the BaaN Tools Parameters,
which has the current BaaN Tools installation's VRC, an encrypted
password and a date (I guess an expiration date). You can view the
contents from the DBA studio etc but you cannot break the codes there.

This table is created during the installation process.

If this table is not created/loaded you cannot start BaaN,
as most of the standard sessions as well as the standard program have
the checks built-in from -


--------------------------------------------------------------------------------
Library ttdllintegra
Integration
(5 Functions available)
--------------------------------------------------------------------------------
This dll tests if a package has integration with the current package version.
It returns a boolean variable and the release tree of the package (according
to current package version)
input: cpac
output: return value (0 = no integration/1 = integration)
adv111 record
--------------------------------------------------------------------------------
Function Summary
long iadv0007.integration( domain ttadv.cpac cpac )

long iadv0007.integration.including.tt( domain ttadv.cpac cpac )

long iadv0007.pvrc.in.pvrc( domain ttadv.cpac component.cpac,
domain ttadv.vers component.vers,
domain ttadv.rele component.rele,
domain ttadv.cust component.cust,
domain ttadv.cpac current.cpac,
domain ttadv.vers current.vers,
domain ttadv.rele current.rele,
domain ttadv.cust current.cust )

long integration.on.runtime( domain ttadv.cpac cpac )

long integration.on.runtime.no.reload( domain ttadv.cpac cpac )

Thanks Prashant.

Since the table is no longer there, I wanted to create it through bdbpost and I gave this command

bdbpost -m -n -IE:\comp000.pre -c000

But it is not working. What should I do?
How can I create baan tables using comp000.pre and bdbpost in NT.

Regards,
Srinivas

fnds,

1) Would you know if this table is used for what purpose (bcos everytime during logging-in this seems the first table that is read in baan. It always reflects as an error in this table on a license error or a permission error etc..)

2) It has a password field namely "pswd".

whenever there is a problem with this table (license not patched or something) baan never logs-in to carry-out possible repair work from with-in baan like Patch objects after system crash etc..

appreciate your input, tks

Vish

fnds,

1) Would you know if this table is used for what purpose (bcos everytime during logging-in this seems the first table that is read in baan. It always reflects as an error in this table on a license error or a permission error etc..)

2) It has a password field namely "pswd". Any idea what this password is used for.

whenever there is a problem with this table (license not patched or something) baan never logs-in to carry-out possible repair work from with-in baan like Patch objects after system crash etc..

Appreciate your input, tks

Vish

Could anyone shed more light into the functioning of table ttadv002?

Task Undertaken:
I copied the BSE from a live server to a standby server(Which had baan and sql installed to the same spec and sps as the live server) that wasnt connected to the network. Changed the name as well as the IP of the standby server to the same as the live one. As a final step, i restored the SQL backup of the live on the standby. All this was done while the baan services were down on the standby.
Problem:
After the sql restore, i fired up the services and pressed the all important [Connect] button to log into baan and i get "Record doesnt exist in ttadv002000.." error.

I know this much that i might have got a message that my baan is not licensed and it will work for few days...once i fired up baan but record doesnt exist wasnt in my "to expect" list..

So could anyone tell me why would i get this message and the all important function of table ttadv002?

sk

Come on...Anyone??

sk