When a user tries to update the schema through Strategy Developer 9.x and above, the following error is thrown:
---------------------------
Strategy Developer
---------------------------
Unknown exception caught (in COM methods)
This error is thrown using both a two-tier or a three-tier connection.
Cause 1: This error is thrown when the machine performing the update schema runs out of memory. The memory usage required to update schema increases as more tables are added to the Warehouse Catalog. Therefore, having a large number of source tables is a common cause for this error.
Cause 2: Another probable reason for this error is that Intelligence Server has very old Intelligent Cube cache (around 2+ years) and the schema of the project becomes very inconsistent with the Intelligent Cube cache.
Cause 3: Another possible reason for this error is that Intelligence Server has a problematic Intelligent Cube cache stored in memory.
Action 1: Users should try to increase the memory available for the Developer process. If the schema is being updated on a 32 bit machine, the user may want to consider moving to a 64 bit environment which would utilize more memory for the Developer process. Moreover, if the Intelligence Server and Developer applications reside on the same machine it is strongly recommended to separate them.
Action 2: Verify whether Intelligence Server has very old Intelligent Cube caches and republishing those Intelligent Cubes can resolve this error.
Action 3: Perform a binary search of unloading cubes from memory to identify the specific cube cache(s) leading to the issue. Once identified, deleting and republishing these cubes can resolve this error.
