Identity Reporting 4.7 throws exception

[liasson]

Hi!

We've upgraded our test Environment to IDM 4.7 and thus reporting to 6.0.1.

I've imported the default reports found at https://nu.novell.com//designer/idmrpt600/.

When running a report the result is it fails with message:
java.sql.SQLException: com.novell.idm.rpt.core.server.persist.rptmgt.DataSourceUsageNotAllowedException
no matter what report I'm trying to run.

Does anyone know what this exception means?
Can't find any clue on the net.

BR
/Thomas

[stevewdj]

On 11/6/18 10:24 AM, liasson wrote:
>
> Hi!
>
> We've upgraded our test Environment to IDM 4.7 and thus reporting to
> 6.0.1.
>
> I've imported the default reports found at
> https://nu.novell.com//designer/idmrpt600/.
>
> When running a report the result is it fails with message:
> java.sql.SQLException:
> com.novell.idm.rpt.core.server.persist.rptmgt.DataSourceUsageNotAllowedException
> no matter what report I'm trying to run.
>
> Does anyone know what this exception means?
> Can't find any clue on the net.
>
> BR
> /Thomas
>
>
Greetings,
What Data Sources (and to what schema/database names do they point
to) do you have defined within Identity Reporting?

--
Sincerely,
Steven Williams
Principal Enterprise Architect
Micro Focus

[liasson]

We have, as far as I understand, set this up as standard using the datasource IDMRPTCfgDataSource (a local PostgreSQL).

from jboss-web.xml:
--------------------

<jboss-web>
    <class-loading java2ClassLoadingCompliance='true'/>
    <resource-ref>
        <res-ref-name>jdbc/IDMRPTDataSource</res-ref-name>
        <jndi-name>java:/IDMRPTDataSource</jndi-name>
    </resource-ref>
    <resource-ref>
        <res-ref-name>jdbc/IDMRPTCfgDataSource</res-ref-name>
        <jndi-name>java:/IDMRPTDataSource</jndi-name>
    </resource-ref>
</jboss-web>

from server.xml:
--------------------

<Resource auth="Container" 
driverClassName="org.postgresql.Driver" 
factory="com.netiq.tomcat.jdbc.pool.CustomBasicDataSourceFactory" 
initialSize="10" maxIdle="10" maxTotal="50" maxWaitMillis="30000" minIdle="10" 
name="shared/IDMRPTDataSource" 
password="obfuscated" 
testOnBorrow="true" 
type="javax.sql.DataSource" 
url="jdbc:postgresql://<server>:<port>/SIEM" 
username="idmrptuser" 
validationInterval="120000" 
validationQuery="SELECT 1" />

where <server> is the localhost fqdn.

Logged in as user idmrptuser in SIEM db, the scchema query yields:
SIEM=> select schema_name from information_schema.schemata;
schema_name
--------------------
pg_catalog
information_schema
idm_rpt_cfg
idm_rpt_data
public
(5 rows)

E.g. I've run the test 'Role Assignments by User'.

I also created a really simple report which I cannot preview in iReport since com.novell.sentinel.content.reports.TemplateReportScriptlet cannot be loaded in the outdated tool.
The preview data in the report query window can execute the query correctly as user idmrptuser.
When importing the query and trying to run it in Identity Reporting, it fails with the exception as mentioned before.

Is there now way to produce a more elaborate error message?

BTW can we use Jaspersoft Studio instead of iReport, since it's quite outdated?

[liasson]

Hi!

I was able to generate reports if I set up a new datasouce pointing to the local database.
The 'Installed Database' option won't work.

/Thomas

[liasson]

Hi!

Just want to point out that the root problem still remains.

What does the exception mean?
How do I identify the problem with 'Installed Database' when running reports?

BR
/Thomas

[stevewdj]

On 11/9/18 3:04 AM, liasson wrote:
>
> Hi!
>
> Just want to point out that the root problem still remains.
>
> What does the exception mean?
> How do I identify the problem with 'Installed Database' when running
> reports?
>
> BR
> /Thomas
>
>
Greetings,
What version of Identity Reporting did you upgrade from? I do not
see that in your original post.

--
Sincerely,
Steven Williams
Principal Enterprise Architect
Micro Focus

[liasson]

Hi!

We upgraded from Identity Reporting version 5.5.3 (revision 6615).

BR
/Thomas