Apelon DTS / Discussion / Help: kbcreate.bat fails (MySQL)

Alba Garcia Jimenez - 2014-01-28

When I execute the kbcreate.bat script to create the MySQL Tables I get this error:

---- Creating table DTS_CONCEPT_ARCHIVE
BaseTable: create
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too
long; max key length is 767 bytes
at sun.reflect.GeneratedConstructorAccessor3.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC

onstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2618)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1749)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1666)
at com.apelon.common.sql.SQL.createMySQLIndex(SQL.java:405)
at com.apelon.common.sql.SQL.createIndex(SQL.java:330)
at com.apelon.dts.db.admin.table.TableDTS_CONCEPT_ARCHIVE.createIndex(Ta
bleDTS_CONCEPT_ARCHIVE.java:50)
at com.apelon.common.util.db.BaseTable.createTable(BaseTable.java:164)
at com.apelon.common.util.db.BaseTable.create(BaseTable.java:147)
at com.apelon.common.util.db.DbCreate.buildTables(DbCreate.java:234)
at com.apelon.common.util.db.DbCreate.run(DbCreate.java:193)
at com.apelon.common.util.db.DbCreate.main(DbCreate.java:362)
Exception running DbAdmin
java.sql.SQLException: unable to copy data: Specified key was too long; max key
length is 767 bytes
at com.apelon.common.util.db.BaseTable.create(BaseTable.java:156)
at com.apelon.common.util.db.DbCreate.buildTables(DbCreate.java:234)
at com.apelon.common.util.db.DbCreate.run(DbCreate.java:193)
at com.apelon.common.util.db.DbCreate.main(DbCreate.java:362)
Presione una tecla para continuar . . .

C:\Program Files\Apelon\DTS 3.5.2\bin\kb\create>kbcreate.bat

Has anybody experienced the same problem?

Thanks in advance.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Jack Bowie - 2014-01-28

What version of MySQL are you using? Do you know which Table Engine (Table Type) you are using? DTS expects MyISAM.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Alba Garcia Jimenez - 2014-01-29

I'm using MySQL Server 5.6 and ..... InnoDB Table Engine because I saw this "Verify that your default storage engine is InnoDB." in the "mysql-guidelines-for-dts-v352.pdf" document.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Alba Garcia Jimenez - 2014-01-29

Anyway I have changed the default engine to MYISAM:

mysql> show engines \G
****** 1. row ***
Engine: FEDERATED
Support: NO
Comment: Federated MySQL storage engine
Transactions: NULL
XA: NULL
Savepoints: NULL*** 2. row ***
Engine: MRG_MYISAM
Support: YES
Comment: Collection of identical MyISAM tables
Transactions: NO
XA: NO
Savepoints: NO*** 3. row ******
Engine: MyISAM
Support: DEFAULT
Comment: MyISAM storage engine
Transactions: NO
XA: NO
Savepoints: NO
...

But I get the same error and when I see the tables that kbcreate has created I see this:

mysql> show table status \G
****** 1. row ***
Name: dts_authority
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 0
Avg_row_length: 0
Data_length: 16384
Max_data_length: 0
Index_length: 0
Data_free: 0
Auto_increment: NULL
Create_time: 2014-01-29 11:11:45
Update_time: NULL
Check_time: NULL
Collation: utf8_bin
Checksum: NULL
Create_options:
Comment:*** 2. row ***
Name: dts_concept_archive
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 0
Avg_row_length: 0
Data_length: 16384
Max_data_length: 0
Index_length: 32768
Data_free: 0
Auto_increment: NULL
Create_time: 2014-01-29 11:11:53
Update_time: NULL
Check_time: NULL
Collation: utf8_bin
Checksum: NULL
Create_options:
Comment:*** 3. row ***
Name: dts_kind
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 0
Avg_row_length: 0
Data_length: 16384
Max_data_length: 0
Index_length: 49152
Data_free: 0
Auto_increment: NULL
Create_time: 2014-01-29 11:11:47
Update_time: NULL
Check_time: NULL
Collation: utf8_bin
Checksum: NULL
Create_options:
Comment:*** 4. row ***
Name: dts_kind_archive
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 0
Avg_row_length: 0
Data_length: 16384
Max_data_length: 0
Index_length: 32768
Data_free: 0
Auto_increment: NULL
Create_time: 2014-01-29 11:11:47
Update_time: NULL
Check_time: NULL
Collation: utf8_bin
Checksum: NULL
Create_options:
Comment:*** 5. row ***
Name: dts_namespace
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 0
Avg_row_length: 0
Data_length: 16384
Max_data_length: 0
Index_length: 49152
Data_free: 0
Auto_increment: NULL
Create_time: 2014-01-29 11:11:45
Update_time: NULL
Check_time: NULL
Collation: utf8_bin
Checksum: NULL
Create_options:
Comment:*** 6. row ***
Name: dts_property_type
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 0
Avg_row_length: 0
Data_length: 16384
Max_data_length: 0
Index_length: 49152
Data_free: 0
Auto_increment: NULL
Create_time: 2014-01-29 11:11:52
Update_time: NULL
Check_time: NULL
Collation: utf8_bin
Checksum: NULL
Create_options:
Comment:*** 7. row ***
Name: dts_property_type_archive
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 0
Avg_row_length: 0
Data_length: 16384
Max_data_length: 0
Index_length: 32768
Data_free: 0
Auto_increment: NULL
Create_time: 2014-01-29 11:11:51
Update_time: NULL
Check_time: NULL
Collation: utf8_bin
Checksum: NULL
Create_options:
Comment:*** 8. row ***
Name: dts_role_type
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 0
Avg_row_length: 0
Data_length: 16384
Max_data_length: 0
Index_length: 114688
Data_free: 0
Auto_increment: NULL
Create_time: 2014-01-29 11:11:49
Update_time: NULL
Check_time: NULL
Collation: utf8_bin
Checksum: NULL
Create_options:
Comment:*** 9. row ***
Name: dts_role_type_archive
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 0
Avg_row_length: 0
Data_length: 16384
Max_data_length: 0
Index_length: 32768
Data_free: 0
Auto_increment: NULL
Create_time: 2014-01-29 11:11:48
Update_time: NULL
Check_time: NULL
Collation: utf8_bin
Checksum: NULL
Create_options:
Comment:*** 10. row ***
Name: dts_sequences
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 15
Avg_row_length: 1092
Data_length: 16384
Max_data_length: 0
Index_length: 0
Data_free: 0
Auto_increment: NULL
Create_time: 2014-01-29 11:11:43
Update_time: NULL
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment:*** 11. row ******
Name: dts_version
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 0
Avg_row_length: 0
Data_length: 16384
Max_data_length: 0
Index_length: 49152
Data_free: 0
Auto_increment: NULL
Create_time: 2014-01-29 11:11:46
Update_time: NULL
Check_time: NULL
Collation: utf8_bin
Checksum: NULL
Create_options:
Comment:
11 rows in set (0.01 sec)

¿What can I do?

¿Where are the scripts that kbcreate uses?

Thanks in advance.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

kbcreate.bat fails (MySQL)

Forums

Help

kbcreate.bat fails (MySQL) document.SUBSCRIPTION_OPTIONS = { "thing": "topic", "subscribed": false, "url": "subscribe", "icon": { "css": "fa fa-envelope-o" } };

kbcreate.bat fails (MySQL)