ORA-01654 error reported for scheduled jobs

[Muhan]

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.