Troubleshooting
Problem
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
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21622392