Problem Note 18210: Incorrect amount of data may be returned when using SAS/ACCESS® Interface
to Sybase with threads
When using SAS/ACCESS Interface to Sybase, if an error such as in the
prepare, execute, or fetch is generated and not returned to the SAS
supervisor, all of the data for that particular thread is not being
brought into SAS because that thread is dead from the error message.
A similar scenario is where one thread is not returning any rows and an
error condition is not being raised to terminate processing and return
an error condition to the user, by limiting the Sybase server to 6
connections, but requesting 7, which causes one of the threads to have a
connection failure.
The problem was in the threaded error routine, where it was trying to
create a temporary command handle allocation that was a de-referenced
null pointer.
After applying the fix, you will have an error message returned back to
the supervisor which is written out to the SAS log.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | SAS/ACCESS Interface to Sybase | 64-bit Enabled HP-UX | 9.1 TS1M3 | 9.2 TS1M0 |
64-bit Enabled AIX | 9.1 TS1M3 | 9.2 TS1M0 |
Linux | 9.1 TS1M3 | 9.2 TS1M0 |
HP-UX IPF | 9.1 TS1M3 | 9.2 TS1M0 |
64-bit Enabled Solaris | 9.1 TS1M3 | 9.2 TS1M0 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Problem Note |
Priority: | high |
Topic: | SAS Reference ==> LIBNAME Engines Data Management ==> Data Sources ==> External Databases ==> Sybase
|
Date Modified: | 2006-08-16 21:08:42 |
Date Created: | 2006-08-02 13:59:00 |