An Error has Occurred

We apologize in advance for the inconvenience this may cause you. We monitor all error reports pro-actively, and our support staff has been alerted to this condition. At this time, we would like to suggest that you retry your request, or return at a later time. Additionally, if you would like to send an email to our support staff, please do so. Please copy and paste the contents of this page in the message as well as any additional information you may have.


##############   NEW ERROR ####################
#####   BaseAction Exception Dump   ###########
###############################################

Error Time: Oct 21, 2020, 12:21:53 AM


Exception: PreparedStatementCallback; bad SQL grammar [select rss.skin_gk, rss.application_name, rss.hostname, rss.home_page, rss.logo,  rss.css, rss.livehelp_url, rss.logout_url, rss.powered_by_image, rss.support_phone, rss.support_email, rss.sales_email,  rss.sales_phone, rss.referral_source_id, rss.velaro_site_id, rss.portal_url, rss.legal_name, rss.privacy_url, rss.billing_email, rss.default_skin, rss.favicon, rss.ga_code, rss.header_html, rss.footer_html, rss.support_hours  from referral_source rs, referral_source_skin rss, company c, sysuser s, requirement r where req_gk = ? and r.client_contact_gk = s.user_gk and s.company_gk = c.company_gk and c.referral_source_id = rs.referral_source_id and rs.referral_source_id = rss.referral_source_id  and c.referral_source_id <> -1]; nested exception is java.sql.SQLSyntaxErrorException: ORA-00904: "RSS"."SUPPORT_HOURS": invalid identifier

PreparedStatementCallback; bad SQL grammar [select rss.skin_gk, rss.application_name, rss.hostname, rss.home_page, rss.logo,  rss.css, rss.livehelp_url, rss.logout_url, rss.powered_by_image, rss.support_phone, rss.support_email, rss.sales_email,  rss.sales_phone, rss.referral_source_id, rss.velaro_site_id, rss.portal_url, rss.legal_name, rss.privacy_url, rss.billing_email, rss.default_skin, rss.favicon, rss.ga_code, rss.header_html, rss.footer_html, rss.support_hours  from referral_source rs, referral_source_skin rss, company c, sysuser s, requirement r where req_gk = ? and r.client_contact_gk = s.user_gk and s.company_gk = c.company_gk and c.referral_source_id = rs.referral_source_id and rs.referral_source_id = rss.referral_source_id  and c.referral_source_id <> -1]; nested exception is java.sql.SQLSyntaxErrorException: ORA-00904: "RSS"."SUPPORT_HOURS": invalid identifier

org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator(SQLErrorCodeSQLExceptionTranslator.java:231)
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator(AbstractFallbackSQLExceptionTranslator.java:73)
org.springframework.jdbc.core.JdbcTemplate(JdbcTemplate.java:649)
org.springframework.jdbc.core.JdbcTemplate(JdbcTemplate.java:684)
org.springframework.jdbc.core.JdbcTemplate(JdbcTemplate.java:716)
org.springframework.jdbc.core.JdbcTemplate(JdbcTemplate.java:726)
com.bm.ats.navigation.dao.SkinJdbcRepository(SkinJdbcRepository.java:49)
jdk.internal.reflect.GeneratedMethodAccessor389(null:-1)
jdk.internal.reflect.DelegatingMethodAccessorImpl(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method(Method.java:566)
org.springframework.aop.support.AopUtils(AopUtils.java:344)
org.springframework.aop.framework.ReflectiveMethodInvocation(ReflectiveMethodInvocation.java:198)
org.springframework.aop.framework.ReflectiveMethodInvocation(ReflectiveMethodInvocation.java:163)
org.springframework.transaction.interceptor.TransactionAspectSupport(TransactionAspectSupport.java:366)
org.springframework.transaction.interceptor.TransactionInterceptor(TransactionInterceptor.java:99)
org.springframework.aop.framework.ReflectiveMethodInvocation(ReflectiveMethodInvocation.java:186)
org.springframework.aop.framework.JdkDynamicAopProxy(JdkDynamicAopProxy.java:212)
com.sun.proxy.$Proxy257(null:-1)
com.bm.ats.navigation.NavigationService(NavigationService.java:82)
jdk.internal.reflect.GeneratedMethodAccessor378(null:-1)
jdk.internal.reflect.DelegatingMethodAccessorImpl(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method(Method.java:566)
org.springframework.aop.support.AopUtils(AopUtils.java:344)
org.springframework.aop.framework.ReflectiveMethodInvocation(ReflectiveMethodInvocation.java:198)
org.springframework.aop.framework.ReflectiveMethodInvocation(ReflectiveMethodInvocation.java:163)
org.springframework.transaction.interceptor.TransactionAspectSupport(TransactionAspectSupport.java:366)
org.springframework.transaction.interceptor.TransactionInterceptor(TransactionInterceptor.java:99)
org.springframework.aop.framework.ReflectiveMethodInvocation(ReflectiveMethodInvocation.java:186)
org.springframework.aop.framework.JdkDynamicAopProxy(JdkDynamicAopProxy.java:212)
com.sun.proxy.$Proxy258(null:-1)
com.brightmove.ats.portal.action.PortalBaseAction(PortalBaseAction.java:159)
com.brightmove.ats.action.BaseAction(BaseAction.java:128)
org.apache.struts.action.RequestProcessor(RequestProcessor.java:425)
org.apache.struts.action.RequestProcessor(RequestProcessor.java:228)
org.apache.struts.action.ActionServlet(ActionServlet.java:1913)
org.apache.struts.action.ActionServlet(ActionServlet.java:449)
javax.servlet.http.HttpServlet(HttpServlet.java:634)
javax.servlet.http.HttpServlet(HttpServlet.java:741)
org.apache.catalina.core.ApplicationFilterChain(ApplicationFilterChain.java:231)
org.apache.catalina.core.ApplicationFilterChain(ApplicationFilterChain.java:166)
org.apache.tomcat.websocket.server.WsFilter(WsFilter.java:52)
org.apache.catalina.core.ApplicationFilterChain(ApplicationFilterChain.java:193)
org.apache.catalina.core.ApplicationFilterChain(ApplicationFilterChain.java:166)
com.bm.filter.CorsFilter(CorsFilter.java:29)
org.apache.catalina.core.ApplicationFilterChain(ApplicationFilterChain.java:193)
org.apache.catalina.core.ApplicationFilterChain(ApplicationFilterChain.java:166)
com.brightmove.ats.util.CharsetFilter(CharsetFilter.java:33)
org.apache.catalina.core.ApplicationFilterChain(ApplicationFilterChain.java:193)
org.apache.catalina.core.ApplicationFilterChain(ApplicationFilterChain.java:166)
org.apache.catalina.core.StandardWrapperValve(StandardWrapperValve.java:199)
org.apache.catalina.core.StandardContextValve(StandardContextValve.java:96)
de.javakaffee.web.msm.RequestTrackingContextValve(RequestTrackingContextValve.java:99)
org.apache.catalina.authenticator.AuthenticatorBase(AuthenticatorBase.java:668)
org.apache.catalina.core.StandardHostValve(StandardHostValve.java:139)
de.javakaffee.web.msm.RequestTrackingHostValve(RequestTrackingHostValve.java:156)
org.apache.catalina.valves.ErrorReportValve(ErrorReportValve.java:81)
org.apache.catalina.valves.RemoteIpValve(RemoteIpValve.java:747)
org.apache.catalina.valves.AbstractAccessLogValve(AbstractAccessLogValve.java:690)
org.apache.catalina.core.StandardEngineValve(StandardEngineValve.java:87)
org.apache.catalina.connector.CoyoteAdapter(CoyoteAdapter.java:343)
org.apache.coyote.http11.Http11Processor(Http11Processor.java:615)
org.apache.coyote.AbstractProcessorLight(AbstractProcessorLight.java:65)
org.apache.coyote.AbstractProtocol$ConnectionHandler(AbstractProtocol.java:818)
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor(NioEndpoint.java:1627)
org.apache.tomcat.util.net.SocketProcessorBase(SocketProcessorBase.java:49)
java.util.concurrent.ThreadPoolExecutor(ThreadPoolExecutor.java:1128)
java.util.concurrent.ThreadPoolExecutor$Worker(ThreadPoolExecutor.java:628)
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable(TaskThread.java:61)
java.lang.Thread(Thread.java:834)


Company not found in session.
User not found in session.
--- Request Attributes ---
org.apache.catalina.AccessLog.RemoteAddr: 3.238.62.144
org.apache.struts.action.MESSAGE: org.apache.struts.util.PropertyMessageResources@2105422f
org.apache.struts.action.mapping.instance: ActionConfig[cancellable=false,path=/PortalViewRequirement,validate=true,scope=session,type=com.brightmove.ats.portal.action.PortalViewRequirementAction
org.apache.struts.action.MODULE: org.apache.struts.config.impl.ModuleConfigImpl@71b5b7a9
org.apache.struts.globals.ORIGINAL_URI_KEY: /PortalViewRequirement.do
org.apache.catalina.AccessLog.ServerPort: 443
org.apache.tomcat.request.forwarded: true
org.apache.catalina.AccessLog.Protocol: HTTP/1.1
org.apache.tomcat.remoteAddr: 3.238.62.144
PortalForward: failure
org.apache.catalina.AccessLog.ServerName: ejob.bz
org.apache.catalina.AccessLog.RemoteHost: 3.238.62.144
--- END Request Attributes ---

--- Request Parameters ---
reqGK: 27417800
--- END Request Parameters ---

Form is null
--- Request Headers ---
connection: upgrade
host: ejob.bz
x-real-ip: 10.10.1.118
accept-encoding: br,gzip
x-forwarded-proto: https
x-forwarded-port: 443
x-amzn-trace-id: Root=1-5f8fb761-4cd8501c7be584ce44812285
user-agent: CCBot/2.0 (https://commoncrawl.org/faq/)
accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
accept-language: en-US,en;q=0.5
--- END Request Headers ---
###############################################
#####   END BaseAction Exception Dump   #######
###############################################