Hi everybody,

My customer have IDM 4.5.4, Identity applications 4.5.4, Identity Reporting 4.5.0.

They have the following two problems:

1. After login in Identity Reporting, they see the message error in the IR web console :

Unable to download reports list from http://cdn.novell.com/cached/designe...450/reports.js

What maybe the cause?

2. They have a new report:

a. Create with iReport 3.5
b. Database conectivity a posgreSQL is with idmrptsrv user
c. A new view called

CREATE OR REPLACE VIEW idm_rpt_data.v_bbva_user_creation
as
SELECT
idv_acct_user as codigo,
idv_acct_dn as dn,
idv_acct_status as status,
idmrpt_valid_from as creado
FROM idm_rpt_data.idmrpt_idv_acct


But, when is executed by IR the following error appears:


2016-12-16 09:39:07,289 [pool-154-thread-7] ERROR com.novell.idm.rpt.core.server.rest.OsgiBridge- [RPT-CORE] The following error was encountered when attempting to run report 'BBVA_001_Alta_de_usuario': An error was detected while running report 'BBVA_001_Alta_de_usuario': Error executing SQL statement for : TemplateReport. ERROR: permission denied for schema idm_rpt_data
Position: 15
2016-12-16 09:39:07,289 [pool-154-thread-7] ERROR com.novell.idm.rpt.core.server.schedules.ScheduleM anagerImpl- [RPT-CORE] The following error was encountered when attempting to run report 'BBVA_001_Alta de usuario - 12/16/2016 9:39 AM': An error was detected while running report 'BBVA_001_Alta_de_usuario': Error executing SQL statement for : TemplateReport. ERROR: permission denied for schema idm_rpt_data
Position: 15
com.netiq.common.i18n.LocalizedException: The following error was encountered when attempting to run report 'BBVA_001_Alta de usuario - 12/16/2016 9:39 AM': An error was detected while running report 'BBVA_001_Alta_de_usuario': Error executing SQL statement for : TemplateReport. ERROR: permission denied for schema idm_rpt_data
Position: 15
at com.novell.idm.rpt.core.server.schedules.ScheduleM anagerImpl$ReportTask.runJasper(ScheduleManagerImp l.java:154)
at com.novell.idm.rpt.core.server.schedules.ScheduleM anagerImpl$ReportTask.runAndUpdateReport(ScheduleM anagerImpl.java:278)
at com.novell.idm.rpt.core.server.schedules.ScheduleM anagerImpl$ReportTask.call(ScheduleManagerImpl.jav a:251)
at com.novell.idm.rpt.core.server.schedules.ScheduleM anagerImpl$ReportTask.call(ScheduleManagerImpl.jav a:90)
at java.util.concurrent.FutureTask.run(FutureTask.jav a:266)
at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.access$201(ScheduledThreadPoolE xecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.run(ScheduledThreadPoolExecutor .java:293)
at java.util.concurrent.ThreadPoolExecutor.runWorker( ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
2016-12-16 09:39:07,290 [pool-154-thread-7] ERROR com.novell.idm.rpt.core.server.schedules.ScheduleM anagerImpl- [RPT-CORE] JasperReports execution failed.

What maybe the cause?

How the have resolve this problem?

TIA