JDBC Receiver Adapter - Synchronous call error in response structure - PI 7.31

Hi All,

I am working on a SOAP->JDBC synchronous scenario in PI 7.31 single stack.

I am getting an error while running the scenario saying "com.sap.aii.utilxi.misc.api.BaseRuntimeException; The content of elements must consist of well-formed character data or markup.". This error is encountered in response mapping.

I am running SQL_QUERY as access in mapping for the JDBC adapter and fetching a count. Query is like 'Select count(field) from table where (condition)'

Based on that, I have only one field in response structure 'COUNT'.

Since I'm getting error in response mapping, my guess is that the response structure is not correct. I was unable to find any thread which tells about the response structure in case of SQL_QUERY.

Please help me in identifying the issue that is causing the failure. Any guidance for JDBC response structures will be highly appreciated.

Thanks,

Abhishek