IBM Support

Error 'Error No=429 ... function:Db_BulkInsert(..) , Description=ActiveX component can't create object Server' When using ERO/optimise2

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:

  1. When using Controller 8.4 FP1 (version 8.4.529) and similar/slightly-higher versions.
  2. 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).

[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.4","Edition":"Not Applicable","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21394477