Kbase P158313: Getting error 11328 trying to update a record with COPY_LOB against MS SQL Server database using OE1
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
14/01/2010 |
|
Status: Unverified
SYMPTOM(s):
Getting error 11328 trying to update a record with COPY_LOB against MS SQL Server database using OE10.2B MS SQL Server DataServer when used skip_schema_check
Failed to delete target large object during copy. (11328)
FACT(s) (Environment):
The error is displayed only when updating a record already exist on the MS SQL Server
The LOB field is null but the other fields has records
A sample code is shown below that generates the error:
FIND FIRST table WHERE field = "XX".
COPY-LOB FROM FILE "<path>\myImage.jpg" TO
my_BLOB_field NO-CONVERT.
The OpenEdge Database is migrated MS SQL Server 2008 through protoMSS DataServer utility
Error is not apparent when -Dsrv skip_schema_check is not used
Windows
OpenEdge 10.2B
MS SQL DataServer
CAUSE:
Bug# OE00194498
FIX:
The workaround is to not use -Dsrv skip_schema_check until the bug is fixed