IBM Support

"Permission denied" when running BIRT reports

Troubleshooting


Problem

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
...

[{"Product":{"code":"SSUC3U","label":"IBM Engineering Workflow Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Integrations: IBM","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"4.0.3","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
16 June 2018

UID

swg21649183