Troubleshooting
Problem
User runs a report with Optimise2 (also known as Enhanced Reporting Optimisation) enabled. User receives error message.
Symptom
Screen:
Example #1:
Description:
The VB Application identified by the event source logged this Application FrExcelLinkB: Thread ID: 3496 ,Logged: Error occured at 17/07/2009 16:24:22 in FrExcelLinkB, Error No=429, Source=Server function:Db_BulkInsert(..) , Description=ActiveX component can't create object Server: SQLSERVER Share: SHARENAME User: DOMAIN\CONTROLLERSYSTEM Psw: ***** Transfer: 0 Prefix: 51934C72872147A2B78234E2A2759A17 Direct Caller: 51934C72872147A2B78234E2A2759A17
Example #2:
Information
Standard Error
Number: 5
Source: FrangoDirect.ExcelLinkD.FetchValuesBulk#ControllerProxyClient
Description: System.Web.Services.Protocols.SoapException: Server was unable to process request. --->
System.Runtime.InteropServices.COMException (0x800A01AD): ActiveX component can't create object Server: SERVERNAME Share: SHARENAME User: DOMAINNAME\WINDOWS_USERNAME Psw: ***** Transfer: 0 Prefix: E82CExxxxxxxxxxxxxxxxxxxxx Direct Caller: E82CExxxxxxxxxxxxxxxxxx
at Cognos.Controller.Proxy.CCRWS.ExcelLinkB_FetchValuesBulk(......
[OK]
Event Viewer (Application log):
Event Type: Warning
Event Source: VBRuntime
Event Category: None
Event ID: 1
Date: 17/07/2009
Time: 16:24:22
User: N/A
Computer: CLIENTPCNAME
Description:
The VB Application identified by the event source logged this Application FrExcelLinkB: Thread ID: 3496 ,Logged: Error occured at 17/07/2009 16:24:22 in FrExcelLinkB, Error No=429, Source=Server function:Db_BulkInsert(..) , Description=ActiveX component can't create object Server: SQLSERVER Share: SHARENAME User: DOMAIN\CONTROLLERSYSTEM Psw: ***** Transfer: 0 Prefix: 51934C72872147A2B78234E2A2759A17 Direct Caller: 51934C72872147A2B78234E2A2759A17, HelpFile= HelpContext=0
Event Type: Warning
Event Source: VBRuntime
Event Category: None
Event ID: 1
Date: 17/07/2009
Time: 16:24:21
User: N/A
Computer: CLIENTPCNAME
Description:
The VB Application identified by the event source logged this Application FrSrvFunc: Thread ID: 3496 ,Logged: Error occured at 17/07/2009 16:24:21 in FrSrvFunc, Error No=429, Source=Server function:Db_GetShareParam(..) , Description=ActiveX component can't create object, HelpFile= HelpContext=0
Event Type: Warning
Event Source: VBRuntime
Event Category: None
Event ID: 1
Date: 17/07/2009
Time: 16:24:21
User: N/A
Computer: CLIENTPCNAME
Description:
The VB Application identified by the event source logged this Application xfrango: Thread ID: 3496 ,Logged: Error occured at 17/07/2009 16:24:21 in xfrango, Error No=429, Source=xFran.fCryptor, Description=ActiveX component can't create object, HelpFile= HelpContext=0
Cause
A required shared file ("FrCrypto.dll") was not correctly registered (on the application server) - this will typically have occurred during the server installation or later patching.
Environment
Problem could potentially affect any version of Controller, but it is most likely to occur either:
- When using Controller 8.4 FP1 (version 8.4.529) and similar/slightly-higher versions.
- Or after upgrading early versions of Controller 10.1.x with a later IF (interim fix) upgrade.
- For more information, see separate IBM Technote #1574744.
Resolving The Problem
Register the required file "FrCrypto.dll" on the Controller application server.
Steps:
1. Logon to the Controller application server as a Windows administrator
2. Launch a command prompt
- TIP: Click "Start - Run" and type in: CMD
3. Change directory to the location of where Controller is installed to.
TIP:
- For Controller 8.x, the default location is: C:\Program Files\cognos\c8
- For Controller 10.x, the default location is: C:\Program Files (x86)\IBM\cognos\c10
For example:
- cd "C:\Program Files (x86)\IBM\cognos\c10"
4. Open the subfolder 'common'
- cd common
5. Type the following commend
RegSvr32 FrCrypto.dll
TIP: If the problem remains, obtain a short period of downtime (no users on the system) and reboot the Controller application server (to ensure that the registration takes effect).
Related Information
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21394477