Data services - invalid CMS connection information

[Former Member]

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

[former_member136842 · Accepted solution]

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.

[Former Member · Accepted solution]

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.

[Former Member · Accepted solution]

Hi Bill ,

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

Thanks,

Rajiv

[Former Member · Accepted solution]

Hi Seb,

Username and Password/server details  looks fine.

Thanks,

Rajiv

[former_member136842 · Accepted solution]

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.

[Former Member · Accepted solution]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

Hi Bill,

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

Thanks,

Visshwas

[Former Member]

Good news - can you mark the question as answered?

Thanks,

Bill