TM1 Forum

Server Error in '/TM1Web' Application.
Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

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

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[NullReferenceException: Object reference not set to an instance of an object.]
Applix.TM1.Web.WebControls.Websheet.TitleData.ChangeTitleElement(String selectedElement) +69
Applix.TM1.Web.WebControls.Websheet.ViewExData.UpdateTitles() +415
Applix.TM1.Web.WebControls.Websheet.TM1WebActiveReport.CheckForTitleChanges(ActiveReportRecalc mode) +52
Applix.TM1.Web.WebControls.Websheet.TM1WebActiveReport.Evaluate(ActiveReportRecalc mode) +28
Applix.TM1.Web.WebControls.Websheet.TM1WebBook.Recalc(Boolean fullRecalc, ActiveReportRecalc mode) +686
Applix.TM1.Web.WebControls.Websheet.TM1WebBook.Recalc() +8
Applix.TM1.Web.Page.ElementSelectorSession.UpdateCallerSubset() +347
Applix.TM1.Web.Page.ElementSelectorSession.PerformEdit(String operation) +1308
Applix.TM1.Web.Page.SubsetTree.Page_Load(Object sender, EventArgs e) +1563
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +50
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627

Workbook Recalculation Variable TM1REBUILDOPTION
A new calculation model was introduced in TM1 9.4 which forced an automatic recalculation of
all sheets in a workbook, even when the Excel calculation mode was set to Manual. The new model
forced a recalculation upon initial opening of any workbook, upon element selection via a SUBMN
formula, or upon any server connect event.
TM1 9.4 MR1 includes a new workbook name variable, TM1REBUILDOPTION, which lets you
manage calculation in workbooks containing TM1 slices and Active Forms. When you create a
slice or Active Form in TM1 9.4 MR1, the TM1REBUILDOPTION name is automatically created
in the corresponding Excel workbook and set to 1, indicating that all worksheets in the current
workbook should be rebuilt and recalculated when a TM1 server connect event occurs.
If TM1REBUILDOPTION is present in a workbook and set to 0, or if TM1REBUILDOPTION is
not present in a workbook, worksheets are not rebuilt/recalculated when a server connect event
occurs.
Modifying the TM1REBUILDOPTION Setting
If you do not want workbooks created with TM1 9.4 MR1 to automatically rebuild and recalculate
all slices and Active Forms when a server connect event occurs, you can set the TM1REBUILDOPTION
value to 0.
Steps
1. In Excel, click Insert, Name, Define.
2. In the Define Name dialog box, select TM1REBUILDOPTION.
3. Set the value in the Refers to box to =0.
4. Click OK.

RLReyes wrote:This may or may not help. It's worth giving it a shot. This is from IBM Cognos' release notes. You may need TM1MR1 File Patch 1.

Workbook Recalculation Variable TM1REBUILDOPTION
A new calculation model was introduced in TM1 9.4 which forced an automatic recalculation of
all sheets in a workbook, even when the Excel calculation mode was set to Manual. The new model
forced a recalculation upon initial opening of any workbook, upon element selection via a SUBMN
formula, or upon any server connect event.
TM1 9.4 MR1 includes a new workbook name variable, TM1REBUILDOPTION, which lets you
manage calculation in workbooks containing TM1 slices and Active Forms. When you create a
slice or Active Form in TM1 9.4 MR1, the TM1REBUILDOPTION name is automatically created
in the corresponding Excel workbook and set to 1, indicating that all worksheets in the current
workbook should be rebuilt and recalculated when a TM1 server connect event occurs.
If TM1REBUILDOPTION is present in a workbook and set to 0, or if TM1REBUILDOPTION is
not present in a workbook, worksheets are not rebuilt/recalculated when a server connect event
occurs.
Modifying the TM1REBUILDOPTION Setting
If you do not want workbooks created with TM1 9.4 MR1 to automatically rebuild and recalculate
all slices and Active Forms when a server connect event occurs, you can set the TM1REBUILDOPTION
value to 0.
Steps
1. In Excel, click Insert, Name, Define.
2. In the Define Name dialog box, select TM1REBUILDOPTION.
3. Set the value in the Refers to box to =0.
4. Click OK.

nhavis wrote:Can anyone confirm that this works as specified?