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

rberger
rberger New Altair Community Member
edited November 2024 in Community Q&A
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
Tagged:

Answers

  • fischer
    fischer New Altair Community Member
    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
    rberger New Altair Community Member
    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
    andrea11 New Altair Community Member
    Thanks, used the changing charset solution! It worked!

Categories