Skip to main content
  • 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


    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").


    All bugs mentioned in My Oracle Support Note 1361107.1 are fixed in Oracle 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?