Dear All

We are on ERP Ln.6.1 FP5 and have one windows server for both the ERP

Application and Database and Licensing. Now we are required to change the

ip address of this server, in this connection what are the other changes that

we will need to carry out, to ensure that erp application/database runs

smoothly.


Thanks A Lot .

Hi,
In Baan IV or ERPLn, you can change IP address without any issue. The only thing you need to take care is while changing network interface card or something like that, which will require re-licensing.

At client side, if your users are using worktop to connect to ERPLn server and server name is provided as host name, you don't need to make any changes. If IP address is provided as host name, you need to change IP address in their BW configuration file.

Regards,
Vishal

In Baan IV or ERPLn, you can change IP address without any issue.
You do have to change the SLM info:

$ cat $BAANHOME/etc/servers.xml
<?xml version="1.0"?>
<cluster clusterName="SLMcluster" clusterId="3348793750" clientUpdate="no">
<servers version="1">
<server port="6005" id="111" IPaddress="10.1.1.1" host="srv1.baan.com" />
<server port="6005" id="222" IPaddress="10.1.1.2" host="srv2.baan.com" />
<server port="6005" id="333" IPaddress="10.1.1.3" host="srv3.baan.com" />
<server port="6005" id="444" IPaddress="10.1.1.4" host="srv4.baan.com" />
</servers>
</cluster>

You do have to change the SLM info:

not always.. only if your servers.xml has the IPAddress line. which not all of them have.

Dave

Hi

Thanks A Lot for the information. Now after changing the ip address , I get the following error message when I try to insert a record into the Enterprise units tables of Ln - Error SQLstate QP999 : No Server specified in table definitions or server cannot be started(error 505)

Please suggest could it be due to missing settings after changing ip address.

Thanks Once Again.

can you show me the content of the $BSE/lib/tabledef6.2 ??
i think there will be a problem...

Hi

The file contains the following data

*:*:msql7(MSQL_SERVERHOST=infor)

not sure wether something is wrong with this file

Can you please help.

Thanks A lot.

Does sql server host 'infor' point to right ip address or is it having proper subnet masks . Check the same.

Hi All,


Thanks a lot for your valuable inputs, the problem got resolved now. Indeed there were a few system files in which the old ip address was being referred to and this was creating the problem.

Many Thanks.

Regards.