SYMPTOM:
The error below occurs when trying to republish certain Data Import created Intelligent Cubes after upgrading a metadata from version 9 to version 10. This does not happen with all cubes.
At least one of the tables in EMMA cube fails when discovering data from data source
CAUSE:This issue occurs because there are some inconsistent objects within the cube definition. Those objects were already inconsistent in the pre-upgraded cube, however the issue is only exposed after the upgrade to version 10.x.
ACTION:Contact Strategy Technical Support for assistance on identifying the root cause of the error.