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

    Pipe fails with java.sql.SQLException

    • Article Type: General
    • Product: Primo
    • Product Version: 3

     

    Problem Symptoms

    Error messages in Primo BE log file:

    ERROR [t-NEP-bulk-2.LoadSourceRecordsFromDB] [c-RetryDBFailureExceptionHandler] - Error executing LoadSourceRecordsFromDB
    org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized

    Cause

    One of several Oracle database bugs which can occur during a JDBC connection to the database (details in My Oracle Support Note 1361107.1 "Troubleshooting ORA-3137 [12333] Errors Encountered When Using Oracle JDBC Driver").

    Resolution

    All bugs mentioned in My Oracle Support Note 1361107.1 are fixed in Oracle 11.2.0.3 which is available with Primo version 4.
    Recommended solution: upgrade Primo to version 4.

    Additional Information

    Potential workaround in Primo 3: disable Bind Peeking in the Oracle database.

    1. Execute the following SQL statement (needs privilege sysdba):

    SQL> alter system set "_optim_peek_user_binds"=false scope=both;

     

    1. Restart the Oracle database.
    2. Run the pipe again and check the log files.

     

    Category: Back End

    Subject: Pipes


    • Article last edited: 1/29/2014
    • Was this article helpful?
    //Feedback