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 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) _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"