- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-01-2019
06:58 PM
12-01-2019
06:58 PM
ORA-01654 error reported for scheduled jobs
Problem:
The RevPro3.0 Reporting Summarize Current Period job is completed with the ORA-01654 error reported in RevPro. The error indicates it is unable to extend table index in some tablespace.
Solution:
The ORA-01654 error usually indicates the server has failed to allocate the required number of blocks for an index segment in the specified tablespace.
To solve this problem, you need to work with DBA to allocate more space. In addition, check the record count for the RPRO_LOG_ACT_G log table. If the returned number of record counts is large, run the RevPro3.0 Log Retention program to truncate the table.
Labels: