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.
- Execute the following SQL statement (needs privilege sysdba):
SQL> alter system set "_optim_peek_user_binds"=false scope=both;
- Restart the Oracle database.
- Run the pipe again and check the log files.
Category: Back End
Subject: Pipes
- Article last edited: 1/29/2014