Unable to configure repository in CMC

[Former Member]

Installed IPS SP5 and DS SP4 with SQL Anywhere on windows server 2012 R2. I created local repository in repository manager and configure the job server post installation but getting below error when trying to configure the repository in CMC.

Error- There is a problem to connect to repository.JZ006.IOException, java.net.UnknownHostexception:BI4_CMS_DSN

please find the screen shot

cmc-error.png

I am able to connect to SQL anywhere in ODBC data source with BI4_CMS_DSN and BI4_Audit_DSN.

[denis_konovalov]

BI4_CMS_DSN - is your CMS DB, not the repository for data services.
DS repository and CMS DB or BI Platform repository are 2 different things.

p.s.

Also, you should find the Data Services/Data Faderator tag, as this is not really BI Platform topic

[Former Member]

Hi Ritesh-

I am able to configure repository in CMC by giving hostname.

Thank you so much!!!

[former_member190982]

As the error suggest, its not abe to find the database server BI4.

Try,

1. IP address or localhost (if db installed locally) insetad of hostname.

2. If 1 does not work, try using the last option, USE DATASOURCE NAME - YES , you might create DSN and specify it here.

NOTE: In the screenshot , your database name is BI_CMS, if this is your CMS DB for IPS ,please create a new DB for Local DS reporsitroy . Using the same DB might corrupt you CMS DB of IPS system

Regards,

RVS

[Former Member]

Yes.. i run the repo manager.

[former_member185603]

Di you run the repository manager to create the repository before adding to CMC?

[Former Member]

Here i am trying to add DS repository in CMC to login Data service designer.

the details what i am giving to create repository is wrong? please elaborate to understand clearly.