TM1 Forum

Hello,

I've installed TM1 9.5.2 on a Windows 2008 64 bits server, and Cognos C10.

TM1Web works in terms of navigating in the cubes. But I can't make Excel work, either through export functionnality (in views), or when trying to open an Excel file published in an application. TM1ExcelServices service is running.

The error message I get is the following:
Cannot connect to TM1 ExcelServices : No connection could be made because the target machine actively refused it <IP Address>:4785

I first followed IBM procedure which fits perfectly the error message I get but the problem remains:
https://www-304.ibm.com/support/docview ... wg21456709

I also tried to solve it through changing/checking different points:
1. "There is also a well known (but not very well documented) bug where any export to Excel or PDF from TM1 web will fail if there is any remote desktop session open on the server."
--> That's not the case.
2. I checked Security Internet options like specified in the following link:
https://www-304.ibm.com/support/docview ... wg21417326
3. The TM1ExcelService is running but the IUSER account does not have sufficient access to the TM1WebEx directory (solution, fix the security of the TM1WebEx folder within the TM1 web virtual directory)
--> That's not the case.
4. Excel sessions used by TM1 web and the TM1ExcelService (for initial rendering and for exports from web page to excel or pdf) have not closed correctly and are in a "hung" state (solution, terminate the hung excel processes on the web server)
--> That's not the case.

Any other suggestion would be welcome because I do not know anymore what to try !
Thanks

Hello, we made some tests with Excel Services on the last weeks (but on 2003 64x), I hope this options can help:

1. The account that is used to logon in to the Excel Services (windows service) has permits to execute it? did you check using the local system account to start the windows service to check if it works.
2. Are you saving files as xlsx? did you tried publishing 2003 format (xls)
3. ExcelWebPublishEnabled on the cfg? Enables the publication of Excel files to TM1® Web, as well as the export of Excel files from TM1 Web, when Excel is not installed on the Web Server. (Check the operations manual if is the case)

Luck,

Cam wrote: 1. The account that is used to logon in to the Excel Services (windows service) has permits to execute it? did you check using the local system account to start the windows service to check if it works.

The account used for the TM1ExcelServices is an administrator and therefore has the maximum level of rights.

Cam wrote: 2. Are you saving files as xlsx? did you tried publishing 2003 format (xls)

I tried with xlsx, and with xls format.

Cam wrote: 3. ExcelWebPublishEnabled on the cfg? Enables the publication of Excel files to TM1® Web, as well as the export of Excel files from TM1 Web, when Excel is not installed on the Web Server. (Check the operations manual if is the case)

I do not need this parameter as Excel is installed on the server (everything is on the same machine).

Any other ideas?
Thanks