Skip to main content
ExLibris
  • Subscribe by RSS
    • Back
    Voyager
    Ex Libris Knowledge Center

    ORA-03114 in acqjob.log after backup during FPC

    1. Last updated
    2. Save as PDF
    • Article Type: General
    • Product: Voyager
    • Product Version: 9

    Problem Symptoms:
    * Backup process occurred at end of Fiscal Period Close (FPC)
    * FPC log indicates success, but acqjob.log contains "SQL Error: ORA-03114: not connected to ORACLE" when retrieving data for reports
    * "After" reports not generated

    Cause:
    Acqjob that builds reports lost connection to database during backup.

    Resolution:
    1. Manually run acqjobs to generate reports.
    2. Process Reports in Reporter module.
    3. Review reports & check for error messages.
    4. Contact Support if you discover unexpected error messages, or if you find evidence of incomplete rollover after checking ledgers, funds, etc. in Acquisitions client.

    Additional Information

    * See Technical User's Guide for information on running Acqjobs.
    * See Reporter User's Guide for information on processing reports and notices.
    * Example messages from acqjob.log when trying to gather data once connection is lost:
    Unable to retrieve SIF version information.
    Failed to retrieve fiscal periods
    SQL Error: ORA-03114: not connected to ORACLE
    Failure selecting ledger and fiscal period
    SQL Error: ORA-03114: not connected to ORACLE

    Category: Acquisitions

    • Article last edited: 6/24/2014