Adding a new BO.
Clicked the 'Indexed' option for a few 'Plain Text' attributes.
Received this error when trying to test:
"Exception changing status of the business space version Aware IM server encountered the following error. Error creating indexes BLOB/TEXT column 'MyColumn' used in key specification without a key length."
I tried to use No Initial data, but got an error about duplicate indexes.
I had to uncheck the Indexed option for all columns.
I am using MySQL with build 1371 on RHEL
Here you can see the logs:
INFO: OutputAdaptor1.Controller has commited 700 transactions
Server encountered an exception Error creating indexes BLOB/TEXT column 'MyColumn' used in key specification without a key length
Error creating tables Table 'BASTESTDOMAINNANODATAMGT_TUBE' already exists
Server encountered an exception Error creating indexes BLOB/TEXT column 'MyColumn' used in key specification without a key length
Error creating tables Table 'BASTESTDOMAINNANODATAMGT_TUBE' already exists
Server encountered an exception Error creating indexes BLOB/TEXT column 'MyColumn' used in key specification without a key length
INFO: InputAdaptor1.Controller has commited 700 transactions
Error creating tables Table 'BASTESTDOMAINNANODATAMGT_TUBE' already exists
Server encountered an exception Error creating indexes BLOB/TEXT column 'MyOtherColumn' used in key specification without a key length
Error creating tables Table 'BASTESTDOMAINNANODATAMGT_TUBE' already exists
Server encountered an exception Error creating indexes BLOB/TEXT column 'MyColumn' used in key specification without a key length
Error creating tables Table 'BASTESTDOMAINNANODATAMGT_TUBE' already exists
Server encountered an exception Error creating indexes Duplicate key name 'I1467050050'
Error creating tables Table 'BASTESTDOMAINNANODATAMGT_TUBE' already exists
Server encountered an exception Error creating indexes Duplicate key name 'I1467050050'
Error creating tables Table 'BASTESTDOMAINNANODATAMGT_TUBE' already exists