Pipe fails with java.sql.SQLException

Last updated
Save as PDF
Share
1. Share
2. Tweet
3. Share

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