• Article Type: General
• Product: Aleph
• Product Version: 19.01

Description:
We are running p_acq_06_b as part of our test fiscal year close and the job is taking much longer to run than normal. Last year it took an hour to run and right now it has been running for 2 hours and still hasn't finished. The last entry in the log was over an hour ago.

The only error in the log is the "Could not find ratio of currency usd for date ...." but we've seen that before and that doesn't appear to be an issue.

Resolution:
The p_acq_06 logs don't indicate any problem. I see the following in util o/14/1:

TABLESPACE_WITHOUT_FREE_SPACE
------------------------------
TS2D
TS3D
TS4D
TS4X

but since this site's tablespaces have "AUTOEXTEND ON", the util o/14/1 is not necessarily accurate. (See KB 16384-19858 in this regard.)

This seemed like KB 16384-17825 ("p_acq_06_b stalled/looping"), so we had the site use SQL to delete the z601_type 'ENC' records for the new fiscal year (z601_rec_key like '%2011-12') and then rerun both p-acq-06-a and p-acq-06-b.

• Article last edited: 10/8/2013