Database Errors
MySQL 8: Public Key Retrieval is not allowed
After upgrading to MySQL 8, you may encounter the following error on startup: liquibase.exception.JDBCException: java.sql.SQLException: Cannot create PoolableConnectionFactory (Public Key Retrieval is not allowed)...Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException:...
Packet for query is too large
When uploading a file into Cascade CMS, users may see an error similar to the following message: An error occurred during editing: Error persisting this bean to storage:com.mysql.jdbc.PacketTooBigException: Packet for query is too large(####### > #######). You can change this value on the...
Error executing SQL DELETE FROM `cxml_history_item`
The following error message may appear when upgrading to Cascade 8 against a version of MySQL 5.7 prior to release 5.7.11: Migration failed for change set com/hannonhill/cascade/model/database/updater/updates/8_0/8_0_006.xml::8_0_006::artur.tomusiak: Reason: liquibase.exception.JDBCException:...
ORA-22275: invalid LOB locator specified
Oracle users may encounter this error when attempting to copy, edit, or submit assets in the system. The behavior will cause messages similar to the following to appear in the cascade.log file: 2015-09-14 07:54:10,936 WARN [JDBCExceptionReporter] SQL Error: 22275, SQLState: 999992015-09-14...
MySQL: Can't create table
When starting Cascade CMS for the first time or after importing a new MySQL database, administrators may see an error message in the log file similar to the following: ERROR [StartupTasks] : *** Startup task: DatabaseIndexAndKeyManagerfailed to execute successfully: java.sql.SQLException: Can't...
MySQL: Can't create/write to file
Organizations using MySQL may see an error message similar to the following when attempting to login to the system: Login failed: An error occurred: Startup task: DatabaseIndexAndKeyManager failed to execute successfully: java.sql.SQLException: Can't create/writeto file...
"Could not acquire change log lock" or "Waiting for changelog lock..."
During start-up, one of the following messages may appear in the cascade.log file and prevent Cascade CMS from starting: Waiting for changelog lock.... Caused by: liquibase.exception.LockException: Could not acquire change log lock. Currently locked by ... These can occur if the application...
The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "Unexpected rethrowing"
This particular error message can appear on startup. The full message will typically appear as the following: Error occurred fetching database vendor type: Cannot create PoolableConnectionFactory (The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL)...