[aerogear-dev] SQLGrammerException using unifiedpush-server-1.0.0.Beta1/JBoss 7.1.1/Postgres

Wed Aug 13 08:32:27 EDT 2014

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 at cb54fdf<rs=org.hibernate.engine.jdbc.internal.proxy.ResultSetProxyHandler at f5479f2[valid=false]>

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 at gmail.com [mailto:mwessendorf at gmail.com] On Behalf Of Matthias Wessendorf
Sent: Wednesday, August 13, 2014 5:46 PM
To: vivek.pandey at 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 at pinelabs.com> 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 at 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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/aerogear-dev/attachments/20140813/96015a26/attachment-0001.html 