Layer7 Privileged Access Management

Expand all | Collapse all

I can´t get a report from CABI

Jump to Best Answer
  • 1.  I can´t get a report from CABI

    Posted 05-05-2016 01:39 PM

    I have installed CA PIM on windows server 2012 R2 and SQL server 2012 standard, on same server I am installing CA BI 4.x  and I have configurate to get a report from Enterprise Management Console, but when I view a report I received this error "failed to open connect" y can't view report, any idea?

     

    Regards

     

    Enrique



  • 2.  Re: I can´t get a report from CABI

    Posted 05-06-2016 09:51 AM


  • 3.  Re: I can´t get a report from CABI

    Posted 05-09-2016 09:45 AM

    Hello DS10,

    Can you please confirm if all the steps provided in the documentation were followed?

    Also if you have enabled the IDM Management console, you can check / verify the DB connection for the CABI as well from there, what is the result you get over there?

    Thanks,

    Reatesh.



  • 4.  Re: I can´t get a report from CABI

    Posted 05-09-2016 11:39 AM

    Hi Reatesh  thanks for you response

     

    Yes, I followed the steps provided in the documentation.

     

    Also, I could enable the IDM Managment Console and the test of connection was succesfully

     

    the probblem is when I see the report from Enterprise Management Console PIM

     

    Regards

     

    Enrique



  • 5.  Re: I can´t get a report from CABI

    Posted 05-10-2016 06:15 AM

    Hi Enrique,

    Can you verify the connection to the DB from CABI universe itself?

    Also can you share a screen shot of the error message, looks like we might have had such error messages in the past too being reported while trying to pull out a report.

    - Confirm the following as well

    a) Capture snapshot was successful

    b) You have generated the report properly

    c) Are you able to view the same report from CABI console itself

    d) Can you try a different browser as well

    Thanks,

    Reatesh.



  • 6.  Re: I can´t get a report from CABI
    Best Answer

    Posted 05-16-2016 07:28 AM

    Enrique Suarez del Real,

     

    I have found that setting up the database connection using ODBC works best. I learned that CA BI 4.1 works best if you create both a 32bit and 64bit ODBC connection named the same.

     

    Example XML File:

     

    <biar-file name="C:/Users/Administrator/Desktop/ReportPackages/MSSQL/CA_Privileged_Identity_Manager_MSSQL.biar">

      <networklayer>ODBC</networklayer>

      <rdbms>Generic ODBC datasource</rdbms>

      <username>ACDBO</username>                                                

      <password>P@SSWORD</password>

      <datasource>ODBC_CONNECTION_NAME</datasource>

      <server> </server>

      </biar-file>

     

    The server line can list the server or be a space. It cannot be blank as the biconfig.bat will error but this field is not used on import.

     

    Thanks,

     

    Aaron Armagost
    Principal Support Engineer, CA Privileged Identity Manager