Hello Listers, At one of client site AR Server get crashed. Environment is ARS 7.0.1, Database ORACLE 10 g OS- Solaris, Midtier 7.0.1
Server was crashed at regular interval of time 3 weeks back but afterwards crashed stopped. The volume of tickets logged into remedy is around 30 thousands per day. 90% of tickets are logged through web services. please help me out as it becomes very critical. The error are Nov 2, 2008 3:56:10 PM com.remedy.arsys.ws.services.ARService expandXPathExpressions FINE: Old Qualification: 0 Expanded Qualification: 0 Nov 2, 2008 3:56:10 PM com.remedy.arsys.log.Log log SEVERE: AxisFault : MessageType: 2 MessageNum: 302 MessageText: Entry does not exist in database AppendedText: at com.remedy.arsys.api.Proxy.ARXMLGetEntry(Native Method) at com.remedy.arsys.api.Util.ARXMLGetEntry(Util.java:2856) at com.remedy.arsys.ws.services.ARService.performOperation(Unknown Source) at com.remedy.arsys.ws.services.ARService.processRequest(Unknown Source) at sun.reflect.GeneratedMethodAccessor43.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.axis.providers.java.MsgProvider.processMessage(MsgProvider.java:141) at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:319) at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32) at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118) at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83) at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:453) at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281) at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699) at javax.servlet.http.HttpServlet.service(HttpServlet.java:647) at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Thread.java:595) Nov 2, 2008 3:56:10 PM com.remedy.arsys.ws.services.ARService processRequest FINE: WS Total time = 58 Nov 2, 2008 3:56:10 PM com.remedy.arsys.ws.services.ARService getInputDoc FINE: inputDocStr(before namespaces): <urn:getLastIncidentsForCustomer xmlns:urn="urn:LTR_HPD_Help_Desk"><urn:MSISDN_No>989366628482</urn:MSISDN_No></urn:getLastIncidentsForCustomer> Nov 2, 2008 3:56:10 PM com.remedy.arsys.ws.services.ARService getWebServiceInfo FINE: operationName: getLastIncidentsForCustomer Nov 2, 2008 3:56:10 PM com.remedy.arsys.ws.services.ARService getWebServiceInfo FINE: nameSpace urn:LTR_HPD_Help_Desk Nov 2, 2008 3:56:10 PM com.remedy.arsys.ws.services.ARService getWebServiceInfo FINE: server: remedy Nov 2, 2008 3:56:10 PM com.remedy.arsys.ws.services.ARService getWebServiceInfo FINE: webService: LTR_HPD_Help_Desk Nov 2, 2008 3:56:10 PM com.remedy.arsys.session.Login initWebService FINE: Login: Axis Session is good !!! Nov 2, 2008 3:56:10 PM com.remedy.arsys.ws.services.ARService processRequest FINE: LOGIN SUCCESS: User[Demo] Nov 2, 2008 3:56:10 PM com.remedy.arsys.ws.services.ARService getOperationInfo FINE: Operation Info: <?xml version="1.0" encoding="windows-1252"?> <operation name="getLastIncidentsForCustomer" type="get" maxLimit="5" startRecord="0" qualification="'MSISDN_No' LIKE XPATH(/ROOT/MSISDN_No)"> <inputMapping name="GetListInputMap111" topLevelElement="getLastIncidentsForCustomer"/> <outputMapping name="GetListOutputMap111" topLevelElement="getLastIncidentsForCustomerResponse"/> </operation> Nov 2, 2008 3:56:10 PM com.remedy.arsys.ws.services.ARService performOperation FINE: input document: <?xml version="1.0" encoding="UTF-8"?> <ROOT xmlns:urn="urn:LTR_HPD_Help_Desk"><urn:MSISDN_No>989366628482</urn:MSISDN_No></ROOT> Nov 2, 2008 3:56:10 PM com.remedy.arsys.ws.services.ARService getXPathValue FINE: Token: ROOT Nov 2, 2008 3:56:10 PM com.remedy.arsys.ws.services.ARService getXPathValue FINE: Token: MSISDN_No Nov 2, 2008 3:56:10 PM com.remedy.arsys.ws.services.ARService getXPathValue FINE: CHILD MSISDN_No Nov 2, 2008 3:56:10 PM com.remedy.arsys.ws.services.ARService getXPathValue FINE: Found matching text node. Value = 989366628482 Nov 2, 2008 3:56:10 PM com.remedy.arsys.ws.services.ARService expandXPathExpressions FINE: Old XPATH Expression: /ROOT/MSISDN_No Expanded XPATH Expression: "989366628482" Nov 2, 2008 3:56:10 PM com.remedy.arsys.ws.services.ARService expandXPathExpressions FINE: Old Qualification: 'MSISDN_No' LIKE XPATH(/ROOT/MSISDN_No) Expanded Qualification: 'MSISDN_No' LIKE "989366628482" Nov 2, 2008 3:56:10 PM com.remedy.arsys.ws.services.ARService expandXPathExpressions FINE: Old Qualification: 5 Expanded Qualification: 5 Nov 2, 2008 3:56:10 PM com.remedy.arsys.ws.services.ARService expandXPathExpressions FINE: Old Qualification: 0 Expanded Qualification: 0 Nov 2, 2008 3:56:10 PM com.remedy.arsys.ws.services.ARService performOperation FINE: WS Get time = 64 Nov 2, 2008 3:56:10 PM com.remedy.arsys.ws.services.ARService performOperation FINE: output document from AR Server: <?xml version="1.0" encoding="utf-8"?> <ns0:ROOT xmlns:ns0="urn:LTR_HPD_Help_Desk" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <ns0:getListValues> <ns0:Assignee>Mozhgan Kamali Mokarram</ns0:Assignee> <ns0:Description>*Caller is not owner/Tamas Girandeh malek nist</ns0:Description> <ns0:Escalated>No</ns0:Escalated> <ns0:First_Name>Mozhgan</ns0:First_Name> <ns0:Incident_Number>INC000001433974</ns0:Incident_Number> <ns0:Last_Modified_Date>2008-08-05T12:24:07+04:00</ns0:Last_Modified_Date> <ns0:Last_Name>Kamali Mokarram</ns0:Last_Name> <ns0:Product_Categorization_Tier_1>End User</ns0:Product_Categorization_Tier_1> <ns0:Reported_Date>2008-08-05T12:24:07+04:00</ns0:Reported_Date> <ns0:Reported_Source>Other</ns0:Reported_Source> <ns0:Status>Resolved</ns0:Status> </ns0:getListValues> <ns0:getListValues> <ns0:Assignee>Mahnaz Aghaalikhani</ns0:Assignee> <ns0:Description>*Caller is not owner/Tamas Girandeh malek nist</ns0:Description> <ns0:Escalated>No</ns0:Escalated> <ns0:First_Name>Mahnaz</ns0:First_Name> <ns0:Incident_Number>INC000001433825</ns0:Incident_Number> <ns0:Last_Modified_Date>2008-08-05T12:20:25+04:00</ns0:Last_Modified_Date> <ns0:Last_Name>Aghaalikhani</ns0:Last_Name> <ns0:Product_Categorization_Tier_1>End User</ns0:Product_Categorization_Tier_1> <ns0:Reported_Date>2008-08-05T12:20:25+04:00</ns0:Reported_Date> <ns0:Reported_Source>Other</ns0:Reported_Source> <ns0:Status>Resolved</ns0:Status> </ns0:getListValues> <ns0:getListValues> <ns0:Assignee>Farhood Farahmand</ns0:Assignee> <ns0:Description>Sim Registration Faild</ns0:Description> <ns0:Escalated>No</ns0:Escalated> <ns0:First_Name>Hossein</ns0:First_Name> <ns0:Incident_Number>INC000000632203</ns0:Incident_Number> <ns0:Last_Modified_Date>2008-06-17T13:24:45+04:00</ns0:Last_Modified_Date> <ns0:Last_Name>Dolati</ns0:Last_Name> <ns0:Product_Categorization_Tier_1>Enterprise Applications</ns0:Product_Categorization_Tier_1> <ns0:Reported_Date>2008-06-16T19:51:41+04:00</ns0:Reported_Date> <ns0:Reported_Source>Email</ns0:Reported_Source> <ns0:Status>Resolved</ns0:Status> </ns0:getListValues> <ns0:getListValues> <ns0:Assignee>Amirhossein Haji Hosseini</ns0:Assignee> <ns0:Description>Cant authenticate Customer / Moshkle dar taeed moshtari</ns0:Description> <ns0:Escalated>No</ns0:Escalated> <ns0:First_Name>Amirhossein</ns0:First_Name> <ns0:Incident_Number>INC000000604826</ns0:Incident_Number> <ns0:Last_Modified_Date>2008-06-14T20:04:54+04:00</ns0:Last_Modified_Date> <ns0:Last_Name>Haji Hosseini</ns0:Last_Name> <ns0:Product_Categorization_Tier_1>End User</ns0:Product_Categorization_Tier_1> <ns0:Reported_Date>2008-06-14T20:04:54+04:00</ns0:Reported_Date> <ns0:Reported_Source>Other</ns0:Reported_Source> <ns0:Status>Resolved</ns0:Status> </ns0:getListValues> <ns0:getListValues> <ns0:Assignee>Amir Radmanesh</ns0:Assignee> <ns0:Description>Puk / Kod Ghofle Goshaye Shakhsi</ns0:Description> <ns0:Escalated>No</ns0:Escalated> <ns0:First_Name>Amir</ns0:First_Name> <ns0:Incident_Number>INC000000591869</ns0:Incident_Number> <ns0:Last_Modified_Date>2008-06-13T22:47:39+04:00</ns0:Last_Modified_Date> <ns0:Last_Name>Radmanesh</ns0:Last_Name> <ns0:Product_Categorization_Tier_1>End User</ns0:Product_Categorization_Tier_1> <ns0:Reported_Date>2008-06-13T22:47:39+04:00</ns0:Reported_Date> <ns0:Reported_Source>Other</ns0:Reported_Source> <ns0:Status>Resolved</ns0:Status> </ns0:getListValues> </ns0:ROOT> Nov 2, 2008 3:56:10 PM com.remedy.arsys.ws.services.ARService processRequest FINE: WS Total time = 97 Nov 2, 2008 3:56:10 PM com.remedy.arsys.ws.services.ARService getInputDoc FINE: inputDocStr(before namespaces): <urn:getLastIncidentsForCustomer xmlns:urn="urn:LTR_HPD_Help_Desk"><urn:MSISDN_No>989356566034</urn:MSISDN_No></urn:getLastIncidentsForCustomer> Nov 2, 2008 3:56:10 PM com.remedy.arsys.ws.services.ARService getWebServiceInfo FINE: operationName: getLastIncidentsForCustomer Nov 2, 2008 3:56:10 PM com.remedy.arsys.ws.services.ARService getWebServiceInfo FINE: nameSpace urn:LTR_HPD_Help_Desk Nov 2, 2008 3:56:10 PM com.remedy.arsys.ws.services.ARService getWebServiceInfo FINE: server: remedy Nov 2, 2008 3:56:10 PM com.remedy.arsys.ws.services.ARService getWebServiceInfo FINE: webService: LTR_HPD_Help_Desk Nov 2, 2008 3:56:10 PM com.remedy.arsys.session.Login initWebService FINE: Login: Axis Session is good !!! Nov 2, 2008 3:56:10 PM com.remedy.arsys.ws.services.ARService processRequest FINE: LOGIN SUCCESS: User[Demo] Nov 2, 2008 3:56:10 PM com.remedy.arsys.ws.services.ARService getOperationInfo FINE: Operation Info: <?xml version="1.0" encoding="windows-1252"?> <operation name="getLastIncidentsForCustomer" type="get" maxLimit="5" startRecord="0" qualification="'MSISDN_No' LIKE XPATH(/ROOT/MSISDN_No)"> Thanks & Regards Anil Add more friends to your messenger and enjoy! Go to http://messenger.yahoo.com/invite/ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"