Troubleshooting
Problem
User launches Excel. User logs onto Controller via the Controller Add-in. User clicks "Reports - Run" and tries to run a report. User receives an error message. After clicking OK, more errors appear. This same report used to work OK in the past, when the customer was using Controller 8.5.1 with Excel 2003. However, the customer is now using 10.1.1 with later version of Excel (for example Excel 2010).
Symptom
Error #1
Standard Error
Number: -2147467261
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)
Error #2
-2147417851
HRESULT: 0x80010105 (RPC_E_SERVERFAULT)
Error #3
462
Source: mscorlib
The RPC server is not ... 0x800706BA
Cause
The report contains an invalid use of the function ccfText.
More Information:
The format for 'cc.fText' has changed (when using versions of Excel higher/later than 2003) in order to be able to handle double byte characters.
Environment
Client device has Excel 2007 or Excel 2010 installed.
Diagnosing The Problem
Check by searching on the report layout for the following formula:
=cc.fText
For example:
=cc.fText(1,2)
Resolving The Problem
Modify the report layout, so that any entries for 'cc.fText' so that each and every one of the text parameters has "" around them.
For example, in the above example you would change the formula to:
=ccfText("1","2")
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21618123