Problem Note 65167: "ERROR: Value for option DBMAX_TEXT is out of range..." occurs when you use SAS/ACCESS® Interface to the PI System
 |  |  |  |  |
If you specify the DBMAX_TEXT= option with a value higher than 976 in a LIBNAME statement, you receive the following:
The limit of 976 characters for PI System should apply to the tag value only. The limit should not apply to PIPOINT table columns, such as the description.
Click the Hot Fix tab in this note to access the hot fix for this issue.
After you install the hot fix, PI point attributes of up to 32,767 characters (each) can be read into SAS. The DBMAX_TEXT= option is no longer required and has no effect. SAS column sizes are adjusted automatically to allow enough space for the longest string in each column for the PI points requested.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to the PI System | Solaris for x64 | 9.4 TS1M5 | |
| Linux for x64 | 9.4 TS1M5 | |||
| HP-UX IPF | 9.4 TS1M5 | |||
| 64-bit Enabled Solaris | 9.4 TS1M5 | |||
| 64-bit Enabled AIX | 9.4 TS1M5 | |||
| Microsoft® Windows® for x64 | 9.4 TS1M5 | |||
A fix for this issue for SAS/ACCESS Interface to the PI System 9.44 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/F8X.html#65167A fix for this issue for SAS/ACCESS Interface to the PI System 9.43 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/D3W.html#65167| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2019-12-04 13:57:34 |
| Date Created: | 2019-11-25 10:31:30 |