ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

RPT-0020 error in Reports and Jobs due to Tablespace Issue

book

Article ID: 199278

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

Multiple Reports fail / are not working from Reports and Jobs when run in immediate mode or scheduled mode

  • Reports that use the DWH Bean work okay, but those that use the PPM Bean are failing
  • Reports run from Advanced Reporting run successfully. 
  • Impacted reports include custom and Out of the Box (OOTB)

One error that may be seen:

  • RPT-0020: Error occurred while downloading the report <Report Name>. Please contact your system administrator.

Cause

This can be due to a tablespace issue, if an error similar to the following is found in the logs.

  • This error may show up in the bg-ca.logs (to validate, run a report in scheduled mode from Reports and Jobs) or in the Jasperserver.logs

com.jaspersoft.jasperserver.api.JSExceptionWrapper: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not insert: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.ContentRepoFileResource]; uncategorized SQLException for SQL [insert into JIContentResource (data, file_type, id) values (?, ?, ?)]; SQL state [72000]; error code [1691]; ORA-01691: unable to extend lob segment zzzzzzz by 8192 in tablespace zzzzz_DATA
; nested exception is java.sql.SQLException: ORA-01691: unable to extend lob segmentzzzzzzz by 8192 in tablespace zzzzzzz_DATA

Caused by: java.sql.SQLException: ORA-01691: unable to extend lob segment zzzzz by 8192 in tablespace zzzzzzz_DATA

Environment

Release : All Supported Releases

Component : CA PPM SAAS JASPERSOFT

Resolution

On Premise customers: Extend the tablespace

SaaS customers: Please contact Broadcom support for assistance

Additional Information

See KB: 141061 for tips on how to optimize use of Self Service for Clarity