Skip to Content
avatar image
Former Member

JDBC Sender channel skips date fields when polling from SQL Server


I have the weirdest problem with JDBC Adapter. In a JDBC->RFC scenario I poll some data record by record from MSSQL Server database using a SELECT query. I have each field specified in the query (not using * ).

Fields of type "date" however, are empty in payload. The same query executed in Management Studio returns all fields, including dates, but communication channel just skips them.

Have you experienced similar behavior? How to fix this issue? The only workaround I found was to include JDBC Lookup in mapping, where I select those missing fields seperately.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Mar 21, 2017 at 04:42 PM

    Have you tried using SQL Profiler to check the exact statement is being sent to SQL Server?

    I suspect your problem might not be with the JDBC or SQL Server at all.

    Add comment
    10|10000 characters needed characters exceeded

  • May 15, 2017 at 01:56 PM

    We have got the same error after updating our SAP PI 7.31 to SP19. We are using some jdbc sender channels to read data from an Informix Database (Version 12.1). The IFlows and channels worked well just before the update to SP19.

    Symptoms: SQL queries give empty result fields on SQL Date-fields although the source has defined date-values there.

    Scale of problem: this seems only to happen with JDBC sender channels, not with JDBC receiver channels. Seems to be in relation to SP19 of SAP PI 7.31.

    Workaround: Use SAP Note 2151731 and enforce the date format for the sender adapter in the advanced adapter tab. We set it to yyyy-MM-dd and the channels worked fine again after activating-

    I think this is an error in SP19 and have reported this to SAP already.

    Best regards,

    Oliver Schönwald

    University of Hagen

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 17, 2018 at 12:45 PM

    Hi Oliver,

    Thanks for the answe. We got the same problem and solved according to your comment.

    Add comment
    10|10000 characters needed characters exceeded