Bogdan
16th August 2001, 09:40
Hi,

I installed BaaN IVc on Windows NT 4.0 with Oracle 8.0.5.

Everything seems to work fine except Tools. When I'm trying to launch sessions from this package (e.g. "Maintain sessions") I get the message "Package VRC unknown".

An other problem is that I can't login to BaaN with other users except user baan. I set up these users in Oracle and NT (applic, bsp, tools, root), but I get the error message "Error 514 (Security error; probably no permission) on ttadv002000 in db_first".

Thank you.

Best regards,
Bogdan

patvdv
16th August 2001, 09:57
Hi Bogdan,

Your 2 questions:

Unable to use tools sessions: package VRC unknown:

You have to setup a proper developer's profile for your user (baan, bsp) and assign a default package VRC to it (ttaad0140m000)

Unable to login: error 514:

This is an authentication error from Baan -> Oracle/Informix. You can check the $BSE/lib/ora/ora_users file first and make sure that all users have an entry and that the encrypted password = database user password

Otherwise I know that NT installations used to create a wrong baan group in $BSE/lib/ora/ora_groups (not baandb but baandbc or something like that). There are several cases on this topic on the Baan support website on how to fix this.

Ravenscross
16th August 2001, 11:20
Also with that info, you may have installed a patch that has effected the Tools VRC structure. If possible, run the 'Convert Tools to Run Time', just in case you have installed a new patch in the last few days.

A similar things once happened to me, but I lost the entire Utils module as well, took me 3 days to sort out. Absolute nightmare.

Bogdan
16th August 2001, 11:25
Hi,

Thank you for your help, but I can't run session ttaad0140m000 (it doesn't exist).

But in session "Maintain developer autorization by package VRC" ttadv0141m000 I have been inserted a record with user baan and package=tt, VRC=B40c1, authorizations for all modules and languages. No result.

I'll check BaaN support too.

Thank you again

Ravenscross
16th August 2001, 11:51
Have you done a convert to runtime for the user? Plus, check that the tools files are there in the directory structure.

Andy..
16th August 2001, 12:10
You have to set your current VRC, initially this is blank.
All the development/customisation sessions require a 'current VRC' before your can enter them

Can't remember the session code, but its under User Data - Developers data...

PS - if you only have standard Baan VRCs, you can't set them to be current! You get an error like 'no authorisation for standard', in that case you have to add a single temporary VRC and set that as current. Once you get in, then you can setup stuff properly.

Hope that's clear

Oh yes, error 514 must be due to not adding the database user, under Database administration - RDBMS admin - Link Baan to DB user (don't forget to conv to runtime)

patvdv
16th August 2001, 12:23
The session to use are:

ttadv0110m000: Maintain Development Parameters by User
ttadv0145m000: Maintain General Developers Authorizations
ttadv0141m000: Maintain Development Authorizations by Package VRC
ttadv0140m000: Change Current Package VRC of User

They can all be found under User management, developer's data

Sorry for giving you the wrong session code earlier.:o

Bogdan
16th August 2001, 13:17
Hi,

Thank you all for help.

I did set up the development parameters for users, I did convert to runtime and all.
But: few minutes ago I did a Check table and I found an error 512 on table ttiex188000.
Maybe because I tryied to import a tools patch and this action crashed. I try to do it again today but I got an error message (data dictonary corrupted).
Is there a possibility to reinstall only the Tools ?

Thank you again.

P.S. This site is realy cool ! Congratulations to webmasters and everybody else who build it !

Ravenscross
16th August 2001, 13:27
Okay, it is possible to recover the tools applications and modules, data is another problem (it depends on your database setup and backup solution)

Sadly, with a data dictionary corruption, a restore is one of the few ways to solve it without getting a consultant in there and looking at the problem first.

And yes, I have come across this problem and solved it, but it took ages and stopped the company working (due to the database solution installed).

This is one of the problems, the possibility has to be considered at install time.

It looks like during a patch of tools (always a problem), you suffered a crash or manually stopped the install. This has lead to a corruption of your tools module. No matter what you play about with here, you are sort of in a screwed situation.

Recovery has to be at a file level to start with, this involves recovery of the tt files and the dict files. Then a check has to be done on the table definintions to see if there is any problems there. If so, then you have to recover your 000 table. Unless this has been saved as a seperate file (ie seperate instances, data dump or other) the you will have to recover the whole of your data for this. This means that any work done since the backup you are recovering is lost. Okay, you can dump the company as it stands but an average idea of how long this kind of work is about 3 - 4 DAYS... Its a lot of prep and work and should only be done by an experience consultant if you have any worries about doing it yourself

Gerhard
16th August 2001, 13:44
Originally posted by Bogdan
Hi,

Thank you all for help.

I did set up the development parameters for users, I did convert to runtime and all.
But: few minutes ago I did a Check table and I found an error 512 on table ttiex188000.
Maybe because I tryied to import a tools patch and this action crashed. I try to do it again today but I got an error message (data dictonary corrupted).
Is there a possibility to reinstall only the Tools ?

Thank you again.

P.S. This site is realy cool ! Congratulations to webmasters and everybody else who build it !

Bogdan,

check whether you find a file $BSE/tools/dd/dttiex/dttiex188.old.
If yes, rename the dttiex188 to dttiex188.new and dttiex188.old to dttiex188 and try to access the table f.e. by ttaad4100. If that is successfull run the command bdbreconfig6.1 -R -nmi -Nttiex188 -C 000 . When this is finished, rename the dttiex188 to dttiex188.old and dttiex188.new to dttiex188. That's it.

phoenix
17th August 2001, 12:59
As this command has to be used also in case of
an error during a reorg you should read the additional information carefully.

Please always make a copy of that file you would
like to recover by using this command!

Bogdan
17th August 2001, 14:54
Thank you very very much ! It's working !! There still some errors but for now it's O.K.
Thank you again to everybody