Error during last attempt to refresh cache

[Former Member]

Hello,,

I am getting the error in refreshing the cache in transaction SXI_CACHE...

The error i am getting is ERROR ID -- UPDATE

The operator 'EQ' needs two operands, only one is available...

The cache is getting cleared successfully using the URL http://<hostname>:<port>/CPACache/refresh?mode=full

CPA cache refresh (mode=full) successfully executed in 125687 milliseconds..

I have checked RFC destinations ... all are working fine....

Can anyone help ?

[Former Member]

to solve this try in the INTEGRATION_DIRECTORY_HMI destination put in the path field /dir/hmi_cache_refresh_service/ext

[STALANKI]

check wether the user id and password are fine by manually logging onto XI.

[Former Member]

Hi ,,,

Thanx for ur prompt reply,,,,I followed the guide...

in administration tab, i click directory and then on cache overview.... i clicked on partial cache refresh for INTEGRATION_RUNTIME and got the error ...

Method fault! Message : IBaseException:Connection to system DIRECTORY using application DIRECTORY lost. Detailed information: Error accessing "http://ibmbtsa11.megacenter.de.ibm.com:50600/dir/hmi_cache_refresh_service/int?container=any" with user "XIISUSER". Response code is 401, response message is "Unauthorized" com.sap.aii.ib.server.abapcache.CacheRefreshException: Connection to system DIRECTORY using application DIRECTORY lost. Detailed information: Error accessing "http://ibmbtsa11.megacenter.de.ibm.com:50600/dir/hmi_cache_refresh_service/int?container=any" with user "XIISUSER". Response code is 401, response message is "Unauthorized" at com.sap.aii.ibrun.server.valueMapping.cache.RefreshClient.refresh_VMCache(RefreshClient.java:58) at com.sap.aii.ibrun.server.valueMapping.cache.HmiMethod_Invalidate.refresh(HmiMethod_Invalidate.java:79) at com.sap.aii.ibrun.server.valueMapping.cache.HmiMethod_Invalidate.process(HmiMethod_Invalidate.java:40) at com.sap.aii.ib.server.hmi.HmiServiceImpl.invokeMethod(HmiServiceImpl.java:132) at com.sap.aii.ib.server.hmi.HmiServer.process(HmiServer.java:237) at com.sap.aii.ib.sbeans.hmi.HmiBean.process(HmiBean.java:62) at com.sap.aii.ib.sbeans.hmi.HmiLocalLocalObjectImpl20.process(HmiLocalLocalObjectImpl20.java:144) at com.sap.aii.ib.web.hmi.HmiServlet.processRequestByHmiServer(HmiServlet.java:284) at com.sap.aii.ib.web.hmi.workers.ExternalClient.doWork(ExternalClient.java:78) at com.sap.aii.ib.web.hmi.HmiServlet.doWork(HmiServlet.java:563) at com.sap.aii.ib.web.hmi.HmiServlet.doGet(HmiServlet.java:705) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:390) at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:264) at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:347) at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:325) at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:887) at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:241) at com.sap.engine.services.httpserver.server.Client.handle(Client.java:92) at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:148) at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:33) at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41) at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37) at java.security.AccessController.doPrivileged(Native Method) at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:95) at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:159) IBaseException:Connection to system DIRECTORY using application DIRECTORY lost. Detailed information: Error accessing "http://ibmbtsa11.megacenter.de.ibm.com:50600/dir/hmi_cache_refresh_service/int?container=any" with user "XIISUSER". Response code is 401, response message is "Unauthorized" com.sap.aii.utilxi.hmi.api.HmiCoreException: Connection to system DIRECTORY using application DIRECTORY lost. Detailed information: Error accessing "http://ibmbtsa11.megacenter.de.ibm.com:50600/dir/hmi_cache_refresh_service/int?container=any" with user "XIISUSER". Response code is 401, response message is "Unauthorized" at com.sap.aii.utilxi.hmi.api.HmiCoreException.newCommunicationError(HmiCoreException.java:83) at com.sap.aii.utilxi.hmi.api.HmiHttpClientImpl.sendRequestAndReceiveResponseViaHttp(HmiHttpClientImpl.java:181) at com.sap.aii.utilxi.hmi.api.HmiHttpClientImpl.sendRequestAndReceiveResponse(HmiHttpClientImpl.java:92) at com.sap.aii.utilxi.hmi.api.HmiClientAdapter.invokeMethod(HmiClientAdapter.java:88) at com.sap.aii.ibrun.server.valueMapping.cache.HmiCaller.connect(HmiCaller.java:48) at com.sap.aii.ibrun.server.valueMapping.cache.HmiCaller.getXMLData(HmiCaller.java:54) at com.sap.aii.ibrun.server.valueMapping.cache.RefreshClient.refresh_VMCache(RefreshClient.java:53) at com.sap.aii.ibrun.server.valueMapping.cache.HmiMethod_Invalidate.refresh(HmiMethod_Invalidate.java:79) at com.sap.aii.ibrun.server.valueMapping.cache.HmiMethod_Invalidate.process(HmiMethod_Invalidate.java:40) at com.sap.aii.ib.server.hmi.HmiServiceImpl.invokeMethod(HmiServiceImpl.java:132) at com.sap.aii.ib.server.hmi.HmiServer.process(HmiServer.java:237) at com.sap.aii.ib.sbeans.hmi.HmiBean.process(HmiBean.java:62) at com.sap.aii.ib.sbeans.hmi.HmiLocalLocalObjectImpl20.process(HmiLocalLocalObjectImpl20.java:144) at com.sap.aii.ib.web.hmi.HmiServlet.processRequestByHmiServer(HmiServlet.java:284) at com.sap.aii.ib.web.hmi.workers.ExternalClient.doWork(ExternalClient.java:78) at com.sap.aii.ib.web.hmi.HmiServlet.doWork(HmiServlet.java:563) at com.sap.aii.ib.web.hmi.HmiServlet.doGet(HmiServlet.java:705) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:390) at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:264) at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:347) at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:325) at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:887) at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:241) at com.sap.engine.services.httpserver.server.Client.handle(Client.java:92) at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:148) at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:33) at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41) at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37) at java.security.AccessController.doPrivileged(Native Method) at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:95) at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:159) Stack trace: com.sap.aii.utilxi.hmi.api.HmiMethodFault: IBaseException:Connection to system DIRECTORY using application DIRECTORY lost. Detailed information: Error accessing "http://ibmbtsa11.megacenter.de.ibm.com:50600/dir/hmi_cache_refresh_service/int?container=any" with user "XIISUSER". Response code is 401, response message is "Unauthorized" com.sap.aii.ib.server.abapcache.CacheRefreshException: Connection to system DIRECTORY using application DIRECTORY lost. Detailed information: Error accessing "http://ibmbtsa11.megacenter.de.ibm.com:50600/dir/hmi_cache_refresh_service/int?container=any" with user "XIISUSER". Response code is 401, response message is "Unauthorized" at com.sap.aii.ibrun.server.valueMapping.cache.RefreshClient.refresh_VMCache(RefreshClient.java:58) at com.sap.aii.ibrun.server.valueMapping.cache.HmiMethod_Invalidate.refresh(HmiMethod_Invalidate.java:79) at com.sap.aii.ibrun.server.valueMapping.cache.HmiMethod_Invalidate.process(HmiMethod_Invalidate.java:40) at com.sap.aii.ib.server.hmi.HmiServiceImpl.invokeMethod(HmiServiceImpl.java:132) at com.sap.aii.ib.server.hmi.HmiServer.process(HmiServer.java:237) at com.sap.aii.ib.sbeans.hmi.HmiBean.process(HmiBean.java:62) at com.sap.aii.ib.sbeans.hmi.HmiLocalLocalObjectImpl20.process(HmiLocalLocalObjectImpl20.java:144) at com.sap.aii.ib.web.hmi.HmiServlet.processRequestByHmiServer(HmiServlet.java:284) at com.sap.aii.ib.web.hmi.workers.ExternalClient.doWork(ExternalClient.java:78) at com.sap.aii.ib.web.hmi.HmiServlet.doWork(HmiServlet.java:563) at com.sap.aii.ib.web.hmi.HmiServlet.doGet(HmiServlet.java:705) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:390) at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:264) at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:347) at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:325) at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:887) at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:241) at com.sap.engine.services.httpserver.server.Client.handle(Client.java:92) at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:148) at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:33) at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41) at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37) at java.security.AccessController.doPrivileged(Native Method) at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:95) at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:159) IBaseException:Connection to system DIRECTORY using application DIRECTORY lost. Detailed information: Error accessing "http://ibmbtsa11.megacenter.de.ibm.com:50600/dir/hmi_cache_refresh_service/int?container=any" with user "XIISUSER". Response code is 401, response message is "Unauthorized" com.sap.aii.utilxi.hmi.api.HmiCoreException: Connection to system DIRECTORY using application DIRECTORY lost. Detailed information: Error accessing "http://ibmbtsa11.megacenter.de.ibm.com:50600/dir/hmi_cache_refresh_service/int?container=any" with user "XIISUSER". Response code is 401, response message is "Unauthorized" at com.sap.aii.utilxi.hmi.api.HmiCoreException.newCommunicationError(HmiCoreException.java:83) at com.sap.aii.utilxi.hmi.api.HmiHttpClientImpl.sendRequestAndReceiveResponseViaHttp(HmiHttpClientImpl.java:181) at com.sap.aii.utilxi.hmi.api.HmiHttpClientImpl.sendRequestAndReceiveResponse(HmiHttpClientImpl.java:92) at com.sap.aii.utilxi.hmi.api.HmiClientAdapter.invokeMethod(HmiClientAdapter.java:88) at com.sap.aii.ibrun.server.valueMapping.cache.HmiCaller.connect(HmiCaller.java:48) at com.sap.aii.ibrun.server.valueMapping.cache.HmiCaller.getXMLData(HmiCaller.java:54) at com.sap.aii.ibrun.server.valueMapping.cache.RefreshClient.refresh_VMCache(RefreshClient.java:53) at com.sap.aii.ibrun.server.valueMapping.cache.HmiMethod_Invalidate.refresh(HmiMethod_Invalidate.java:79) at com.sap.aii.ibrun.server.valueMapping.cache.HmiMethod_Invalidate.process(HmiMethod_Invalidate.java:40) at com.sap.aii.ib.server.hmi.HmiServiceImpl.invokeMethod(HmiServiceImpl.java:132) at com.sap.aii.ib.server.hmi.HmiServer.process(HmiServer.java:237) at com.sap.aii.ib.sbeans.hmi.HmiBean.process(HmiBean.java:62) at com.sap.aii.ib.sbeans.hmi.HmiLocalLocalObjectImpl20.process(HmiLocalLocalObjectImpl20.java:144) at com.sap.aii.ib.web.hmi.HmiServlet.processRequestByHmiServer(HmiServlet.java:284) at com.sap.aii.ib.web.hmi.workers.ExternalClient.doWork(ExternalClient.java:78) at com.sap.aii.ib.web.hmi.HmiServlet.doWork(HmiServlet.java:563) at com.sap.aii.ib.web.hmi.HmiServlet.doGet(HmiServlet.java:705) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:390) at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:264) at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:347) at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:325) at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:887) at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:241) at com.sap.engine.services.httpserver.server.Client.handle(Client.java:92) at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:148) at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:33) at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41) at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37) at java.security.AccessController.doPrivileged(Native Method) at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:95) at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:159) at com.sap.aii.ibrun.server.valueMapping.cache.HmiMethod_Invalidate.refresh(HmiMethod_Invalidate.java:80) at com.sap.aii.ibrun.server.valueMapping.cache.HmiMethod_Invalidate.process(HmiMethod_Invalidate.java:40) at com.sap.aii.ib.server.hmi.HmiServiceImpl.invokeMethod(HmiServiceImpl.java:132) at com.sap.aii.ib.server.hmi.HmiServer.process(HmiServer.java:237) at com.sap.aii.ib.sbeans.hmi.HmiBean.process(HmiBean.java:62) at com.sap.aii.ib.sbeans.hmi.HmiLocalLocalObjectImpl20.process(HmiLocalLocalObjectImpl20.java:144) at com.sap.aii.ib.web.hmi.HmiServlet.processRequestByHmiServer(HmiServlet.java:284) at com.sap.aii.ib.web.hmi.workers.ExternalClient.doWork(ExternalClient.java:78) at com.sap.aii.ib.web.hmi.HmiServlet.doWork(HmiServlet.java:563) at com.sap.aii.ib.web.hmi.HmiServlet.doGet(HmiServlet.java:705) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:390) at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:264) at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:347) at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:325) at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:887) at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:241) at com.sap.engine.services.httpserver.server.Client.handle(Client.java:92) at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:148) at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:33) at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41) at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37) at java.security.AccessController.doPrivileged(Native Method) at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:95) at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:159) Root cause : null

As you can see.. the error is reflecting that XIISUSER is not authorized.. however the required authorizaton ( SAP_XI_IS_SERV_USER) is assigned to XIISUSER...

so what shuld i do to avoid this error ??

[MichalKrawczyk]

hi,

check pass for XIISUSER

in exchange profile and in SAPgui

try refreshing the cache with this user

it's probably not a auth issue but a password related

Regards,

michal

[Former Member]

Hello ..

I tried changing the password of XIISUSER.. and i changed the new password in exchange profile and in RFC destination also.... but i m not getting cache refreshed...

In runtime workbench when i m clicking on cache connectivity test and when i start cache test there, i m getting error in Integration Server - ABAP ... its showing..

Cache notification from Integration Directory received successfully..

Attempt to fetch cache data from Integration Directory failed; cache could not be updated.... Detailed error :

Data Evaluation]: The operator 'EQ' needs two operands, only one is available...

[Former Member]

Hi Chaitanya,

Is your RFC destination INTEGRATION_DIRECTORY_HMI is working fine?

Regards

Vijaya

[Former Member]

Hi vijaya..

i checked the RFC destination... its giving status code 500.. which i think is absolutely fine... ??

[MichalKrawczyk]

hi,

did you have a look at this doc:

https://websmp204.sap-ag.de/~sapdownload/011000358700003163902004E/HowTo_handle_XI_30_Caches.pdf

if not have a look at it just in case you've missed something

Regards,

michal

-

---

<a href="/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions"><b>XI / PI FAQ - Frequently Asked Questions</b></a>

[Former Member]

Hi Michal,

Can u send that pdf across to mew also.

My mail id: ganesh.jonna@gmail.com

Thanks a lot.