Suddenly our business space refused to go into TEST mode. It displayed the following error in the configuration tool:
Error renaming the table [TABLE-NAME] Table '[TABLE-NAME]' already exists.
Not knowing what to do, we have restored our yesterday backup of the MySQL database and our yesterday backup of the business space. Now the error is this in the console:
Error creating tables Table '[ANOTHER-TABLE-NAME]' already exists
Server encountered an exception
Error creating indexes Duplicate key name 'codigo_I'
And this in the configuration tool:
Error creating indexes Duplicate key name 'codigo_I'
Please help, we are stuck.
Eduardo Méndez.
Business space problems
-
- Posts: 7525
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
-
- Posts: 7525
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
Done the 2 DROPs and Grr. Error with another index:
Error creating indexes Duplicate key name 'descripcion_I'
I went ahead with the "No previous data" option and this is what I got:
Exception changing status of the business space version Aware IM server encountered the following error. Error creating indexes Duplicate key name 'codigo_I'
I have to say that codigo means code and descripcion means description so those properties exist in all of the BO's. It seems like if Aware IM is incorrectly generating the index names not having into account the table names.
Eduardo.
Error creating indexes Duplicate key name 'descripcion_I'
I went ahead with the "No previous data" option and this is what I got:
Exception changing status of the business space version Aware IM server encountered the following error. Error creating indexes Duplicate key name 'codigo_I'
I have to say that codigo means code and descripcion means description so those properties exist in all of the BO's. It seems like if Aware IM is incorrectly generating the index names not having into account the table names.
Eduardo.
-
- Posts: 7525
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
-
- Posts: 7525
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
Actually just looked at the code and there could be a bug in MySQL or SQL Server (not in Derby). Are you using MySQL or SQL Server?
It does appear not to consider the table name for indexes. We'll check it out immediately. If a bug is confirmed we'll issue a patch. In the meantime the workaround could be to use different names for indexed attributes across business objects, so that indexes are created with unique names.
It does appear not to consider the table name for indexes. We'll check it out immediately. If a bug is confirmed we'll issue a patch. In the meantime the workaround could be to use different names for indexed attributes across business objects, so that indexes are created with unique names.
Aware IM Support Team
Yes, MySQL, check my first message.
Until this, it was working perfectly. I don't think it will be an error.
Please, I just want to reset it and start over. Later, I will import the data from my backup table by table. As I said before, putting it in test mode and saying "No previous data" doesn't work.
Regards,
Eduardo Méndez.
Until this, it was working perfectly. I don't think it will be an error.
Please, I just want to reset it and start over. Later, I will import the data from my backup table by table. As I said before, putting it in test mode and saying "No previous data" doesn't work.
Regards,
Eduardo Méndez.
-
- Posts: 7525
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
I was wrong about the bug - there is no bug and Aware IM does consider table names for MySQL. This problem is a bit of a mystery. Could you send your BSV file to [email protected], so that we can try to reproduce the problem?
In the meantime can you try the following:
1) Export your configuration into a BSV file
2) Delete the entire business space
3) Re-create the business space
4) Import the configuration
5) Publish for testing
In the meantime can you try the following:
1) Export your configuration into a BSV file
2) Delete the entire business space
3) Re-create the business space
4) Import the configuration
5) Publish for testing
Aware IM Support Team