SQL Error (1461). Can't Create More Than MAX_PREPARED_STMT_COUNT Statements (Current Value: 120000)
(Doc ID 2239331.1)
Last updated on APRIL 09, 2020
Applies to:Oracle GoldenGate - Version 18.104.22.168.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, rtest.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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document