IncorrectFormat with json

Data Abstract
1

I’m getting this error when call sqlGetData on a DA server on .net:

{u’version’: u’1.1’, u’id’: u’{c02211db-f18f-4a25-80b1-f3f1deb65d05}’, u’error’: {u’message’: u’IncorrectFormat’, u’code’: u’1’, u’name’: u’JsonRPCError’}}

This not happend if call getData.

This is using json streamer, json message, and jsonrpc from python.

This is the full post debug info from httplib:

send: ‘{“params”: [“SELECT * FROM Product ORDER BY Name”, true, -1], “method”: “Data.sqlGetData”, “id”: “{6190264a-3290-44e0-baed-3f9f767b28e4}”}‘
reply: ‘HTTP/1.1 200 OK\r\n’
header: Server: RemObjects SDK for .NET HTTP Server/5.0
header: Content-Type: application/json
header: Content-Length: 134
header: Connection: Close
{u’version’: u’1.1’, u’id’: u’{6190264a-3290-44e0-baed-3f9f767b28e4}’, u’error’: {u’message’: u’IncorrectFormat’, u’code’: u’1’, u’name’: u’JsonRPCError’}}

2

Well, in fact this happend too with BIN message. I’m complete stuck on this, because I don’t get any stack trace or any other info about this error (I ask about how get the exceptions on http://connect.remobjects.com/discussion/1170/how-catch-log-exceptions-on-net).

This happend too when call from the Delphi IDE “Get Design data” with any table, as with normal calls.

3

Hello.

Sorry for the belated response.
Unfortunately I can’t reproduce the problem. Can you send us small testcase with it to investigate this problem in details? Seems you use custom method sqlGetData. Could you provide RODL with its definition ?

Thanks in advance.

4

Hi, This was related to a error in the daConfig file.

To make DevArt work to fetch the params, this need to be in the config NameSymbol=":", however that mess with the apply updates and the use of params in the calls, so is necesary to change it to NameSymbol="".

Without a detailed callstack I wrongly assume was a problem with the format of the JSON message, however, after get the response about how log the exceptions, I detect was a issue with the driver…

http://connect.remobjects.com/discussion/1170/how-catch-log-exceptions-on-net