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?
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?
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
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
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:
<rdbms>Generic ODBC datasource</rdbms>
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.
Aaron ArmagostPrincipal Support Engineer, CA Privileged Identity Manager