Here are a few more details.Environment
SQL Server 2008 R2 (error happens on both dev and prod systems).
PlanetPress Workflow version 126.96.36.19967 running on Windows Server 2003 R2.
Database task is using System DSN based on Microsoft SQL Native Client Version 09.00.4035.
Database task is using dynamic SQL with parse normally and expect record set checked.
Database task emulation is set to XML, one record per datapage with data encoding of MS Windows Codepage 1252 (Latin 1).Troubleshooting
Tested SELECT query using trusted connection and SQL credentials - same result (Invalid field size).
Tested SELECT query in several different SQL tools; all work just fine (to rule out ODBC quirks).Query details
SELECT query is designed to retrieve "serialized" XML from a specific column.
Retrieved XML can run over a million characters in length on a single line (since it's serialized).
Here's the overall structure of the query:
SELECT a.MessageUid, b.StatusDescription, a.RawMessage
FROM Message as a
LEFT JOIN MessageDetails as b ON a.MessageUid = b.MessageUid
WHERE a.Status = -1 AND a.PartnerMessageUid = '1235678910'
I have even tried simplifying the query to the point where it just retrieves a single row (with no joins) but it still errors out.
Anything jump out at you as the potential problem?