CellRange is invalid when showing Trial Balance

Product:
Cognos Controller 8.4 FixPack 1

Symptom:
User is trying to print a standard report as Trail Balance to there printer in there office, or try to send the report to a application like Microsoft Excel 2003.
They get a Cognos controller error when doing this.
Click OK and they are back in Cognos Controller.

This only happens for a few users, other users can successfully print the trail balance report.
The users having the issue are running Cognos Controller in a Citrix Farm.

Problem:
Error message when showing Trial Balance.

Error message in windows event log:


Event Type: Warning
Event Source: Cognos Controller
Event Category: None
Event ID: 0
Date: 2010-01-14
Time: 06:34:22
User: N/A
Computer: CITRIXSERVER
Description:
Standard Error
Source: C1.Win.C1FlexGrid.2
Description: CellRange is invalid.
at C1.Win.C1FlexGrid.CellRange.d()
at C1.Win.C1FlexGrid.CellRange.get_Clip()
at C1.Win.C1FlexGrid.Classic.C1FlexGridClassic.get_Cell(CellPropertySettings setting, Int32 row1, Int32 col1, Int32 row2, Int32 col2)
at C1.Win.C1FlexGrid.Classic.C1FlexGridClassic.get_Cell(CellPropertySettings setting, Int32 row, Int32 col)
at Cognos.Controller.Forms.Form.frmTrialBalance.DrillSet()
at Cognos.Controller.Forms.Form.frmTrialBalance.grdReport_RowColChange(Object eventSender, EventArgs eventArgs)
at C1.Win.C1FlexGrid.C1FlexGridBase.OnRowColChange(EventArgs e)
at C1.Win.C1FlexGrid.C1FlexGridBase.bb()
at C1.Win.C1FlexGrid.C1FlexGridBase.OnGridChanged(Object sender, GridChangedEventArgs e)
at C1.Win.C1FlexGrid.C1FlexGrid.OnGridChanged(Object sender, GridChangedEventArgs e)
at C1.Win.C1FlexGrid.v.a8(GridChangedTypeEnum A_0, Int32 A_1, Int32 A_2, Int32 A_3, Int32 A_4)
at C1.Win.C1FlexGrid.v.bm(GridChangedTypeEnum A_0)
at C1.Win.C1FlexGrid.g.j()
at C1.Win.C1FlexGrid.v.a8(GridChangedTypeEnum A_0, Int32 A_1, Int32 A_2, Int32 A_3, Int32 A_4)
at C1.Win.C1FlexGrid.RowColCollection.v(GridChangedTypeEnum A_0, Int32 A_1, Int32 A_2, Int32 A_3, Int32 A_4)
at C1.Win.C1FlexGrid.RowCollection.aa(Int32 A_0, Boolean A_1, q A_2, Int32 A_3)
at C1.Win.C1FlexGrid.C1FlexGridBase.AddItem(String item, Int32 index)
at Cognos.Controller.Forms.Form.frmTrialBalance.PrepareGridForPrinter(String& sGroup, String& sGroupName, String& sForm, String& sFormName, Boolean& bChangeFont, Boolean& bSpillHeader)
at Cognos.Controller.Forms.Form.frmTrialBalance.SendGridToPrinter(String& sGroup, String& sGroupName, String& sForm, String& sFormName)

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.


Event Type: Warning
Event Source: Cognos Controller
Event Category: None
Event ID: 0
Date: 2010-01-14
Time: 06:34:06
User: N/A
Computer: CITRIXSERVER
Description:
Standard Error
Number: 5
Source: C1.Win.C1FlexGrid.2
Description: CellRange is invalid.
at C1.Win.C1FlexGrid.CellRange.d()
at C1.Win.C1FlexGrid.CellRange.get_Clip()
at C1.Win.C1FlexGrid.Classic.C1FlexGridClassic.get_Cell(CellPropertySettings setting, Int32 row1, Int32 col1, Int32 row2, Int32 col2)
at C1.Win.C1FlexGrid.Classic.C1FlexGridClassic.get_Cell(CellPropertySettings setting, Int32 row, Int32 col)
at Cognos.Controller.Forms.Form.frmTrialBalance.DrillSet()
at Cognos.Controller.Forms.Form.frmTrialBalance.grdReport_RowColChange(Object eventSender, EventArgs eventArgs)
at C1.Win.C1FlexGrid.C1FlexGridBase.OnRowColChange(EventArgs e)
at C1.Win.C1FlexGrid.C1FlexGridBase.bb()
at C1.Win.C1FlexGrid.C1FlexGridBase.OnGridChanged(Object sender, GridChangedEventArgs e)
at C1.Win.C1FlexGrid.C1FlexGrid.OnGridChanged(Object sender, GridChangedEventArgs e)
at C1.Win.C1FlexGrid.v.a8(GridChangedTypeEnum A_0, Int32 A_1, Int32 A_2, Int32 A_3, Int32 A_4)
at C1.Win.C1FlexGrid.v.bm(GridChangedTypeEnum A_0)
at C1.Win.C1FlexGrid.g.j()
at C1.Win.C1FlexGrid.v.a8(GridChangedTypeEnum A_0, Int32 A_1, Int32 A_2, Int32 A_3, Int32 A_4)
at C1.Win.C1FlexGrid.RowColCollection.v(GridChangedTypeEnum A_0, Int32 A_1, Int32 A_2, Int32 A_3, Int32 A_4)
at C1.Win.C1FlexGrid.RowCollection.p(Int32 A_0, Boolean A_1)
at C1.Win.C1FlexGrid.RowCollection.set_Count(Int32 value)
at C1.Win.C1FlexGrid.Classic.C1FlexGridClassic.set_Rows(Int32 value)
at Cognos.Controller.Forms.Form.frmTrialBalance.FillReport(DataSet[]& m_rsReport, String& sGroup, String& sCurrencyType)
at Cognos.Controller.Forms.Form.frmTrialBalance.LoadReport(String& sPerAct, String& sForm, Object& varCompanies, String& sAccount, String& sGroup, String& sConsType, String& sCloseVer, String& sContVer, String& sCurrencyType, String[]& sClosVers, String[]& sContVers, String[]& sDims)

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Event Type: Warning
Event Source: MetaFrameEvents
Event Category: Printer Management
Event ID: 1103
Date: 2010-01-14
Time: 06:29:57
User: N/A
Computer: CITRIXSERVER
Description:
An error occurred while retrieving client printer properties. Default printer properties will be used instead. Client name: (EUR-gmuehle) Printer: (PN776154 on SPHAMLX3517 (from EUR-gmuehle) in session 3) Printer driver: (LEXMARK UNIVERSAL)

Event Type: Error
Event Source: Microsoft Office 11
Event Category: None
Event ID: 1000
Date: 2010-01-14
Time: 05:50:59
User: N/A
Computer: CITRIXSERVER
Description:
The description for Event ID ( 1000 ) in Source ( Microsoft Office 11 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: excel.exe; 11.0.6560.0; 4296b6f2; excel.exe; 11.0.6560.0; 4296b6f2; 0; 0002b34f.
Data:
0000: 41 00 70 00 70 00 6c 00 A.p.p.l.
0008: 69 00 63 00 61 00 74 00 i.c.a.t.
0010: 69 00 6f 00 6e 00 20 00 i.o.n. .
0018: 46 00 61 00 69 00 6c 00 F.a.i.l.
0020: 75 00 72 00 65 00 20 00 u.r.e. .
0028: 20 00 65 00 78 00 63 00 .e.x.c.
0030: 65 00 6c 00 2e 00 65 00 e.l…e.
0038: 78 00 65 00 20 00 31 00 x.e. .1.
0040: 31 00 2e 00 30 00 2e 00 1…0…
0048: 36 00 35 00 36 00 30 00 6.5.6.0.
0050: 2e 00 30 00 20 00 34 00 …0. .4.
0058: 32 00 39 00 36 00 62 00 2.9.6.b.
0060: 36 00 66 00 32 00 20 00 6.f.2. .
0068: 69 00 6e 00 20 00 65 00 i.n. .e.
0070: 78 00 63 00 65 00 6c 00 x.c.e.l.
0078: 2e 00 65 00 78 00 65 00 …e.x.e.
0080: 20 00 31 00 31 00 2e 00 .1.1…
0088: 30 00 2e 00 36 00 35 00 0…6.5.
0090: 36 00 30 00 2e 00 30 00 6.0…0.
0098: 20 00 34 00 32 00 39 00 .4.2.9.
00a0: 36 00 62 00 36 00 66 00 6.b.6.f.
00a8: 32 00 20 00 66 00 44 00 2. .f.D.
00b0: 65 00 62 00 75 00 67 00 e.b.u.g.
00b8: 20 00 30 00 20 00 61 00 .0. .a.
00c0: 74 00 20 00 6f 00 66 00 t. .o.f.
00c8: 66 00 73 00 65 00 74 00 f.s.e.t.
00d0: 20 00 30 00 30 00 30 00 .0.0.0.
00d8: 32 00 62 00 33 00 34 00 2.b.3.4.
00e0: 66 00 0d 00 0a 00 f…


Solution:
Exit the Cognos controller session.
The user should change there default printer driver to some thing else (go from HP to LEXMARK) then start there Controller session in Citrix.
Maybe they have a different printer in the office corridor they can select instead of there default printer at there desk.

In Cognos controller they should now try to print the same report again.
Go to group – reports – trail balance – and click on the print button.
In the citrix printer dialog that comes up – the user should be able to select the printer they used before and then print out on that printer.

The issue seems to be with the selected printer when they start there Citrix session.

www.cogknowhow.com