Skip to Content
avatar image
Former Member

JDBC sender channel running but not picking up the data from sp

Hi,

One of the jdbc sender channels in production is running at its schedule time but it is not picking up the data from the sql side, we have checked with the sp side and they are saying that sp is running fine. No changes have been done in its configuration. Last message coming in RWB is Retry interval started but that is of 1 day and its already been 3 days. I tried by starting and stopping the channel but of no use. The channel was re activated but that also didn't help.

Please help, what can be the reason for the same.

thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • avatar image
    Former Member
    Jun 25, 2010 at 05:24 AM

    First you need to set this property of communication channel for later

    "Disconnect from DB after processing each message"

    Second .Go to your basis team; tell them to check for Locks on Communication channel.

    Check in the nwa -->Availability and Performance Management --> LOCKS

    we get a option of Display Locks .Check for an entry with

    NAME : $XIDBAD.JDBC2XI

    reset the locks and restart the CC ,now it works fine.

    Or

    You Can create a new communication channel with copy option from existing channel, then later use that channel in scenario.

    Hope ..this will resolve your problem.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 21, 2010 at 10:08 AM

    Hi,

    Please, check note 1083488 (JDBC channel stop polling indefinitely)

    ¿have you configure task timeout parameter in your CC?

    Try to recreate your CC from Integration Directory.

    Regards,

    Carme Alentorn

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 21, 2010 at 05:09 PM

    Hi,

    Delete the Enqueue-lock related to the stopped Communication Channel.

    For the 7.1 versions, please note that the Lock Manager is under the /nwa/locks, or on the location "Availability and Performance Management -> Locks".

    Hope this helps.

    Regards,

    Neetesh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 21, 2010 at 09:05 PM

    Hi,

    Is there are any records available to pickup according to your sql statement??

    Regards

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 24, 2010 at 07:06 PM

    Hi,

    The JDBCadapter ( The respective channel) is definitely locked in PI . Ideally for each polling interval a lock is being created and once the processing is over , the lock should be released/deleted automatically to allow further polling interval. If the lock is not released by the system automatically,further polling will not happen as expected. ( This may affect all sender JDBC adapters as well. I would recommend to do a check in all sender JDBC communication channels)

    You can see/delete the locks in Visual admin.

    Go to Server>Services->Locking adapter and click refresh

    The entries for JDBC adapter ( with name $XIDBAD.JDBC2XI) should be deleted by selecting those particilar entries and click delete selected locks.

    If you have more than one node, then same should be done in all server nodes.

    The temprory solution would be creating/copy the existing channel in ID with same properties and assign it into particular sender agreement.

    But, the lock may be created again which potentailly stops all your database interfaces. Hence i would suggest to use Disconnect From Database After processing of Each messages in Advanced tab in the sender JDBC adapter.

    Hope this solves your issue.

    PS: The same bahaviour would expected for all file adapter as well

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      @ Rajesh,

      The same has been answered already, it's of no use to repeat the same thing. If you have any new ideas, share it with the forum.

  • Jun 24, 2010 at 07:32 PM

    hi

    do you see any error in Channel Monitoring?

    if you execute the SP in the data base, does it return any value? maybe there is no data to pick!

    Thanks

    Rodrigo P.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      @ Sudheer,

      This solution was already proposed, so please don't repeat the same thing. If you have new ideas / solutions, then please do share.

      -- Abhi