Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Primo

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Primo
    3. Knowledge Articles
    4. ORA-04088: error during execution of trigger

    ORA-04088: error during execution of trigger

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: Primo
    • Product Version: 3

    Problem Symptoms:

    • Primo pipe stalls or is terminated during NEP phase
    • The following pipe error message is recorded in the Back Office: "ORA-04088: error during execution of trigger 'P31_PRM00.PNX_MTCHID_INST_TRG'; nested exception is java.sql.SQLException"
    • Primo system issues the error message: "The schedule for XXX_PIPE was disabled, because the processed is not allowed to run"


    Cause:
    Slow or stalled Primo indexing caused by limited Oracle temp tablespace causes pipes to stall.

    Resolution:
    1. Increase the amount of Oracle temp tablespace in Primo.
    2. Confirm that the Primo indexing process has completed successfully.
    3. Terminate the stalled Pipe.
    4. If the Pipe was terminated after completing the Harvest phase AND it is an ongoing pipe, change the Define Pipe > ?€œStart harvesting files/records from?€? field value to an earlier date in order to reharvest the same file(s) again.
    5. Re-execute the terminated pipe.

    Category: Publishing Platform

    Subject: Pipe Clean-up


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • OpenURL parameters used in Primo service page
      • Oracle error in ARC ETL log on Aleph production: "Oracle error: io_z900_by_time"
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Community Content Type
      How To
      Content Type
      Knowledge Article
      Language
      English
      Product
      Primo
    2. Tags
      1. 3
      2. contype:kba
      3. Pipe Clean-up
      4. Prod:Primo
      5. Publishing Platform
      6. 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