Trying the build the question.. On Tue, Mar 6, 2012 at 5:55 PM, Tauf Chowdhury <[email protected]> wrote:
> ** > 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 <[email protected]> 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 <[email protected]> > *Sent:* Tuesday, March 06, 2012 9:36 PM > *Newsgroups:* public.remedy.arsystem.general > *To:* [email protected] > *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 <[email protected]>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: [email protected] >> 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"_ > > _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"
