jmendes
30th November 2011, 12:41
After moving BaaN to another server I can´t login on the new environment.
Here are the setup of both enviroments:
Old server New server
AIX 5.3 AIX 7.1
Informix 9.40 Informix 11.7
BaanIVc4 SP15 BaanIVc4 SP15
Porting set 6.1c.14 Porting set 6.1c.16
On the attache file please find two error messages: the first is the one I´ve got when I try to login via BW or ba6.1. The second one comes up when I´ve tryied to do a table dump on the new sever.
The steps I performed to migrate were:
1 - Copy $BSE from old server to the new one.
2 - Install a new portingset.
3 - Export of the database "unload to <tabe_name>.unl select * from <table_name>
4 - Import of the database "load from <tabe_name>.unl insert into <table_name>

Could anyone help me on this problem?
Thanks in advance.

vinceco252
30th November 2011, 17:08
It looks like the new Baan environment isn't set correctly to connect to Informix. I am not very familiar with Informix so I can't really advise on what the settings should be. I would review your $BSE/lib/tabledef6.1 file and the files in the $BSE/lib/inf directory to make sure they are referring to the correct locations/variables.

Also, based on your error message, I would google "informix 1829" to see what that error means.

Thanks,

Vince

jclju1
1st December 2011, 14:06
Check http://baanboard.com/baanboard/showthread.php?t=9628. Maybe you have to do same.

Homer-J-
5th December 2011, 15:54
are the user and the passwords also copied??
informix dont habe a own user administration. it tooks the user from the OS system. sho i think the group dosent exist.

another way: have you created the database (for exampel baandb) with dbaccess ?? you must grant also permissions to the database (for user specified at $BSE/lib/informix/ user and group)

jmendes
5th December 2011, 16:24
I´ve also copied the users and passwords from the old system.

As per Iconnect, it has not been installed when the installation of informix, but only after the error occurred. Could it be a problem?

nmolinaa
5th December 2011, 20:50
-can you use dbaccess with the user you're connecting to Baan?
-can you read any tables with that user?

If you're not the dba, you can always issue this command to test:
$BSE/bin/qptool6.1 -q"select * from ttaad200" -c000

Most likely, you will get a similar error. If you don't, this command should query the users table with the baan database driver.

I fear that for the error message you're obtaining, two things might need to be checked,

1) The encrypted password for the user ($BSE/lib/inf/inf_user)
2) In Informix, make sure the db_user to which your Baan user is linked exists as well as make sure the user has the appropriate roles assigned to it.

Best luck!

jmendes
6th December 2011, 11:33
I found the problem´s cause: a link to iconnect was missing. I defined it
lrwxrwxrwx 1 informix informix 18 05 Dez 18:35 server -> /informix/iconnect and now I´m able to access the database.

Thank you for you help.