cancel
Showing results for 
Search instead for 
Did you mean: 

Sender JDBC error

ravi_reddy1
Participant
0 Kudos

Hi Folks,

My scenario is JDBC to Proxy and development is over.

For testing purpose Database side they insert some data.

While pulling from our side i am not getting the data and i checked communication channel in RWB.

it showing only "Processing started", i nothing get like


"Polling interval started. Length: 60.0 seconds"

"Processing finished successfully"

Please the below screenshot for the same.

i didn't get the Test data, Please tell me where is the problem.

Regards,

Ravi

Accepted Solutions (1)

Accepted Solutions (1)

former_member182412
Active Contributor
0 Kudos

Hi Ravi,

  • First of all execute the same query which you configured in sender JDBC channel in any client like squirrel to see the query is returning any records.
  • Second did you configure poolWaitingTime in the channel??

Regards,

Praveen.

Answers (3)

Answers (3)

ravi_reddy1
Participant
0 Kudos

Hi Friends,

Thnks for your replay,

Channel is locked in NWA, i unlock the channel and its working fine now

Regards,

Ravi

former_member186851
Active Contributor
0 Kudos

Hello Ravi,

Great..

Please close the thread .

former_member187587
Contributor
0 Kudos

This might be due to many reasons.

Bug in PI,J2EE engine issue, or database side.

try in the following order:

  1. Stop and start channel.review results.
  2. Deactivate and activate channel.review results.
  3. Ask your Basis team to stop and start PI Instance
former_member186851
Active Contributor
0 Kudos

Hello Ravi,

check whether there is a data matching your query and check the below discussion,remove locks if any

JDBC sender adapter is polling but not picking ... | SCN