liasson

Captain
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
2018-11-06
15:17
609 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
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
6 Replies
stevewdj

Micro Focus Expert
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
2018-11-07
00:43
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
>
> 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

Captain
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
2018-11-07
12:08
We have, as far as I understand, set this up as standard using the datasource IDMRPTCfgDataSource (a local PostgreSQL).
from jboss-web.xml:
--------------------
from server.xml:
--------------------
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?
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"where <server> is the localhost fqdn.
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" />
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

Captain
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
2018-11-08
10:05
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
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

Captain
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
2018-11-09
08:01
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
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

Micro Focus Expert
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
2018-11-10
15:24
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
>
> 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

Captain
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
2018-11-12
08:30
Hi!
We upgraded from Identity Reporting version 5.5.3 (revision 6615).
BR
/Thomas
We upgraded from Identity Reporting version 5.5.3 (revision 6615).
BR
/Thomas