Welcome Guest. Sign in or Signup

29 Answers

500 errors

Asked by: Zero-K 1275 views Installation

I installed AdvertPro and as I was trying to set it up, I started getting 500 errors.
I get it on the Campaigns screen whenever it tries to filter results and also on the maintenance screen under software. Everything still seems like it’s functional, I can add/edit/delete everything, but I can’t list off the campaigns.
It’s nothing major, but I would like to fix it before I start adding advertisers in and giving them access.

Any ideas what might be causing this?

29 Answers



  1. on Feb 19, 2007

    Sounds like a database connectivity issue to me. Have you changed any of MySQL’s connection timeout settings?

    What you should do though, is go to Settings > Expert > Logging and set the “Logging Level” to “Warning”. Try to go to the listing after that. Then go to Maintenance > Diagnostics > Logs and look at today’s error_log file. You should find the cause of the error in there, which if post it here we’ll tell you what’s wrong.

    0 Votes Thumb up 0 Votes Thumb down 0 Votes



  2. Zero-K on Feb 19, 2007

    I didn’t relize there was an error log and event log. I kept scrolling to the bottom and looking at the last log  :-[

    Anyway, I'm getting the following error repeated over and over every 3 minutes

    [Mon Feb 19 14:44:22 AST 2007] [ALERT] the following monitor has detected a component failure
    [Mon Feb 19 14:44:22 AST 2007] [ALERT] com.renegade.advertpro.servlet.util.monitor.ConnectionPoolMonitor
    [Mon Feb 19 14:44:22 AST 2007] [ALERT] attempting to execute the repair procedure(s) for the failed component
    [Mon Feb 19 14:44:22 AST 2007] [EMERGENCY] the following monitor has detected a serious component failure that could not be repaired
    [Mon Feb 19 14:44:22 AST 2007] [EMERGENCY] com.renegade.advertpro.servlet.util.monitor.ConnectionPoolMonitor
    [Mon Feb 19 14:44:22 AST 2007] [EMERGENCY] please restart your application server or reboot your system immediately
    [Mon Feb 19 14:44:22 AST 2007] [EMERGENCY] contact technical support for further assistance if this problem persists

    [edit]
    Nope, didn’t change any timeout settings
    [/edit]

    0 Votes Thumb up 0 Votes Thumb down 0 Votes



  3. on Feb 19, 2007

    Did you try going to the pages where you were getting the 500 errors? They should have produced different error messages than this. Although, these error messages do indicate that AdvertPRO is having trouble connecting to the database or maintaining its persistent connections.

    What versions of AdvertPRO, MySQL, and the Connector/J JDBC driver are you using?

    You can find the AdvertPRO version/build number if you click on “Version Information” at the bottom of the screen. The Connector/J driver version can be found if you go to Maintenance > Diagnostics > Connection Pool. And the MySQL version can also be found if you go to Maintenance > Diagnostics > Database.

    0 Votes Thumb up 0 Votes Thumb down 0 Votes



  4. StephenL on Feb 20, 2007

    I’ve gotten a few 500 errors lately too!

    The logs all look like this:


    [Sun Feb 18 17:21:10 IST 2007] [CRITICAL] com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data truncated for column ‘ref’ at row 1
    at com.mysql.jdbc.SQLError.convertShowWarningsToSQLWarnings(SQLError.java:709)
    at com.mysql.jdbc.MysqlIO.scanForAndThrowDataTruncation(MysqlIO.java:3461)
    at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1202)
    at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:681)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1368)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1283)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1268)
    at com.renegade.advertpro.sql.logging.temporary.BatchSQL.processBatch(BatchSQL.java:78)
    at com.renegade.advertpro.loggers.TemporaryLogger.run(TemporaryLogger.java:545)
    at java.lang.Thread.run(Thread.java:595)

    Furthermore, one of my publishers embedded the code (for a GIF ad) into his email list, and while I see and click on it OK, he sent me the error he got from some of his recipients:

    500 / INTERNAL SERVER ERROR

     Error Information
     
    The request could not be completed due to an unexpected internal error encountered by the server.  

    Error Time
     
    Tue Feb 20 10:45:14 IST 2007

    I don’t see an error log on it yet though.

    0 Votes Thumb up 0 Votes Thumb down 0 Votes



  5. Zero-K on Feb 20, 2007

    Mike Cherichetti wrote: Did you try going to the pages where you were getting the 500 errors?  They should have produced different error messages than this.  Although, these error messages do indicate that AdvertPRO is having trouble connecting to the database or maintaining its persistent connections.

    What versions of AdvertPRO, MySQL, and the Connector/J JDBC driver are you using?

    You can find the AdvertPRO version/build number if you click on “Version Information” at the bottom of the screen.  The Connector/J driver version can be found if you go to Maintenance > Diagnostics > Connection Pool.  And the MySQL version can also be found if you go to Maintenance > Diagnostics > Database.

    When I go to any of the pages, I get this error:

    Error Information
    The request could not be completed due to an unexpected internal error encountered by the server.

    Error Time
    Tue Feb 20 08:52:16 AST 2007

    I also found out that I get this error when I go to “Licence Information” too

    Versions
    AdvertPRO – Installed Version: 1.0 build 9160
    AdvertPRO – Current Version: 1.0 build 9080
    Connector/J driver: 3.1.14
    MySQL: 4.1.22

    0 Votes Thumb up 0 Votes Thumb down 0 Votes



  6. on Feb 20, 2007

    StephenL wrote: I’ve gotten a few 500 errors lately too!

    The logs all look like this:


    [Sun Feb 18 17:21:10 IST 2007] [CRITICAL] com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data truncated for column ‘ref’ at row 1
    at com.mysql.jdbc.SQLError.convertShowWarningsToSQLWarnings(SQLError.java:709)
    at com.mysql.jdbc.MysqlIO.scanForAndThrowDataTruncation(MysqlIO.java:3461)
    at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1202)
    at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:681)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1368)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1283)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1268)
    at com.renegade.advertpro.sql.logging.temporary.BatchSQL.processBatch(BatchSQL.java:78)
    at com.renegade.advertpro.loggers.TemporaryLogger.run(TemporaryLogger.java:545)
    at java.lang.Thread.run(Thread.java:595)

    Furthermore, one of my publishers embedded the code (for a GIF ad) into his email list, and while I see and click on it OK, he sent me the error he got from some of his recipients:

    500 / INTERNAL SERVER ERROR

    Error Information

    The request could not be completed due to an unexpected internal error encountered by the server.

    Error Time

    Tue Feb 20 10:45:14 IST 2007

    I don’t see an error log on it yet though.

    This looks like a small bug. It will only happen when a visitor has cookies and JavaScript disabled and the page URL is very long (more than 128 characters). Kind of strange that it’s happened in an e-mail though — any idea what e-mail client these people who reported the error were using? To the best of my knowledge, no e-mail clients send a ‘referrer’ header at all, let alone a very long one.

    0 Votes Thumb up 0 Votes Thumb down 0 Votes



  7. on Feb 20, 2007

    Zero-K wrote:
    When I go to any of the pages, I get this error:

    Error Information
    The request could not be completed due to an unexpected internal error encountered by the server.

    Error Time
    Tue Feb 20 08:52:16 AST 2007

    After you saw this error page, there weren’t any additional messages in the error_log? That is what I’m looking for, the message from the error_log because the error message on the page says nothing about what happened. If there is no message added to the error_log when you see this error page, go to Settings > Expert > Logging in AdvertPRO and change “Logging Level” to “Warning” and then access the page where you get the error again. There should be a message in the error_log after that because all database related errors are logged above WARNING level (most of them at CRITICAL or ERROR level).

    0 Votes Thumb up 0 Votes Thumb down 0 Votes



  8. StephenL on Feb 20, 2007

    He was getting the error only in Gmail. But then it stopped as abruptly as it started.

    0 Votes Thumb up 0 Votes Thumb down 0 Votes



  9. on Feb 20, 2007

    StephenL wrote: He was getting the error only in Gmail. But then it stopped as abruptly as it started.

    Ahh, that makes sense now. A web based e-mail client will send us back a ‘referrer’ and the URLs in Gmail are pretty long.

    0 Votes Thumb up 0 Votes Thumb down 0 Votes



  10. Zero-K on Feb 20, 2007

    Mike Cherichetti wrote:
    After you saw this error page, there weren’t any additional messages in the error_log?  That is what I’m looking for, the message from the error_log because the error message on the page says nothing about what happened.  If there is no message added to the error_log when you see this error page, go to Settings > Expert > Logging in AdvertPRO and change “Logging Level” to “Warning” and then access the page where you get the error again.  There should be a message in the error_log after that because all database related errors are logged above WARNING level (most of them at CRITICAL or ERROR level).

    Nope, I even had the logging to “debug” and It was still the same errors

    [Tue Feb 20 08:51:37 AST 2007] [ALERT] the following monitor has detected a component failure
    [Tue Feb 20 08:51:37 AST 2007] [ALERT] com.renegade.advertpro.servlet.util.monitor.ConnectionPoolMonitor
    [Tue Feb 20 08:51:37 AST 2007] [ALERT] attempting to execute the repair procedure(s) for the failed component
    [Tue Feb 20 08:51:37 AST 2007] [EMERGENCY] the following monitor has detected a serious component failure that could not be repaired
    [Tue Feb 20 08:51:37 AST 2007] [EMERGENCY] com.renegade.advertpro.servlet.util.monitor.ConnectionPoolMonitor
    [Tue Feb 20 08:51:37 AST 2007] [EMERGENCY] please restart your application server or reboot your system immediately
    [Tue Feb 20 08:51:37 AST 2007] [EMERGENCY] contact technical support for further assistance if this problem persists
    [Tue Feb 20 08:54:37 AST 2007] [ALERT] the following monitor has detected a component failure
    [Tue Feb 20 08:54:37 AST 2007] [ALERT] com.renegade.advertpro.servlet.util.monitor.ConnectionPoolMonitor
    [Tue Feb 20 08:54:37 AST 2007] [ALERT] attempting to execute the repair procedure(s) for the failed component
    [Tue Feb 20 08:54:37 AST 2007] [EMERGENCY] the following monitor has detected a serious component failure that could not be repaired
    [Tue Feb 20 08:54:37 AST 2007] [EMERGENCY] com.renegade.advertpro.servlet.util.monitor.ConnectionPoolMonitor
    [Tue Feb 20 08:54:37 AST 2007] [EMERGENCY] please restart your application server or reboot your system immediately
    [Tue Feb 20 08:54:37 AST 2007] [EMERGENCY] contact technical support for further assistance if this problem persists

    0 Votes Thumb up 0 Votes Thumb down 0 Votes



  11. on Feb 20, 2007

    Ok, that is surprising. Maybe there is something else wrong and the errors are actually happening in Tomcat. Do you have any errors in the /usr/local/tomcat/logs/catalina.out file?

    0 Votes Thumb up 0 Votes Thumb down 0 Votes



  12. Zero-K on Feb 20, 2007

    I’m in windows so I assume thats c:tomcatlogscatalina.[date].log?
    Theres nothing in those for errors.
    Although in the localhost.2007-02-20.log Its updating when I get errors on those pages.

    Here’s one of the errors

    <br />Feb 20, 2007 1:06:27 PM org.apache.catalina.core.ApplicationDispatcher invoke<br />SEVERE: Servlet.service() for servlet jsp threw exception<br />java.lang.NoSuchMethodError: com.renegade.jsp.tags.format.DateTag.setFormat(Ljava/lang/String;)V<br />   at org.apache.jsp.control.campaigns.listing_jsp._jspService(listing_jsp.java:764)<br />   at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)<br />   at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)<br />   at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334)<br />   at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)<br />   at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)<br />   at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)<br />   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)<br />   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)<br />   at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)<br />   at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:463)<br />   at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:398)<br />   at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)<br />   at com.renegade.advertpro.servlet.controller.ActionRouter.processInternalForward(ActionRouter.java:196)<br />   at com.renegade.advertpro.servlet.controller.ActionRouter.route(ActionRouter.java:112)<br />   at com.renegade.advertpro.servlet.controller.ActionServlet.service(ActionServlet.java:236)<br />   at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)<br />   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)<br />   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)<br />   at com.renegade.advertpro.servlet.filter.GZipFilter.doFilter(GZipFilter.java:122)<br />   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)<br />   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)<br />   at com.renegade.advertpro.servlet.filter.P3PFilter.doFilter(P3PFilter.java:70)<br />   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)<br />   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)<br />   at com.renegade.advertpro.servlet.filter.NoCacheFilter.doFilter(NoCacheFilter.java:72)<br />   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)<br />   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)<br />   at com.renegade.advertpro.servlet.filter.CharsetFilter.doFilter(CharsetFilter.java:78)<br />   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)<br />   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)<br />   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:204)<br />   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)<br />   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)<br />   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)<br />   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)<br />   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)<br />   at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:833)<br />   at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:639)<br />   at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1285)<br />   at java.lang.Thread.run(Unknown Source)<br />

    0 Votes Thumb up 0 Votes Thumb down 0 Votes



  13. Zero-K on Feb 20, 2007

    Here’s the second part of that error, I had both of these entries, but it was too large to put in one post.

    Feb 20, 2007 1:06:27 PM org.apache.catalina.core.StandardWrapperValve invoke<br />SEVERE: Servlet.service() for servlet com.renegade.advertpro.servlet.controller.ActionServlet threw exception<br />java.lang.NoSuchMethodError: com.renegade.jsp.tags.format.DateTag.setFormat(Ljava/lang/String;)V<br />   at org.apache.jsp.control.campaigns.listing_jsp._jspService(listing_jsp.java:764)<br />   at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)<br />   at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)<br />   at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334)<br />   at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)<br />   at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)<br />   at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)<br />   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)<br />   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)<br />   at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)<br />   at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:463)<br />   at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:398)<br />   at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)<br />   at com.renegade.advertpro.servlet.controller.ActionRouter.processInternalForward(ActionRouter.java:196)<br />   at com.renegade.advertpro.servlet.controller.ActionRouter.route(ActionRouter.java:112)<br />   at com.renegade.advertpro.servlet.controller.ActionServlet.service(ActionServlet.java:236)<br />   at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)<br />   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)<br />   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)<br />   at com.renegade.advertpro.servlet.filter.GZipFilter.doFilter(GZipFilter.java:122)<br />   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)<br />   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)<br />   at com.renegade.advertpro.servlet.filter.P3PFilter.doFilter(P3PFilter.java:70)<br />   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)<br />   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)<br />   at com.renegade.advertpro.servlet.filter.NoCacheFilter.doFilter(NoCacheFilter.java:72)<br />   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)<br />   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)<br />   at com.renegade.advertpro.servlet.filter.CharsetFilter.doFilter(CharsetFilter.java:78)<br />   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)<br />   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)<br />   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:204)<br />   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)<br />   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)<br />   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)<br />   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)<br />   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)<br />   at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:833)<br />   at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:639)<br />   at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1285)<br />   at java.lang.Thread.run(Unknown Source)<br />

    0 Votes Thumb up 0 Votes Thumb down 0 Votes



  14. on Feb 20, 2007

    Mike Cherichetti wrote: [quote author=StephenL link=1171908809/0#8 date=1171985913]He was getting the error only in Gmail. But then it stopped as abruptly as it started.

    Ahh, that makes sense now. A web based e-mail client will send us back a ‘referrer’ and the URLs in Gmail are pretty long.[/quote]
    Well, turns out I had already fixed this bug a few weeks ago. I updated your account with a patch for it. You would have been getting this soon anyway as we’re going to be rolling out a new update at the end of month.

    0 Votes Thumb up 0 Votes Thumb down 0 Votes



  15. on Feb 20, 2007

    Zero-K wrote: I’m in windows so I assume thats c:tomcatlogscatalina.[date].log?
    Theres nothing in those for errors.
    Although in the localhost.2007-02-20.log Its updating when I get errors on those pages.

    Here’s one of the errors

    <br />Feb 20, 2007 1:06:27 PM org.apache.catalina.core.ApplicationDispatcher invoke<br />SEVERE: Servlet.service() for servlet jsp threw exception<br />java.lang.NoSuchMethodError: com.renegade.jsp.tags.format.DateTag.setFormat(Ljava/lang/String;)V<br />   at org.apache.jsp.control.campaigns.listing_jsp._jspService(listing_jsp.java:764)<br />   at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)<br />   at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)<br />   at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334)<br />   at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)<br />   at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)<br />   at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)<br />   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)<br />   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)<br />   at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)<br />   at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:463)<br />   at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:398)<br />   at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)<br />   at com.renegade.advertpro.servlet.controller.ActionRouter.processInternalForward(ActionRouter.java:196)<br />   at com.renegade.advertpro.servlet.controller.ActionRouter.route(ActionRouter.java:112)<br />   at com.renegade.advertpro.servlet.controller.ActionServlet.service(ActionServlet.java:236)<br />   at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)<br />   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)<br />   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)<br />   at com.renegade.advertpro.servlet.filter.GZipFilter.doFilter(GZipFilter.java:122)<br />   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)<br />   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)<br />   at com.renegade.advertpro.servlet.filter.P3PFilter.doFilter(P3PFilter.java:70)<br />   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)<br />   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)<br />   at com.renegade.advertpro.servlet.filter.NoCacheFilter.doFilter(NoCacheFilter.java:72)<br />   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)<br />   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)<br />   at com.renegade.advertpro.servlet.filter.CharsetFilter.doFilter(CharsetFilter.java:78)<br />   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)<br />   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)<br />   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:204)<br />   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)<br />   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)<br />   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)<br />   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)<br />   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)<br />   at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:833)<br />   at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:639)<br />   at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1285)<br />   at java.lang.Thread.run(Unknown Source)<br />

    Yeah, that definitely would cause the 500 error, but I’ve never seen that particular error before.

    First, let’s make sure you aren’t missing the file it’s referencing. Does the following file exist?

    c:tomcatwebappsadvertproWEB-INFcomrenegadejsptagsformatDateTag.class

    If that file exists, can you tell me which version of the JDK and Tomcat you installed? We support Tomcat 4.0, 4.1, 5.0, and 5.5. The newest version 6.0 is a beta release and we don’t support it yet. As far as the JDK goes, we can run on any 1.4.x, 1.5.x, or 1.6.x release.

    0 Votes Thumb up 0 Votes Thumb down 0 Votes



  16. Zero-K on Feb 20, 2007

    Mike Cherichetti wrote: Yeah, that definitely would cause the 500 error, but I’ve never seen that particular error before.

    First, let’s make sure you aren’t missing the file it’s referencing.  Does the following file exist?

    c:tomcatwebappsadvertproWEB-INFcomrenegadejsptagsformatDateTag.class

    If that file exists, can you tell me which version of the JDK and Tomcat you installed?  We support Tomcat 4.0, 4.1, 5.0, and 5.5.  The newest version 6.0 is a beta release and we don’t support it yet.  As far as the JDK goes, we can run on any 1.4.x, 1.5.x, or 1.6.x release.

    It’s actually in
    c:tomcatwebappsadvertproweb-infclassescomrenegadejsptagsformatdatetag.class
    But it is there.

    I’m running Tomcat 5.5 and JDK 1.5.0.10

    When I break things, I break them good :)

    0 Votes Thumb up 0 Votes Thumb down 0 Votes



  17. on Feb 20, 2007

    Zero-K wrote:
    It’s actually in
    c:tomcatwebappsadvertproweb-infclassescomrenegadejsptagsformatdatetag.class
    But it is there.

    I’m running Tomcat 5.5 and JDK 1.5.0.10

    When I break things, I break them good :)

    Yes, sorry, I messed up the path. That is where the file is supposed to be.

    Let’s try something.

    1) Stop the Tomcat service.

    2) Delete all of the files in the C:tomcatwork directory.

    3) Start the Tomcat service.

    Then try hitting the pages where you were getting the errors again, cross your fingers, and hopefully it will work :) My thinking is that Tomcat screwed up compiling some of the JSP files, which I’ve seen happen a few times. Clearing out everything in the work directory, which is where it stores the compiled files, will make it re-compile them once it’s started back up.

    0 Votes Thumb up 0 Votes Thumb down 0 Votes



  18. Zero-K on Feb 20, 2007

    That worked perfect!
    Something so simple causing so many problems.

    Thanks Mike!

    0 Votes Thumb up 0 Votes Thumb down 0 Votes



  19. on Feb 20, 2007

    Excellent! Glad to hear that worked because I wasn’t sure what to try next if it hadn’t ;)

    0 Votes Thumb up 0 Votes Thumb down 0 Votes



  20. Zero-K on Feb 20, 2007

    Guess I spoke too soon.
    I can view the pages and can’t seem to find any more errors anywhere, but I am still getting

    [Tue Feb 20 13:53:58 AST 2007] [ALERT] the following monitor has detected a component failure
    [Tue Feb 20 13:53:58 AST 2007] [ALERT] com.renegade.advertpro.servlet.util.monitor.ConnectionPoolMonitor
    [Tue Feb 20 13:53:58 AST 2007] [ALERT] attempting to execute the repair procedure(s) for the failed component
    [Tue Feb 20 13:53:58 AST 2007] [EMERGENCY] the following monitor has detected a serious component failure that could not be repaired
    [Tue Feb 20 13:53:58 AST 2007] [EMERGENCY] com.renegade.advertpro.servlet.util.monitor.ConnectionPoolMonitor
    [Tue Feb 20 13:53:58 AST 2007] [EMERGENCY] please restart your application server or reboot your system immediately
    [Tue Feb 20 13:53:58 AST 2007] [EMERGENCY] contact technical support for further assistance if this problem persists

    No errors in any of the other log files though.

    0 Votes Thumb up 0 Votes Thumb down 0 Votes



  21. on Feb 20, 2007

    Can you post the contents of your MySQL config file? It should be located here: C:my.cnf or C:WINNTmy.ini

    If it’s in neither of those places, right click on MySQL in the services control panel, choose properties.

    Look at the “Path to executable” field and you should see the path to the config file after the –defaults-file= option.

    0 Votes Thumb up 0 Votes Thumb down 0 Votes



  22. Zero-K on Feb 20, 2007

    I snipped out some comments to fit the whole file in.

    <br /><br />[client]<br /><br />port=3306<br /><br />[mysql]<br /><br />default-character-set=latin1<br /><br />[mysqld]<br /><br /># The TCP/IP Port the MySQL Server will listen on<br />port=3306<br /><br /><br />#Path to installation directory. All paths are usually resolved relative to this.<br />basedir="C:/MySQL/"<br /><br />#Path to the database root<br />datadir="C:/MySQL/Data/"<br /><br /># The default character set that will be used when a new schema or table is<br /># created and no character set is defined<br />default-character-set=latin1<br /><br /># The default storage engine that will be used when create new tables when<br />default-storage-engine=INNODB<br /><br /><br />max_connections=800<br /><br />query_cache_size=84M<br /><br />table_cache=1520<br /><br />tmp_table_size=30M<br /><br /><br />thread_cache_size=38<br /><br />#*** MyISAM Specific options<br /><br />myisam_max_sort_file_size=100G<br /><br />myisam_max_extra_sort_file_size=100G<br /><br />myisam_sort_buffer_size=30M<br /><br />key_buffer_size=129M<br /><br />read_buffer_size=64K<br />read_rnd_buffer_size=256K<br /><br />sort_buffer_size=256K<br /><br /><br />#*** INNODB Specific options ***<br />innodb_data_home_dir="E:/MySQL Datafiles/"<br /><br />innodb_additional_mem_pool_size=6M<br /><br />innodb_flush_log_at_trx_commit=1<br /><br />innodb_log_buffer_size=3M<br /><br />innodb_buffer_pool_size=249M<br /><br />innodb_log_file_size=50M<br /><br />innodb_thread_concurrency=8<br />

    0 Votes Thumb up 0 Votes Thumb down 0 Votes



  23. on Feb 20, 2007

    Well, your settings look OK to me. Can you try running the following query on the MySQL database?

    SELECT * FROM test LIMIT 0,5;

    AdvertPRO uses that query to test a MySQL connection every 5 minutes. It should return 5 data rows if it works.

    I think it would also be a good to try creating something to make sure it can get written to the database. Probably quickest to create a new theme. To do that, click on the Settings icon in the AdvertPRO toolbar. Then click on Themes -> New in the navigation menu on the left. All you have to do is enter a name for it hit the “Create Theme” button.

    If that works, I’m going to say that everything is probably OK. I remember now having another customer with this issue and we never did figure it out, but it wasn’t causing any errors or problems for them.

    0 Votes Thumb up 0 Votes Thumb down 0 Votes



  24. on Feb 20, 2007

    One more thing I just thought of. Go to Maintenance > Diagnostics > Monitor in AdvertPRO. Do any of the monitors show “IGNORE” in the results field?

    0 Votes Thumb up 0 Votes Thumb down 0 Votes



  25. Zero-K on Feb 20, 2007

    Mike Cherichetti wrote: Well, your settings look OK to me.  Can you try running the following query on the MySQL database?

    SELECT * FROM test LIMIT 0,5;

    AdvertPRO uses that query to test a MySQL connection every 5 minutes.  It should return 5 data rows if it works.

    I think it would also be a good to try creating something to make sure it can get written to the database.  Probably quickest to create a new theme.  To do that, click on the Settings icon in the AdvertPRO toolbar.  Then click on Themes -> New in the navigation menu on the left.  All you have to do is enter a name for it hit the “Create Theme” button.

    If that works, I’m going to say that everything is probably OK.  I remember now having another customer with this issue and we never did figure it out, but it wasn’t causing any errors or problems for them.

    When I run that sql statement, I get “Empty Set”
    But I was able to create and delete the theme without any problems.

    The only monitor that is different, is the one from the error logs
    com.renegade.advertpro.servlet.util.monitor.ConnectionPoolMonitor shows FAILED

    Everything else seems to be working fine.

    I’ll give it a try and if I have any problems, I’ll be back on the forums ;D

    Thanks again Mike!

    0 Votes Thumb up 0 Votes Thumb down 0 Votes



  26. on Feb 20, 2007

    Hmm, I think it may fix things if you run these queries to populate the test table with a few records.

    INSERT INTO test (id,name) VALUES (1,’A');
    INSERT INTO test (id,name) VALUES (2,’B');
    INSERT INTO test (id,name) VALUES (3,’C');
    INSERT INTO test (id,name) VALUES (4,’D');
    INSERT INTO test (id,name) VALUES (5,’E');

    The setup utility should have created those records though, so I have to wonder if there are any others missing in different tables.

    If you want to Maintenance > Database > Backup, run a backup, and send the ZIP file it creates (it will take about 3-4 minutes) to [email]support@renegadeinternet.com[/email] I can run a quick compare of it against a known good database without much trouble, just to be safe before you go live with it :)

    0 Votes Thumb up 0 Votes Thumb down 0 Votes



  27. StephenL on Feb 21, 2007

    Since you put the new build up, when I timeout on the system and try to go to a different category I get a 500 error instead of going to the logon page like it used to.

    0 Votes Thumb up 0 Votes Thumb down 0 Votes



  28. Zero-K on Feb 21, 2007

    Well I added those 5 records into the db, and I dont’ have any more errors. I checked all the log files and it doesn’t look like there are any problems. 8-)

    0 Votes Thumb up 0 Votes Thumb down 0 Votes



  29. on Feb 21, 2007

    StephenL wrote: Since you put the new build up, when I timeout on the system and try to go to a different category I get a 500 error instead of going to the logon page like it used to.

    Can you confirm if you checked the new “Remember My Login Credentials” check box on the login screen or not?

    0 Votes Thumb up 0 Votes Thumb down 0 Votes