Error: Exception changing status of business space version

Herbert · Post by **Herbert** » Tue Nov 13, 2007 1:27 pm

When I try to do a first Test of a new business space (just configured several business objects, nothing more) I get this error:

[b]"Exception changing status of business space version Aware Im server encountered the following error .Error creating indexes Duplicate key name 'I1738547712'"[/b]

I've already tried several things (besides searching here for the same error...), eg. Shuting/restarting, exporting/deleting/importing the version - all to no avail.
I simply cannot do anything, neither test nor publish - I'm stuck!
I even did a re-install of the trial-version - and btw. I'm using MySQL as the database.

Thanks a lot for your help!
Herbert

aware_support · Post by **aware_support** » Tue Nov 13, 2007 10:17 pm

Could you please send your BSV file to [email protected]

In the meantime please do the following:

1. Export your configuration in the BSV file
2. Delete your business space
3. Create business space again
4. Import your BSV
5. UNTICK "Indexed" flag in all your attributes

aware_support · Post by **aware_support** » Fri Nov 16, 2007 7:09 am

This problem can happen if you have 2 business objects and a combination of object name + attribute name in one object is the same as in another object and both attributes are indexed. For example,

1. Object named A with attribute named BC
2. Object named AB with attribute C

combination of object + attribute name is the same for both objects (ABC). If the attribute BC in object A and C in object AB are indexed we may have the above problem.

The workaround is simple - rename either objects or attributes to avoid this combination