We have a client application built with DA and RO 9.3 which is calling GetData from the DataService.
The server is built on Linux64 (Ubuntu 18.04) with DA and RO 9.5 (November 2018). When the server is trying to add the dynamicwhere to the statement it gives conversion error.
I found out that the XML parser is not reading correctly the values. The operators, table names and types are processed correctly.
I tried to define the OpenXML and NextGenXML, but the error is the same.
I attached a sample to reproduce the error. I copied the code which is processing the dynamicwhere clause.
Thank you.
Now the test project is working, so I replaced the source file.
With this update when the server receives an GetData with dynamicwhere clause, it cuts the first < character before query and the Xml.Internal.OmniXML unit ReadFromStream function gives unclosed document error HIERARCHY_REQUEST_ERR.
The temporary solution was to add it TDASchema.ApplyDynWhere function if the first char of lWhereClause is not <
I don’t think it’s a bug, because before I have overwritten the fixed unit, the XML received by the server was correct. The only change what I made is to replace the file.