Kbase P95751: Error 6176 when running a query against MS SQL Server
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
14/07/2006 |
|
Status: Unverified
FACT(s) (Environment):
RedHat Enterprise Linux AS 3.0
OpenEdge 10.0B
MS SQL DataServer
SYMPTOM(s):
Error 6176 when running a query against MS SQL Server
An overflow of a character value. (6176)
22001: string data, right truncation
The issue occurs only when connecting 10.0A client on Linux to a 10.0B DataServer on Windows
A 4GL query FOR EACH NO-LOCK DISP with WHERE clause is run
The trace file reveals that a wrong SQL statement is generated, which misses 2 closing brackets before the ORDER BY clause
CAUSE:
This is a known issue being investigated by Development
FIX:
As the workaround use the following configurations:
1. Open Edge 10.0B client to connect to 10.0B DataServer, or
2. Open Edge 10.0A client to connect to 10.0A DataServer