Adapter Lock Testing

[Former Member]

Dear All

We had an issue in our production environment where a critical interface involving sender JDBC adapter stopped working, the reason was the adapter service $XIDBAD.JDBC2XI was locked. It was then manually unlocked in NWA ->locks.

We raised an OSS note with SAP and they suggested some paremeters and patches for the permanent solution. Now when we have applied these parameters we need to test and verify the solution...

We have two options

1. We start the interface and wait for a time when lock happens ( which could be rare/impossible after applying the changes)

2. we force a lock on the service $XIDBAD.JDBC2XI ....

Is there anyway where we can utilize the option 2

regards

Sourabh

[rodrigoalejandro_pertierr]

At times JDBC adapter could be heavyly loaded or PI is high on Java Threads might cause the JDBC adapter lo get locked in NWA. Some times it could be network issues reaching the host as well.

Then this happens the adapter starts to process but never completes.

As of now we know the remedy to this as to unlock it in NWA but nothing else. :-(.

in case you monitoring channel show something like this:

1/23/08 4:06:26 PM Processing started

1/23/08 4:06:11 PM Processing started

1/23/08 4:05:56 PM Processing started

1/23/08 4:05:41 PM Processing started

1/23/08 4:05:26 PM Processing started

1/23/08 4:05:11 PM Processing started

1/23/08 4:04:56 PM Processing started

1/23/08 4:04:41 PM Processing started

Possible solution:

Either there is no data in the Database that confirms to the Query in sender jdbc adapter or , some network issues as pointed.

The solution for network issues is to select option "Disconnect From Database after each message processing"

If the JDBC adapter is going to be pulling data out from a Database every 10 secs, its gonna be a lot of data that is going through XI.

have a look at SAP Note 1083488 and see if it helps

also Two channel can poll data but should not try to change the data as it would lead to some consistency or locking issues..!! It might cause the adapter locked!!

Edited by: Rodrigo Alejandro Pertierra on Apr 6, 2011 11:38 AM

take a look to:

--> particular this

there are many thread realated to this error in SDN, some are those. incase or more datails search by "JDBC adapter locked"

page 2

[Former Member]

Hi Rodrigo,

I facing the same issue as described above.

There is data in database and query is running fine. I checked nwa/locks and restarted the java service for JDBC adapter, restarted the channel multiple times, created new channel and replace the old channel in ICO with new but nothing helped.

I am still seeing message Processing Started only.

Do you think anything else can be done to resolve the issue?

Thanks,

Vertika