java.sql.SQLException: Io exception: Size Data Unit (SDU) mismatch
I have a synchronous RFC to JDBC interface with action = SQL_QUERY without placeholder. When I tested the interface, I got below error. Is this a problem in the Oracle side? Has anyone encountered this before?
<SAP:AdditionalText>com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'dbTableName' (structure 'statement'): java.sql.SQLException: Io exception: Size Data Unit (SDU) mismatch</SAP:AdditionalText>
Mark Bernabe replied
FYI, after moving and testing the interface in QA environment, the real error was exposed. It's ORA-01861: literal does not match format string - which happened due to incorrect TO_DATE function in the query.
I guess SDU mismatch was just masking the real problem which is very frustrating.