Internal Error 500 And "Dad is Not Enabled" Error when accessing Portal (Doc ID 1439202.1)

Last updated on NOVEMBER 09, 2022

Applies to:

Symptoms

When attempting to access a PL/SQL custom procedure in a custom schema using the following URL  e.g. http://<HOSTNAME>:<PORT>/portal/pls/<DAD_NAME>/<SCHEMA>.<PROCEDURE>, the following error occurs in the browser:

Internal Error 500

In Portal diagnostics Log the error is:

[2012-03-21T16:36:39.451-05:00] [WLS_PORTAL] [TRACE] [] [oracle.portal] [tid: [ACTIVE].ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: <ECID>] [SRC_CLASS: oracle.webdb.log.ServletLogger] [APP: portal] [SRC_METHOD: debug] Dad <DAD_NAME>, index 0
[2012-03-21T16:36:39.453-05:00] [WLS_PORTAL] [TRACE] [] [oracle.portal] [tid: [ACTIVE].ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: <ECID>] [SRC_CLASS: oracle.webdb.log.ServletLogger] [APP: portal] [SRC_METHOD: debug] Dad <DAD_NAME>, index 1
[2012-03-21T16:36:39.453-05:00] [WLS_PORTAL] [TRACE] [] [oracle.portal] [tid: [ACTIVE].ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: <ECID>] [SRC_CLASS: oracle.webdb.log.ServletLogger] [APP: portal] [SRC_METHOD: debug] Dad <DAD_NAME>, index 2
[2012-03-21T16:36:39.455-05:00] [WLS_PORTAL] [TRACE] [] [oracle.portal] [tid: [ACTIVE].ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: <ECID>] [SRC_CLASS: oracle.webdb.log.ServletLogger] [APP: portal] [SRC_METHOD: debug] Calling initDadConfiguration
[2012-03-21T16:36:39.457-05:00] [WLS_PORTAL] [ERROR] [] [oracle.portal] [tid: [ACTIVE].ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: <ECID>] [APP: portal] ERROR: Unable to set property plsqlsessionstatemanagement for DAD <DAD_NAME>: Should be one of [StatelessWithResetPackageState], [StatelessWithFastResetPackageState], [StatelessWithPreservePackageState]. DAD will be disabled.
[2012-03-21T16:36:39.465-05:00] [WLS_PORTAL] [ERROR] [] [oracle.portal] [tid: [ACTIVE].ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: <ECID>] [APP: portal] ERROR: Unable to set property plsqlsessionstatemanagement for DAD <DAD_NAME>: Should be one of [StatelessWithResetPackageState], [StatelessWithFastResetPackageState], [StatelessWithPreservePackageState]. DAD will be disabled.
.
.
.
[2012-03-21T16:38:55.616-05:00] [WLS_PORTAL] [ERROR] [] [oracle.portal] [tid: [ACTIVE].ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: <ECID>] [APP: portal] ERROR: Repository Gateway error: Configuration Error: Dad is not enabled

[2012-03-21T16:38:55.619-05:00] [WLS_PORTAL] [NOTIFICATION] [] [oracle.portal] [tid: [ACTIVE].ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: <ECID>] [APP: portal] [module=PortalServlet, thread=[ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] [perf-repos] url=/pls/<DAD_NAME>/<SCHEMA>.wwc_version.get_http_portal_version status=500 user=(null) reqTime=4ms connSU=(null),0ms connRO=(null),0ms procTime=0ms sessionTidyTime=0ms cache=(null) cookie=(null),0ms pageCalls=0,0ms bytes=0 describe=NO,0ms streamTime=0ms pid=12651i_75 sessFile=(null) userFile=(null) sysFile=(null) cacheLevel=(null) cacheTime=0ms dbProcTime=0ms spid=(null) requestTrace=(null) cookieLen=0 cookieValue=(null) reqUserTime=4ms assertUser=(null) subid=(null) authLevel=(null) oraError=0 uploads=0,0ms referer=/portal/pls/helpdeskdocs/HELPDESK.wwc_version.get_http_portal_version readTime=0ms

[2012-03-21T16:38:55.620-05:00] [WLS_PORTAL] [TRACE] [] [oracle.portal] [tid: [ACTIVE].ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: <ECID>] [SRC_CLASS: oracle.webdb.log.ServletLogger] [APP: portal] [SRC_METHOD: debug] Call status: false

[2012-03-21T16:38:55.621-05:00] [WLS_PORTAL] [TRACE] [] [oracle.portal] [tid: [ACTIVE].ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: <ECID>] [SRC_CLASS: oracle.webdb.log.ServletLogger] [APP: portal] [SRC_METHOD: debug] Request status: 500

[2012-03-21T16:38:55.622-05:00] [WLS_PORTAL] [TRACE] [] [oracle.portal] [tid: [ACTIVE].ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: <ECID>] [SRC_CLASS: oracle.webdb.log.ServletLogger] [APP: portal] [SRC_METHOD: debug] Oracle error: 0

[2012-03-21T16:38:55.630-05:00] [WLS_PORTAL] [ERROR] [] [oracle.portal] [tid: [ACTIVE].ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: <ECID>] [APP: portal] ERROR: oracle.webdb.utils.PortalExceptionImpl: Unable to obtain Portal Repository version.[[
at oracle.portal.PortalException.<init>(Unknown Source)
at oracle.webdb.repository.service.RepositoryServiceException.<init>(Unknown Source)
at oracle.webdb.repository.service.DadConfig$DadImpl.getRepositoryVersion(Unknown Source)
at oracle.webdb.portal.servlet.PortalServlet.doGet(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
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:300)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:111)
at java.security.AccessController.doPrivileged(Native Method)
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 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:1459)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:207)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:176)
Caused by: oracle.webdb.repository.service.RepositoryServiceException: Unable to obtain Portal Repository version.
... 28 more
caused by: oracle.webdb.utils.PortalExceptionImpl: Unable to obtain Portal Repository version.
at oracle.portal.PortalException.<init>(Unknown Source)
at oracle.webdb.repository.service.RepositoryServiceException.<init>(Unknown Source)
at oracle.webdb.repository.service.RepositoryServiceException.<init>(Unknown Source)
at oracle.webdb.repository.service.RepositoryServiceException.<init>(Unknown Source)
at oracle.webdb.repository.service.DadConfig$DadImpl.getRepositoryVersion(Unknown Source)
at oracle.webdb.portal.servlet.PortalServlet.doGet(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.