SQL Error (1461). Can't Create More Than MAX_PREPARED_STMT_COUNT Statements (Current Value: 120000)

(Doc ID 2239331.1)

Last updated on APRIL 06, 2017

Applies to:

Oracle GoldenGate - Version and later
Information in this document applies to any platform.


Replicat running against MYSQL database was failed by the following message:

2016-04-29 08:53:32 ERROR OGG-00768 Oracle GoldenGate Delivery for MySQL, reptrade.prm: DYNSQL: Preparing SQL statement (ID = 0) failed. SQL error (1461). Can't create more than max_prepared_stmt_count statements (current value: 120000).

In the translate, there are a lot of prepare update statement against some tables. Even setting the max_prepared_stmt_count to 120000 did not help


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms