Login Returns 500 Internal Server Error in Oracle 11 (Doc ID 2928417.1)

Last updated on JUNE 25, 2024

Applies to:

Symptoms

When trying to login, it gives following error:
500 Internal Server Error
An unexpected error with the following message occurred: null

Complete error stack

2023-01-18T11:39:19.183Z INFO        Oracle REST Data Services initialized
Oracle REST Data Services version : 22.4.0.r3401044
Oracle REST Data Services server info: jetty/10.0.12
Oracle REST Data Services java info: Java HotSpot(TM) 64-Bit Server VM 17.0.6+9-LTS-190

2023-01-18T11:40:05.838Z SEVERE      <ZyWP8XoqalYOvNREc4m98g> POST testserver /ords/wwv_flow.accept 500 An unexpected error with the following message occurred: null
InternalServerException [statusCode=500, logLevel=SEVERE, reasons=[An unexpected error with the following message occurred: null]]
       at oracle.dbtools.http.errors.ServletResponseExceptionMapper.mapError(ServletResponseExceptionMapper.java:60)
       at oracle.dbtools.http.errors.ErrorLogger.log(ErrorLogger.java:27)
       at oracle.dbtools.http.errors.ErrorPageFilter.doFilter(ErrorPageFilter.java:106)
       at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
       at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
       at oracle.dbtools.http.secure.ForceHttpsFilter.doFilter(ForceHttpsFilter.java:74)
       at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
       at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
       at oracle.dbtools.http.auth.ForceAuthFilter.doFilter(ForceAuthFilter.java:44)
       at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
       at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
       at oracle.dbtools.http.filters.Filters.filter(Filters.java:67)
       at oracle.dbtools.http.entrypoint.EntryPoint.service(EntryPoint.java:70)
       at oracle.dbtools.http.entrypoint.EntryPointServlet.service(EntryPointServlet.java:126)
       at oracle.dbtools.entrypoint.WebApplicationRequestEntryPoint.service(WebApplicationRequestEntryPoint.java:50)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:590)
       at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:764)
       at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:529)
       at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:221)
       at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1571)
       at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:221)
       at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1383)
       at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:176)
       at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:484)
       at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1544)
       at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:174)
       at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1305)
       at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:129)
       at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:192)
       at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:141)
       at org.eclipse.jetty.server.handler.StatisticsHandler.handle(StatisticsHandler.java:173)
       at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:122)
       at org.eclipse.jetty.server.Server.handle(Server.java:563)
       at org.eclipse.jetty.server.HttpChannel.lambda$handle$0(HttpChannel.java:505)
       at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:762)
       at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:497)
       at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:282)
       at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:314)
       at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:100)
       at org.eclipse.jetty.io.SelectableChannelEndPoint$1.run(SelectableChannelEndPoint.java:53)
       at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.runTask(AdaptiveExecutionStrategy.java:421)
       at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.consumeTask(AdaptiveExecutionStrategy.java:390)
       at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.tryProduce(AdaptiveExecutionStrategy.java:277)
       at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.lambda$new$0(AdaptiveExecutionStrategy.java:139)
       at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:411)
       at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:933)
       at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1077)
       at java.base/java.lang.Thread.run(Thread.java:833)
Caused by: java.lang.UnsupportedOperationException
       at oracle.dbtools.common.jdbc.JDBCArrays$PLSQLIndexTableSupport.setStringArray(JDBCArrays.java:284)
       at oracle.dbtools.apex.OWA.bind(OWA.java:461)
       at oracle.dbtools.apex.OWA.execute(OWA.java:136)
       at oracle.dbtools.apex.ModApex.handleRequest(ModApex.java:311)
       at oracle.dbtools.apex.ModApex.doPost(ModApex.java:193)
       at oracle.dbtools.apex.ModApex.service(ModApex.java:121)
       at oracle.dbtools.http.entrypoint.Dispatcher.dispatch(Dispatcher.java:126)
       at oracle.dbtools.http.entrypoint.EntryPoint$FilteredServlet.service(EntryPoint.java:170)
       at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:73)
       at oracle.dbtools.http.forwarding.QueryFilteringRewrite.doFilter(QueryFilteringRewrite.java:90)
       at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
       at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
       at oracle.dbtools.http.forwarding.ForwardingFilter.doFilter(ForwardingFilter.java:68)
       at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
       at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
       at oracle.dbtools.http.cors.CORSPreflightFilter.doFilter(CORSPreflightFilter.java:68)
       at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
       at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
       at oracle.dbtools.http.cookies.auth.CookieSessionCSRFFilter.doFilter(CookieSessionCSRFFilter.java:75)
       at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
       at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
       at oracle.dbtools.http.auth.AuthenticationFilter.authenticate(AuthenticationFilter.java:101)
       at oracle.dbtools.http.auth.AuthenticationFilter.doFilter(AuthenticationFilter.java:64)
       at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
       at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
       at oracle.dbtools.url.mapping.RequestMapperImpl.doFilter(RequestMapperImpl.java:158)
       at oracle.dbtools.url.mapping.URLMappingBase.doFilter(URLMappingBase.java:89)
       at oracle.dbtools.url.mapping.db.DatabaseTenantMapping.dispatchSelf(DatabaseTenantMapping.java:212)
       at oracle.dbtools.url.mapping.db.DatabaseTenantMappingBase.doFilter(DatabaseTenantMappingBase.java:51)
       at oracle.dbtools.url.mapping.tenant.TenantMappingDispatcher.dispatch(TenantMappingDispatcher.java:56)
       at oracle.dbtools.jdbc.pools.local.DefaultLocalTenantMapping.dispatchSelf(DefaultLocalTenantMapping.java:132)
       at oracle.dbtools.url.mapping.db.DatabaseTenantMappingBase.doFilter(DatabaseTenantMappingBase.java:51)
       at oracle.dbtools.jdbc.pools.local.DefaultLocalTenantMapping.doFilter(DefaultLocalTenantMapping.java:100)
       at oracle.dbtools.url.mapping.tenant.TenantMappingDispatcher.dispatch(TenantMappingDispatcher.java:56)
       at oracle.dbtools.url.mapping.tenant.TenantMappingFilter.doFilter(TenantMappingFilter.java:75)
       at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
       at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
       at oracle.dbtools.http.forwarding.ForwardingFailedFilter.doFilter(ForwardingFailedFilter.java:41)
       at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
       at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
       at oracle.dbtools.http.auth.external.ExternalSessionFilter.doFilter(ExternalSessionFilter.java:59)
       at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
       at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
       at oracle.dbtools.apex.support.auth.ApexSessionQueryRewriteFilter.doFilter(ApexSessionQueryRewriteFilter.java:58)
       at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
       at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
       at oracle.dbtools.http.cors.CORSResponseFilter.doFilter(CORSResponseFilter.java:90)
       at oracle.dbtools.http.filters.HttpResponseFilter.doFilter(HttpResponseFilter.java:45)
       at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
       at oracle.dbtools.http.filters.AbsoluteLocationFilter.doFilter(AbsoluteLocationFilter.java:65)
       at oracle.dbtools.http.filters.HttpResponseFilter.doFilter(HttpResponseFilter.java:45)
       at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
       at oracle.dbtools.http.auth.external.ExternalAccessValidationFilter.doFilter(ExternalAccessValidationFilter.java:59)
       at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
       at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
       at oracle.dbtools.http.errors.ErrorPageFilter.doFilter(ErrorPageFilter.java:87)
       ... 45 more

Changes

 New install

Cause

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