Is the error actually within SRM's display of the service request or the actual interface to build the questions?
Sent from my iPhone On Mar 6, 2012, at 9:53 PM, Joe Martin D'Souza <jdso...@shyle.net> wrote: ** That is indeed strange considering that even when using the User Tool, the DVF field that displays the SRM application, uses the Mid-Tier to display those fields. Have you tried the age old thing – uninstall and reinstall the Mid-Tier in the hope that what's broken gets fixed?? Joe *From:* Robert Heverley <robert.hever...@gmail.com> *Sent:* Tuesday, March 06, 2012 9:36 PM *Newsgroups:* public.remedy.arsystem.general *To:* arslist@ARSLIST.ORG *Subject:* Re: Receiveing ARERR 552 within SRM ** Hi Joe, Thank you for the input. That is another part of the issue.. The SQL logs and AR Server logs are not showing any detailed information.. Here is some added information since my posting.. The functionality works when using the User Tool but, not when using Midtier.. Thanks again.. Rob On Tue, Mar 6, 2012 at 5:32 PM, Joe Martin D'Souza <jdso...@shyle.net>wrote: > I would suggest taking an SQL log to see what SQL failed. A combined SQL > and API log may prove to be useful too although at this stage an SQL log > would be more useful. > > Joe > > -----Original Message----- From: Robert Heverley > Sent: Tuesday, March 06, 2012 8:24 PM Newsgroups: > public.remedy.arsystem.general > To: arslist@ARSLIST.ORG > Subject: Receiveing ARERR 552 within SRM > > Hello List, > > I was attempting to build a Query menu within the SRM application. There > is not much info to go on and the logs are not helping. > > Win 2008 64 > SQL 2008 R2 > ITSM 7.6.04 > > Thank you.. > > I need some help with the following: > > Mar 6, 2012 4:00:18 PM - SEVERE (com.remedy.log.SERVLET) : GoatException > during NDXRequest: 1/021/SRM:QuestionsFormName12/**w86sandrem0122/SRM:** > QuestionManagement12/**w86sandrem0112/SRM:ARSchema94/** > 2\2\2\4\1\1\303800600\2\2\1\4\**1\1\303800600\2\2\2\4\1\1\** > 303800600\2\2\3\4\1\1\**303800600\2\2\5\0/1/10/2/0/2/**0/2/0/2/0/2/0/2/0/2/0/2/0/2/0/ > = > ARERR [552] The SQL database operation failed. : Multiple-step OLE DB > operation generated errors. Check each OLE DB status value, if available. > No work was done. (HRESULT: 0X80040E21) > > at com.remedy.arsys.goat.menu.**Menu.expandMenu(Unknown Source) > at com.remedy.arsys.goat.menu.**QueryMenu.emitJS(Unknown Source) > at com.remedy.arsys.backchannel.**ExpandMenuAgent.process(**Unknown > Source) > at com.remedy.arsys.backchannel.**NDXRequest.processRequest(**Unknown > Source) > at com.remedy.arsys.backchannel.**NDXRequest.<init>(Unknown Source) > at com.remedy.arsys.backchannel.**EntryListBase.<init>(Unknown Source) > at com.remedy.arsys.backchannel.**NDXExpandMenu.<init>(Unknown Source) > at com.remedy.arsys.backchannel.**ExpandMenuAgent.<init>(Unknown Source) > at com.remedy.arsys.backchannel.**NDXFactory.handleRequest(**Unknown > Source) > at com.remedy.arsys.stubs.**BackchannelServlet.doRequest(**Unknown Source) > at com.remedy.arsys.stubs.**GoatServlet.postInternal(**Unknown Source) > at com.remedy.arsys.stubs.**GoatHttpServlet.doGet(Unknown Source) > at javax.servlet.http.**HttpServlet.service(**HttpServlet.java:617) > at javax.servlet.http.**HttpServlet.service(**HttpServlet.java:717) > at org.apache.catalina.core.**ApplicationFilterChain.**internalDoFilter(** > ApplicationFilterChain.java:**290) > at org.apache.catalina.core.**ApplicationFilterChain.**doFilter(** > ApplicationFilterChain.java:**206) > at org.apache.catalina.core.**StandardWrapperValve.invoke(** > StandardWrapperValve.java:233) > at org.apache.catalina.core.**StandardContextValve.invoke(** > StandardContextValve.java:191) > at org.apache.catalina.core.**StandardHostValve.invoke(** > StandardHostValve.java:128) > at org.apache.catalina.valves.**ErrorReportValve.invoke(** > ErrorReportValve.java:102) > at org.apache.catalina.core.**StandardEngineValve.invoke(** > StandardEngineValve.java:109) > at org.apache.catalina.connector.**CoyoteAdapter.service(** > CoyoteAdapter.java:293) > at org.apache.jk.server.**JkCoyoteHandler.invoke(** > JkCoyoteHandler.java:190) > at org.apache.jk.common.**HandlerRequest.invoke(**HandlerRequest.java:291) > at org.apache.jk.common.**ChannelSocket.invoke(**ChannelSocket.java:769) > at org.apache.jk.common.**ChannelSocket.**processConnection(** > ChannelSocket.java:698) > at org.apache.jk.common.**ChannelSocket$**SocketConnection.runIt(** > ChannelSocket.java:891) > at org.apache.tomcat.util.**threads.ThreadPool$**ControlRunnable.run(** > ThreadPool.java:690) > at java.lang.Thread.run(Unknown Source) > Caused by: ERROR (552): The SQL database operation failed.; Multiple-step > OLE DB operation generated errors. Check each OLE DB status value, if > available. No work was done. (HRESULT: 0X80040E21) _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
