SReporting3: R-7310 failed -- Unknown column 'c5' in 'having clause'

im running p1150 on everything but rptv2.1.ear thats p1195 on prodclone

#7310 Mar 27, 2008 06:40:28 PDT
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'c5' in
'having clause' com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
com.mysql.jdbc.Connection.execSQL(Connection.java:3170)
com.mysql.jdbc.Connection.execSQL(Connection.java:3099)
com.mysql.jdbc.Statement.execute(Statement.java:695)
com.carldunham.jst.db.Database.execute(Database.java:274)
com.carldunham.jst.db.CreateTable.screate(CreateTable.java:337)
com.thesearchagency.services.ReportService.v2.Submit.createReport(Submit.java:914)
com.thesearchagency.services.ReportService.v2.Submit.createReport(Submit.java:344)
com.thesearchagency.services.ReportService.v2.MessageProcessorBean.onMessage(MessageProcessorBean.java:56)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:585)
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)
org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166)
org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63)
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:54)
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
org.jboss.aspects.tx.TxPolicy.invokeInCallerTx(TxPolicy.java:126)
org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:195)
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:62)
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
org.jboss.ejb3.mdb.MessagingContainer.localInvoke(MessagingContainer.java:245)
org.jboss.ejb3.mdb.inflow.MessageInflowLocalProxy.delivery(MessageInflowLocalProxy.java:268)
org.jboss.ejb3.mdb.inflow.MessageInflowLocalProxy.invoke(MessageInflowLocalProxy.java:138)
$Proxy133.onMessage(Unknown Source)
org.jboss.resource.adapter.jms.inflow.JmsServerSession.onMessage(JmsServerSession.java:178)
org.jboss.jms.client.container.ClientConsumer.callOnMessage(ClientConsumer.java:157)
org.jboss.jms.client.container.SessionAspect.handleRun(SessionAspect.java:801)
org.jboss.aop.advice.org.jboss.jms.client.container.SessionAspect14.invoke(SessionAspect14.java)
org.jboss.jms.client.delegate.ClientSessionDelegate$run_N8003352271541955702.invokeNext(ClientSessionDelegate$run_N8003352271541955702.java)
org.jboss.jms.client.container.ClosedInterceptor.invoke(ClosedInterceptor.java:170)
org.jboss.aop.advice.PerInstanceInterceptor.invoke(PerInstanceInterceptor.java:105)
org.jboss.jms.client.delegate.ClientSessionDelegate$run_N8003352271541955702.invokeNext(ClientSessionDelegate$run_N8003352271541955702.java)
org.jboss.jms.client.delegate.ClientSessionDelegate.run(ClientSessionDelegate.java)
org.jboss.jms.client.JBossSession.run(JBossSession.java:199)
org.jboss.resource.adapter.jms.inflow.JmsServerSession.run(JmsServerSession.java:237)
org.jboss.resource.work.WorkWrapper.execute(WorkWrapper.java:204)
org.jboss.util.threadpool.BasicTaskWrapper.run(BasicTaskWrapper.java:275)
EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:743)
java.lang.Thread.run(Thread.java:595)