JDBC Sender Mapping structure

[former_member69608]

Hi!

I want to get data from a SELECT in my sender jdbc channel. The select is "SELECT CNAME, CSENDER".

I want to put this into a message mapping, but I'm not sure what the structure should look like.

Right now source looks like this:

MT_Source

row

     CNAME

     CSENDER

I this correct? It doesnt seem to work. Is there any guide on this?

[former_member184720 · Accepted solution]

What is your PI version? You can import this automatically

If not you can refer to the imported structure in the above blog.

How did you configure Document Name in sender channel?

SAP PI Adapter Series: JDBC Adapter Configuration

Message was edited by: Hareesh Gampa

[former_member69608 · Accepted solution]

Hi,

thanks for input. This is what log viewer tells me. Must be a problem with structure, yes?

Executed query successfully, confirmation skipped - data may be sent again ("TEST" mode)

Sending query result failed with com.sap.aii.af.lib.mp.module.ModuleException: senderChannel '79bfc0c780963911923618976c426bb3': Catching exception calling messaging system - continue processing

[former_member184720 · Accepted solution]

What did you configure for Update SQL statement?

Can you share channel config screenshot?(procesing tab)

[former_member69608 · Accepted solution]

Hi,

This is sender channel and MM.

[former_member184720 · Accepted solution]

How many records does that select query return? Are there too many? If so try restricting the result set(use some where condition in select statement)

If there are not many records, May be enable xpi inspector to get additional traces.

[former_member69608 · Accepted solution]

What is the limit? I can not restrict the SELECT more because I need all the entries.

[former_member184720 · Accepted solution]

>>> I can not restrict the SELECT more because I need all the entries

What is your database? See if you can make use of rownum

select <<c1>>,<<c2>> from <<table>> where rownum <= <<n>>

If not at-least for the testing purpose, add some where clause to see if the messages goes through?

>>>What is the limit?

No answer for this

[former_member69608 · Accepted solution]

Tried this...Did not make any difference.

I get this in communication channel:

InterfaceDetermination did not yield any actual interface.

[former_member184720 · Accepted solution]

>>>Tried this...Did not make any difference.

It does i believe as you are getting a different error which makes complete sense.

If you open the failed messages from  PIMON/RWB, You should be able to see the payload. Compare the same with the structure that you defined in ESR.

>>> InterfaceDetermination did not yield any actual interface.

Go to inbound processing tab -> keep the SW component of sender interface to blank and see if it helps..

For Other alternatives -

Check for Nicolas Freyre reply in the below thread.

Error: InterfaceDetermination did not yield any actual interface in Advanced Adapter Engine

[former_member69608 · Accepted solution]

Hi,

I have had the interface-error all the time I see I forgot to type it in my first post.

The message never get sent, so I can not see it in RWB 😕

[former_member184720 · Accepted solution]

>>>The message never get sent, so I can not see it in RWB :

Ideally for that error(interface determination **** ), you should be able to find the message under AE monitoring.

May be enable the staging for message preparation step (ICo-> Advanced Settings -> Staging -> scenario specific) and then see if you can view the xml.

If not as I suggested earlier, try to get additional traces with XPI inspector.

[former_member69608 · Accepted solution]

Hi!

I managed to get it to work with your help Hareesh! Thank you!!

I disabled SWC and then the structure appeared in RWB and I was able to adjust message mapping accordingly.

[former_member192343]

HI, yes this is correct

http://help.sap.com/saphelp_nwpi71/helpdata/en/1d/756b3c0d592c7fe10000000a11405a/frameset.htm

Also you can start collecting messages by jdbc sender and see the exact structure of sender message in monitoring and then you can correct you  structure for mapping.

[former_member69608]

"start collecting messages by jdbc sender and see the exact structure of sender message in monitoring"

How can I do this?

[former_member192343]

In rwb monitoring, you can see what message jdbc adapter trying to send to pi

but usually root node of structure is what you set in channel field 'document name', then 'row', and then selected fields

If you confused by errors, you should configure right scenario first.