IBM Support

How to mitigate CCL-COM-003 errors when running a high volume of reports against a Compatible Query Mode Package Using a Microsoft SQL Server Data Source

How To


Summary

With high volumes of reports being processed using a Compatible Query Mode packages against a Microsoft SQL Server data source, it is possible to see the error "CCL-COM-0003 Failed to initialize COM because of an unknown error." This maybe an indication that the Desktop Heap of a Windows Server is being exhausted.

The complete error is logged to the cogserver.log file in the following format:
RSV-SRV-0063 An error occurred while executing the 'asynchRun_Request' command.
QE-DEF-0285 The logon failed.
QE-DEF-0325 The logon failed for the following reason:
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
UDA-SQL-0031 Unable to access the database. Check that the connection parameters to the database
are configured correctly. For example, ensure that the data source connection contains the signon
information, such as a password, to connect to the database.
UDA-SQL-0107 A general exception has occurred during the operation "{0}". CCL-COM-0003 Failed to initialize COM because of an unknown error.
UDA-SQL-0201 There was an error initializing "COM"

Document Location

Worldwide


[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m3p000000hBPzAAM","label":"Troubleshooting-\u003ESupport How To"}],"ARM Case Number":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions"},{"Product":{"code":"SS6G84","label":"IBM Cognos Analytics 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 Analytics

Component:
Troubleshooting->Support How To

Software version:
All Versions

Operating system(s):
Windows

Document number:
7161697

Modified date:
01 May 2025

UID

ibm17161697

Page Feedback