Got an error from a COM+ server that has been in use for over a year.
The error occurs when using an XMLAdapter to apply a DiffGram to a CursorAdapter only when the DiffGram contains a lot of memo fields (20 in this case) each containing a relatively small amount of data. The error number is 18: "Line is too long - The maximum length for a command line (8,192 bytes) has been exceeded."
To be specific, the following error was logged at line 357 where loXA.Tables(1).ApplyDiffgram("", loCA) is executed:
COM Error
Server : xmlsession
Error# : 18
Method : updatecursorxml()
Line# : 357
Source : create cursor XMLTable_2A480336_BD66_4EFD_8D99_54A3C6B093D2_ from array _XMLFieldsArray_C32668E1_4C99_42FF_B8CE_DDE9B8DCE360_ (This is a VFP internal command that was trapped)
Cause : Line is too long.
Upon further investigation the following condition existed just before the attempt to apply the DiffGram:
LEN(tcXMLDiffGram) = 35671
LEN(loCA.cursorschema) = 1383
LEN(loCA.updatablefieldlist) = 1231
LEN(loCA.updatenamelist) = 3793
One of the above seems to be exceeding some internal limit.
Any one had this problem? I think this is a bug.
- Jeff