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

[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.4","Edition":"Not Applicable","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSMRTZ","label":"IBM Cognos Controller on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

More support for:
IBM Cognos Controller

Software version:
8.4

Operating system(s):
Windows

Document number:
393101

Modified date:
08 May 2025

UID

swg21394477

Manage My Notification Subscriptions