User Tools

Site Tools


tech:psoft:psa_acctggl

PSA_ACCTGGL ORA-600 Error

The Application Engine PSA_ACCTGGL program sometimes errors out with an ORA-600 error.

Manual Fix

  • Run the SQL below and restart the job.
  • The job may fail more than once. Repeat the analyze steps below and continue restarting the Application engine program until it goes to success.
ANALYZE TABLE PS_PSA_ACCTG_TA0 COMPUTE STATISTICS; 
ANALYZE TABLE PS_PSA_ACCTG_TA1 COMPUTE STATISTICS; 
ANALYZE TABLE PS_PSA_ACCTG_TA2 COMPUTE STATISTICS; 
ANALYZE TABLE PS_PSA_ACCTG_TA3 COMPUTE STATISTICS; 
ANALYZE TABLE PS_PSA_ACCTG_TA4 COMPUTE STATISTICS; 
ANALYZE TABLE PS_PSA_ACCTG_TA5 COMPUTE STATISTICS; 
ANALYZE TABLE PS_PSA_ACCTG_TA6 COMPUTE STATISTICS; 
ANALYZE TABLE PS_PSA_ACCTG_TA7 COMPUTE STATISTICS; 
ANALYZE TABLE PS_PSA_ACCTG_TA8 COMPUTE STATISTICS; 
ANALYZE TABLE PS_PSA_CURR_TA1 COMPUTE STATISTICS; 
ANALYZE TABLE PS_PSA_CURR_TA2 COMPUTE STATISTICS; 
ANALYZE TABLE PS_PSA_IU_TA1 COMPUTE STATISTICS; 
ANALYZE TABLE PS_PSA_IU_TA2 COMPUTE STATISTICS; 
ANALYZE TABLE PS_PSA_PLANS_TA0 COMPUTE STATISTICS; 
ANALYZE TABLE PS_PSA_PLANS_TA1 COMPUTE STATISTICS; 
ANALYZE TABLE PS_PSA_PPD_TA1 COMPUTE STATISTICS; 
ANALYZE TABLE PS_PSA_RIDE_TA1 COMPUTE STATISTICS; 
ANALYZE TABLE PS_PSA_CF_TA1 COMPUTE STATISTICS; 
ANALYZE TABLE PS_PSA_ACCTDSTGL COMPUTE STATISTICS;

COMMIT;

Reason for the Error

blah blah

Permanent Fix

Move the AE temp tables to a tablespace that does not have blah blah.

tech/psoft/psa_acctggl.txt · Last modified: 2024/06/21 12:04 by 127.0.0.1