The client reported an issue with not being able to process OLAP cubes after returning to work after being away on holiday.
It was pretty clear from the error, what the issue was - missing OLAP client components and after a quick investigation it was discovered that the client's PC had been rebuilt with Windows 7.
But after installing the required OLAP client components we still couldn't update OLAP cubes.
The error we were now getting was:
Method 'connect' in COM object of class '{B492C386-0195-11D2-89BA-00C04FB9898D}' returned error code 0x800A0005 () which means: The connection string to repository needs to be specified in the 9.0 server properties (see ... section in msmdsrv.ini file from Analysis Services 9.0).
Upon further investigation it was discovered that the OLAP version which is stored in the AX database was reset to SQL 2000. This is apparently a known issue that sometimes happens when you try to connect to OLAP from a PC that doesn't have the client tools installed. Even if you install them later on this doesn't fix the issue. You need to go into the OLAPServer table in AX and manually set the OLAP version back to SQL 2005.
No comments:
Post a Comment