Polling Notification is not stable

, ,
1

The trigger on table is not stable, sometimes it work, and not work. I dont know the reason make it happen.

[71540]2008-05-23 13:58:22 JST [ADA.0001.0104V1] ローカルトランザクションをコミットします。
[71539]2008-05-23 13:58:22 JST [ART.0116.3507V1] Adapter Runtime (Notification): 通知: Test.DBSERVICES:insNotify、UUID: 7ee402146be4961f10d803f552d に対して useConnection 接続:null。
[71538]2008-05-23 13:58:22 JST [ART.0116.3504V1] Adapter Runtime (Notification): 通知: Test.DBSERVICES:insNotify、UUID: 7ee402146be4961f10d803f552d に対して実行終了。
[71537]2008-05-23 13:58:22 JST [ART.0116.3508V1] Adapter Runtime (Notification): 通知: Test.DBSERVICES:insNotify、UUID: 7ee402146be4961f10d803f552d に対して getConnection 接続:com.wm.adapter.wmjdbc.connection.JDBCConnection@e5b35。
[71536]2008-05-23 13:58:22 JST [ADA.0001.0109V1] 通知のコールバック “runCallBack”()
[71535]2008-05-23 13:58:22 JST [ART.0116.3507V1] Adapter Runtime (Notification): 通知: Test.DBSERVICES:insNotify、UUID: 7ee402146be4961f10d803f552d に対して useConnection 接続:com.wm.adapter.wmjdbc.connection.JDBCConnection@e5b35。
[71534]2008-05-23 13:58:22 JST [ADA.0001.0103V1] ローカルトランザクションを開始します。

Pls help me.

2

Have u checked if the adapter connection is working fine during this time.

3

Yes, it’s working at that time.After I reinstall WmRoot,wmPublic packages, notification is work not stable.Is this affect on it ?

4

What do you mean by reinstall WmRoot, WmPublic?

Did you copy the packages from another server? Does your server have patches/fixes that change files/classes in these packages?

5

I copied from backup files from current server.Because these package is partial so I have to do that.

6

Is it possible to retart the server.If so restart it and see whether you are geeting those errors again or not.

7

I restarted it, but it still happen.

8

Check for the connections,if they are ok…then I guess u need to disable the notification and delete the tables related to it(trigger table etc).enable it again and see if it works.