500 Internal Server Error

 | YBUj34yU-vBB1AODZqXz-A

Debug Trace

mapped request using: /*:PL/SQL to: |apex||
==== Processing Request: ====
--Attributes--
oracle.dbtools.http.servlet.UriRequest = UriRequest [uri=https://prod-banner.msudenver.edu/PROD/rwwla12.P_FSLAformDriver, contextPath=/PROD]
oracle.dbtools.http.ecid = YBUj34yU-vBB1AODZqXz-A
oracle.dbtools.common.di.Services = URL Mapped Scope
oracle.dbtools.plugin.api.di.InstanceLocator = URL Mapped Scope
ECID-Principal = ECIDPrincipal [ecid=YBUj34yU-vBB1AODZqXz-A]
oracle.dbtools.http.servlet.dispatch.score = PLSQLDispatchScore
--Attributes--
GET /PROD/rwwla12.P_FSLAformDriver HTTP/1.1
Host: prod-banner.msudenver.edu
accept: */*
user-agent: claudebot
referer: https://prod-banner.msudenver.edu/pls/prod_web/rwwla12.P_FSLAformDriver
host: prod-banner.msudenver.edu


org.apache.catalina.connector.CoyoteInputStream@633b726d
Using Procedure:rwwla12.P_FSLAformDriver
SID: 2540
PATCHING: N
isValidRequest(), procedure name: <rwwla12.P_FSLAformDriver>
Validating: rwwla12.P_FSLAformDriver
*** Total number of arguments: 0
Parse: 0 ms
-----
begin 
 rwwla12.P_FSLAformDriver;
commit;
  end;
*** Total number of arguments: 0

EXEC FAILED:ORA-04063: package body "BANINST1.RWWLA12" has errors
ORA-06508: PL/SQL: could not find program unit being called: "BANINST1.RWWLA12"
ORA-06512: at line 2
java.sql.SQLException: ORA-04063: package body "BANINST1.RWWLA12" has errors
ORA-06508: PL/SQL: could not find program unit being called: "BANINST1.RWWLA12"
ORA-06512: at line 2

	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)
	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)
	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268)
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)
	at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:265)
	at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:86)
	at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:965)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1205)
	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666)
	at oracle.jdbc.driver.T4CCallableStatement.executeInternal(T4CCallableStatement.java:1358)
	at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3778)
	at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4251)
	at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1081)
	at oracle.ucp.jdbc.proxy.oracle$1ucp$1jdbc$1proxy$1oracle$1StatementProxy$2oracle$1jdbc$1internal$1OracleCallableStatement$$$Proxy.execute(Unknown Source)
	at oracle.dbtools.apex.OWA.execute(OWA.java:161)
	at oracle.dbtools.apex.ModApex.handleRequest(ModApex.java:310)
	at oracle.dbtools.apex.ModApex.doGet(ModApex.java:147)
	at oracle.dbtools.apex.ModApex.service(ModApex.java:110)
	at oracle.dbtools.http.entrypoint.Dispatcher.dispatch(Dispatcher.java:126)
	at oracle.dbtools.http.entrypoint.EntryPoint$FilteredServlet.service(EntryPoint.java:239)
	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:160)
	at oracle.dbtools.url.mapping.URLMappingBase.doFilter(URLMappingBase.java:92)
	at oracle.dbtools.url.mapping.filter.URLMappingFilter.doFilter(URLMappingFilter.java:141)
	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.rt.authentication.apex.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:89)
	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.errors.ErrorPageFilter.doFilter(ErrorPageFilter.java:98)
	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:82)
	at oracle.dbtools.http.entrypoint.EntryPointServlet.service(EntryPointServlet.java:115)
	at oracle.dbtools.entrypoint.WebApplicationRequestEntryPoint.service(WebApplicationRequestEntryPoint.java:50)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:596)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:492)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:673)
	at org.apache.catalina.valves.rewrite.RewriteValve.invoke(RewriteValve.java:545)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:389)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:926)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:750)
Caused by: Error : 4063, Position : 0, Sql = begin 
 rwwla12.P_FSLAformDriver;
commit;
  end;, OriginalSql = begin 
 rwwla12.P_FSLAformDriver;
commit;
  end;, Error Msg = ORA-04063: package body "BANINST1.RWWLA12" has errors
ORA-06508: PL/SQL: could not find program unit being called: "BANINST1.RWWLA12"
ORA-06512: at line 2

	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513)
	... 92 more
==== Request Processed ====
[TE] GET /PROD/rwwla12.P_FSLAformDriver start: 2024-03-29T07:19:14.075Z duration: 247ms

		

Stack Trace

InternalServerException [statusCode=500, logLevel=SEVERE, reasons=[]]
	at oracle.dbtools.apex.ModApexContext.handleError(ModApexContext.java:288)
	at oracle.dbtools.apex.OWA.execute(OWA.java:206)
	at oracle.dbtools.apex.ModApex.handleRequest(ModApex.java:310)
	at oracle.dbtools.apex.ModApex.doGet(ModApex.java:147)
	at oracle.dbtools.apex.ModApex.service(ModApex.java:110)
	at oracle.dbtools.http.entrypoint.Dispatcher.dispatch(Dispatcher.java:126)
	at oracle.dbtools.http.entrypoint.EntryPoint$FilteredServlet.service(EntryPoint.java:239)
	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:160)
	at oracle.dbtools.url.mapping.URLMappingBase.doFilter(URLMappingBase.java:92)
	at oracle.dbtools.url.mapping.filter.URLMappingFilter.doFilter(URLMappingFilter.java:141)
	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.rt.authentication.apex.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:89)
	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.errors.ErrorPageFilter.doFilter(ErrorPageFilter.java:98)
	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:82)
	at oracle.dbtools.http.entrypoint.EntryPointServlet.service(EntryPointServlet.java:115)
	at oracle.dbtools.entrypoint.WebApplicationRequestEntryPoint.service(WebApplicationRequestEntryPoint.java:50)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:596)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:492)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:673)
	at org.apache.catalina.valves.rewrite.RewriteValve.invoke(RewriteValve.java:545)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:389)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:926)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:750)
Caused by: java.sql.SQLException: ORA-04063: package body "BANINST1.RWWLA12" has errors
ORA-06508: PL/SQL: could not find program unit being called: "BANINST1.RWWLA12"
ORA-06512: at line 2

	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)
	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)
	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268)
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)
	at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:265)
	at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:86)
	at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:965)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1205)
	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666)
	at oracle.jdbc.driver.T4CCallableStatement.executeInternal(T4CCallableStatement.java:1358)
	at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3778)
	at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4251)
	at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1081)
	at oracle.ucp.jdbc.proxy.oracle$1ucp$1jdbc$1proxy$1oracle$1StatementProxy$2oracle$1jdbc$1internal$1OracleCallableStatement$$$Proxy.execute(Unknown Source)
	at oracle.dbtools.apex.OWA.execute(OWA.java:161)
	... 76 more
Caused by: Error : 4063, Position : 0, Sql = begin 
 rwwla12.P_FSLAformDriver;
commit;
  end;, OriginalSql = begin 
 rwwla12.P_FSLAformDriver;
commit;
  end;, Error Msg = ORA-04063: package body "BANINST1.RWWLA12" has errors
ORA-06508: PL/SQL: could not find program unit being called: "BANINST1.RWWLA12"
ORA-06512: at line 2

	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513)
	... 92 more