Recipients overview tab "A general error occurred."

Use this forum to report bugs and to check for bugfixes and new releases of OpenEMM

Moderator: moderator

Marc Lima
Posts: 2
Joined: Mon Dec 06, 2010 10:46 pm

Recipients overview tab "A general error occurred."

Post by Marc Lima » Mon Dec 06, 2010 11:07 pm

I've just transfered openemm to a new server. Everything seems to be working fine except this "A general error occurred. Please check your input." error when clicking on the recipients overview tab. theopenemm_stdout.log file looks like this"

Code: Select all

2010-12-06 17:05:44,931: ERROR [resin-tcp-connection-*:8080-11] org.agnitas - recipientList: java.util.concurrent.ExecutionException: org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [SELECT count(*) FROM ( select cust.customer_id, cust.gender, cust.firstname, cust.lastname, cust.email FROM customer_1_tbl cust ) agn]; SQL state [HY000]; error code [126]; Incorrect key file for table '/tmp/#sql_21f_0.MYI'; try to repair it; nested exception is java.sql.SQLException: Incorrect key file for table '/tmp/#sql_21f_0.MYI'; try to repair it
java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:222)
java.util.concurrent.FutureTask.get(FutureTask.java:83)
org.agnitas.web.RecipientAction.execute(RecipientAction.java:219)
org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
javax.servlet.http.HttpServlet.service(HttpServlet.java:115)
javax.servlet.http.HttpServlet.service(HttpServlet.java:92)
com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:106)
org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:174)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:46)
com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
it appears i have an incorrect key file?

thanks for the help.

Marc Lima
Posts: 2
Joined: Mon Dec 06, 2010 10:46 pm

Solved

Post by Marc Lima » Tue Dec 14, 2010 7:16 pm

Turned out to be a memory issue. Added more ram and problem solved.

Post Reply