liasson Respected Contributor.
Respected Contributor.
562 views

Identity Reporting 4.7 throws exception

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
Labels (1)
0 Likes
6 Replies
Micro Focus Expert
Micro Focus Expert

Re: Identity Reporting 4.7 throws exception

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
0 Likes
liasson Respected Contributor.
Respected Contributor.

Re: Identity Reporting 4.7 throws exception

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?
0 Likes
liasson Respected Contributor.
Respected Contributor.

Re: Identity Reporting 4.7 throws exception

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
0 Likes
liasson Respected Contributor.
Respected Contributor.

Re: Identity Reporting 4.7 throws exception

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
0 Likes
Micro Focus Expert
Micro Focus Expert

Re: Identity Reporting 4.7 throws exception

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
0 Likes
liasson Respected Contributor.
Respected Contributor.

Re: Identity Reporting 4.7 throws exception

Hi!

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

BR
/Thomas
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.