Hi @ all!

We have installed an new Baan Server on a sun primepower. Informix Dynamic Server Version 9.21 UC4 we are using to store the data. The Tool-Tables instead are using the Bisam-Database. Login into Baan is possible. Session can also be started. But if we want to create a Table with "ttaad4230m000" it doesn´t work. Under $BSE/log/log.informix we found the Error Code 387.

Can anybody help us???

Bye,

Foster

I am not sure about the error code but a typical problem when creating tables while normal sessions work is a mismatch of the 'baan' group user's password in the $BSE/lib/inf_groups and the actual password of the database user 'baan' in informix.

Reset the password of the database user first, then use the $BSE/bin/inf_admin6.1 utility to update the $BSE/lib/inf_groups file.

I think this error is telling you that the user does not have connect permission. Contact your Database administrator and make sure connect permission is granted for the database user that the baan login is using.

Thanks for your answers!

The inf_groups, inf_users and inf_storage are alright. that we have often checked. The change of the password has no effect.

Connect to Informix - dbaccess (I think you must be user informix on OS) and execute command:
grant resource to username
for Baan user. I hope it will help.

That we have also tested. Instead we have given the user DBA rights but it doesn´t work. Even if i want to create a table the error "Cannot create table ttccom010 (error 26572)" appeared in the Baan Session. In the error log you find then the informix error code 387.

Informix error 25572 (26572 –1000) means »Network driver cannot bind a name to the port«. It could be something wrong with port name or database server name. Check the file sqlhosts.
Maybe you can get error explanation with: finderr 25572.

These are our entries in the sqlhosts:

ol_wibro ontlitcp primepower turbo m=1

In /etc/services the port 1526/tcp is set for turbo. Also i can make an odbc-connection to the database. Only Baan makes trouble. In the onconfig i have also made the entry NETTYPE sqlmux. But these has no effect to the error.

There are two Unix variables, INFORMIXSERVER and INFORMIXDIR. Are this variables set? This information must be in tabledef6.1 or Unix variable must be set.

This is an entry from our tabledef6.1:

*:*:informix(INFORMIXDIR=/informix,INFORMIXSERVER=ol_wibro,ONCONFIG=onconfig):N

And this are the settings in /etc/profile:

INFORMIXDIR=/informix
INFORMIXSERVER=ol_wibro
ONCONFIG=onconfig
SQLEXEC=/informix/lib/sqlrm
INFORMIXSQLHOSTS=/informix/etc/sqlhosts
DBMONEY=.
export INFORMIXDIR INFORMIXSERVER ONCONFIG SQLEXEC DBMONEY INFORMIXSQLHOSTS

The variables must be correct.