Kbase P114132: Error 83 during the create or update schema holder
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
29/05/2007 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.1A
MS SQL DataServer
SYMPTOM(s):
Error 83 during the create or update schema holder
** The length argument value must be greater or equal to -1. (83)
The error is apparent when a varchar field has a default value assigned as numeric 0 (zero)
The MS SQL Server Database is assigning the zero as a character data if insert it from the SQL analyzer tool from the SQL Server
CAUSE:
This is a known issue being investigated by Development
FIX:
The workaround is to change the default value of the varchar filed from numeric 0 (zero) to character 0 by using single quotes around it as '0' in the MS SQL Server Database