My Oracle Support Banner

DB2 Error on repeated Queries using Audit Trail Item 2 (Doc ID 2510647.1)

Last updated on JANUARY 23, 2020

Applies to:

Siebel CRM - Version 16.19 [IP2016] and later
Information in this document applies to any platform.

Symptoms

DB2 Error on repeated queries using Audit Trail Item 2.

ERROR
-----------------------
SQLError: sqlstate HY014: [IBM][CLI Driver] CLI0129E An attempt to allocate a handle failed because there are no more handles to allocate. SQLSTATE=HY014

STEPS TO REPRODUCE THE ISSUE:
------------------------------------------
1. Export the audit trail data from Siebel via the business layer using Audit Trail item 2 buscomp.
2. Develop a process that translates the encoded audit string into rows in a buscomp.
3. The process is encountering DB2 errors after a period of operation.

Alternate / detailed repro steps:

  1. Launch Siebel Call Center Application
  2. Navigate to Sitemap --> Administration - Business Service
  3. Navigate to Details tab
  4. Create a new Business Service
       Name = Audit Test
       State Management Type = Stateless
       Save the Business Service
  5. Drilldown on the new Business Service - Audit Test
  6. Create a new Business Service Script
    Name = Service_PreInvokeMethod
    Program Language = eScript
    Actual script is as follows:
    function Service_PreInvokeMethod (MethodName, Inputs, Outputs)
    {
        // Create & Declare Objects
        var oApp = TheApplication()
        var boAudit, bcAuditItem;
        var i = 0;
        try
        {
            TheApplication().TraceOn("c:\\tracefile.txt", "Allocation", "All");
            boAudit = oApp.GetBusObject("Audit Trail");
            bcAuditItem = boAudit.GetBusComp("Audit Trail Item 2");
            TheApplication().Trace("Before for loop");
            for (i=0; i<2200; i++)
            {
                TheApplication().Trace("Inside for loop, i: " + i + ".");
                bcAuditItem.ClearToQuery();
                bcAuditItem.SetSearchSpec("Record Id", "XYZ");
                bcAuditItem.ExecuteQuery();
            }
            TheApplication().Trace("i: " + i + ".");
        }
        catch(e)
        {
            TheApplication().RaiseErrorText(i + ":" + e);
            throw (e);
        }
        finally
        {
            bcAuditItem = null;
            boAudit = null;
            oApp = null;
        }
        TheApplication().Trace("After finally");
        TheApplication().TraceOff();
        return (CancelOperation);
    }

    7. Navigate to Simulator tab
    8. Create a new Simulator
       Service Name = Audit Test
       Method Name = Test
       Iterations = 1
    9. Click on Run button

    The Business Service would run for a few seconds and then an error message such as the following would pop:

    <Hostname>.<Domain Name>.com:9001 says
    1321: An error has occurred executing a Sql statement.
    Please continue to ask your system administrator to check your
    application configuration if the problem
    persists.(SBL-DBC-00105)(SBL-EXL-00151)

    In the object manager log file, the following errors appears:
    --------------------------------------------------------------------------
    Please continue or ask your systems administrator to check your application configuration if the problem persists.
    DBCLog DBCLogError 1 000000605b8413b0:0 2018-08-27 20:12:40 SQLError:
    sqlstate HY014: [IBM][CLI Driver] CLI0129E  An attempt to allocate a handle
    failed because there are no more handles to allocate. SQLSTATE=HY014
    ObjMgrLog Error 1 000000605b8413b0:0 2018-08-27 20:12:40 (sqlmisc.cpp (5954))
    SBL-DBC-00105: An error has occurred executing a Sql statement.

    Please continue or ask your systems administrator to check your application configuration if the problem persists.
    ObjMgrLog Error 1 000000605b8413b0:0 2018-08-27 20:12:40 (app.cpp (2343))
    SBL-EXL-00151: 1321:An error has occurred executing a Sql statement.

    Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DBC-00105)
    ObjMgrBusCompLog Error 1 000000685b8413b0:0 2018-08-27 20:13:38 (clicon.cpp
    (3621)) SBL-DBC-00111: An error has occurred writing to a record.

    Please continue or ask your systems administrator to check your application configuration if the problem persists.
    DBCLog DBCLogError 1 000000685b8413b0:0 2018-08-27 20:13:38 SQLError:
    sqlstate HY014: [IBM][CLI Driver] CLI0129E  An attempt to allocate a handle
    failed because there are no more handles to allocate. SQLSTATE=HY014


    Issue has been reproduced with DB2 on Z/OS. However, this issue can be seen with DB2 on Windows as well.

    Test environment:
    Siebel 18.8
    DB2 10.5
    Windows 2012 R2

Changes

 

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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