企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 2677|回复: 6

TM1 Web Issue - Vista

[复制链接]

96

主题

400

帖子

617

积分

高级会员

Rank: 4

积分
617
QQ
发表于 2014-6-27 20:51:41 | 显示全部楼层 |阅读模式
Hi all,
I've encountered the following error when I login to my TM1 web: -
Error occurred while converting the MS Excel workbook into XML format: Object reference not set to an insance of an object.::Internal Error:The file could not be opened.

I have tried to change the setting in Component Services - MS Excel Application. And, the problem still persists.
回复

使用道具 举报

86

主题

396

帖子

584

积分

高级会员

Rank: 4

积分
584
QQ
发表于 2014-6-27 21:53:42 | 显示全部楼层
I have encountered this error so many times. There could be a lot of reasons behind it. Is this the problem with all the spreadsheets or is that just one sheet which is causing the problem?

Your spreadsheets could have some Object which TM1Web is having difficulty in displaying.

Also have you tried restarting the TM1 Excel windows service?
回复 支持 反对

使用道具 举报

71

主题

393

帖子

560

积分

高级会员

Rank: 4

积分
560
QQ
发表于 2014-6-27 22:02:35 | 显示全部楼层
It applied to all my excel file.  And, I've reboot the PC for few times and the problem still exist.
回复 支持 反对

使用道具 举报

66

主题

363

帖子

518

积分

高级会员

Rank: 4

积分
518
QQ
发表于 2014-6-27 22:09:05 | 显示全部楼层
I did get this error once and as I said before there could be so many things which could cause this problem.

1)In Excel, create a new workbook. Do not connect to TM1. Type something in only 1 cell. Save this files as Excel 2003 format (*.XLS). Upload it to Applications in TM1. Now try to open it in TM1web.
Make sure your excel files do not contain objects which are not supported in TM1Web e.g combo boxes etc.
2) Go to C:InetpubwwwrootTM1WebExExcelSheet and check if any *.XLS and *.XML files exists.
3) check and confirm that the TM1 Excel Service is configured to run under an account that is also an administrator on that local machine?
4) Exclude the following folders from your Virus scan:
c:InetpubwwwrootTM1Web
c:InetpubwwwrootTM1WebEx
5) Delete all files in the ExcelSheet and UserTempDir folders (these are temp files) and then restart your TM1ExcelService and IIS.
6) Check the tm1excelservice.log file. There might be some information in that file.
7) If you are on 64-bit then make sure you add LockPagesInMemory=T set in your tm1s.cfg file. Restart the TM1 services after you change this.

Hope this helps.
回复 支持 反对

使用道具 举报

91

主题

407

帖子

615

积分

高级会员

Rank: 4

积分
615
QQ
发表于 2014-6-27 22:50:16 | 显示全部楼层
Hi,

For the benefits of others... I had the following error message "an error occured while converting the MS Excel workbook into XML format : object reference not set to an instance of an object"... I had this error with some files but NOT ALL ? I am using TM1 V9.5.1 with Excel 2003 SP3...
After investigation on the workbook I realised the issue was caused by some conditional formatting. Funny enough I am using conditional formatting on TM1Web with other workbooks without any problems... For this particular workbook I did not want conditional formatting anyway, this was only copied unintentionally? so I just removed the conditional formatting and it solved the problem.

Hope that will be useful to someone one day!

Nick
回复 支持 反对

使用道具 举报

85

主题

419

帖子

604

积分

高级会员

Rank: 4

积分
604
QQ
发表于 2014-6-28 00:48:55 | 显示全部楼层
Hi,

You should also check your Webserver's TM1Web log file
typicaly located in C:InetpubwwwrootTM1Weblog


The messages are sometimes cryptic but can also give you valuable clues on what is wrong.

Hope this helps.
回复 支持 反对

使用道具 举报

69

主题

365

帖子

518

积分

高级会员

Rank: 4

积分
518
QQ
发表于 2014-6-28 01:05:13 | 显示全部楼层
yeap - me also, conditional formatting with background fills etc works, conditional formatting number format e.g. number to % of total gives me that error..

TM1web log errors:

2012-02-21 19:51:21,323 [15] ERROR Applix.TM1.Web.WebControls.TM1WebUtils - <Cannot connect to TM1 ExcelServices : > not localized.

and


2012-02-13 14:41:13,000 [9] ERROR Applix.TM1.Web.Page.TM1WebPageUtils - <AVAILABLE> not localized.
2012-02-13 14:41:22,025 [9] ERROR Applix.TM1.Web.Page.TM1WebPageUtils - <System Parameter Type Invalid> not localized.
2012-02-13 14:41:22,026 [9] ERROR Applix.TM1.Web.Page.TM1WebPageUtils - <System Parameter Type Invalid> not localized.
2012-02-13 14:41:27,101 [9] ERROR Applix.TM1.Web.Page.TM1WebPageUtils - <AVAILABLE> not localized.
2012-02-13 14:41:29,316 [7] ERROR Applix.TM1.Web.Page.TM1WebPageUtils - <System Parameter Type Invalid> not localized.
2012-02-13 14:41:29,316 [7] ERROR Applix.TM1.Web.Page.TM1WebPageUtils - <System Parameter Type Invalid> not localized.
2012-02-13 14:41:33,649 [5] ERROR Applix.TM1.Web.Page.TM1WebPageUtils - <AVAILABLE> not localized.
2012-02-13 14:41:39,169 [7] ERROR Applix.TM1.Web.Page.TM1WebPageUtils - <AVAILABLE> not localized.
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|小黑屋|企业绩效管理网 ( 京ICP备14007298号   

GMT+8, 2022-12-1 11:52 , Processed in 0.070529 second(s), 11 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表