Troubleshooting
Problem
User clicks on 'Company - Data Entry - Reported Values'. An Excel spreadsheet appears, and then the user receives an error message.
Symptom
Microsoft Visual C++ Debug Library
Debug Error!
Program C:\Archivos de programa\Microsoft Office\OFFICE11\EXCEL.EXE
Module:
File: i386\chkesp.c
Line: 42
The value of ESP was not properly saved across a function call. This is usually a result of calling a function declared with one calling convention with a function pointer declared with a different calling convention.
(Press Retry to debug the application)
Abort Retry Ignore
Cause
Scenario #1:
Inside Controller, the user can select their preferred language inside the following screen: 'Maintain - User - Personal Defaults' and click 'Layout 2' tab.
The attached screenshot shows Controller 8.2, which supports the following 6 languages: EN, SV, DE, ES, FR, ZT (Traditional Chinese).
There are different language versions of Microsoft Excel. Cognos only supports using Controller with a version of Microsoft Excel that has the same language that you are using Controller with (i.e. one of English, Swedish, German, Spanish, French and Chinese).
This means that if you are using Controller in French, then Cognos supports using MS Excel in French language, and so on. This also means that we do not support other Excel language versions, for example Excel in Portugese.
Scenario #2:
Client PC has third-party software installed. An example is an old version (V3R2M0) of IBM Client Access (for use as PC5250/telnet emulation). This has downgraded the Microsoft C Runtime Library to an version which is incompatible with Cognos Controller.
Environment
Scenario #1:
Client PC with a non-English version of Microsoft Excel.
Scenario #2:
Client PC has old third-party software installed.
Resolving The Problem
Scenario #1:
Change the Microsoft Office language to match the Controller language version (e.g. English). Change the client PC's 'Regional Settings' to match the Controller language version (e.g. English).
WARNING: Changing these settings may fix Controller, but Cognos cannot guarantee that third-party (non-Cognos) software will be unaffected by these changes.
Scenario #2:
User versions of third party software (e.g. IBM Client Access) which do not downgrade shared files, so that client PC has compatible version of Microsoft C Runtime Library installed. For example, use version V5R2M0 of IBM Client Access.
Steps:Scenario #1:
Microsoft Office language:
The following example is for MS Office2003, to change it to English:
- Logon to the client PC
- Inside the Start Menu, choose 'Programs - Microsoft Office - Microsoft Office Tools'
- Click on 'Microsoft Office 2003 Language Settings'
- Change the language as appropriate (e.g. to English)
Regional Settings:
The following example is for Windows XP, to change it to English:
- Logon to the client PC
- Inside Control Panel, launch 'Regional and Language Options'
- Change the language setting as appropriate (e.g. to English).
Scenario #2:
- Logon to a 'working' Controller PC
- Take a copy of the file C:\WINDOWS\system32\msvcrt.dll
- Logon to the 'bad' PC (where Controller has an error)
- Rename the existing file C:\WINDOWS\system32\msvcrt.dll to msvcrt.dll.OLD
- Copy the 'working' file msvcrt.dll to the folder C:\WINDOWS\system32\ on the 'bad' PC
- Repeat steps 1 to 5 for any other C++ files that are relevant
- Re-test
- 1035791_1.zipHistorical Number
1035791
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21371271