"Permission denied" when running BIRT reports

Technote (troubleshooting)


Problem(Abstract)

Attempts to set up BIRT reporting system with the IBM Rational Team Concert (RTC) 4.0.3 result in an "Cannot execute the statement. org.eclipse.datatools.connectivity.oda.OdaException: Permission Denied" error.

Symptom

Steps to reproduce:

The following steps use RTC Eclipse client with BIRT plugin


  1. Create a new project Business Intelligence and Reporting Tools -> Report Project.

  2. Add new Report to the project and use the Blank report as a report template.

  3. Add new Data Sources and from the list of accessible data sources types use the Jazz Data Source.

  4. Select your RTC repository URL and use the COMMON_SNAPSHOT from the snapshot section and one of the accessible projects from you repository.

  5. Test the connection using the Test Connection button and than use the Finish button.

  6. Add new Data Sets and in the Fact Information tab choose the PROJECT_AREA as a table name and select all columns.

  7. Drag the new created Data Set to the Report Editor area.

  8. Use the Preview tab in the Report Editor area.



The following error message appears.



- Cannot execute the statement.
org.eclipse.datatools.connectivity.oda.OdaException: Permission Denied

odaconsumer.CannotExecuteStatement ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: Cannot execute the statement.
org.eclipse.datatools.connectivity.oda.OdaException: Permission Denied

at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1245)
at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1224)
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:96)
..
Caused by: org.eclipse.birt.data.engine.odaconsumer.OdaDataException: Cannot execute the statement.
org.eclipse.datatools.connectivity.oda.OdaException: Permission Denied
...
Caused by: org.eclipse.datatools.connectivity.oda.OdaException: Permission Denied
...

Cause

There are two possible causes.

  • The user who is executing the report is not a member of the project area.

  • The role assigned to this user does not have permissions to the following actions:

    • Create Report Resource,
    • Modify Report Resource from the Deploy Report Resource (server) group.

The permission was added in RTC 4.0.3 to prevent guest users from accessing data from the BIRT designer without permission.

Resolving the problem

In the RTC Eclipse client or web client, verify the following settings.


  1. Verify that the user is a member of this project area. If appropriate, add that user to this project area. See screen capture.





  2. Check if the user role has permissions to perform actions like "Create Report Resource" and "Modify Report Resource". See the screen capture.




Rate this page:

(0 users)Average rating

Document information


More support for:

Rational Team Concert
Integrations: IBM

Software version:

4.0.3

Operating system(s):

Linux, Windows

Reference #:

1649183

Modified date:

2013-09-09

Translate my page

Machine Translation

Content navigation