Kbase P24558: Error 6182 occurs when SQL Server schema has been adjusted without recompiling code
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
23/08/2010 |
|
Status: Verified
SYMPTOM(s):
Error 6182 occurs when attempting to run a program against MS SQL Server
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
Error occurs when column size in MS SQL Server is expanded beyond original precompiled r-code column size
When column size is changed in ORACLE, precompiled r-code does not fail using Oracle DataServer
Behavioral differences exist between Oracle and MS SQL Dataserver
FACT(s) (Environment):
Progress 9.1x
OpenEdge 10.x
Windows
MS SQL DataServer
CHANGE:
Column size in MS SQL Server is altered/changed
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 all code against newly adjusted/altered MS SQL Server.