Cannot create target element.....Values missing in queue context

[Former Member]

Hi,

our scenario is proxy to jdbc . we are getting the following error in SXMB_MONI :-

Runtime exception occurred during application mapping com/sap/xi/tf/_xyz_; com.sap.aii.mappingtool.tf7.IllegalInstanceException: Cannot create target element /ns1:abc. Values missing in queue c~

we have tested our payload in message mapping test tab it throws same error .

we have checked our mapping everything is right and it is working fine in production system.

please suggest something its urgent!!

Thanks

Debanjan.

[praveen_sutra]

hi Debanjan,

Request you to provide some more clarity.

"we have checked our mapping everything is right and it is working fine in production system."

in that case where are you getting the error and second are you using same payload to do testing ?

thanks and regards,

Praveen T

[azharshaikh]

Hello Debanjan,

we have tested our payload in message mapping test tab it throws same error

>>> Means there is issue in the payload that you are using. There is no value being passed to the Mandatory Target filed. Do a Display queue and check if there are values in the queue.

we have checked our mapping everything is right and it is working fine in production system

>>> Are you doing some lookup / mapping lookup value to target field in your MM? Check if the table you are doing lookup has the required set of values in Dev box also.

Regards,

Azhar

[Former Member]

hi

yes we are using lookup and when we  do display queue on that lookup we get:-

    .

• null object loaded in lookup of XYZ

• while trying to invoke the method javax.sql.DataSource.getConnection() of a null object loaded from a local variable at slot 21

• while trying to invoke the method java.sql.Connection.createStatement() of a null object loaded from a local variable at slot 22

thanks

Debanjan

[praveen_sutra]

hi Debanjan,

Might be the there is an issue with the look-up which is causing the issue.

In production system your connection is working fine hence the lookup is returning appropriate values where as in your  other env the lookup is failing.

For the set of data you are sending there are no values existing in your table stored for look-up.

So that is causing the issues.

thanks and regards,

Praveen T

[Former Member]

Hello Debanjan ,

If your lookup is takign values from some backend tabel then you need to check that. Check your lookup.

There can be a case that data is maintained properly in Production and not in quality.

Thanks

[Former Member]

Where can we see these backend tables.

Regards

[Former Member]

Check with ABAP team for details if you are using some function module for lookup.

They might be able to tell you the details.

Paste the lookup mapping in detail here.

Thanks