Hi Experts,
Im working on oracle apex, i'm getting this error message:
In Debug Trace i get:
mapped request using: /ws_dev/* to: -HR|apex|rt|, cryptoKeys=*****, id=1240736020378542, identityDomain=__NO_IDENTITY_DOMAIN__
Choosing: oracle.dbtools.rt.ResourceTemplatesServlet as current candidate with score: ResourceTemplatesScore [score=Score
[handle={Score [handle=ResourceTemplateMatch [module=ResourceModule [id=1240736020378542|1408638940905871, itemsPerPage=25, metadata=EntityMetaData
[created=-1, createdBy=unknown, updated=-1, updatedBy=unknown, version=-1], name=ocp.attestation.hr, originsAllowed=[], parsingSchema=HR,
status=PUBLISHED, uriPrefix=hr/, comments=null], privilegeId=null, template=ResourceTemplate [pattern=hr/attestation/, priority=0, etagQuery=]],
score=0, scope=SecurityConfig [constraint=none, realm=NONE, logonConfig=NONE], originsAllowed=[], corsEnabled=true],
oracle.dbtools.rt.resource.templates.jdbc.JDBCResourceTemplateDispatcher@1feae578}, score=0, scope=SecurityConfig [constraint=none, realm=NONE,
logonConfig=NONE], originsAllowed=[], corsEnabled=true]]
[TE] GET /apex/ws_dev/hr/attestation/ start: 2019-09-20T16:25:25.275Z duration: 125ms
And in Stack Trace
InternalServerException [statusCode=500, reasons=[Une erreur inattendue est survenue avec le message suivant : null]]
at oracle.dbtools.http.errors.ServletResponseExceptionMapper.mapError(ServletResponseExceptionMapper.java:89)
at oracle.dbtools.http.errors.ErrorPageRenderer.<init>(ErrorPageRenderer.java:43)
at oracle.dbtools.http.errors.ErrorPageRenderer.<init>(ErrorPageRenderer.java:34)
at oracle.dbtools.http.errors.ErrorPageFilter.doFilter(ErrorPageFilter.java:113)
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:102)
at oracle.dbtools.entrypoint.WebApplicationRequestEntryPoint.service(WebApplicationRequestEntryPoint.java:50)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678)
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:408)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.IllegalStateException
at oracle.dbtools.rt.json.query.JSONQueryStream$DataType.dataType(JSONQueryStream.java:214)
at oracle.dbtools.rt.json.query.JSONQueryStream$JSONChunker.renderValue(JSONQueryStream.java:406)
at oracle.dbtools.rt.json.query.JSONQueryStream$JSONChunker.render(JSONQueryStream.java:328)
at oracle.dbtools.rt.json.query.JSONQueryStream$JSONChunker.advance(JSONQueryStream.java:255)
at oracle.dbtools.rt.json.query.JSONQueryStream$JSONChunker.advance(JSONQueryStream.java:221)
at oracle.dbtools.common.util.AbstractIterator._advance(AbstractIterator.java:140)
at oracle.dbtools.common.util.AbstractIterator.next(AbstractIterator.java:98)
at oracle.dbtools.common.util.ChunkedInputStream.advance(ChunkedInputStream.java:91)
at oracle.dbtools.common.util.ChunkedInputStream.read(ChunkedInputStream.java:65)
at java.io.FilterInputStream.read(Unknown Source)
at java.io.FilterInputStream.read(Unknown Source)
at java.security.DigestInputStream.read(Unknown Source)
at java.nio.channels.Channels$ReadableByteChannelImpl.read(Unknown Source)
at oracle.dbtools.common.util.IOStreamsProvider.copy(IOStreamsProvider.java:189)
at oracle.dbtools.common.util.IOStreamsProvider.copy(IOStreamsProvider.java:152)
at oracle.dbtools.common.util.StreamCopy.drain(StreamCopy.java:34)
at oracle.dbtools.rt.web.ETags$DigestedEntity.<init>(ETags.java:247)
at oracle.dbtools.rt.web.ETags$DigestedEntity.<init>(ETags.java:233)
at oracle.dbtools.rt.web.ETags.etag(ETags.java:154)
at oracle.dbtools.rt.web.ETags.checkPrecondition(ETags.java:69)
at oracle.dbtools.rt.ResourceTemplatesServlet.restfulServices(ResourceTemplatesServlet.java:313)
at oracle.dbtools.rt.ResourceTemplatesServlet.service(ResourceTemplatesServlet.java:154)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
at oracle.dbtools.http.servlet.DispatchableServletBase.service(DispatchableServletBase.java:58)
at oracle.dbtools.http.entrypoint.Dispatcher.dispatch(Dispatcher.java:143)
at oracle.dbtools.http.entrypoint.EntryPoint$FilteredServlet.service(EntryPoint.java:243)
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:71)
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:95)
at oracle.dbtools.url.mapping.filter.URLMappingFilter.doFilter(URLMappingFilter.java:130)
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:88)
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:85)
... 35 more
Informations:
APEX version 19.1
APACHE Tomcat version 9.
ORDS version 19.1
Browser (Chrome)
Thank you for he