Unable to Access BPA Publisher Launch Page on WebLogic (Error in checking existence of bpsys_system table) (Doc ID 1124285.1)

Last updated on APRIL 13, 2011

Applies to:

Oracle Business Process Analysis Suite - Version: 11.1.1.2.0 and later   [Release: 11gR1 and later ]
Information in this document applies to any platform.

Symptoms

You have installed BPA Business Publisher on top of WebLogic and you are using Oracle as the Repository database, but if you go to http://<servername>:<port>/businesspublisher the application is not accessible .

In the log files the following stack trace is generated:


<BEA-101020> <[ServletContext@1120563602[app:businesspublisher module:businesspublisher.war path:/businesspublisher spec-version:2.5]] Servlet failed with Exception
com.idsscheer.aris.businesspublisher.application.dao.ADAOException: ADAOException
at com.idsscheer.aris.businesspublisher.application.dao.ADAOSystemFacade.installSystemIfNotExistent(ADAOSystemFacade.java:108)
at com.idsscheer.aris.businesspublisher.application.dao.ADAOSystemFacade.<init>(ADAOSystemFacade.java:73)
at com.idsscheer.aris.businesspublisher.application.dao.ADAOAdminFacade.<init>(ADAOAdminFacade.java:74)
at com.idsscheer.aris.businesspublisher.application.dao.ABPDAOFacadeFactory.getDAOAdminFacade(ABPDAOFacadeFactory.java:76)
at com.idsscheer.aris.businesspublisher.application.dao.ABPDAOFacadeFactory.getDAOAdminFacade(ABPDAOFacadeFactory.java:64)
at com.idsscheer.aris.businesspublisher.application.connectivity.export.data.ABPExportDataProvider.getAdminDAO(ABPExportDataProvider.java:560)
at com.idsscheer.aris.businesspublisher.application.connectivity.export.data.ABPExportDataProvider.getExportNodes(ABPExportDataProvider.java:232)
at com.idsscheer.aris.businesspublisher.application.connectivity.export.data.ABPExportDataProvider.getActiveExportNames(ABPExportDataProvider.java:99)
at jsp_servlet._layouts._shared.__login._jspService(__login.java:208)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:292)
at weblogic.servlet.internal.ServletStubImpl.onAddToMapException(ServletStubImpl.java:408)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:318)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at com.idsscheer.aris.itinventory.common.internal.ServletRequestBindFilter.doFilter(ServletRequestBindFilter.java:21)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at com.idsscheer.aris.businesspublisher.application.web.filter.ASessionFilter.doFilterInternal(ASessionFilter.java:34)
at com.idsscheer.aris.businesspublisher.application.web.filter.ABPServletFilter.doFilter(ABPServletFilter.java:86)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at com.idsscheer.aris.businesspublisher.application.web.filter.ABPForwardBackwardFilter.doFilterInternal(ABPForwardBackwardFilter.java:52)
at com.idsscheer.aris.businesspublisher.application.web.filter.ABPServletFilter.doFilter(ABPServletFilter.java:86)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at com.idsscheer.aris.businesspublisher.application.web.filter.ABPScopeFilter.doFilterInternal(ABPScopeFilter.java:35)
at com.idsscheer.aris.businesspublisher.application.web.filter.ABPServletFilter.doFilter(ABPServletFilter.java:86)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at com.idsscheer.aris.businesspublisher.application.web.filter.AEncodingFilter.doFilterInternal(AEncodingFilter.java:39)
at com.idsscheer.aris.businesspublisher.application.web.filter.ABPServletFilter.doFilter(ABPServletFilter.java:86)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3592)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2202)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2108)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1432)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)

Caused By: com.idsscheer.aris.businesspublisher.application.dao.util.ADAOSystemException: Error in checking existence of bpsys_system table


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms