Up Prev Next
From: Roleigh Martin <rol at uhc dot com>
Subject: after 5000 dbe deletes, internal directory control layer error
Date: Mar 28 2001 11:35PM
We have a DBI perl program that after about 5,000 deletes we get this
error message -- something similar happened with another program that did
about 5,000 updates. The update program worked around the problem by
removing use of the second database handle. The program logic basically
has a parent SQL select command that uses one database handle to get a
list of unique index keys of records to update, then inside a while fetchrow
next record loop, it does the update or delete for only one database record
at a time to minimize database locking.
This is the error message:
DBD::Sybase::db prepare failed: OpenClient message: LAYER = (6) ORIGIN = (8)
SEVERITY = (5) NUMBER = (1) Message String: ct_connect(): directory service
layer: internal directory control layer error: There was an error encountered
while binding to the directory service.
Do you know what could be causing this error message?
Thanks in advance.
Specs about the program versions/machine, etc:
rol/ftp/perl>perl -e "print join('; ',
Adaptive Server Enterprise/18.104.22.168/P/SWR 9268 ESD 3/RS6000/AIX 4.3.2/1629/
32bit/FBO/Fri Sep 8 01:43:53 2000
IBM RS/6000 AIX 4.3
# $Id: Sybase.pm,v 1.22 2000/03/24 04:44:49 mpeppler Exp $
# $Id: CTlib.pm.in,v 1.30 2000/05/13 22:50:56 mpeppler Exp $
# $Id: DBD.pm,v 10.7 1999/05/06 17:29:14 timbo Exp $
# $Id: DBI.pm,v 10.25 1999/07/12 02:02:33 timbo Exp $