Highlighted
Contributor.
Contributor.
217 views

Identity Reporting - IGA 3.5.1 - "auth_user_resource_v" does not exist

hello, when running some reports in identity reporting, errors of non existent tables are presented (attached example).

I would like to know if the identiy reporting in the IGA installation package presented the same error to anyone. Database Version - Oracle 12c

2 Replies
Highlighted
Micro Focus Expert
Micro Focus Expert

Re: Identity Reporting - IGA 3.5.1 - "auth_user_resource_v" does not exist

Greetings,

Please be aware that IGA is not a product but rather a suite of products that work together. The product itself is Identity Governance.

1)When you defined the external datasource in ID Reporting

a) What database did you point to?

b) What was the user ID that used?

2) Did you download the "additional downloads" zip file for the 'Current User Access' Report and execute the sql file for Oracle as outlined in the ReadMe.html within the zip? When you are on the Download page in ID Reporting on looking at the Download column, there are three (3) icons for this report. Going from left to right:

Download the generated .rpz
Download the source zip
Download the additional downloads (the icon looks like a magnifying glass)

When the 3rd icon is there, you must download this file and update your ID Gov schema/Database with the correct sql file for the Report to work correctly


*NOTE: This is the same for IDM as well*



Sincerely,
Steven Williams
Principal Enterprise Architect
Micro Focus

Highlighted
Contributor.
Contributor.

Re: Identity Reporting - IGA 3.5.1 - "auth_user_resource_v" does not exist

Steven, thanks for the support!
I am applying the indicated processes.
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.