MySQL: Can't create table
When starting Cascade Server 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: DatabaseIndexAndKeyManager
failed to execute successfully: java.sql.SQLException: Can't create table
'.\cascade\#sql-1648_8.frm' (errno:150)
This means that the collation for the tables is incorrect. To fix this problem, take the following steps:
- Drop the database
- Create the database and alter it to use the proper collation as
mentioned in the MySQL Database Configuration section here:
http://www.hannonhill.com/kb/Database-Config/index.html#mysql
- Re-import the database dump from before the last import was
attempted
- Start Cascade Server