Skip to Content
avatar image
Former Member

Receiver JDBC:- No data in access tab while pullinfg data using JDBC Lookup

Hi,

I am using JDBC lookup to extract data from database using a field at runtime. But I am nt getting any values in access node at target structure. Snapshots are attached.

Thanks

3.PNG (31.5 kB)
2.PNG (34.8 kB)
1.PNG (20.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Oct 30, 2015 at 06:39 AM

    Hi Nav,

    Can we see the display queue output of the JDBC lookup?

    Regards,

    Mark

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 30, 2015 at 07:01 AM

    Hi Nav,

    Check the message monitoring and the communication channel monitoring in order to check if there is any exception.

    Check if the signature tab,in your message mapping, is correctly filled, SAP PI 7.1 Mapping Enhancements Series: Graphical Support for JDBC and RFC Lookups

    Regards.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 30, 2015 at 07:27 AM

    Hi Mark,

    There is no error in CC, but the inbound message is also not capturing this inbound field.

    Inbound and Outbound message in RWB are empty.

    Thanks

    Nav

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 01, 2015 at 07:23 PM

    Hi guys,

    My scenario File(Contains a value "123")------->Use JDBC Lookup to check for this value in Oracle 10g DB (Select all records)-------> Snd to RFC DB Table.

    I am using Receiver JDBC for JDBC Lookup. and also an ICO.for this whole setup but i am getting following error.


    Error: com.sap.aii.adapter.xi.routing.RoutingException: Unable to parse XML message payload to extract operation for receiver determinationorg.xml.sax.SAXParseException: Content is not allowed in prolog.

    Also followed this blog

    The Mystery of 'Content is not allowed in prolog'

    Can you please guide how to resolve this issue and whether the approach that I am following for this scenario is OK.

    Add comment
    10|10000 characters needed characters exceeded