cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Reliable Contributor Nielsb
Reliable Contributor
Report Inappropriate Content
Message 1 of 6

HTTP 500 Internal Server Error

Hi,

I have 10322 "HTTP 500 Internal Server Error" entries in my orion.log file since my ePO 5.10 upgrade  (5.9.1 --> ePO 5.10) this is in the last 7 days.

 

1 error event in my Orion.log file:

2019-05-20 14:00:49,066 WARN [http-nio-8443-exec-89] rest.DefaultExceptionMapper - HTTP 500 Internal Server Error
javax.ws.rs.InternalServerErrorException: HTTP 500 Internal Server Error
at com.mcafee.csi.commonui.core.rest.DefaultExceptionMapper.internalServerException(DefaultExceptionMapper.java:66)
at com.mcafee.csi.commonui.core.rest.DefaultExceptionMapper.toResponse(DefaultExceptionMapper.java:56)
at org.glassfish.jersey.server.ServerRuntime$Responder.mapException(ServerRuntime.java:601)
at org.glassfish.jersey.server.ServerRuntime$Responder.process(ServerRuntime.java:476)
at org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:334)
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
at org.glassfish.jersey.internal.Errors.process(Errors.java:267)
at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317)
at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:305)
at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154)
at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:471)
at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:425)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:383)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:336)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:223)
at com.mcafee.csi.commonui.core.rest.jersey.ProxyBean.service(ProxyBean.java:146)
at com.mcafee.csi.commonui.core.rest.jersey.ProxyServlet.service(ProxyServlet.java:39)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.mcafee.orion.core.servlet.filter.OptionsHttpMethodFilter.doFilter(OptionsHttpMethodFilter.java:29)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.filters.ExpiresFilter.doFilter(ExpiresFilter.java:1203)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.mcafee.orion.core.server.MdcFilter.doFilter(MdcFilter.java:31)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.mcafee.orion.core.server.DisableUrlSessionFilter.doFilter(DisableUrlSessionFilter.java:58)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:1025)
at com.mcafee.orion.core.server.mfsvalve.ValveContext.invokeNextInChain(ValveContext.java:27)
at com.mcafee.orion.core.server.LoginValidationValveHook.invoke(LoginValidationValveHook.java:89)
at com.mcafee.orion.core.server.mfsvalve.ValveContext.invokeNextInChain(ValveContext.java:25)
at com.mcafee.orion.core.server.AccessControlValveHook.invoke(AccessControlValveHook.java:81)
at com.mcafee.orion.core.server.mfsvalve.ValveContext.invokeNextInChain(ValveContext.java:25)
at com.mcafee.orion.core.server.mfsvalve.MfsValve.invoke(MfsValve.java:39)
at com.mcafee.orion.core.server.AjaxValve.invoke(AjaxValve.java:84)
at com.mcafee.orion.core.server.OrionUserSetupValve.invoke(OrionUserSetupValve.java:41)
at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:321)
at com.mcafee.orion.core.server.OrionSingleSignOn.invoke(OrionSingleSignOn.java:203)
at com.mcafee.orion.core.server.ClientCertValve.invoke(ClientCertValve.java:60)
at com.mcafee.orion.core.server.ExternalAuthenticationStrategyExtPointValve.invoke(ExternalAuthenticationStrategyExtPointValve.java:140)
at com.mcafee.orion.core.server.ClientCertValve.invoke(ClientCertValve.java:60)
at com.mcafee.orion.core.server.ClientCertValve.invoke(ClientCertValve.java:60)
at com.mcafee.orion.core.server.ClientCertValve.invoke(ClientCertValve.java:60)
at com.mcafee.orion.core.server.ClientCertValve.invoke(ClientCertValve.java:60)
at com.mcafee.orion.core.server.ClientCertValve.invoke(ClientCertValve.java:60)
at com.mcafee.orion.core.server.ClientCertValve.invoke(ClientCertValve.java:60)
at com.mcafee.orion.core.server.ParameterEncodingValve.invoke(ParameterEncodingValve.java:34)
at com.mcafee.orion.core.server.ThreadLocalInfoCleanupValve.invoke(ThreadLocalInfoCleanupValve.java:25)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1137)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1775)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1734)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.reflect.UndeclaredThrowableException
at com.sun.proxy.$Proxy3.prepareStatement(Unknown Source)
at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:293)
at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:293)
at com.mcafee.orion.core.db.base.DatabaseConnectionImpl.prepareStatement(DatabaseConnectionImpl.java:92)
at com.mcafee.protectionworkspace.rest.dao.impl.AbstractDao.executeQuerySQL(AbstractDao.java:306)
at com.mcafee.protectionworkspace.rest.dao.impl.ProductCoverageDaoImpl.findByProductIdOrderByTimeDesc(ProductCoverageDaoImpl.java:90)
at com.mcafee.protectionworkspace.rest.service.impl.ComplianceOverviewServiceImpl.getLastSecurityCoverages(ComplianceOverviewServiceImpl.java:23)
at com.mcafee.protectionworkspace.rest.resources.ComplianceResource.getProductCoverages(ComplianceResource.java:59)
at sun.reflect.GeneratedMethodAccessor3582.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161)
at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$ResponseOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:160)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)
at org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:326)
... 68 more
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.GeneratedMethodAccessor85.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.mcafee.orion.core.db.sqlserver.JtdsConnectionInvocationHandler.invoke(JtdsConnectionInvocationHandler.java:32)
... 88 more
Caused by: java.sql.SQLException: Prepared or callable statement has more than 2000 parameter markers.
at net.sourceforge.jtds.jdbc.SQLParser.parse(SQLParser.java:1265)
at net.sourceforge.jtds.jdbc.SQLParser.parse(SQLParser.java:167)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.(JtdsPreparedStatement.java:111)
at net.sourceforge.jtds.jdbc.JtdsConnection.prepareStatement(JtdsConnection.java:2538)
at net.sourceforge.jtds.jdbc.JtdsConnection.prepareStatement(JtdsConnection.java:2496)
... 92 more

 

This KB article is not applicable:

https://kc.mcafee.com/agent/index?page=content&id=KB91104&actp=null&viewlocale=en_US&showDraft=false...

Labels (1)
5 Replies
McAfee Employee hem
McAfee Employee
Report Inappropriate Content
Message 2 of 6

Re: HTTP 500 Internal Server Error

error 500 occurs when there is either connectivity issue with database or partial extensions present on the machine.

For partial extension, please look into #: KB81737

 

For DB connectivity, I would start with UDL test #: KB70929

 

Was my reply helpful?

If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?please select Accept as Solution in my reply and together we can help other members?
Reliable Contributor Nielsb
Reliable Contributor
Report Inappropriate Content
Message 3 of 6

Re: HTTP 500 Internal Server Error

Hi Hem,

Thank you for your response.

I have no hit related to a partially installed extensions or Database connection issues in the orion log.
The ePO console is up and running.

But I found this:

5161 events in the last week:

Caused by: java.lang.reflect.UndeclaredThrowableException
at com.sun.proxy.$Proxy3.prepareStatement(Unknown Source)
at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:293)
at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:293)
at com.mcafee.orion.core.db.base.DatabaseConnectionImpl.prepareStatement(DatabaseConnectionImpl.java:92)
at com.mcafee.protectionworkspace.rest.dao.impl.AbstractDao.executeQuerySQL(AbstractDao.java:306)
at com.mcafee.protectionworkspace.rest.dao.impl.SummaryDaoImpl.getResponseSummaries(SummaryDaoImpl.java:210)
at com.mcafee.protectionworkspace.rest.dao.impl.SummaryDaoImpl.findAllByDateRange(SummaryDaoImpl.java:109)
at com.mcafee.protectionworkspace.rest.service.impl.SummaryServiceImpl.getSummaries(SummaryServiceImpl.java:78)
at com.mcafee.protectionworkspace.rest.resources.SummariesV2Resource.getAllSummaries(SummariesV2Resource.java:101)
at sun.reflect.GeneratedMethodAccessor1550.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161)
at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$ResponseOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:160)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)
at org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:326)
... 68 more
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.GeneratedMethodAccessor87.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.mcafee.orion.core.db.sqlserver.JtdsConnectionInvocationHandler.invoke(JtdsConnectionInvocationHandler.java:32)
... 89 more
Caused by: java.sql.SQLException: Prepared or callable statement has more than 2000 parameter markers.
at net.sourceforge.jtds.jdbc.SQLParser.parse(SQLParser.java:1265)
at net.sourceforge.jtds.jdbc.SQLParser.parse(SQLParser.java:167)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.(JtdsPreparedStatement.java:111)
at net.sourceforge.jtds.jdbc.JtdsConnection.prepareStatement(JtdsConnection.java:2538)
at net.sourceforge.jtds.jdbc.JtdsConnection.prepareStatement(JtdsConnection.java:2496)
... 93 more

 

And 33 hits:

2019-05-27 13:42:06,795 WARN [http-nio-8443-exec-23] table.TableUIUtil - Invalid sort property for data source epo.rt.productevents. List of columns does not contain column 'EPOProductEvents.ReceivedUTC'
2019-05-27 13:42:33,092 WARN [http-nio-8443-exec-18] table.TableUIUtil - Invalid sort property for data source epo.rt.event. List of columns does not contain column 'EPOEvents.ReceivedUTC'
2019-05-27 13:42:37,171 WARN [http-nio-8443-exec-19] table.TableUIUtil - Invalid sort property for data source epo.rt.event. List of columns does not contain column 'EPOEvents.ReceivedUTC'
2019-05-27 13:42:38,718 WARN [http-nio-8443-exec-11] table.TableUIUtil - Invalid sort property for data source epo.rt.event. List of columns does not contain column 'EPOEvents.ReceivedUTC'
2019-05-27 13:42:40,139 WARN [http-nio-8443-exec-12] table.TableUIUtil - Invalid sort property for data source epo.rt.event. List of columns does not contain column 'EPOEvents.ReceivedUTC'
2019-05-27 13:42:41,655 WARN [http-nio-8443-exec-3] table.TableUIUtil - Invalid sort property for data source epo.rt.event. List of columns does not contain column 'EPOEvents.ReceivedUTC'

McAfee Employee hem
McAfee Employee
Report Inappropriate Content
Message 4 of 6

Re: HTTP 500 Internal Server Error

console is up and running? then where do you get 500 error?

Was my reply helpful?

If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?please select Accept as Solution in my reply and together we can help other members?
McAfee Employee cdinet
McAfee Employee
Report Inappropriate Content
Message 5 of 6

Re: HTTP 500 Internal Server Error

When does this error appear?  Logging into console?  When accessing certain page in epo or doing a specific function or task?  How frequently does it occur?  Are you able to access the console at all?

Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?

McAfee Employee Hawkmoon
McAfee Employee
Report Inappropriate Content
Message 6 of 6

Re: HTTP 500 Internal Server Error

Hi Nielsb, 

The log section you posted, offers a reference to 'protectionworkspace', which is something that comes from either MAR or Mvision.
(I'm not aware of any other product that uses that term in ePO, ref:
ePolicy Orchestrator 5.10.x minimum supported extension versions. 
Technical Articles ID:   KB90383)

What one do you have or maybe had and no longer use?
Maybe one or more queries/reports are still in the server and need to be removed?

 

Was my reply helpful?

If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?

More McAfee Tools to Help You

Community Help Hub

    New to the forums or need help finding your way around the forums? There's a whole hub of community resources to help you.

  • Find Forum FAQs
  • Learn How to Earn Badges
  • Ask for Help
Go to Community Help

Join the Community

    Thousands of customers use the McAfee Community for peer-to-peer and expert product support. Enjoy these benefits with a free membership:

  • Get helpful solutions from McAfee experts.
  • Stay connected to product conversations that matter to you.
  • Participate in product groups led by McAfee employees.
Join the Community
Join the Community