IPS Installation

[Former Member]

I have an error stating that "CMS is not part of cluster" after few days after a successful Installation of IPS .I have checked with the System DSN which is working fine.When the CMS service is connecting to database there has been an error. Please find below hardware and software prerequisites

IPS 4.1 SP4

IPS  SP5 Patch

Hardware 

Windows 2012 64 bit

SQL server management studio 2012 32 bit

Databases are created on SQL Server 2008.

Note: Initially the Installation  has been successful,after few days the CMS has been down giving the above error.

[DayaJha]

Hi Keerthi,

For debugging the issue please share CMS log file.

Path where trace log file of Server Intelligence Agent in

<Install-DIR>\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.x\logging directory named as SIA_nodename_trace.glf.

Thanks,

Daya

[Former Member]

Could you suggest what to check in the .glf file?

[Former Member]

Hi Keerthi,

It looks like there is some issue with CMS system database connectivity. CMS is unable to conect to CMS database for some reason. Could you please check :

1. CMS database connection using DSN and make sure the DSN is 64 bit
2. Network connection and ports between IPS server and SQL Server
3. If you are using Windows authentication for DSN then make sure the Windows account has full rights on database.
4. Check Windows Event Viewer->Application logs and let us know the error messages.

Regards,

Hrishikesh