Skip to Content
0

Unable to configure repository in CMC

Mar 03, 2017 at 02:06 AM

154

avatar image

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.

cmc-error.png (91.1 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

6 Answers

Denis Konovalov
Mar 03, 2017 at 06:45 PM
1

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

Share
10 |10000 characters needed characters left characters exceeded
Jawahar Konduru Mar 06, 2017 at 02:32 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Khaleel P Mar 06, 2017 at 03:04 AM
0

Yes.. i run the repo manager.

Share
10 |10000 characters needed characters left characters exceeded
Khaleel P Mar 06, 2017 at 02:18 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Ritesh sharma Mar 06, 2017 at 08:03 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Khaleel P Mar 07, 2017 at 07:18 AM
0

Hi Ritesh-

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

Thank you so much!!!

Share
10 |10000 characters needed characters left characters exceeded