ORA-00936: missing expression

[ravi_reddy1]

Hi friends,

My scenario is  Proxy to JDBC. its in production now.

Every day Billing invoices will flow from ECC to PI and further sent  to database to respective tables.

Every day around thousand's of invoices are flowing .

Today I checked in Message monitoring(RWB), 2 invoices are stuck in PI production system i.e in massage monitoring. once open the details of these 2 invoices from message monitoring these 2 are given same error.

I got the error like:

* what is this error?

* where exactly this error occurs?

* how to rectify this error?

Please help me

Regards,

Ravi

[bhavesh_kantilal · Accepted solution]

Please check the output of your mapping. Looks like the JDBC structure is missing some data.

Compare this with a successful message and identify the missing fields and then trace them back to why they are not populated.

Regards

Bhavesh

[ravi_reddy1 · Accepted solution]

Hi Bhavesh,

Thanks for quick replay.

could u please elaborate how to compare?

Regards

Ravi

[bhavesh_kantilal · Accepted solution]

• Take the output XML of your mapping for a successful message and failed message.
• Save it locally
• Use a File comparison tool. In my case i use either notepadd++ or KDiff3 - Homepage
• Would suggest kdiff3 as its easier to set up.

Or - you can share the XML's here and probably that can also help quickly understand what is wrong.

Regards

Bhavesh

[ravi_reddy1 · Accepted solution]

Hi Bhavesh,

I checked the payload in message mapping. but it gives all values correct.

where exactly the problem?

Regards,

Ravi

[bhavesh_kantilal · Accepted solution]

Until you cannot share the output XML of the file in message in error it is rather difficult to go ahead.

The JDBC Adapter complaints of a missing expression which means in the XML that is being created either a operator or a field is missing.

Regards

Bhavesh

[Bhargavakrishna · Accepted solution]

Hi Ravi,

You mean to say mapping is successfully executed for both Successful and error payload xml?

There might be some additional data / missing data in the error xml's.

Regards

Bhargava Krishna

[ravi_reddy1 · Accepted solution]

Hi Bhavesh,

I am unable to  share xml. its not copied to this editor.

please tell me how to copy?

Regards

Ravi

[ravi_reddy1 · Accepted solution]

Hi Bhargava,

Yes. but I don't know where exactly error occurs?

Regards,

Ravi

[bhavesh_kantilal · Accepted solution]

In SXMB_MONI, go to your payload, right click -> view source.

If that doesnt work, a screen shot might also help but otherwise it is kind of difficult to help.

And like i mentioned check the successful payload vs failed payload. One of the fields will be different or there will be some mismatch. That is what can help then nail down what this missing expression is.

Regards

Bhavesh

[bhavesh_kantilal · Accepted solution]

In SXMB_MONI, go to your payload, right click -> view source.

If that doesnt work, a screen shot might also help but otherwise it is kind of difficult to help.

And like i mentioned check the successful payload vs failed payload. One of the fields will be different or there will be some mismatch. That is what can help then nail down what this missing expression is.

Regards

Bhavesh

[Bhargavakrishna]

Hi Ravi,

In addition to Bhavesh inputs, check the below threads

JDBC: How  to select only those records wh... | SCN

JDBC receiver error- Insert whole xml as a text... | SCN

Regards

Bhargava Krishna