Skip to Content
avatar image
Former Member

Unable to configure repository in CMC

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Mar 03, 2017 at 06:45 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 06, 2017 at 02:32 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 06, 2017 at 03:04 AM

    Yes.. i run the repo manager.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 06, 2017 at 02:18 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 06, 2017 at 08:03 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 07, 2017 at 07:18 AM

    Hi Ritesh-

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

    Thank you so much!!!

    Add comment
    10|10000 characters needed characters exceeded