2 Replies Latest reply on May 10, 2013 9:49 PM by 984189

    Content Server Request Failed

    984189
      This error has caused the UCM to not respond to any search request.

      "     Unable to execute service GET_SEARCH_RESULTS and function tagSearchedContent."


      Event generated by user 'hddUCMAdmin' at host 'brmhdd01.us.oracle.com:16200'. Unable to execute service GET_SEARCH_RESULTS and function tagSearchedContent.
      Unable to execute SQL statement 'insert into taggedContentStorage (dDocName,dDocAuthor,Disk_Drive_Name,dDocTitle,dDocType,dID,Accesses,Last_Accesses) values ('HDD_012158','mikemartinez','ITVSC2BA3SUN100G','ssd-dc-s3700-spec May'13.pdf','Vendor Documents','14038',1,sysdate)'. ORA-00917: missing comma
      java.sql.SQLSyntaxErrorException: ORA-00917: missing comma. [ Details ]

      An error has occurred. The stack trace below shows more information.

      !csUserEventMessage,hddUCMAdmin,brmhdd01.us.oracle.com:16200!$!csServiceDataException,GET_SEARCH_RESULTS,tagSearchedContent!$!csDbUnableToExecuteSql,insert into taggedContentStorage (dDocName\,dDocAuthor\,Disk_Drive_Name\,dDocTitle\,dDocType\,dID\,Accesses\,Last_Accesses) values ('HDD_012158'\,'mikemartinez'\,'ITVSC2BA3SUN100G'\,'ssd-dc-s3700-spec May'13.pdf'\,'Vendor Documents'\,'14038'\,1\,sysdate)!$ORA-00917: missing comma<br>!syJavaExceptionWrapper,java.sql.SQLSyntaxErrorException: ORA-00917: missing comma<br>
      intradoc.common.ServiceException: !csServiceDataException,GET_SEARCH_RESULTS,tagSearchedContent!$
      *ScriptStack GET_SEARCH_RESULTS
      3:tagSearchedContent,dID=14039,dDocName=HDD_012159
      at intradoc.server.ServiceRequestImplementor.buildServiceException(ServiceRequestImplementor.java:2115)
      at intradoc.server.Service.buildServiceException(Service.java:2260)
      at intradoc.server.Service.createServiceExceptionEx(Service.java:2254)
      at intradoc.server.Service.createServiceException(Service.java:2249)
      at intradoc.server.ServiceRequestImplementor.handleActionException(ServiceRequestImplementor.java:1766)
      at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1716)
      at intradoc.server.Service.doAction(Service.java:477)
      at intradoc.server.ServiceRequestImplementor.doActions(ServiceRequestImplementor.java:1458)
      at intradoc.server.Service.doActions(Service.java:472)
      at intradoc.server.ServiceRequestImplementor.executeActions(ServiceRequestImplementor.java:1391)
      at intradoc.server.Service.executeActions(Service.java:458)
      at intradoc.server.ServiceRequestImplementor.doRequest(ServiceRequestImplementor.java:737)
      at intradoc.server.Service.doRequest(Service.java:1890)
      at intradoc.server.ServiceManager.processCommand(ServiceManager.java:435)
      at intradoc.server.IdcServerThread.processRequest(IdcServerThread.java:265)
      at intradoc.idcwls.IdcServletRequestUtils.doRequest(IdcServletRequestUtils.java:1343)
      at intradoc.idcwls.IdcServletRequestUtils.processFilterEvent(IdcServletRequestUtils.java:1715)
      at intradoc.idcwls.IdcIntegrateWrapper.processFilterEvent(IdcIntegrateWrapper.java:222)
      at sun.reflect.GeneratedMethodAccessor167.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at idcservlet.common.IdcMethodHolder.invokeMethod(IdcMethodHolder.java:87)
      at idcservlet.common.ClassHelperUtils.executeMethodEx(ClassHelperUtils.java:305)
      at idcservlet.common.ClassHelperUtils.executeMethodWithArgs(ClassHelperUtils.java:278)
      at idcservlet.ServletUtils.executeContentServerIntegrateMethodOnConfig(ServletUtils.java:1600)
      at idcservlet.IdcFilter.doFilter(IdcFilter.java:352)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:111)
      at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:313)
      at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:413)
      at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:94)
      at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:161)
      at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:136)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:111)
      at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:313)
      at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:413)
      at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:94)
      at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:161)
      at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715)
      at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)
      at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
      at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
      at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277)
      at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)
      at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)
      at weblogic.work.ExecuteThread.execute(ExecuteThread.java:207)
      at weblogic.work.ExecuteThread.run(ExecuteThread.java:176)
      Caused by: intradoc.data.DataException: !csDbUnableToExecuteSql,insert into taggedContentStorage (dDocName\,dDocAuthor\,Disk_Drive_Name\,dDocTitle\,dDocType\,dID\,Accesses\,Last_Accesses) values ('HDD_012158'\,'mikemartinez'\,'ITVSC2BA3SUN100G'\,'ssd-dc-s3700-spec May'13.pdf'\,'Vendor Documents'\,'14038'\,1\,sysdate)!$ORA-00917: missing comma

      at intradoc.jdbc.JdbcWorkspace.handleSQLException(JdbcWorkspace.java:2461)
      at intradoc.jdbc.JdbcWorkspace.executeSQL(JdbcWorkspace.java:830)
      at com.ecm.oracle.hdd.TagSearchedContent.tagSearchedContent(TagSearchedContent.java:163)
      at sun.reflect.GeneratedMethodAccessor505.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at intradoc.common.IdcMethodHolder.invokeMethod(IdcMethodHolder.java:87)
      at intradoc.common.ClassHelperUtils.executeMethodReportStatus(ClassHelperUtils.java:324)
      at intradoc.server.ServiceHandler.executeAction(ServiceHandler.java:79)
      at intradoc.server.Service.doCodeEx(Service.java:533)
      at intradoc.server.Service.doCode(Service.java:506)
      at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1643)
      at intradoc.server.Service.doAction(Service.java:477)
      at intradoc.server.ServiceRequestImplementor.doActions(ServiceRequestImplementor.java:1458)
      at intradoc.server.Service.doActions(Service.java:473)
      ... 43 more
      Caused by: java.sql.SQLSyntaxErrorException: ORA-00917: missing comma

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:457)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
      at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:889)
      at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:476)
      at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:204)
      at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:540)
      at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:202)
      at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1074)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1466)
      at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:6474)
      at oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(OracleStatement.java:6621)
      at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:2127)
      at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:2067)
      at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:306)
      at weblogic.jdbc.wrapper.Statement.executeUpdate(Statement.java:511)
      at intradoc.jdbc.JdbcWorkspace.executeSQL(JdbcWorkspace.java:824)
      at com.ecm.oracle.hdd.TagSearchedContent.tagSearchedContent(TagSearchedContent.java:163)
      at sun.reflect.GeneratedMethodAccessor505.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at intradoc.common.IdcMethodHolder.invokeMethod(IdcMethodHolder.java:86)
      at intradoc.common.ClassHelperUtils.executeMethodReportStatus(ClassHelperUtils.java:324)
      at intradoc.server.ServiceHandler.executeAction(ServiceHandler.java:79)
      at intradoc.server.Service.doCodeEx(Service.java:533)
      at intradoc.server.Service.doCode(Service.java:505)
      at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1643)
      at intradoc.server.Service.doAction(Service.java:477)
      at intradoc.server.ServiceRequestImplementor.doActions(ServiceRequestImplementor.java:1458)
      at intradoc.server.Service.doActions(Service.java:472)
      at intradoc.server.ServiceRequestImplementor.executeActions(ServiceRequestImplementor.java:1391)
      at intradoc.server.Service.executeActions(Service.java:458)
      at intradoc.server.ServiceRequestImplementor.doRequest(ServiceRequestImplementor.java:737)
      at intradoc.server.Service.doRequest(Service.java:1890)
      at intradoc.server.ServiceManager.processCommand(ServiceManager.java:435)
      at intradoc.server.IdcServerThread.processRequest(IdcServerThread.java:265)
      at intradoc.idcwls.IdcServletRequestUtils.doRequest(IdcServletRequestUtils.java:1343)
      at intradoc.idcwls.IdcServletRequestUtils.processFilterEvent(IdcServletRequestUtils.java:1715)
      at intradoc.idcwls.IdcIntegrateWrapper.processFilterEvent(IdcIntegrateWrapper.java:222)
      at sun.reflect.GeneratedMethodAccessor167.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at idcservlet.common.IdcMethodHolder.invokeMethod(IdcMethodHolder.java:87)
      at idcservlet.common.ClassHelperUtils.executeMethodEx(ClassHelperUtils.java:305)
      at idcservlet.common.ClassHelperUtils.executeMethodWithArgs(ClassHelperUtils.java:278)
      at idcservlet.ServletUtils.executeContentServerIntegrateMethodOnConfig(ServletUtils.java:1600)
      at idcservlet.IdcFilter.doFilter(IdcFilter.java:352)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:111)
      at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:313)
      at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:413)
      at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:94)
      at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:161)
      at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:136)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:111)
      at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:313)
      at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:413)
      at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:94)
      at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:161)
      at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715)
      at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)
      at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
      at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
      at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277)
      at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)
      at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)
      at weblogic.work.ExecuteThread.execute(ExecuteThread.java:207)
      at weblogic.work.ExecuteThread.run(ExecuteThread.java:176)
        • 1. Re: Content Server Request Failed
          William Phelps
          !csUserEventMessage,hddUCMAdmin,brmhdd01.us.oracle.com:16200!$!csServiceDataException,GET_SEARCH_RESULTS,tagSearchedContent!$!csDbUnableToExecuteSql,insert into taggedContentStorage (dDocName\,dDocAuthor\,Disk_Drive_Name\,dDocTitle\,dDocType\,dID\,Accesses\,Last_Accesses) values ('HDD_012158'\,'mikemartinez'\,'ITVSC2BA3SUN100G'\,'ssd-dc-s3700-spec May'13.pdf'\,'Vendor Documents'\,'14038'\,1\,sysdate)!$ORA-00917: missing comma
          !syJavaExceptionWrapper,java.sql.SQLSyntaxErrorException: ORA-00917: missing comma>

          Looks like some malformed SQL.
          \,'ssd-dc-s3700-spec May'13.pdf'\,
          The extra single-tick between 'May' and '13' in the file name is the likely culprit. You'll likely need to delete this file from Repository Manager - search for content id "HDD_012158".

          "tagSearchContent"... is this a custom component? If not, file a bug with Oracle to get them to fix it.
          • 2. Re: Content Server Request Failed
            984189
            Thanks William

            We deleted the file using the archiver but somehow still the problem persists. What category should I file this bug.