Discussion:
ODBC failure / timeout?
(too old to reply)
Steven Fitzgerald
2005-08-21 16:00:08 UTC
Permalink
Using eDir 8.7.3, 8.7.3.1, 8.7.3.2, 8.7.3.4, and even the withdrawn
8.7.3.6, we have intermittent failures with queries. We get an ISAM Error
4, not much more information. The query we are running is valid, and always
works on directories with relatively few objects. Once the directory grows,
the query MIGHT succeed, but it seems that most of the time it fails. It is
common for the queries to use a computed count(*), and they always search
for object types added as schema extensions (with extensions for the
attributes, as well). The error can occur after 10 minutes, sometimes goes
as long as 20.

Our directory is very large, with hundreds of thousands of objects and
millions of values. Our OS is Windows 2000.

This happens in the RO driver, and I am pretty sure we have also run into
the problem with the RW driver.

This seems to me like a capacity or timeout issue somewhere, but I cannot
figure out what settings might need to be tuned.

I am looking for any help or insights that forum members can add.
Susan Perrin
2005-08-23 16:07:19 UTC
Permalink
Hi

It could be a timeout issue. On an older version of the driver, when the
sql client would send a time out due to excessive chaining (especially
across wan links) to fulfill the nds search data, we had a crash problem.
This was replaced with a more polite error message.

This was put into the readme at http://forgeftp.novell.com/odbc/README.html
under Query Cancelled error.

If you're writing code you might try setting the query timeout. Also you
might try setting your primary connection (Novell client icon/connections)
to a server that contains copies of the replicas that you're searching.

You might also set the DSN to the explicit container that you're requesting.
For example, if you only want to look at ou=users,ou=engineering,o=novell,
use the data source administrator to set up a driver that points there
directly, rather than using default nds database which points to the root.

Aside from that if you have a reproduceable example (even if it takes
several tries to reproduce) and a server containing partitions to complete
the query, I'd like to collect a dibset to reproduce. You can email me at
sperrin at novell .com and I'll set up an incident for this.

Thank you
Susan

Loading...