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.