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

[Former Member]

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

[Former Member]

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

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

[Former Member]

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

[iaki_vila]

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,

Regards.

[markangelo_dihiansan]

Hi Nav,

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

Regards,

Mark

[Former Member]

Hi Mark,

Output of JDBC Lookup

Thanks

Nav

[markangelo_dihiansan]

Hi Nav,

Do you have any errors in rwb->cc monitoring?

Regards,

Mark