cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC Receiver channel is not showing any payloads

former_member192238
Participant
0 Kudos

Hello Experts,

My interface is ABAP PROXY to JDBC i am facing a strange issue in ECC moni payload is succesful in PI moni also Payload is black colour flag but my Receiver JDBC channel is not showing any thing but it is in green colour (it is not showing neither succes nor error messages logs are empty).Sender chaneels are working only problem with receiver JDBC channels

In DEV and PROD it it is working in QUAL it is showing this problem.I take the restart of QUAL server still it is behaving like that

Please throw some light on the issue any help is higlhly apprecaited.

Regards

Praveen

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

HI,

Increase the Trace level to 5 in Integration engine specific settings, if i am not wrong that should show you the outbound payload in MONI.

thanks...

Karna....

baskar_gopalakrishnan2
Active Contributor
0 Kudos

In addition to above, go to advance tab additional settings in the jdbc receiver channel and set

logSQLStatement= true

see whether that helps.

Answers (6)

Answers (6)

Former Member
0 Kudos

Hi,

As of your questation...you r says that it is fine in xi......

So it is better that you can go again on AGGREMENTS...edit all the four aggrements and save them and activate and again TEST IT..

Former Member
0 Kudos

Hi Praveen,

Please check in sxmb_moni,whether payload is dipalying or not .Please deactiave the jdbc channel and re active the channel.It will help you.In addission assign logSQLStatement=true in jdbc advance mode.

Thanks

Ravi

rajasekhar_reddy14
Active Contributor
0 Kudos

Hi,

first check in pipe line step call technical routing , mapping execution generated JDBC receiver message pay load or not.

if it is not generated then check mapping , if is is generated then restart the channel and check what communication channel name you given in receiver agreement.

monitor the same channel, if all JDBC receiver channels have same behavior then restart the JDBC adapter service in NWA.

rEGARDS,

rAJ

baskar_gopalakrishnan2
Active Contributor
0 Kudos

>Please throw some light on the issue any help is higlhly apprecaited

Manually try to do same test outside PI using toad or some database tools. See you get any data for it. It might be even data issues. Also stop and restart the channel and see the behaviour.

former_member191435
Contributor
0 Kudos

Please check your database with the credentials u have mentione din Quality. and try to check the DB with select Query if it is working fine. it is the problem of PI.

For this pleae refresh the cache and test ur interface in receiver determination with payload of moni.

Thanks,

Enivas

PriyankaAnagani
Active Contributor
0 Kudos

Hi,

Are you able to see payload in MONI after request message mapping pipeline step??? Try to do some dummy changes in JDBC receiver channel and reactivate it....also make sure that cache is updated accordingly.....

Regards,

Priyanka

former_member192238
Participant
0 Kudos

Thanks@ every one for the valuable inputs

I have edited the Communication channel and in ID i have cleared SLD cache and in SXI_CACHE i have done complete Cache refresh now it is working.

Regards

Praveen Reddy