continuously getting adapter notification error

Hi
we are getting below error continuously in server log

ART.116.3001] Adapter Runtime (Notification): Notification error during execution of adapter service name. Error: [ADA.1.316] Cannot execute the SQL statement “SELECT t1.OUTLET,t1.RISK_RATING,t1.wm_rowid,t1.wm_sendTime FROM WMB_UPD_FAC_PROG_bhw0h4g t1 WHERE (wm_rowid> ? ) ORDER BY wm_rowid”. "
(42000/942) ORA-00942: table or view does not exist
"
ORA-00942: table or view does not exist.

disabled and enabled the adapter connection and min connection pool is set to zero but no use…

can someone help on this

It is saying ORA-00942: table or view does not exist

Please check this with your target DBA based on the connection properties you are connecting db name and table details that resource was trying:

HTH,
RMG

1 Like

Hi RMG,

Thanks for quick reply, no such errors noticed today in ISA node but ISB(ISA and ISB are in cluster) node getting some other error related to same adapter connection

[ART.114.722] Adapter Runtime: Errors occurred attempting to lock cluster coordination in shared cache for node: adapter service name:updateRTM_SITE_FAC_PROG.
(Wrapped: Interrupted while waiting for response from:[Member(Id=3, Timestamp=2013-07-29 07:49:46.043, Address=10.146.96.189:24547, MachineId=63677, Location=machine:wmiprdc****,process:19136,member:wma:4)]) null
Stack trace data … fdb4e360-f926-11e2-abe9-8087883be8c4 NULL fdb4e360-f926-11e2-abe9-8087883be8c4
2013-07-30 08:47:43 MDT (Wrapped: Interrupted while waiting for response from:[Member(Id=3, Timestamp=2013-07-29 07:49:46.043, Address=10.146.96.189:24547, MachineId=63677, Location=machine:wmi
a,process:19136,member:wcgy003a:***4)]) null
Caused by: java.lang.InterruptedException: null

could you please advise on this.is there any impact on interface?or this is buffer memory problem?

Thanks in advance

vasu

I believe these errors in the logs should be fine unless you see any impact on your cluster and I do see some of these wrapped errors in our cluster712 servers too dealing with Adapter Notifications in the cluster env…but nothing strange or issues happened from the interface point of view.

But I would say check with SAG support also or Empower related to your error if any resolution given for cluster adjustments.

HTH,
RMG