Problem Note 37608: User-generated queries conflict with batch programs and errors occur in SAS/ACCESS® Interface to HP Neoview
SAS/ACCESS Interface to HP Neoview appears to be locking tables in the database, which is causing user-generated queries to conflict with batch programs. The following error messages might be issued if these conflicts occur:
ERROR: CLI cursor extended fetch error: [HP][HP ODBC Driver][HP
Neoview Database] SQL error:***
ERROR[8551] Error 73 was returned by the file system on
NEO.PROD_EDW_FACT_04.TB_SHOPPING_TRANSACTION_LINE (partition
\SNA0104.$FC0700.ZSDFXN8V.WLV6JH00). [2009-06-02 02:33:42]
By default, the ISOLATION_LEVEL= option is set to COMMITTED READ in SAS/ACCESS Interface to HP Neoview.
To work around this issue,
- Set ISOLATION_LEVEL=UNCOMMITTED READ in the the LIBNAME statement.
- Use pass-through processing in the SQL procedure to set the RU isolation-level parameter.
Click the Hot Fix tab in this note to access the hot fix for this issue.
This hot fix removes the default behavior and avoids setting the isolation level unless you specifically set it in the LIBNAME statement. This behavior enables the data source name (DSN) configuration on either the client side or the server side to control the current solation-level setting.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to HP Neoview | Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS1M0 | |
| Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS1M0 | |
| Microsoft Windows Server 2003 Standard Edition | 9.2 TS1M0 | |
| Microsoft Windows XP Professional | 9.2 TS1M0 | |
| Windows Vista | 9.2 TS1M0 | |
| 64-bit Enabled Solaris | 9.2 TS1M0 | |
| HP-UX IPF | 9.2 TS1M0 | |
| Linux | 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.
The following error is occuring in SAS/ACCESS Interface to HP Neoview:
ERROR: CLI cursor extended fetch error: [HP][HP ODBC Driver][HP
Neoview Database] SQL error:***
ERROR[8551] Error 73 was returned by the file system on
NEO.PROD_EDW_FACT_04.TB_SHOPPING_TRANSACTION_LINE (partition
\SNA0104.$FC0700.ZSDFXN8V.WLV6JH00). [2009-06-02 02:33:42]
| Type: | Problem Note |
| Priority: | high |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> HP Neoview
|
| Date Modified: | 2009-11-02 09:47:36 |
| Date Created: | 2009-10-27 10:06:43 |
