Question Re: Data services - invalid CMS connection information in Technology Q&A

Data services - invalid CMS connection information

Former Member — Tue, 04 Mar 2014 11:47:37 GMT

Hi,

I am installing Data services 4.1 on one server and trying to connect cms which is another server.

When i enter the username and password of the cms server during the installation. i get the below error.

"you cannot proceed as the following has failed validation :invalid CMS connection information.

Please check the CMS connection inforamtion."

Please help.

Thanks,

Rajiv

Re: Data services - invalid CMS connection information

former_member136842 — Tue, 04 Mar 2014 12:29:53 GMT

Hi,

well first of all check if the information are correct. Any typos in Server name, username or password?

As a second step try to ping the BI Server from the DS Server by Name, FQDN and IP- Adress.

Regards

-Seb.

Re: Data services - invalid CMS connection information

Former Member — Tue, 04 Mar 2014 12:47:59 GMT

Also try and telnet to port 6400 from the DS machine to the CMS machine - that will check that the port is open.

If you have a multi-homed machine (more than 1 IP address/ network interface) then you need to make sure that the CMS is listening on the right IP address.

Re: Data services - invalid CMS connection information

Former Member — Tue, 04 Mar 2014 14:12:37 GMT

Hi Bill ,

I am able to telnet the cms server on port 6400 .

Thanks,

Rajiv

Re: Data services - invalid CMS connection information

Former Member — Tue, 04 Mar 2014 14:13:40 GMT

Hi Seb,

Username and Password/server details looks fine.

Thanks,

Rajiv

Re: Data services - invalid CMS connection information

former_member136842 — Tue, 04 Mar 2014 14:44:59 GMT

Hi,

then i would recommend you add each of the hosts into the hosts.sam file inside the Windows Directory. Do this on the DS Host and on the BI Host.

Add them with IP, Hostname and FQDN.

Regards

-Seb.

Re: Data services - invalid CMS connection information

Former Member — Tue, 04 Mar 2014 21:36:22 GMT

Is this a single CMS or is it clustered? Do you have any firewalls between DS server and CMS server(s)?

Verify that the hostname you are using resolves to the correct IP address (or use IP address in the DS setup - should be a temporary measure as really you should be using hostname or FQDN) - unlikely as you have telnetted to 6400.

If you're really stuck an it's a Windows machine you can temporarily install one of the BI4 client tools and see if that can log in.

I'm guessing that the CMS is part of a supported BI4 or IPS platform.

What do the DS install logs say? Is auditing enabled on the BI4/IPS side - if not enable it to audit login information and check that the BI4/IPS is registering.

Re: Data services - invalid CMS connection information

Former Member — Thu, 27 Mar 2014 07:40:51 GMT

Hello,

The issue was resolved by imnplementing the note 1682686.

In the next screen, it is asking for the local repository connection

Repository name for CMS registry:

Oracle Db connection name:

Db server name:

Database port:

SID

USer id:

Pwd:

I get an error

You cannot proceed because the following has failed validation:

Invalid Data Services Repository Connection information

BODI-320006:cannot open connection to the repository.The error mesage from the

underlying DBMS is <OCI call<OCIServerAttach> for connection <YYY> failed:

<ORA -12154:TNS:could not resolve the connect identifier specified>.

The db server is on a seperate host.

Thanks,

Rajiv

Re: Data services - invalid CMS connection information

Former Member — Thu, 27 Mar 2014 09:14:51 GMT

The error message is an Oracle middleware error:

ORA -12154:TNS:could not resolve the connect identifier specified

Either you have specified an incorrect SID or the TNS is not set up correctly.

Re: Data services - invalid CMS connection information

Former Member — Mon, 14 Apr 2014 08:38:28 GMT

Hi Bill,

The issue was resolved.The listener file had wrong entires.

Thanks,

Visshwas

Re: Data services - invalid CMS connection information

Former Member — Mon, 14 Apr 2014 09:19:44 GMT

Good news - can you mark the question as answered?

Thanks,

Bill