Exception Publishing BSV, Too many keys specified

Gabbitas

Hi,

I get the following error when trying to publish my bsv:

"Exception Publishing Business Space Version Aware IM Server encountered the following error, Error creating indexes Too many keys specified; max 64 keys allowed"

I can place the same bsv on test without any problems.

I have tried creating a new business space and importing the bsv but I get the same problem.

I have tried restarting the server, creating new business space and importing the bsv but I still get the same problem.

Has anyone any ideas?

Thanks

BTW im Running MySQL

Gabbitas

Has anyone got any ideas for me?

I’m really stuck on this one.

If I create a new BSV (Blank BSV) and make changes to it I can both test it and publish it without problems. I can also delete it and the tables created in basdbtest and basdb are deleted. (I’m using MySQL and looking at the structure using phpMyAdmin)

I can put my production BSV on test but I can’t publish it. Even if I export it and import it into a new BSV, I still get the same problem of being able to test but not publish. If I delete my production BSV then the tables in basdbtest are deleted but they are not deleted from basdb.

This makes me think that there is some sort of corruption in my production BSV. I can go back to the last published version of my production BSV and use this but I have made lots of changes since that last published version.
Because the version that I have been working on of late has been in and out of test mode without any problems I have been unaware of the problem and possible corruption that appears only when I try to publish.
I’m guessing if it is corruption then it must have occurred when I created a new version from my last published version.

I obviously do not want to have to redo all of the changes since my last published version as I will loose lots of time and effort.

Would it make any difference to uninstall AwareIM, delete basdbtest and basdb from mySQL and then re-install AwareIM?

Please Help - I’m really worried I might loose two months work!!

aware_support

First of all if you need serious help, you need to purchase support. Consider subscribing to the support plan or purchasing a support ticket.

Second of all - use Google, this is the MySQL problem. You are either using an old version of MySQl or there is a business object that uses too many indexes.

Aware IM uses an index if an attribute has been marked as "indexed". Starting from 5.2 it also indexes the single references. So if you have a business object with more than 64 attributes like this you may have a problem in the older version of MySQL

Gabbitas

Hi Support,

I have googled the problem and have read about the limit of 64 keys with mySQL. It is possible to increase MAX_KEY in mySQL and set a new limit. I dont think this will solve my problem though - Firstly I dont think I have indexed any attribute in any businesss object. Most certanly not 64 or more!
Secondly why is it possible to put the version in test? If mySQL accepts my configuration in test why wouldn't it accept it when publishing?

I think I will purchase support on this one. What should I do? Purchase a ticket and e-mail my BSV to support?

Thanks

aware_support

Yes, please

Gabbitas

Thanks for your help on this one support.

This is a mySQL issue because it only supports a maximum of 64 indexes. The SystemSetting BO in my BSV had more than 21 single references in it and AwareIM creates 3 indexes per single reference - meaning more than 64 indexes being created in a single table of mySQL database (the strange thing in all of that is that the BSV creates the test database without problem?!)

After some research it is possible to have mySQL accept more than 64 indexes. It can support 128 but to be able to configure that you must download the source code, make the appropriate changes to MAX_KEY in source and then compile it.
I have done some further research into how to go about editing the source and compiling but it is well beyond my understanding and capability. For now I have adapted my BSV so that there are not so many single references in any one business object.

I would love to hear from anyone who does know how to recompile mySQL source or anybody who has a copy of mySQL that will support 128 indexes.