TM1 Web - can't open report

[Martin Ryan]

I'm getting an error creating a TM1 Web report that seems slightly different from all the others I've found on the forum - or at least following their suggestions hasn't fixed it.

The important part of the error (see screenshot) seems to be "Microsoft Excel cannot access the file", but I've checked security is lax, and that I can open it using Excel normally, so it must mean the service can't open it. TM1 Excel Service is running as Local System and has been restarted a few times.

I'm using Windows 7, Excel 2010 (but the document is 97-2003 format), TM1 9.5.1

Error from the service log is:

2010-09-27 14:11:24,744 [6] ERROR Applix.TM1.ExcelApp.ExcelApplication - Could Not Get Region Specific (html folder) Info :
System.Runtime.InteropServices.COMException (0x800A03EC): Exception from HRESULT: 0x800A03EC
at Microsoft.Office.Interop.Excel.WorkbookClass.SaveAs(Object Filename, Object FileFormat, Object Password, Object WriteResPassword, Object ReadOnlyRecommended, Object CreateBackup, XlSaveAsAccessMode AccessMode, Object ConflictResolution, Object AddToMru, Object TextCodepage, Object TextVisualLayout, Object Local)
at Applix.TM1.ExcelApp.ExcelApplication.GetSeriesFormulaRegionInfo()
2010-09-27 14:11:24,760 [6] ERROR Applix.TM1.ExcelApp.ExcelApplication - Excel could not open Xls file:
System.Runtime.InteropServices.COMException (0x800A03EC): Microsoft Excel cannot access the file 'C:\inetpub\wwwroot\TM1WebEx\ExcelSheet\41373378350312.xls'. There are several possible reasons:

• The file name or path does not exist.
• The file is being used by another program.
• The workbook you are trying to save has the same name as a currently open workbook.
at Microsoft.Office.Interop.Excel.Workbooks.Open(String Filename, Object UpdateLinks, Object ReadOnly, Object Format, Object Password, Object WriteResPassword, Object IgnoreReadOnlyRecommended, Object Origin, Object Delimiter, Object Editable, Object Notify, Object Converter, Object AddToMru, Object Local, Object CorruptLoad)
at Applix.TM1.ExcelApp.ExcelApplication.OpenFile()

tm1web.png (30.5 KiB) Viewed 6195 times

[John Hammond]

Martin

IIRC correctly I got this error when the excel sheet contained a function unsupported by TM1 web Excel.

Once you get this error it persists and excel sheets that worked before with TM1 web will not work. Looking in Process Explorer shows the TM1 excel translation service holding the spreadsheet continuously open. You have to re-cycle the TM1 excel service and things will return to normal.

Hope this helps it was a long time ago this happened tho.

Regards

John

[Martin Ryan]

No such luck. I just created a simple =a1*b1 formula after a machine restart, and it still fell over.

Martin

[Neil Watson]

Hey there Martin,

The issue probably lies with Excel 2010. Although the xls is in an old version won't the rendering still be done using Excel 2010. As yet this version, even in 9.5, is unsupported.

I suspect the whole point of this was to establish if it worked though! If you install Excel 2003 or 2007 does it work then?

Supported versions can be found here: http://www-01.ibm.com/support/docview.w ... wg27017362

Good Luck
Neil

[Martin Ryan]

After installing Excel 2007, then reinstalling TM1 I found the problem. Local System doesn't have permission for the directory. Once I set the Excel Service to run as an administrator it was fine.

Kinda obvious now that I think about it. Though I had been labouring under the impression that Local System could do anything locally. Evidently not.

Martin