Adding full log info: 2008-08-04 12:05:30,613 INFO [STDOUT] Caused by: org.hibernate.exception.GenericJDBCException: could not execute query 2008-08-04 12:05:30,613 INFO [STDOUT] at org.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:92) 2008-08-04 12:05:30,613 INFO [STDOUT] at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:80) 2008-08-04 12:05:30,613 INFO [STDOUT] at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) 2008-08-04 12:05:30,613 INFO [STDOUT] at org.hibernate.loader.Loader.doList(Loader.java:1565) 2008-08-04 12:05:30,613 INFO [STDOUT] at org.hibernate.loader.Loader.list(Loader.java:1545) 2008-08-04 12:05:30,613 INFO [STDOUT] at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375) 2008-08-04 12:05:30,613 INFO [STDOUT] at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:271) 2008-08-04 12:05:30,613 INFO [STDOUT] at org.hibernate.impl.SessionImpl.list(SessionImpl.java:840) 2008-08-04 12:05:30,613 INFO [STDOUT] at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74) 2008-08-04 12:05:30,613 INFO [STDOUT] at com.dcs.applications.service.LogicModuleServiceBean.getDisplayValueForValueObjectWithLocaleData(LogicModuleServiceBean.java:2228) 2008-08-04 12:05:30,613 INFO [STDOUT] at com.dcs.applications.service.LogicModuleServiceBean.getDisplayValueForValueObject(LogicModuleServiceBean.java:2157) 2008-08-04 12:05:30,613 INFO [STDOUT] at sun.reflect.GeneratedMethodAccessor298.invoke(Unknown Source) 2008-08-04 12:05:30,613 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 2008-08-04 12:05:30,613 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:585) 2008-08-04 12:05:30,613 INFO [STDOUT] at org.jboss.invocation.Invocation.performCall(Invocation.java:345) 2008-08-04 12:05:30,613 INFO [STDOUT] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:214) 2008-08-04 12:05:30,613 INFO [STDOUT] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185) 2008-08-04 12:05:30,613 INFO [STDOUT] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:130) 2008-08-04 12:05:30,613 INFO [STDOUT] at org.jboss.webservice.server.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor.java:51) 2008-08-04 12:05:30,613 INFO [STDOUT] at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:48) 2008-08-04 12:05:30,613 INFO [STDOUT] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:105) 2008-08-04 12:05:30,613 INFO [STDOUT] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:335) 2008-08-04 12:05:30,613 INFO [STDOUT] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:166) 2008-08-04 12:05:30,613 INFO [STDOUT] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:139) 2008-08-04 12:05:30,613 INFO [STDOUT] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192) 2008-08-04 12:05:30,613 INFO [STDOUT] ... 59 more 2008-08-04 12:05:30,613 INFO [STDOUT] Caused by: java.sql.SQLException: 'nvl' is not a recognized built-in function name. 2008-08-04 12:05:30,613 INFO [STDOUT] at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365) 2008-08-04 12:05:30,613 INFO [STDOUT] at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781) 2008-08-04 12:05:30,613 INFO [STDOUT] at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224) 2008-08-04 12:05:30,613 INFO [STDOUT] at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628) 2008-08-04 12:05:30,613 INFO [STDOUT] at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:418) 2008-08-04 12:05:30,613 INFO [STDOUT] at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693) 2008-08-04 12:05:30,613 INFO [STDOUT] at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:296) 2008-08-04 12:05:30,613 INFO [STDOUT] at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:118) 2008-08-04 12:05:30,613 INFO [STDOUT] at org.hibernate.loader.Loader.getResultSet(Loader.java:1239) 2008-08-04 12:05:30,613 INFO [STDOUT] at org.hibernate.loader.Loader.doQuery(Loader.java:374) 2008-08-04 12:05:30,613 INFO [STDOUT] at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:210) 2008-08-04 12:05:30,613 INFO [STDOUT] at org.hibernate.loader.Loader.doList(Loader.java:1562) View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4168358#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...