"Standard Error ... -2147467161 ... interop.Excel ... Attempted to read or write..." when using Excel 2007 or 2010

Technote (troubleshooting)


Problem(Abstract)

User opens a spreadsheet (XLSX file) and clicks F9 to run it. User receives Error #1. After clicking OK, user receives Error #2. After clicking OK, user receives Error #3.

Symptom

Error #1:

Information

Standard Error

Number: -2147467161

Source: interop.Excel

Description: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.

at Excel._Worksheet.set_EnableCalculation(Boolean RHS)

at Cognos.Controller.Reports.XlLinkLayout.RecalcXL(Int32 lVersion, Boolean bActiveSheetOnly)

[OK]

Error #2:

Information

Standard Error

Number: -2147467161

Source: Microsoft.VisualBasic

Description: De server heeft een .... (Exception from HRESULT: 0x80010105 (RPC_E_SERVERFAULT))

Error #3:


Cause

There are several possible causes for similar errors.

  • TIP: For more examples, see separate IBM Technote #1665528.

This Technote specifically relates to the scenario where the cause is that the Controller client has run out of memory, triggered by the spreadsheet report using an incorrect formula similar to:
    =cc.fText(1;2)

Specifically, the customer is not using the correct parameter syntax in the report.

More Information:
By design, Controller (when using Excel 2007 or later Excel version) is has been modified to be able to handle double byte characters.
  • However, for this new functionality to work the text parameters must be surrounded with "".
  • For example, by changing the formula to =cc.fText("1";"2") it will work.

Therefore, in one real-life customer case, the customer received this error/problem after upgrading from Excel 2003 to Excel 2007.

Environment

Client device using Excel 2007 or 2010.

Resolving the problem

Fix:

Modify the cc.fText (in the report/report layout) formulae to contain double quotes ("") around each parameter.

For example, here is a valid (correct) example:

    =cc.fText("1";"2")

Workaround:
Either:

  • Redesign the report to exclude the "Contribution Version" and "Closing Version" in the columns.
  • or use Excel 2003 (instead of Excel 2007 or Excel 2010).

Related information

1618123 - Run report error -2147467261 in excel 2010 or
1665528 - ** Troubleshooting ** "Standard Error ... int

Rate this page:

(0 users)Average rating

Document information


More support for:

Cognos Controller
Controller

Software version:

10.1

Operating system(s):

Windows

Reference #:

1622392

Modified date:

2014-02-24

Translate my page

Machine Translation

Content navigation