Message ID is not highlighted in channel to see details

[ramu_g4]

Hi Experts,

In channel logs the it shows the messages are processed but those are not highlighted as shown in first screen shot but for successfully running interface it should be highlighted as shown in second screen shot below.

But the message ID are highlighted as shown below.

Since this is a sender channel do you think the incoming payload do not match with data structure as that of existing defined in PI? or what all might be the reasons for it?

Thanks,

Ramu G.

[Former Member · Accepted solution]

is the sender channel is JDBC? if so then during polling there are no records to pull from database, polling ends with empty result set (Message id).

[ramu_g4 · Accepted solution]

Hi Ramkumar,

Thanks for your reply!

Yes the sender channel is JDBC. But sender side people complain there are records present but the channel is not picking up? Can you pls help to resolve this?

Regards,

Ramu.

[PavanKumar]

Hi Ramu,

1) when there are no records to fetch from DB

In this case whenever jdbc channel got polled u can see message id which is not highlighted

2) when there are records in DB to fetch

you can see message id highlighted and also same message id you can also see in explanation tab this means data got fetched from Db.

Please cross check with your DB team that the select/update query which you are using in jdbc sender channel is correct and also make sure data available in Db to fetch.

Its purely data not available in db/you are some wrong query due to that messages are not generating.

Regards

Pavan

[Former Member]

Hi Ruma,

Your polling interval is 120sec for the first screenshot and 7200sec for the second one.

Are you sure there is a record as mentioned by above.

Also what is the your scenario?

Thanks

Faith

[ramu_g4]

Hi Faith,

Thanks for you reply.

Are you sure there is a record as mentioned by Ajinkya Deshpande above.

- Yes records are present.

Also what is the your scenario?

- JDBC to RFC scenario where sender is GreenPlum DB and Receiver is SAP BI/BW.

Thanks,

Ramu.

[Former Member]

HI Ruma,

As others have suggested it might be the query in the DB. What is your query?

Look at this thread  below as there are different answers hope it helps.

[former_member233209]

Hi Ramu,

Please check with DBA whether any data/record is present in table you are accessing via sender channel.

It happens when there is no record available to process.

Regards,

Ajinkya

[ramu_g4]

Hi Ajinkya,

Thanks for you reply,the records are present on DBA side but they are not getting picked up.

Here there are multiple sender channels but some are functioning well and records are getting picked up and processed. But only few channels are showing in logs records are processed but no records are picked/processed.

Regards,

Ramu.

[former_member233209]

Hi Ramu,

Try to execute query you have maintained in sender channel manually at database end, and check whether records are visible or not?

Regards,

Ajinkya

[former_member186851]

Hello Ramu,

If all the logs are enabled check if the notes in the below discussion helps you

Message id not highlighted to see the details i... | SCN

[ramu_g4]

Hi Raghu,

Thanks for your inputs. The scenario is JDBC to RFC here, the issue is records are not pulled/picked up from DB side. Would it be the issue with query [ SELECT or UPDATE] ?

Thanks,

Ramu G.

[former_member186851]

Hello Ramu,

I don't think so Since your getting success response and some times message id is also generated.

Did you check the discussion I shared.

[ramu_g4]

Hi Raghu,

The issue is not like message getting highlighted but records not getting picked up from sender JDBC side? How to resolve this?

Thanks,

Ramu.

[former_member186851]

Hello Ramu,

Try restarting the channel or check for any channel locks.

Are you facing this issue for all the messages or particular to some?