Dear All,

I am trying to install BAAN 50.c in Oracle Enterprise Linux ver 5. with database Oracle Db 11g.

But I have a problem when installing baan (Running BW) thats error show up "Error 514 during creating table ttaad000"

Has anyone resolve this problem i need suggestion to resolve this.

thanks & regards,

Iwan

Check portingset, does your version support Oracle 11g. Did you create database users? Check files $BSE/lib/ora/ora_groups and $BSE/lib/ora/ora_users.

try using a new installer with a erpln portingset

514 error means your group user for the database cannot log in to the database. Most likely, the encrypted password in $BSE/lib/db/db_groups is out of sync with the password that is set at the database level.

If you can log in at the database level with your group user, e.g., baandb; then use the $BSE/bin/encrypt6.2 to encrypt that password.

For instance if the password is P4$$w0rd you would issue the following command
# encrypt6.2 P4$$w0rd

that in return will give you a string you can place in $BSE/lib/db/db_groups
like so:

baandb:JL2#4%)('[asdfkLnda12klK}}

then save that password.

Once you know it works also do not forget to type that string via GTM in ttdba020 Database Group Password for the group user because otherwise, next time you do a convert to run time you will corrupt the $BSE/lib/db/db_groups

(This whole time I've referred to the groups file as $BSE/lib/db/db_groups, replace the leters db with your database, ora for oracle, inf for informix, sql for Microsoft SQL and so forth)

Basically, the reason why you obtain the 514 is all users should have a database user. However, none have permissions to perform any alter operations at the database level. The only database user that is authorized to perform add, remove, modify actions at the database level is the group user which you can see is linked to all the database users. So, this explains why you can log in because for logging in, the ERP uses the database user to authenticate that new connection but and all users have access to read but that is it. When it comes to make a change like creating a table if the group user cannot log in then you will get a 514 error.

Of course, the problem could be something else but in my experience this is the most common reason and solution to this message given the situation.

Cheers!

Sorry I said, sql for Microsoft SQL, it is msql.

Cheers!

Dears,

I'm using Portingset 8.2b and database Oracle 10g

With user system and database group baan

THanks,

Iwan