java.sql.SQLException: Io exception: Size Data Unit (SDU) mismatch

[markbernabe]

Hi,

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>

Thanks!

[markbernabe · Accepted solution]

Hi,

Issue closed.

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.

[Former Member]

Hi Mark

Thanks for updating the correct answer.

[markbernabe]

Hi experts,

Any ideas on this error? Appreciate your insights regarding this.

Thanks!

[iaki_vila]

Hi Mark,

This oracle error should be a problem with the table/store procedure name. Try to use the schema before the table name.

Regards.

[markbernabe]

Hi Inaki,

I'm sorry, can you please elaborate this part"Try to use the schema before the table name."? Am I right that the problem is in oracle (database schema) and not in PI? Thanks!