- Article Type: General
- Product: Primo
- Product Version: 3
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  Errors Encountered When Using Oracle JDBC Driver").
All bugs mentioned in My Oracle Support Note 1361107.1 are fixed in Oracle 22.214.171.124 which is available with Primo version 4.
Recommended solution: upgrade Primo to version 4.
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
- Article last edited: 1/29/2014