Support Questions
Find answers, ask questions, and share your expertise

getting 404 error while lunching url itself.

Highlighted

getting 404 error while lunching url itself.

New Contributor

when i use below Querry i got error page 404 ( i tested Querry in pgAdmin its working fine data is returning and i dont get any error while building after deployed , after hiting url gettimg below error message instance of login page)

Thanks in Advance.

Querry

CREATE TEMP TABLE wph AS (SELECT windprobs.fcsthr, windprobs.filedate, windprobs.prob, windprobs.speed, windprobs.geom, co.countyns, co.name, st.statefp, st.name as st_nameFROM windprob.windprobs

INNER JOIN exp.county20m as co

ON ST_Intersects(co.geom, windprobs.geom)

INNER JOIN exp.states20m as st

ON co.statefp = st.statefp

WHERE filedate = (select max(filedate) from windprob.windprobs where filedate <= to_timestamp(1539054000)) AND SPEED = 'TS');

CREATE TEMP TABLE mx AS (SELECT max(wph.prob), wph.countyns FROM wph

WHERE fcsthr = '120'

GROUP BY wph.countyns);

SELECT MIN(wph.fcsthr), wph.name, wph.st_name, wph.speed, wph.prob FROM wph

JOIN mx as mt

ON wph.countyns = mt.countyns

WHERE wph.prob >= mt.max/2

GROUP BY wph.name, wph.st_name, wph.speed, wph.prob, wph.geom

ORDER BY wph.st_name, wph.name, wph.speed, wph.prob;

ERROR:

org.springframework.web.client.HttpClientErrorException: 404 Not Found

org.springframework.web.client.DefaultResponseErrorHandler.handleError(DefaultResponseErrorHandler.java:63)

org.springframework.web.client.RestTemplate.handleResponse(RestTemplate.java:700)

org.springframework.web.client.RestTemplate.doExecute(RestTemplate.java:653)

org.springframework.web.client.RestTemplate.execute(RestTemplate.java:628)

org.springframework.web.client.RestTemplate.exchange(RestTemplate.java:602)

edu.mit.ll.nhp.config.AppAuthenticationSuccessHandler.updateUsersApi(AppAuthenticationSuccessHandler.java:83)

edu.mit.ll.nhp.config.AppAuthenticationSuccessHandler.onAuthenticationSuccess(AppAuthenticationSuccessHandler.java:62)

org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.successfulAuthentication(AbstractAuthenticationProcessingFilter.java:326)

org.keycloak.adapters.springsecurity.filter.KeycloakAuthenticationProcessingFilter.successfulAuthentication(KeycloakAuthenticationProcessingFilter.java:190)

org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:240)

org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)

org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

org.keycloak.adapters.springsecurity.filter.KeycloakPreAuthActionsFilter.doFilter(KeycloakPreAuthActionsFilter.java:84)

org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64)

org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)

org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)

org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214)

org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177)

org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.jav