Hi Vivek, thanks for reporting. I noticed the same bug a few days ago and this has has been fixed in the upcoming BETA2 https://issues.jboss.org/browse/AGPUSH-879 Greetings, Matthias On Wed, Aug 13, 2014 at 2:09 PM, Vivek Pandey <vivek.pandey(a)pinelabs.com&gt; wrote: -- Matthias Wessendorf blog: http://matthiaswessendorf.wordpress.com/ sessions: http://www.slideshare.net/mwessendorf twitter: http://twitter.com/mwessendorf

Works with a fresh database… Thanks Matthias From: aerogear-dev-bounces(a)lists.jboss.org [mailto:aerogear-dev-bounces@lists.jboss.org] On Behalf Of Vivek Pandey Sent: Wednesday, August 13, 2014 6:02 PM To: 'Matthias Wessendorf'; 'AeroGear Developer Mailing List' Subject: Re: [aerogear-dev] SQLGrammerException using unifiedpush-server-1.0.0.Beta1/JBoss 7.1.1/Postgres Thanks Matthias, I upgraded to Beta2 and that problem went away. I was able to create a variant (android). However, when I try to open the applications, I see following error ing.internal.CollectionLoadContext@cb54fdf&lt;rs=org.hibernate.engine.jdbc.internal.proxy.ResultSetProxyHandler(a)f5479f2[valid=false]&gt; 17:59:38,112 WARN [org.hibernate.engine.loading.internal.CollectionLoadContext] (http--127.0.0.1-10000-2) HHH000160: On CollectionLoadContext#cleanup, localLoadingColl ectionKeys contained [1] entries 17:59:38,113 ERROR [org.jboss.ejb3.invocation] (http--127.0.0.1-10000-2) JBAS014134: EJB Invocation failed on component PushApplicationEndpoint for method public javax. ws.rs.core.Response org.jboss.aerogear.unifiedpush.rest.registry.applications.PushApplicationEndpoint.listAllPushApplications(javax.servlet.http.HttpServletRequest): ja vax.ejb.EJBException: java.lang.IllegalArgumentException: Unknown name value for enum class org.jboss.aerogear.unifiedpush.api.VariantType: 0 at org.jboss.as.ejb3.tx.CMTTxInterceptor.handleExceptionInOurTx(CMTTxInterceptor.java:166) [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final] at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:230) [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final] at org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:304) [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final] at org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:190) [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41) [jboss-as-ejb3-7. 1.1.Final.jar:7.1.1.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] at org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59) [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] From: mwessendorf(a)gmail.com [mailto:mwessendorf@gmail.com] On Behalf Of Matthias Wessendorf Sent: Wednesday, August 13, 2014 5:46 PM To: vivek.pandey(a)pinelabs.com; AeroGear Developer Mailing List Subject: Re: [aerogear-dev] SQLGrammerException using unifiedpush-server-1.0.0.Beta1/JBoss 7.1.1/Postgres Hi Vivek, thanks for reporting. I noticed the same bug a few days ago and this has has been fixed in the upcoming BETA2 https://issues.jboss.org/browse/AGPUSH-879 Greetings, Matthias On Wed, Aug 13, 2014 at 2:09 PM, Vivek Pandey <vivek.pandey(a)pinelabs.com&gt; wrote: Hello Guys, I see following error in logs when I try to create a variant Caused by: org.postgresql.util.PSQLException: ERROR: column "variant1_.type" must appear in the GROUP BY clause or be used in an aggregate function Position: 8 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:560) I am using JAVA: C:\jdk1.7.0_45 UPS: unifiedpush-server-1.0.0.Beta1 Postgres: 9.3 Postgres driver: postgresql-9.3-1100-jdbc4.jar Please find the log files attached _____ This message may contain privileged and confidential information and is solely for the use of intended recipient. The views expressed in this email are those of the sender and not of Pine Labs. The recipient should check this email and attachments for the presence of viruses / malwares etc. Pine Labs accepts no liability for any damage caused by any virus transmitted by this email. Pine Labs may monitor and record all emails. _____ _______________________________________________ aerogear-dev mailing list aerogear-dev(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/aerogear-dev -- Matthias Wessendorf blog: http://matthiaswessendorf.wordpress.com/ sessions: http://www.slideshare.net/mwessendorf twitter: http://twitter.com/mwessendorf _____ This message may contain privileged and confidential information and is solely for the use of intended recipient. The views expressed in this email are those of the sender and not of Pine Labs. The recipient should check this email and attachments for the presence of viruses / malwares etc. Pine Labs accepts no liability for any damage caused by any virus transmitted by this email. Pine Labs may monitor and record all emails. _____ _____ This message may contain privileged and confidential information and is solely for the use of intended recipient. The views expressed in this email are those of the sender and not of Pine Labs. The recipient should check this email and attachments for the presence of viruses / malwares etc. Pine Labs accepts no liability for any damage caused by any virus transmitted by this email. Pine Labs may monitor and record all emails. _____ This message may contain privileged and confidential information and is solely for the use of intended recipient. The views expressed in this email are those of the sender and not of Pine Labs. The recipient should check this email and attachments for the presence of viruses / malwares etc. Pine Labs accepts no liability for any damage caused by any virus transmitted by this email. Pine Labs may monitor and record all emails.