SQL Error (1461). Can't Create More Than MAX_PREPARED_STMT_COUNT Statements (Current Value: 120000)
Last updated on APRIL 06, 2017
Applies to:Oracle GoldenGate - Version 126.96.36.199.0 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
Million Knowledge Articles and hundreds of Community platforms