"Installation Step 1 - MySQL Error: Creation of Quartz tables failed"

rberger

Hy!

I have almost finished the installation of RapidAnalytics, but during the installation step 1 I got the following error:

ERROR: Creation of Quartz tables failed: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key lenght is 1000 bytes

I already googled this error and I think it is a problem with the MySQL character set.

Could anyone help me please?  

Cheers,
rberger

fischer

Hi,

quartz uses compound keys with three VARCHAR columns of length 200, I believe. That makes for a total of 600 characters. With most encodings, this is still ok, but in UTF16 this is 1200 bytes, which MySQL does not handle by default: Keys can have length at most 1200. Two solutions: Change encoding or allow longer keys. Consult MySQL manual for more info.

Best,
Simon

rberger

Hy Simon!

Thank you very much! I solved the problem this way: I changed the default character set from mysql from utf8 to latin1.

If anyone has the same problem, here is the code:

alter database *yourdatabsename* default character set latin1 collate latin1_swedish_ci;

Cheers!

andrea11

Thanks, used the changing charset solution! It worked!