Skip to Content

JDBC Sender adapter "Processing started" but doesnt pick any records

Hi ,

I have a JDBC Sender adapter which doesn't pick records from the DB Tables. It only gives me the message "Processing started" in communication channel monitoring.

I had tried the following,

1. Stop and Started the channel

2. Copied the existing channel to a new channel and assigned the new channel to ICO.

3. Create a new sender JDBC channel from scratch and assigned it to the ICO

4. I did dummy changes and activate the channel then data is coming PI but it is not showing in channel monitoring. Only 1 or 2 records will come after that same issue.

5. i have restart the JDBC server then also no luck.

6. There are 50 to 60 columns are there in DB to select. Is there any limit to select the records from DB.

7. i have changed select query (select * from table where flag=1) instead of selecting all the coloumns only 3 to4 coloumns i have selected. (Select coloumn1 , column2 ,..coloumn4 from table where flag=1) then it is working fine.

I tired all the above approach, but still the adapter is not working. kindly suggest any solution for this.

Thanks,

Ramu

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Feb 16 at 06:45 AM

    Hi Ramu,

    1)How many records are there in that particular table which you trying to fetch

    2)Are you updating the records which got fetched if not use the update statement

    3) what is the polling interval you had set?

    Instead of fetching all the records in a particular time interval you can keep restriction by keeping the limit such as (select * from table where rownum<=100)

    4) you can able to see the processing started log in communication channel monitor it is because select or update statement is still running in the database it is because you are fetching/updating more records from the database at particular interval

    In order to get out of this issue put limit for records to fetch and update check with database team as well.

    If it is in development DB administrator can kill the session but not recommended in production

    Regards

    Pavan

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 16 at 07:15 AM

    Hi Ramu!

    As Pavan has already suggested, first, you should try with couple of records in order to clarify, which would be the size of your message. Second, I'd strongly suggest not to use "select *" in your statements.

    Regards, Evgeniy.

    Add comment
    10|10000 characters needed characters exceeded