Skip to Content

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

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!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Oct 29, 2013 at 09:28 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 29, 2013 at 09:42 AM

    Hi Mark

    Thanks for updating the correct answer.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 23, 2013 at 10:57 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • 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!

  • Oct 25, 2013 at 03:07 AM

    Hi experts,

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

    Thanks!

    Add comment
    10|10000 characters needed characters exceeded