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.ReportMan agerImpl- [RPT-CORE]
Rapporten har skapats (krs 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] Kr 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] Fljande fel
ptrffades vid frsk att kra 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.ScheduleM anagerImpl- [RPT-CORE]
Fljande fel ptrffades vid frsk att kra 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.ScheduleM anagerImpl$ReportTask.runJasper(ScheduleManagerImp l.java:155)
at
com.novell.idm.rpt.core.server.schedules.ScheduleM anagerImpl$ReportTask.runAndUpdateReport(ScheduleM anagerImpl.java:285)
at
com.novell.idm.rpt.core.server.schedules.ScheduleM anagerImpl$ReportTask.call(ScheduleManagerImpl.jav a:258)
at
com.novell.idm.rpt.core.server.schedules.ScheduleM anagerImpl$ReportTask.call(ScheduleManagerImpl.jav a:90)
at java.util.concurrent.FutureTask.run(Unknown Source)
at
java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.access$201(Unknown
Source)
at
java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.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.ScheduleM anagerImpl- [RPT-CORE]
Krningen av JasperReports misslyckades.
2016-03-10 11:30:53,965 [pool-4-thread-2] INFO
com.novell.idm.rpt.core.server.schedules.ReportMan agerImpl- [RPT-CORE]
Rapporten har uppdaterats (slutfrts) f8a73450-001b-42b1-8773-d6343fed91f4.