My Oracle Support Banner

SBL-DBC-00104 / [IBM][CLI Driver][DB2/NT64] SQL0954C ... SQLSTATE=57011 error, iterating 100K+ records of the "Audit Trail Item 2" VBC (Doc ID 2026347.1)

Last updated on AUGUST 19, 2022

Applies to:

Siebel CRM - Version 8.1.1.10 [23021] and later
Generic Windows

Symptoms

A custom server side  that reads Audit Trail records via standard Virtual Business Component (VBC) fails on Db client error when it has to proceed more than 100.000 records.

Below is the sample code in Siebel escript:

Once error occurs, the Siebel Application has to be restarted, since no further data query (to any BC) can be executed.

The error remains  even after DB Client specific parameter ("applheapsz") that controls heap size for DB client, is tuned to warrant larger application heap.

Changes

Siebel CRM Application is connected to Siebel Servcer DB that is provided by DBMS instance of the IBM DB/2 certified client and server product.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.