java.sql.SQLException

tip

MySQL doesn't support some types of characters (such as emojis) with the utf8 encoding. You need to be on MySQL 5.5+ and force utf8mb4 (everywhere, client and server). You can do this sending the query "SET NAMES utf8mb4". Check this https://goo.gl/3E2qzg

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

  • Error when dumping logs
    via GitHub by havejack
    ,
  • Errors Spamming Server Logs
    via GitHub by brodiej
    ,
  • new install problem
    via GitHub by gzanthony
    ,
  • Unable to update 1.0.3 db?
    via GitHub by ojhunt
    ,
  • Nie wybrano żadnej bazy danych
    via GitHub by divinuss
    ,
    • java.sql.SQLException: Cannot proceed because system tables used by Event Scheduler were found damaged at server start at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2814) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2763) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:896) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:734) at com.mstr.usher.tool.CustomUpdate.updateDBfromFile(Unknown Source) at com.mstr.usher.tool.CustomUpdate.coreFlow(Unknown Source) at com.mstr.usher.tool.SqlToolsBase.execute(Unknown Source) at com.microstrategy.install.products.UsherServer.configureDb(UsherServer.java:1018) at com.microstrategy.install.products.UsherServer.configureProduct(UsherServer.java:637) at com.microstrategy.install.products.UsherServer.execute(UsherServer.java:254) at com.microstrategy.install.products.Usher.execute(Usher.java:53) at com.microstrategy.install.products.MstrSuite.execute(MstrSuite.java:616) at com.microstrategy.install.wizard.graphic.dialogs.ProductInstallationDialog$ProductInstallationSwingWorker.doInBackground(ProductInstallationDialog.java:356) at com.microstrategy.install.wizard.graphic.dialogs.ProductInstallationDialog$ProductInstallationSwingWorker.doInBackground(ProductInstallationDialog.java:326) at javax.swing.SwingWorker$1.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at javax.swing.SwingWorker.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source)

    Users with the same issue

    slash
    4 times, last one,
    tvrmsmith
    4 times, last one,
    Unknown visitor1 times, last one,
    MethodCall
    1 times, last one,
    mortalman7
    2 times, last one,
    145 more bugmates