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
Controller client has run out of memory.
In turn, this is triggered by the spreadsheet report using the formula:
-
=cc.fText(1;2)
...but the customer 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
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.