Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. p_acq_06_b job stalls

    p_acq_06_b job stalls

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • 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
    View article in the Exlibris Knowledge Center
    1. Back to top
      • p_acq_06 (for Serials): "Ratio of currency DEM for date 19940427 is zero"
      • p_acq_06_b stalled/looping
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 19.01
      2. contype:kba
      3. Prod:Aleph
      4. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved