java.sql.SQLException: Exception while executing JDBC operation

Oracle Community | Jack Lu | 10 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Planning 9.2 to 9.3.1 migration issues

    Oracle Community | 8 years ago | 698244
    java.sql.SQLException: [Hyperion][SQLServer JDBC Driver][SQLServer]'FK_HSP_FCALC _FID' is not a constraint.

    Root Cause Analysis

    1. java.sql.SQLException

      Exception while executing JDBC operation

      at oracle.biee.search.services.crawl.scheduler.dao.impl.AbstractSchedulerDAOImpl.getCrawlConfiguration()
    2. oracle.biee.search
      BISearchEventService.postEvent
      1. oracle.biee.search.services.crawl.scheduler.dao.impl.AbstractSchedulerDAOImpl.getCrawlConfiguration(AbstractSchedulerDAOImpl.java:211)
      2. oracle.biee.search.services.crawl.scheduler.BISearchCrawlSchedulerImpl.readCrawlConfiguration(BISearchCrawlSchedulerImpl.java:431)
      3. oracle.biee.search.services.crawl.BISearchCatalogPushCrawlManager.createIndexedCrawlConfigPathValidator(BISearchCatalogPushCrawlManager.java:262)
      4. oracle.biee.search.services.crawl.BISearchCatalogPushCrawlManager.getIndexedCrawlPathValidator(BISearchCatalogPushCrawlManager.java:316)
      5. oracle.biee.search.services.crawl.BISearchCatalogPushCrawlManager.isValidIndexedCrawlPath(BISearchCatalogPushCrawlManager.java:332)
      6. oracle.biee.search.services.event.BISearchEventService.postEvent(BISearchEventService.java:306)
      6 frames
    3. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor1263.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      3. java.lang.reflect.Method.invoke(Method.java:497)
      3 frames
    4. jersey-core-server
      ServerRuntime$2.run
      1. org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
      2. org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144)
      3. org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161)
      4. org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$ResponseOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:160)
      5. org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99)
      6. org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389)
      7. org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347)
      8. org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)
      9. org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:309)
      9 frames
    5. Jersey Core
      RequestScope.runInScope
      1. org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
      2. org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
      3. org.glassfish.jersey.internal.Errors.process(Errors.java:315)
      4. org.glassfish.jersey.internal.Errors.process(Errors.java:297)
      5. org.glassfish.jersey.internal.Errors.process(Errors.java:267)
      6. org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317)
      6 frames
    6. jersey-core-server
      ApplicationHandler.handle
      1. org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:292)
      2. org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154)
      2 frames
    7. jersey-container-servlet-core
      ServletContainer.service
      1. org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:460)
      2. org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:386)
      3. org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:334)
      4. org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:221)
      4 frames
    8. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:286)
      2. weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:260)
      3. weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:137)
      4. weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:350)
      5. weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)
      6. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
      6 frames
    9. oracle.security.jps
      JpsAbsFilter$1.run
      1. oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:141)
      1 frame
    10. Java RT
      AccessController.doPrivileged
      1. java.security.AccessController.doPrivileged(Native Method)
      1 frame
    11. oracle.security.jps
      JpsFilter.doFilter
      1. oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
      2. oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:649)
      3. oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:124)
      4. oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:232)
      5. oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:94)
      5 frames
    12. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
      1 frame
    13. oracle.dms.servlet
      DMSServletFilter.doFilter
      1. oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:224)
      1 frame
    14. Atmosphere weblogic
      WebAppServletContext$ServletInvocationAction.run
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
      2. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3654)
      3. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3620)
      3 frames
    15. weblogic.security.acl
      AuthenticatedSubject.doAs
      1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:326)
      1 frame
    16. weblogic.security.service
      SecurityManager.runAsForUserCode
      1. weblogic.security.service.SecurityManager.runAsForUserCode(SecurityManager.java:196)
      1 frame
    17. weblogic.servlet.provider
      WlsSubjectHandle.run
      1. weblogic.servlet.provider.WlsSecurityProvider.runAsForUserCode(WlsSecurityProvider.java:203)
      2. weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:71)
      2 frames
    18. Atmosphere weblogic
      ServletRequestImpl.run
      1. weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2423)
      2. weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2280)
      3. weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2258)
      4. weblogic.servlet.internal.ServletRequestImpl.runInternal(ServletRequestImpl.java:1626)
      5. weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1586)
      5 frames
    19. weblogic.servlet.provider
      ContainerSupportProviderImpl$WlsRequestExecutor.run
      1. weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:270)
      1 frame
    20. weblogic.invocation
      ComponentInvocationContextManager.runAs
      1. weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:348)
      2. weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:333)
      2 frames
    21. weblogic.work
      ExecuteThread.run
      1. weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:54)
      2. weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)
      3. weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:617)
      4. weblogic.work.ExecuteThread.execute(ExecuteThread.java:397)
      5. weblogic.work.ExecuteThread.run(ExecuteThread.java:346)
      5 frames