TM1 9.5.1 Tm1 Excel servces: no connection ..

[edward]

Hi,

Can someone please help me. I am currently installed tm1 9.5.1 on VM with win 2008 r2 64 bit. I managed to log on to the TM1 web and I was able to view the cubes. Once I click one of the websheets, I get an error

Cannont conenct to TM1 ExcelSercives: No connection could be made because the target machine actively refused it (server IP address and the port number)

The excel service is running and when I try to get the what ports are used port (netstat), I am able to find the port number assinged.

from the error log:

2011-04-06 11:40:21,619 [10] ERROR Applix.TM1.Web.WebControls.TM1WebUtils - <Cannot connect to TM1 ExcelServices : > not localized.
2011-04-06 11:40:21,619 [10] ERROR Applix.TM1.Web.WebControls.TM1WebApplication - Exception occurred while checking for xlsx support in ES
System.ApplicationException: Cannot connect to TM1 ExcelServices : No connection could be made because the target machine actively refused it (server IP address and the port number)
at Applix.TM1.Web.WebControls.TM1WebUtils.ConnectToExcelServices()
at Applix.TM1.Web.WebControls.TM1WebApplication.get_isXLSXsupportedEX()
2011-04-06 11:40:28,151 [10] ERROR Applix.TM1.Web.WebControls.TM1WebUtils - <Cannot connect to TM1 ExcelServices : > not localized.

Thanking you

Ed

[Marcus Scherer]

Hi Ed,
this error may appear if Excel reports were edited in two different versions (2003/2007). Restart service, create a new report in one version, publish it. Report should run fine. If you then run one of the corrupted ones then .. Puff! again for all available reports.

Ciao,
Marcus

[BigG]

Hi, excel service may not like the local system account, set up a domain account and use this to start services?

[moby91]

As you are using Windows Server 2008 R2, and as you get the error message "Cannot connect to TM1 ExcelService", what are the settings of the Windows Firewall for the TCP Port 4785 used by the Windows Service TM1ExcelService.exe ?


For a detailed step-by-step description on how to configure the Windows Firewall to enable TM1 and TM1 Web see the website

http://tm1resources.com/index.php?optio ... 3&Itemid=1
Installing IBM Cognos TM1 9.5.1 on Windows 2008 R2 Architecture Part 3

[edward]

Hi Ed,
this error may appear if Excel reports were edited in two different versions (2003/2007). Restart service, create a new report in one version, publish it. Report should run fine. If you then run one of the corrupted ones then .. Puff! again for all available reports.

Ciao,
Marcus

HI Marcus,

You are correct that the file could have been edited with 2 different versions. I wil try to create just one version. What it puzzles me is in our Production, we don't have any problem. Only on our VM machines that seems to have that problem. Production has 9.4.1 and also one of our test VM with the same specs also has an error.

Thanking you

Ed

[edward]

Hi, excel service may not like the local system account, set up a domain account and use this to start services?

Hi BigG,

excel service has a domain account already..

Thanking you

Ed

[edward]

As you are using Windows Server 2008 R2, and as you get the error message "Cannot connect to TM1 ExcelService", what are the settings of the Windows Firewall for the TCP Port 4785 used by the Windows Service TM1ExcelService.exe ?


For a detailed step-by-step description on how to configure the Windows Firewall to enable TM1 and TM1 Web see the website

http://tm1resources.com/index.php?optio ... 3&Itemid=1
Installing IBM Cognos TM1 9.5.1 on Windows 2008 R2 Architecture Part 3

Hi Moby91,

The setting for TCP Port 4785 has allow. Tried to create a rule anyway and still no avail.

Thanking you

Ed

[BigG]

What it puzzles me is in our Production, we don't have any problem. Only on our VM machines that seems to have that problem. Production has 9.4.1 and also one of our test VM with the same specs also has an error

Ironically 9.4 does not support Windows Server 2008 R2, but the 9.5.1 does. If you are running your production 9.4 in Windows Server 2008 R2 and everything is fine then welldone. The good thing though is your broken environment is supported so IBM will help you with this one - have you raised this with IBM. Windows Server 2008 R2 has manymore security configurations that may be affecting your TM1 application and excel services

[edward]

What it puzzles me is in our Production, we don't have any problem. Only on our VM machines that seems to have that problem. Production has 9.4.1 and also one of our test VM with the same specs also has an error

Ironically 9.4 does not support Windows Server 2008 R2, but the 9.5.1 does. If you are running your production 9.4 in Windows Server 2008 R2 and everything is fine then welldone. The good thing though is your broken environment is supported so IBM will help you with this one - have you raised this with IBM. Windows Server 2008 R2 has manymore security configurations that may be affecting your TM1 application and excel services

Apologies BigG

Our Production and Test VM has Windows 2003 R2 Std, I haven't advised IBM yet and will log this issue.

[edward]

Hi Ed,
this error may appear if Excel reports were edited in two different versions (2003/2007). Restart service, create a new report in one version, publish it. Report should run fine. If you then run one of the corrupted ones then .. Puff! again for all available reports.

Ciao,
Marcus

HI Marcus,

You are correct that the file could have been edited with 2 different versions. I wil try to create just one version. What it puzzles me is in our Production, we don't have any problem. Only on our VM machines that seems to have that problem. Production has 9.4.1 and also one of our test VM with the same specs also has an error.

Thanking you

Ed

Hi Marcus,

Even with newly created file still have the same issue.

Thanking you

Edward

[edward]

Managed to fix the issue. Changed the account in the services to have admin rights, however, I have new issue now with I am trying to export to excel or pdf.

2011-05-12 09:10:40,944 [6] ERROR Applix.TM1.Web.WebControls.Websheet.TM1WebFormula - An unexpected error occurred while evaluating TM1WebFormula: "='\MGD\Feasibilities\Proforma Feasibilities\[Proforma Single Tenant Single Stage.xls]Drop Down & Form Cells Menu'!R22C4:R24C4" in NR DevType Feasibility Report - Summary Feasibility Report - Summary.xls

System.NullReferenceException: Object reference not set to an instance of an object.

at Applix.TM1.Web.WebControls.Websheet.FormulaParser.PtgRef.GetAbsoluteRow(ITM1WebObject parent)

at Applix.TM1.Web.WebControls.Websheet.FormulaParser.PtgRef.GetCellPosition(ITM1WebObject parent)

at Applix.TM1.Web.WebControls.Websheet.FormulaParser.PtgArea.Evaluate(Stack stack, ITM1WebObject parent)

at Applix.TM1.Web.WebControls.Websheet.TM1WebFormula.Evaluate(ITM1WebObject parent)

2011-05-12 09:10:41,131 [6] ERROR Applix.TM1.Web.WebControls.Websheet.TM1WebFormula - An unexpected error occurred while evaluating TM1WebFormula: "='http://intranet/magi/cmsaxs/main/images/[DM Input Feasibility - 30-06-03.xls]Cost Link'!R27C1:R28C1" in NR Yes Feasibility Report - Summary Feasibility Report - Summary.xls

System.NullReferenceException: Object reference not set to an instance of an object.

at Applix.TM1.Web.WebControls.Websheet.FormulaParser.PtgRef.GetAbsoluteRow(ITM1WebObject parent)

at Applix.TM1.Web.WebControls.Websheet.FormulaParser.PtgRef.GetCellPosition(ITM1WebObject parent)

at Applix.TM1.Web.WebControls.Websheet.FormulaParser.PtgArea.Evaluate(Stack stack, ITM1WebObject parent)

at Applix.TM1.Web.WebControls.Websheet.TM1WebFormula.Evaluate(ITM1WebObject parent)

2011-05-12 09:10:41,709 [6] ERROR Applix.TM1.Web.Page.TM1WebError - Error in: http://tm1web/TM1WebSheet.aspx?ObjectId=22639330

2011-05-12 09:10:41,709 [6] ERROR Applix.TM1.Web.Page.TM1WebError - Request Info - Browser: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729), User Host Name: 192.168.10.167, Method: POST, Encoding: System.Text.UTF8Encoding, Content Length: 325, Content Type: application/x-www-form-urlencoded

2011-05-12 09:10:41,709 [6] ERROR Applix.TM1.Web.Page.TM1WebError - Action Type: SNAPSHOT

2011-05-12 09:10:41,709 [6] ERROR Applix.TM1.Web.Page.TM1WebError - Value:

2011-05-12 09:10:41,709 [6] ERROR Applix.TM1.Web.Page.TM1WebError - Error Details:

System.NullReferenceException: Object reference not set to an instance of an object.

at Applix.TM1.Web.WebControls.Websheet.FormulaParser.PtgRef.GetAbsoluteRow(ITM1WebObject parent)

at Applix.TM1.Web.WebControls.Websheet.FormulaParser.PtgRef.ToStringSheetNameOptional(Stack stack, Boolean omitBadRefs, Boolean withSheetNameIfExists, ITM1WebObject parent)

at Applix.TM1.Web.WebControls.Websheet.FormulaParser.PtgRef.ToString(Stack stack, Boolean omitBadRefs, ITM1WebObject parent)

at Applix.TM1.Web.WebControls.Websheet.FormulaParser.PtgArea.ToString(Stack stack, Boolean omitBadRefs, ITM1WebObject parent)

at Applix.TM1.Web.WebControls.Websheet.TM1WebBook.UpdateNamesXmlFromNamedRangeCollection(XmlNode namesNode, TM1WebNamesCollection namesCollection)

at Applix.TM1.Web.WebControls.Websheet.TM1WebBook.UpdateNamedRangesToXmlDocument(XmlNodeList nl)

at Applix.TM1.Web.WebControls.Websheet.TM1WebBook.UpdateCellchangesToXmlDocument(TM1ExcelServiceCommands command)

at Applix.TM1.Web.WebControls.Websheet.TM1WebBook.CreateXmlFile(TM1ExcelServiceCommands command)

at Applix.TM1.Web.WebControls.Export.TM1Export.RequestExportJob(TM1WebBook sourceWebBook, TM1ExcelServiceCommands command, String titleDims)

at Applix.TM1.Web.WebControls.Websheet.TM1WebBook.RequestWebSheetExportJob(TM1ExcelServiceCommands command, String titleDims)

at Applix.TM1.Web.Page.TM1WebSheet.Page_Load(Object sender, EventArgs e)

at System.Web.UI.Control.OnLoad(EventArgs e)

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

2011-05-12 09:12:11,849 [5] ERROR Applix.TM1.Web.WebControls.Websheet.TM1WebFormula - An unexpected error occurred while evaluating TM1WebFormula: "='\MGD\Feasibilities\Proforma Feasibilities\[Proforma Single Tenant Single Stage.xls]Drop Down & Form Cells Menu'!R22C4:R24C4" in NR DevType Data Data.xls

System.NullReferenceException: Object reference not set to an instance of an object.

at Applix.TM1.Web.WebControls.Websheet.FormulaParser.PtgRef.GetAbsoluteRow(ITM1WebObject parent)

at Applix.TM1.Web.WebControls.Websheet.FormulaParser.PtgRef.GetCellPosition(ITM1WebObject parent)

at Applix.TM1.Web.WebControls.Websheet.FormulaParser.PtgArea.Evaluate(Stack stack, ITM1WebObject parent)

at Applix.TM1.Web.WebControls.Websheet.TM1WebFormula.Evaluate(ITM1WebObject parent)

2011-05-12 09:12:11,849 [5] ERROR Applix.TM1.Web.WebControls.Websheet.TM1WebFormula - An unexpected error occurred while evaluating TM1WebFormula: "='http://intranet/magi/cmsaxs/main/images/[DM Input Feasibility - 30-06-03.xls]Cost Link'!R27C1:R28C1" in NR Yes Data Data.xls

System.NullReferenceException: Object reference not set to an instance of an object.

at Applix.TM1.Web.WebControls.Websheet.FormulaParser.PtgRef.GetAbsoluteRow(ITM1WebObject parent)

at Applix.TM1.Web.WebControls.Websheet.FormulaParser.PtgRef.GetCellPosition(ITM1WebObject parent)

at Applix.TM1.Web.WebControls.Websheet.FormulaParser.PtgArea.Evaluate(Stack stack, ITM1WebObject parent)

at Applix.TM1.Web.WebControls.Websheet.TM1WebFormula.Evaluate(ITM1WebObject parent)

2011-05-12 09:12:14,599 [5] ERROR Applix.TM1.Web.Page.TM1WebError - Error in: http://tm1web/TM1WebSheet.aspx?ObjectId=30207786

2011-05-12 09:12:14,615 [5] ERROR Applix.TM1.Web.Page.TM1WebError - Request Info - Browser: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729), User Host Name: 192.168.10.167, Method: POST, Encoding: System.Text.UTF8Encoding, Content Length: 328, Content Type: application/x-www-form-urlencoded

2011-05-12 09:12:14,615 [5] ERROR Applix.TM1.Web.Page.TM1WebError - Action Type: SNAPSHOT

2011-05-12 09:12:14,615 [5] ERROR Applix.TM1.Web.Page.TM1WebError - Value:

2011-05-12 09:12:14,615 [5] ERROR Applix.TM1.Web.Page.TM1WebError - Error Details:

System.NullReferenceException: Object reference not set to an instance of an object.

at Applix.TM1.Web.WebControls.Websheet.FormulaParser.PtgRef.GetAbsoluteRow(ITM1WebObject parent)

at Applix.TM1.Web.WebControls.Websheet.FormulaParser.PtgRef.ToStringSheetNameOptional(Stack stack, Boolean omitBadRefs, Boolean withSheetNameIfExists, ITM1WebObject parent)

at Applix.TM1.Web.WebControls.Websheet.FormulaParser.PtgRef.ToString(Stack stack, Boolean omitBadRefs, ITM1WebObject parent)

at Applix.TM1.Web.WebControls.Websheet.FormulaParser.PtgArea.ToString(Stack stack, Boolean omitBadRefs, ITM1WebObject parent)

at Applix.TM1.Web.WebControls.Websheet.TM1WebBook.UpdateNamesXmlFromNamedRangeCollection(XmlNode namesNode, TM1WebNamesCollection namesCollection)

at Applix.TM1.Web.WebControls.Websheet.TM1WebBook.UpdateNamedRangesToXmlDocument(XmlNodeList nl)

at Applix.TM1.Web.WebControls.Websheet.TM1WebBook.UpdateCellchangesToXmlDocument(TM1ExcelServiceCommands command)

at Applix.TM1.Web.WebControls.Websheet.TM1WebBook.CreateXmlFile(TM1ExcelServiceCommands command)

at Applix.TM1.Web.WebControls.Export.TM1Export.RequestExportJob(TM1WebBook sourceWebBook, TM1ExcelServiceCommands command, String titleDims)

at Applix.TM1.Web.WebControls.Websheet.TM1WebBook.RequestWebSheetExportJob(TM1ExcelServiceCommands command, String titleDims)

at Applix.TM1.Web.Page.TM1WebSheet.Page_Load(Object sender, EventArgs e)

at System.Web.UI.Control.OnLoad(EventArgs e)

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Thanks

Ed

[BigG]

Hi, what browser are you using, is it supported?

Also on the server is the PDFCamp installed and running, also make sure the Tm1 excel service starts (even try to delay the start or make it dependant on the print spooler) after the PDFCamp printer setting has bstarted (after server restart). maybe just try and restarting the tm1 excel service after checking PDFCamp is running

[edward]

Hi BigG,

PDFcamp is running and browser is supported. I am able to export to excel and PDF via the cube in TM1 Web, however, I can't to export when access the websheets. In 9.4.1 has no problem only on 9.5.1 or 9.5.2.

Thanking you

Edward

[BigG]

maybe create a very simple websheet and see if its successful

also, Tools > Internet Options > Security > allow downloads or some similar setting. But if tm1web works cant understand why websheets wouldnt.

[edward]

a simple excel websheet is successul ... can't seem to see why the other ones are not be able to export ...

[BigG]

this may be the issue?
https://www-304.ibm.com/support/docview ... wg21472396

think there is a way to trace the error in logs somhow, but cant remember this method or location of files for tm1 web excel...