Unable to slice/snapshot from TM1Web: error: 80080005

Error seen by user in GUI:

Internal error occurred while creating MS Excel Workbook :Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80080005

If debug logging is turned on for the TM1ExcelService, then lines similar to the following may be seen in the tm1excelservice.log:

2012-05-14 03:33:52,717 [73] DEBUG Applix.TM1.ExcelApp.ExcelApplication - ES error message set: Internal error occurred while creating MS Excel Workbook : Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80080005.

2012-05-14 03:33:52,717 [73] DEBUG Applix.TM1.ExcelServices.ThreadWithState - Internal error occurred while creating MS Excel Workbook : Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80080005.

System.Runtime.InteropServices.COMException (0x80080005): Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80080005.

Typically, this issue is resolved with a reboot of the TM1 Web machine. If rebooting the web server does not resolve it, also try rebooting the application server. Periodic reboots of servers need to be done to reset memory and allow the machines to run more efficiently. Especially after applying updates, a machine should be rebooted to assure that the changes are written to the registry.

If the reboot does not resolve the problem, try changing the service account user that is running the TM1ExcelService to the Local System account. Restart the service and close/reopen the browser and test again. If it works with the Local System account, then it is likely something in the security of the local admin service account user that is not allowing it to function.

If neither one of those suggestions resolves it, then do the following to begin the troubleshooting process:

- On the web server, stop the TM1ExcelService and IIS.

- Go to the task manager and see if there are multiple EXCEL.EXE processes running. These processes should really only pop up briefly when a slice is being done, then it should disappear, so in a properly functioning environment there shouldn't be multiples that remain running. If there are, manually delete them.

- Go to C:\Inetpub\wwwroot\TM1WebEx\ExcelSheet (default install location) and delete all files in that folder, including the ExcelReport.bin.

- Go to C:\Inetpub\wwwroot\TM1WebEx\UserTempDir and delete all files in that folder, if any.

- Delete the tm1web.log in C:\Inetpub\wwwroot\TM1Web\log so that a new one will be generated.

- Go to the Web.config file, located in C:\Inetpub\wwwroot\TM1Web and apply debug logging according to technote 1459780 (link below).

- Go to the browser on the client machine and clear cache then close the browser and open a new one.

- Attempt the slice again and if the error still appears, WHILE THE ERROR IS STILL UP, make a copy of everything in the ExcelSheet and UserTempDir folders. Repeat with the export to PDF, if PDF is also an issue.

- Open a PMR with Support and attach the newly created tm1server.log, tm1web.log and the tm1excelservice.log, as well as, the files in the ExcelSheet and UserTempDir folders that were captured in the previous step.