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"