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) > ______________________________**______________________________** > ___________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug12 www.wwrug12.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"