TM1 Forum

Posted: **Mon Jan 31, 2011 11:47 pm**

Hi,

We have a TM1 websheet (TM1 9.4) with a few 'buttons' to run a TI process, rebuild active form or jump to another websheet. This works well when you initially access the websheet - everything seems fine. But then after a few user changes to subset selections and rerunning the process we get a vague error. This is repeatable for many users so not user specific. I have gone to the TM1web.log and get the following messages

Code: Select all

2011-02-01 08:48:04,401 [1] ERROR Applix.TM1.Web.Page.TM1WebError - Error in: http://cognosserver/TM1Web/TM1WebSheet.aspx?ObjectId=52983808
2011-02-01 08:48:04,401 [1] ERROR Applix.TM1.Web.Page.TM1WebError - Request Info -  Browser: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 1.1.4322; .NET CLR 3.0.04506.648; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; FKPSOE20; FKPSOE20), User Host Name: 192.XXX.1.XXX, Method: POST, Encoding: System.Text.UTF8Encoding, Content Length: 314, Content Type: application/x-www-form-urlencoded
2011-02-01 08:48:04,401 [1] ERROR Applix.TM1.Web.Page.TM1WebError - Action Type: WS_TIBtnClick
2011-02-01 08:48:04,401 [1] ERROR Applix.TM1.Web.Page.TM1WebError - Value: TIButton_0
2011-02-01 08:48:04,401 [1] ERROR Applix.TM1.Web.Page.TM1WebError - Error Details:
System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
   at System.ThrowHelper.ThrowKeyNotFoundException()
   at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
   at Applix.TM1.Web.WebControls.Websheet.TM1WebSheet.get_ActiveCell()
   at Applix.TM1.Web.WebControls.Websheet.TM1WebTIButton.DoClick()
   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)

or

Code: Select all

2011-02-01 09:03:51,204 [7] ERROR Applix.TM1.Web.WebControls.Websheet.FormulaParser.PtgFunc - An unexpected error occurred while evaluating PtgFunc
System.NullReferenceException: Object reference not set to an instance of an object.
   at Applix.TM1.Web.WebControls.Websheet.FormulaParser.TM1Funcs.ConvertPTGReferenceToA1String(Ptg aRef)
   at Applix.TM1.Web.WebControls.Websheet.FormulaParser.TM1Funcs.ViewArgEx(ITM1WebObject parent, ArrayList args)
   at Applix.TM1.Web.WebControls.Websheet.FormulaParser.TM1Funcs.TITLEEX(ITM1WebObject parent, ArrayList args)
   at Applix.TM1.Web.WebControls.Websheet.FormulaParser.PtgFunc.Evaluate(Stack stack)

the user message:

: ERROR.png (50.28 KiB) Viewed 4063 times

Posted: **Wed Feb 02, 2011 2:59 am**

Cognos reply.. seems like you need to upgrade. Note although I said 9.4 TM1 its actually Cognos Express 9.0 (which is TM1 9.4)

COGNOS EMAIL
"As discussed in yesterdays phone call, I believe you have hit a know defect that has been fixed in TM1 v9.4.1 FP2 HF16. Unfortunately TM1 specific hotfixes are not supported for Cognos Express but this fix is available in CX v9.5 which was released last week. My recommendation would be for you to upgrade to this version.

It is available on Passport Advantage, please see below instructions for this download:

Please let me know how you decide to proceed."

Posted: **Thu Feb 03, 2011 5:04 pm**

Hi BigG,

We used to get this error in our TM1 9.5.1 web sheets for budgets. Yo can try doing a "iisreset" from start --> run -->cmd . It got resolved for us with iisreset.

Posted: **Thu Feb 03, 2011 10:52 pm**

Cheers anoops81, just tried that and still replicating the error... will continue to look for a solution.

TM1 Forum

TM1 web button error

TM1 web button error

Re: TM1 web button error

Re: TM1 web button error

Re: TM1 web button error