Kbase P27404: MS SQL DataServer errors w/ error 6182 when precompile rcode
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/12/2003 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1D
FACT(s) (Environment):
MS SQL DataServer
SYMPTOM(s):
You tried to compare or to update a character field with a value longer than the maximum length. (6182)
When column size is changed in MS SQL Server, precompiled r-code fails with error 6182 using MS SQL DataServer
When column size is changed in ORACLE, precompiled r-code does not fail using Oracle DataServer
Error occurs when column size in MS SQL Server is expanded beyond original precompiled r-code column size
Behavior differences exist between Oracle and MS SQL Dataserver
CAUSE:
This is by design. The Oracle Dataserver is designed to cache column size on server and does not send column size to client for comparison within .r code whereas the MS SQL DataServer is designed to not to ignore size changes. Anytime there is a schema change, all code must be recompiled with MS SQL DataServer.
FIX:
Recompile .r code against newly adjusted MS SQL server schema holder.