Knowledge Partner
Knowledge Partner
1124 views

Identity Reporting AR data source

Hello,

Trying to configure Identity Reporting for Access Review (Same Reporting
Module that is already configured for IDM).

I have added a new data source which I call 'arops' that points to the
PostgreSQL AR database using the database 'arops' and username 'arops'.
(I have also tested with the 'arrptuser' with the same result)

'Test Connection' works fine.

I have stopped Tomcat, deleted the content of tomcat/temp and
tomcat/work directories.

But I can't get the reports to work, the log tells me that the database
"arops" does not exist when I run the 'Database Statistics for Access
Review' report.

Using pgAdmin I can access the database as the 'arops' user just fine.

From catalina.out:

2016-03-10 11:30:53,813 [pool-4-thread-2] INFO
com.novell.idm.rpt.core.server.schedules.ReportManagerImpl- [RPT-CORE]
Rapporten har skapats (körs snart) f8a73450-001b-42b1-8773-d6343fed91f4.
2016-03-10 11:30:53,847 [pool-4-thread-2] INFO
com.novell.idm.rpt.core.server.rest.OsgiBridge- [RPT-CORE] Kör rapporten
'Database_Statistics_for_Access_Review'.
2016-03-10 11:30:53,960 [pool-4-thread-2] ERROR
com.novell.idm.rpt.core.server.rest.OsgiBridge- [RPT-CORE] Följande fel
påträffades vid försök att köra rapporten
'Database_Statistics_for_Access_Review': An error was detected while
running report 'Database_Statistics_for_Access_Review':
net.sf.jasperreports.engine.JRException: Error executing SQL statement
for : table_size. ERROR: database "arops" does not exist
2016-03-10 11:30:53,961 [pool-4-thread-2] ERROR
com.novell.idm.rpt.core.server.schedules.ScheduleManagerImpl- [RPT-CORE]
Följande fel påträffades vid försök att köra rapporten 'Database
Statistics for Access Review - 3/10/2016 11:30 AM': An error was
detected while running report 'Database_Statistics_for_Access_Review':
net.sf.jasperreports.engine.JRException: Error executing SQL statement
for : table_size. ERROR: database "arops" does not exist
com.netiq.common.i18n.LocalizedException: The following error was
encountered when attempting to run report 'Database Statistics for
Access Review - 3/10/2016 11:30 AM': An error was detected while running
report 'Database_Statistics_for_Access_Review':
net.sf.jasperreports.engine.JRException: Error executing SQL statement
for : table_size. ERROR: database "arops" does not exist
at
com.novell.idm.rpt.core.server.schedules.ScheduleManagerImpl$ReportTask.runJasper(ScheduleManagerImpl.java:155)
at
com.novell.idm.rpt.core.server.schedules.ScheduleManagerImpl$ReportTask.runAndUpdateReport(ScheduleManagerImpl.java:285)
at
com.novell.idm.rpt.core.server.schedules.ScheduleManagerImpl$ReportTask.call(ScheduleManagerImpl.java:258)
at
com.novell.idm.rpt.core.server.schedules.ScheduleManagerImpl$ReportTask.call(ScheduleManagerImpl.java:90)
at java.util.concurrent.FutureTask.run(Unknown Source)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown
Source)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown
Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
Source)
at java.lang.Thread.run(Unknown Source)
2016-03-10 11:30:53,961 [pool-4-thread-2] ERROR
com.novell.idm.rpt.core.server.schedules.ScheduleManagerImpl- [RPT-CORE]
Körningen av JasperReports misslyckades.
2016-03-10 11:30:53,965 [pool-4-thread-2] INFO
com.novell.idm.rpt.core.server.schedules.ReportManagerImpl- [RPT-CORE]
Rapporten har uppdaterats (slutförts) f8a73450-001b-42b1-8773-d6343fed91f4.


0 Likes
3 Replies
Anonymous_User Absent Member.
Absent Member.

Re: Identity Reporting AR data source

On 3/10/16 6:03 AM, alekz wrote:
> Hello,
>
> Trying to configure Identity Reporting for Access Review (Same Reporting
> Module that is already configured for IDM).
>
> I have added a new data source which I call 'arops' that points to the
> PostgreSQL AR database using the database 'arops' and username 'arops'.
> (I have also tested with the 'arrptuser' with the same result)
>
> 'Test Connection' works fine.
>
> I have stopped Tomcat, deleted the content of tomcat/temp and
> tomcat/work directories.
>
> But I can't get the reports to work, the log tells me that the database
> "arops" does not exist when I run the 'Database Statistics for Access
> Review' report.
>
> Using pgAdmin I can access the database as the 'arops' user just fine.
>
> From catalina.out:
>
> 2016-03-10 11:30:53,813 [pool-4-thread-2] INFO
> com.novell.idm.rpt.core.server.schedules.ReportManagerImpl- [RPT-CORE]
> Rapporten har skapats (körs snart) f8a73450-001b-42b1-8773-d6343fed91f4.
> 2016-03-10 11:30:53,847 [pool-4-thread-2] INFO
> com.novell.idm.rpt.core.server.rest.OsgiBridge- [RPT-CORE] Kör rapporten
> 'Database_Statistics_for_Access_Review'.
> 2016-03-10 11:30:53,960 [pool-4-thread-2] ERROR
> com.novell.idm.rpt.core.server.rest.OsgiBridge- [RPT-CORE] Följande fel
> påträffades vid försök att köra rapporten
> 'Database_Statistics_for_Access_Review': An error was detected while
> running report 'Database_Statistics_for_Access_Review':
> net.sf.jasperreports.engine.JRException: Error executing SQL statement
> for : table_size. ERROR: database "arops" does not exist
> 2016-03-10 11:30:53,961 [pool-4-thread-2] ERROR
> com.novell.idm.rpt.core.server.schedules.ScheduleManagerImpl- [RPT-CORE]
> Följande fel påträffades vid försök att köra rapporten 'Database
> Statistics for Access Review - 3/10/2016 11:30 AM': An error was
> detected while running report 'Database_Statistics_for_Access_Review':
> net.sf.jasperreports.engine.JRException: Error executing SQL statement
> for : table_size. ERROR: database "arops" does not exist
> com.netiq.common.i18n.LocalizedException: The following error was
> encountered when attempting to run report 'Database Statistics for
> Access Review - 3/10/2016 11:30 AM': An error was detected while running
> report 'Database_Statistics_for_Access_Review':
> net.sf.jasperreports.engine.JRException: Error executing SQL statement
> for : table_size. ERROR: database "arops" does not exist
> at
> com.novell.idm.rpt.core.server.schedules.ScheduleManagerImpl$ReportTask.runJasper(ScheduleManagerImpl.java:155)
> at
> com.novell.idm.rpt.core.server.schedules.ScheduleManagerImpl$ReportTask.runAndUpdateReport(ScheduleManagerImpl.java:285)
> at
> com.novell.idm.rpt.core.server.schedules.ScheduleManagerImpl$ReportTask.call(ScheduleManagerImpl.java:258)
> at
> com.novell.idm.rpt.core.server.schedules.ScheduleManagerImpl$ReportTask.call(ScheduleManagerImpl.java:90)
> at java.util.concurrent.FutureTask.run(Unknown Source)
> at
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown
> Source)
> at
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown
> Source)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
> Source)
> at java.lang.Thread.run(Unknown Source)
> 2016-03-10 11:30:53,961 [pool-4-thread-2] ERROR
> com.novell.idm.rpt.core.server.schedules.ScheduleManagerImpl- [RPT-CORE]
> Körningen av JasperReports misslyckades.
> 2016-03-10 11:30:53,965 [pool-4-thread-2] INFO
> com.novell.idm.rpt.core.server.schedules.ReportManagerImpl- [RPT-CORE]
> Rapporten har uppdaterats (slutförts) f8a73450-001b-42b1-8773-d6343fed91f4.
>
>

Greetings,

There are only subset of reports that you can run with Access Review.
They all have the tag of "access review". Also, when you are in the
Properties view of the Report Definition, you have to select the
external datasource that you defined.

**Plesase only create your datasource connection with the arrptuser that
was defined during the AR install**

--
Sincerely,
Steven Williams
Lead Software Engineer
Micro Focus
0 Likes
Anonymous_User Absent Member.
Absent Member.

Re: Identity Reporting AR data source

On 3/10/16 10:14 AM, Steven Williams wrote:
> On 3/10/16 6:03 AM, alekz wrote:
>> Hello,
>>
>> Trying to configure Identity Reporting for Access Review (Same Reporting
>> Module that is already configured for IDM).
>>
>> I have added a new data source which I call 'arops' that points to the
>> PostgreSQL AR database using the database 'arops' and username 'arops'.
>> (I have also tested with the 'arrptuser' with the same result)
>>
>> 'Test Connection' works fine.
>>
>> I have stopped Tomcat, deleted the content of tomcat/temp and
>> tomcat/work directories.
>>
>> But I can't get the reports to work, the log tells me that the database
>> "arops" does not exist when I run the 'Database Statistics for Access
>> Review' report.
>>
>> Using pgAdmin I can access the database as the 'arops' user just fine.
>>
>> From catalina.out:
>>
>> 2016-03-10 11:30:53,813 [pool-4-thread-2] INFO
>> com.novell.idm.rpt.core.server.schedules.ReportManagerImpl- [RPT-CORE]
>> Rapporten har skapats (körs snart) f8a73450-001b-42b1-8773-d6343fed91f4.
>> 2016-03-10 11:30:53,847 [pool-4-thread-2] INFO
>> com.novell.idm.rpt.core.server.rest.OsgiBridge- [RPT-CORE] Kör rapporten
>> 'Database_Statistics_for_Access_Review'.
>> 2016-03-10 11:30:53,960 [pool-4-thread-2] ERROR
>> com.novell.idm.rpt.core.server.rest.OsgiBridge- [RPT-CORE] Följande fel
>> påträffades vid försök att köra rapporten
>> 'Database_Statistics_for_Access_Review': An error was detected while
>> running report 'Database_Statistics_for_Access_Review':
>> net.sf.jasperreports.engine.JRException: Error executing SQL statement
>> for : table_size. ERROR: database "arops" does not exist
>> 2016-03-10 11:30:53,961 [pool-4-thread-2] ERROR
>> com.novell.idm.rpt.core.server.schedules.ScheduleManagerImpl- [RPT-CORE]
>> Följande fel påträffades vid försök att köra rapporten 'Database
>> Statistics for Access Review - 3/10/2016 11:30 AM': An error was
>> detected while running report 'Database_Statistics_for_Access_Review':
>> net.sf.jasperreports.engine.JRException: Error executing SQL statement
>> for : table_size. ERROR: database "arops" does not exist
>> com.netiq.common.i18n.LocalizedException: The following error was
>> encountered when attempting to run report 'Database Statistics for
>> Access Review - 3/10/2016 11:30 AM': An error was detected while running
>> report 'Database_Statistics_for_Access_Review':
>> net.sf.jasperreports.engine.JRException: Error executing SQL statement
>> for : table_size. ERROR: database "arops" does not exist
>> at
>> com.novell.idm.rpt.core.server.schedules.ScheduleManagerImpl$ReportTask.runJasper(ScheduleManagerImpl.java:155)
>>
>> at
>> com.novell.idm.rpt.core.server.schedules.ScheduleManagerImpl$ReportTask.runAndUpdateReport(ScheduleManagerImpl.java:285)
>>
>> at
>> com.novell.idm.rpt.core.server.schedules.ScheduleManagerImpl$ReportTask.call(ScheduleManagerImpl.java:258)
>>
>> at
>> com.novell.idm.rpt.core.server.schedules.ScheduleManagerImpl$ReportTask.call(ScheduleManagerImpl.java:90)
>>
>> at java.util.concurrent.FutureTask.run(Unknown Source)
>> at
>> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown
>>
>> Source)
>> at
>> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown
>>
>> Source)
>> at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown
>> Source)
>> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
>> Source)
>> at java.lang.Thread.run(Unknown Source)
>> 2016-03-10 11:30:53,961 [pool-4-thread-2] ERROR
>> com.novell.idm.rpt.core.server.schedules.ScheduleManagerImpl- [RPT-CORE]
>> Körningen av JasperReports misslyckades.
>> 2016-03-10 11:30:53,965 [pool-4-thread-2] INFO
>> com.novell.idm.rpt.core.server.schedules.ReportManagerImpl- [RPT-CORE]
>> Rapporten har uppdaterats (slutförts)
>> f8a73450-001b-42b1-8773-d6343fed91f4.
>>
>>

> Greetings,
>
> There are only subset of reports that you can run with Access Review.
> They all have the tag of "access review". Also, when you are in the
> Properties view of the Report Definition, you have to select the
> external datasource that you defined.
>
> **Plesase only create your datasource connection with the arrptuser that
> was defined during the AR install**
>

Greetings,
As of today, we have published about 30 Access Review reports.
Please note, that if the version number is 1.5.x.x then that means you
must be using version 1.5 of AR at a min to utilize these reports. If
you are still using version 1.1 of AR, the reports may not work
correctly for you because you may not have the required schema for these
reports.



--
Sincerely,
Steven Williams
Lead Software Engineer
Micro Focus
0 Likes
Knowledge Partner
Knowledge Partner

Re: Identity Reporting AR data source

Hello!

AR is 1.5. Reports are 1.5.0.1

My fault was that I clicked on "Run now" in the Repository.

After clicking on the report *first* and changing the 'Data source'
before running it works better.

But some AR reports I tried did not work with the 'arrptuser', for
example 'Access Review Overview' works but other fail.

'Catalog User Details' fails with:

An error was detected while running report 'Catalog_Users_Details':
Error executing SQL statement for : TemplateReport. ERROR: permission
denied for relation adhoc_sgroup_suser_v

'Database Statistics for Access Review' fails with:

An error was detected while running report
'Database_Statistics_for_Access_Review':
net.sf.jasperreports.engine.JRException: Error executing SQL statement
for : db_size. ERROR: permission denied for relation perf_event_log_v

Maybe I missed a step when setting up AR? My arrptuser has the following
"Dependents" when looking in pgAdmin:

View arops public.access_review_details_v
View arops public.access_review_summary_v
View arops public.access_reviews_in_progress_v
View arops public.appl_collection_detail_v
View arops public.appl_collection_overview_v
View arops public.data_source_v
View arops public.fulfillment_item_combined
View arops public.fulfillment_status_v
View arops public.idsrc_collection_detail_v
View arops public.idsrc_collection_overview_v
View arops public.idsrc_publication_overview_v
View arops public.orphaned_account_v


On 2016-03-10 16:21, Steven Williams wrote:
> On 3/10/16 10:14 AM, Steven Williams wrote:
>> On 3/10/16 6:03 AM, alekz wrote:
>>> Hello,
>>>
>>> Trying to configure Identity Reporting for Access Review (Same Reporting
>>> Module that is already configured for IDM).
>>>
>>> I have added a new data source which I call 'arops' that points to the
>>> PostgreSQL AR database using the database 'arops' and username 'arops'.
>>> (I have also tested with the 'arrptuser' with the same result)
>>>
>>> 'Test Connection' works fine.
>>>
>>> I have stopped Tomcat, deleted the content of tomcat/temp and
>>> tomcat/work directories.
>>>
>>> But I can't get the reports to work, the log tells me that the database
>>> "arops" does not exist when I run the 'Database Statistics for Access
>>> Review' report.
>>>
>>> Using pgAdmin I can access the database as the 'arops' user just fine.
>>>
>>> From catalina.out:
>>>
>>> 2016-03-10 11:30:53,813 [pool-4-thread-2] INFO
>>> com.novell.idm.rpt.core.server.schedules.ReportManagerImpl- [RPT-CORE]
>>> Rapporten har skapats (körs snart) f8a73450-001b-42b1-8773-d6343fed91f4.
>>> 2016-03-10 11:30:53,847 [pool-4-thread-2] INFO
>>> com.novell.idm.rpt.core.server.rest.OsgiBridge- [RPT-CORE] Kör rapporten
>>> 'Database_Statistics_for_Access_Review'.
>>> 2016-03-10 11:30:53,960 [pool-4-thread-2] ERROR
>>> com.novell.idm.rpt.core.server.rest.OsgiBridge- [RPT-CORE] Följande fel
>>> påträffades vid försök att köra rapporten
>>> 'Database_Statistics_for_Access_Review': An error was detected while
>>> running report 'Database_Statistics_for_Access_Review':
>>> net.sf.jasperreports.engine.JRException: Error executing SQL statement
>>> for : table_size. ERROR: database "arops" does not exist
>>> 2016-03-10 11:30:53,961 [pool-4-thread-2] ERROR
>>> com.novell.idm.rpt.core.server.schedules.ScheduleManagerImpl- [RPT-CORE]
>>> Följande fel påträffades vid försök att köra rapporten 'Database
>>> Statistics for Access Review - 3/10/2016 11:30 AM': An error was
>>> detected while running report 'Database_Statistics_for_Access_Review':
>>> net.sf.jasperreports.engine.JRException: Error executing SQL statement
>>> for : table_size. ERROR: database "arops" does not exist
>>> com.netiq.common.i18n.LocalizedException: The following error was
>>> encountered when attempting to run report 'Database Statistics for
>>> Access Review - 3/10/2016 11:30 AM': An error was detected while running
>>> report 'Database_Statistics_for_Access_Review':
>>> net.sf.jasperreports.engine.JRException: Error executing SQL statement
>>> for : table_size. ERROR: database "arops" does not exist
>>> at
>>> com.novell.idm.rpt.core.server.schedules.ScheduleManagerImpl$ReportTask.runJasper(ScheduleManagerImpl.java:155)
>>>
>>>
>>> at
>>> com.novell.idm.rpt.core.server.schedules.ScheduleManagerImpl$ReportTask.runAndUpdateReport(ScheduleManagerImpl.java:285)
>>>
>>>
>>> at
>>> com.novell.idm.rpt.core.server.schedules.ScheduleManagerImpl$ReportTask.call(ScheduleManagerImpl.java:258)
>>>
>>>
>>> at
>>> com.novell.idm.rpt.core.server.schedules.ScheduleManagerImpl$ReportTask.call(ScheduleManagerImpl.java:90)
>>>
>>>
>>> at java.util.concurrent.FutureTask.run(Unknown Source)
>>> at
>>> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown
>>>
>>>
>>> Source)
>>> at
>>> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown
>>>
>>>
>>> Source)
>>> at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown
>>> Source)
>>> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
>>> Source)
>>> at java.lang.Thread.run(Unknown Source)
>>> 2016-03-10 11:30:53,961 [pool-4-thread-2] ERROR
>>> com.novell.idm.rpt.core.server.schedules.ScheduleManagerImpl- [RPT-CORE]
>>> Körningen av JasperReports misslyckades.
>>> 2016-03-10 11:30:53,965 [pool-4-thread-2] INFO
>>> com.novell.idm.rpt.core.server.schedules.ReportManagerImpl- [RPT-CORE]
>>> Rapporten har uppdaterats (slutförts)
>>> f8a73450-001b-42b1-8773-d6343fed91f4.
>>>
>>>

>> Greetings,
>>
>> There are only subset of reports that you can run with Access Review.
>> They all have the tag of "access review". Also, when you are in the
>> Properties view of the Report Definition, you have to select the
>> external datasource that you defined.
>>
>> **Plesase only create your datasource connection with the arrptuser that
>> was defined during the AR install**
>>

> Greetings,
> As of today, we have published about 30 Access Review reports. Please
> note, that if the version number is 1.5.x.x then that means you must be
> using version 1.5 of AR at a min to utilize these reports. If you are
> still using version 1.1 of AR, the reports may not work correctly for
> you because you may not have the required schema for these reports.
>
>
>

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.