CMC Error: Failed to Retrieve cluster name from Database

[Former Member]

Hi All,

Iam getting this error message when Iam checking the properties of CMC.

BOXI Server intelligence Agent is running status . but no server is running.

In CCM , SIA Configuaration tab showing this error message

"Failed to Retrieve cluster name from Database"

Iam unable to change the cluster name of Server Intelligence AGent.

Please help us.

Thanks in advance..

[Former Member · Accepted solution]

Hi,

Did you check you firewalls settings to open comm ports for BO XI ?

You can also try to look into the Logging folder to see if a logfile has a more explicit error.

Samuel.

[Former Member]

Hello,

in my installaiton this helps:

Andreas

[Former Member]

I got the same issue fixed with click here

[christian_key2]

Hi,

I had this issue in BI 4.1 SP5 and SAP note 1711203 resolved it for me.

Chris

[Former Member]

I am Running BO4 SP5 (Patch 5)

I got the Failed to Retrieve cluster name from Database form the SIA

the CMS also cannot start.

Event viewer show CMS have the error "

 

The root server reported an error Initialization Failure.

On the logging folder, CMS show the following errors

LOG Q0I=> NiPGetHostByName: '$SMDAgentHost' not found: getaddrinfo [ninti.c 895]

ERROR => Main agent failed to be initilized due to incorrect host setting! [ncsmtdatasen 20]

- I think this is because I install the Oracle 11G 32bit client on the server

to resolve it, I use SAP NOTE : 1711203

I hope this will help someone

[DayaJha]

Hi Vincent,

If the CMS service won't start and there are one or both of the following error messages in the Event Viewer, it's most likely that you have a firewall somewhere that is blocking your traffic.

• BusinessObjects_CMS: The root server reported an error Initialization Failure.
• BusinessObjects_CMS: Failed to connect to name server XXXXXXX. Reason: Transport error: unable to retrieve the CMS factory.

Solution:

Adjust the firewall settings

Or

Please refer the below SNotes From SAP Market Place

1393747 - CCM error "Failed to retrieve cluster name from the database. Reason: BusinessObjects Enterprise CMS: Unable to connect to the CMS system database"

Links:
https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F6465...

1711203 - Error: "Failed to retrieve the cluster name from the database. Reason: Parser failed to initialize" on Configuration tab in SIA in BI 4.0

Links:

https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F6465...

Hope this will help you as well.

Thanks,

Daya

[Former Member]

hi, I agree firewall can cause CMS issues,

in my case it is not firewall issue. 

Once I apply the solution from SAP NOTE : 1711203

everything is working

[DayaJha]

Hi Vincent,

If your Query is resolved, then please close the thread.

Thanks,

Daya