Kbase P100594: Getting error 83 when trying to create or update schema holder from SQL Server database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/3/2008 |
|
Status: Verified
SYMPTOM(s):
Getting error 83 when trying to create or update schema holder
**The length argument value must be greater or equal to -1. (83)
The length of a requested SUBSTRING (third argument) must be greater than or equal to -1. Other functions such as LENGTH and OVERLAY also are the same.
The field in the MS SQL Server database has a function based default value assigned to it.
FACT(s) (Environment):
Progress 9.1E
OpenEdge 10.x
MS SQL DataServer
Windows NT 32 Intel/Windows 2000
CAUSE:
Bug# OE00113609
FIX:
Upgrade to OpenEdge 10.1A
OR As a work around, you need to change the function based default value to a constant default value in the SQL Server Database. OR If you already have the schema holder created in Progress Version 9.1x, you can dump the .df and edit it to add a new flag that is added in Progress Version 9.1E and the OpenEdge Release 10.x for better performance. After the change is made, you can save the .df file and load it to an empty database created with OpenEdge Release 10.x. If you do not add the flag, the performance will DEGRADE dramatically. When you open the .df for editing, you should see the following properties on the *ADD DATABASE* section of the .df file: DRIVER-CHARS "3,13,14,17,20,23,33,35," Add *36,* after the end value (35,). After you added the value, the .df should look like the following: DRIVER-CHARS "3,13,14,17,20,23,33,35,36,"