errors on SRM after new CABI install "Unable to render HTML for parameter"......

Document ID : KB000046133
Last Modified Date : 14/02/2018
Show Technical Document Details

Symptoms:

after installing CABI and successfully testing the integration on the OC web page, we cannot run reports and get the following errors 

"Unable to render HTML for parameter "WKP_AlarmActivityUSers". 

"Unable to render HTML for parameter "WKP_CustomLogo" 

 

In the CABI customparams.log, we found a connection error as follows:

Program Files\CA\SC\CommonReporting3\Tomcat7\logs\

 

2016-07-19 11:19:04,630 [http-8080-3] ERROR com.ca.spectrum.repmgr.parameters.CustomLogoSelector () 5335888176 - Unable to render parameter's HTML. 

Name: WKP_CustomLogo 

Type: com.ca.spectrum.repmgr.parameters.CustomLogoSelector 

Report Name:   org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure 

 

This indicates that we can't connect to mysql on the SRM server from the CABI server.

Trying is to telnet to port 3306 from the CABI system to the SRM fails to remain open.

 

 

Environment: 

OneClick/ReportManager - Solaris 10 OS. 

CABI 3.3 SP1 windows 2008 SP2 (64-bit) 

no firewall between 

CMS port is 6400 

BO tomcat 8080 

SIA 6410 

 

 

Cause:

 

There are various causes for these errors and one is  that the OS host file was not populated correctly or has become corrupted. 

 

 

Resolution:

The /etc/hosts files needs to be populated on the CABI server before installation as a prerequisite or it will fail. 

Your server host IP should be properly configured in /etc/hosts file so that there is no IP resolution problem.

You should check /etc/hosts before running the installation. The follow entries should occur once:

IP-Address Full-Qualified-Hostname Short-Hostname

For example, if the hostname is abc0008, the domain is myhost.com, and the IP is 141.0.0.0, the following entries display:

141.0.0.0 abc0008.myhost.com abc0008

127.0.0.1 localhost.myhost.com localhost

Ensure there are no duplicate entries for each of the host names. Once you have configured the file, restart the network.

Important! If /etc/hosts is not configured properly, the installation fails.

When installing BusinessObjects Enterprise on multiple computers, ensure that each target computer is able to communicate over TCP/IP with the computer that is running as your Central Management Server (CMS).

Note: If you are installing BusinessObjects Enterprise in a firewall environment, you must be aware of additional configuration details.

 

 

Additional Information:  

http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec566204.aspx 

 http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec561661.aspx