bwagent configured with dbems for MySQL fails to start with the exception, "MySQLSyntaxErrorException".
Article ID: KB0093813
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks | - |
| Not Applicable | - |
Description
Description:
bwagent configured with dbems for My SQL fails to start with the exception, "MySQLSyntaxErrorException".
Symptoms:
The following exception is seen while starting bwagent.
Cause:
Using an unsupported version of MySQL.
bwagent configured with dbems for My SQL fails to start with the exception, "MySQLSyntaxErrorException".
Symptoms:
The following exception is seen while starting bwagent.
+++
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 1000 bytes
at
com.tibco.bw.thor.management.persistence.rdbms.ScriptRunner.o00000(ScriptRunner.java:173)
~[com.tibco.bw.thor.management.persistence_1.3.200.003.jar:na]
+++
Cause:
Using an unsupported version of MySQL.
Issue/Introduction
bwagent configured with dbems for MySQL fails to start with the exception, "MySQLSyntaxErrorException".
Resolution
Run the following two commands against your MYSQL database.
status
SHOW VARIABLES LIKE "%version%";
If the MySQL version is earlier than 5.5.x, upgrade to version 5.5 or later.
Feedback
Yes
No
Powered by
