|

Problem in Sonar 1.11

View: New views

8 Messages — Rating Filter: Alert me

	Problem in Sonar 1.11 by Rogerio Baldini :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Some parts of this message have been removed. Learn more about Nabble's security policy. Hi Guys I’ve updated to Sonar 1.11 and I am getting this error when trying to run sonar goal: [INFO] Execute decorators... [INFO] ANALYSIS SUCCESSFUL, you can browse http://192.168.1.32:9000 [INFO] Purging database... [WARN] SQL Error: 1795, SQLState: 42000 [ERROR] ORA-01795: maximum number of expressions in a list is 1000 [INFO] ------------------------------------------------------------------------ [ERROR] BUILD ERROR [INFO] ------------------------------------------------------------------------ [INFO] Can not execute Sonar Embedded error: org.hibernate.exception.SQLGrammarException: could not execute query ORA-01795: maximum number of expressions in a list is 1000 [INFO] ------------------------------------------------------------------------ [INFO] For more information, run Maven with the -e switch [INFO] ------------------------------------------------------------------------ Thanks, Rogerio.
	Re: Problem in Sonar 1.11 by Jim Sellers :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Looks like you're running into the issue when there are more than 1000 items in an IN sql statement. eg. select * from table_name where blah IN('thing1', 'thing2') This is a very old hibernate bug. When ever I'd seen stuff about this, the hibernate guys usually say something along the lines of "we're not changing hibernate because oracle is stupid. Don't use oracle". http://opensource.atlassian.com/projects/hibernate/browse/HHH-1123 Best of luck. Jim On Fri, Oct 9, 2009 at 10:36 AM, Rogerio Baldini das Neves <rogerio.baldini@...> wrote: Hi Guys I’ve updated to Sonar 1.11 and I am getting this error when trying to run sonar goal: [INFO] Execute decorators... [INFO] ANALYSIS SUCCESSFUL, you can browse http://192.168.1.32:9000 [INFO] Purging database... [WARN] SQL Error: 1795, SQLState: 42000 [ERROR] ORA-01795: maximum number of expressions in a list is 1000 [INFO] ------------------------------------------------------------------------ [ERROR] BUILD ERROR [INFO] ------------------------------------------------------------------------ [INFO] Can not execute Sonar Embedded error: org.hibernate.exception.SQLGrammarException: could not execute query ORA-01795: maximum number of expressions in a list is 1000 [INFO] ------------------------------------------------------------------------ [INFO] For more information, run Maven with the -e switch [INFO] ------------------------------------------------------------------------ Thanks, Rogerio.
	RES: Problem in Sonar 1.11 by Rogerio Baldini :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Some parts of this message have been removed. Learn more about Nabble's security policy. Ok Jim, I understand the problem. But I was working fine in version 1.10.1, using some project and same oracle… So, it’s a new bug in Sonar, even with this bug in Hibernate+Oracle. Thanks, Rogerio. De: Jim Sellers [mailto:jim.sellers@...] Enviada em: sexta-feira, 9 de outubro de 2009 12:21 Para: user@... Assunto: Re: [sonar-user] Problem in Sonar 1.11 Looks like you're running into the issue when there are more than 1000 items in an IN sql statement. eg. select * from table_name where blah IN('thing1', 'thing2') This is a very old hibernate bug. When ever I'd seen stuff about this, the hibernate guys usually say something along the lines of "we're not changing hibernate because oracle is stupid. Don't use oracle". http://opensource.atlassian.com/projects/hibernate/browse/HHH-1123 Best of luck. Jim On Fri, Oct 9, 2009 at 10:36 AM, Rogerio Baldini das Neves <rogerio.baldini@...> wrote: Hi Guys I’ve updated to Sonar 1.11 and I am getting this error when trying to run sonar goal: [INFO] Execute decorators... [INFO] ANALYSIS SUCCESSFUL, you can browse http://192.168.1.32:9000 [INFO] Purging database... [WARN] SQL Error: 1795, SQLState: 42000 [ERROR] ORA-01795: maximum number of expressions in a list is 1000 [INFO] ------------------------------------------------------------------------ [ERROR] BUILD ERROR [INFO] ------------------------------------------------------------------------ [INFO] Can not execute Sonar Embedded error: org.hibernate.exception.SQLGrammarException: could not execute query ORA-01795: maximum number of expressions in a list is 1000 [INFO] ------------------------------------------------------------------------ [INFO] For more information, run Maven with the -e switch [INFO] ------------------------------------------------------------------------ Thanks, Rogerio. No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.421 / Virus Database: 270.14.8/2425 - Release Date: 10/09/09 08:10:00
	Re: Problem in Sonar 1.11 by Freddy Mallet :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Hi Rogerio, Could you launch a new analysis with the option "-e" to get a full stack trace ? Thanks for your help Freddy On Fri, Oct 9, 2009 at 7:20 PM, Rogerio Baldini das Neves <rogerio.baldini@...> wrote: Ok Jim, I understand the problem. But I was working fine in version 1.10.1, using some project and same oracle… So, it’s a new bug in Sonar, even with this bug in Hibernate+Oracle. Thanks, Rogerio. De: Jim Sellers [mailto:jim.sellers@...] Enviada em: sexta-feira, 9 de outubro de 2009 12:21 Para: user@... Assunto: Re: [sonar-user] Problem in Sonar 1.11 Looks like you're running into the issue when there are more than 1000 items in an IN sql statement. eg. select * from table_name where blah IN('thing1', 'thing2') This is a very old hibernate bug. When ever I'd seen stuff about this, the hibernate guys usually say something along the lines of "we're not changing hibernate because oracle is stupid. Don't use oracle". http://opensource.atlassian.com/projects/hibernate/browse/HHH-1123 Best of luck. Jim On Fri, Oct 9, 2009 at 10:36 AM, Rogerio Baldini das Neves <rogerio.baldini@...> wrote: Hi Guys I’ve updated to Sonar 1.11 and I am getting this error when trying to run sonar goal: [INFO] Execute decorators... [INFO] ANALYSIS SUCCESSFUL, you can browse http://192.168.1.32:9000 [INFO] Purging database... [WARN] SQL Error: 1795, SQLState: 42000 [ERROR] ORA-01795: maximum number of expressions in a list is 1000 [INFO] ------------------------------------------------------------------------ [ERROR] BUILD ERROR [INFO] ------------------------------------------------------------------------ [INFO] Can not execute Sonar Embedded error: org.hibernate.exception.SQLGrammarException: could not execute query ORA-01795: maximum number of expressions in a list is 1000 [INFO] ------------------------------------------------------------------------ [INFO] For more information, run Maven with the -e switch [INFO] ------------------------------------------------------------------------ Thanks, Rogerio. No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.421 / Virus Database: 270.14.8/2425 - Release Date: 10/09/09 08:10:00
	Re: Problem in Sonar 1.11 by Jim Sellers :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message I'd assume that it's data dependant. It might not be a regression from 1.10.1 to 1.11 - it just might mean that you have more data that gets used in the IN clause. Jim On Fri, Oct 9, 2009 at 1:20 PM, Rogerio Baldini das Neves <rogerio.baldini@...> wrote: Ok Jim, I understand the problem. But I was working fine in version 1.10.1, using some project and same oracle… So, it’s a new bug in Sonar, even with this bug in Hibernate+Oracle. Thanks, Rogerio. De: Jim Sellers [mailto:jim.sellers@...] Enviada em: sexta-feira, 9 de outubro de 2009 12:21 Para: user@... Assunto: Re: [sonar-user] Problem in Sonar 1.11 Looks like you're running into the issue when there are more than 1000 items in an IN sql statement. eg. select * from table_name where blah IN('thing1', 'thing2') This is a very old hibernate bug. When ever I'd seen stuff about this, the hibernate guys usually say something along the lines of "we're not changing hibernate because oracle is stupid. Don't use oracle". http://opensource.atlassian.com/projects/hibernate/browse/HHH-1123 Best of luck. Jim On Fri, Oct 9, 2009 at 10:36 AM, Rogerio Baldini das Neves <rogerio.baldini@...> wrote: Hi Guys I’ve updated to Sonar 1.11 and I am getting this error when trying to run sonar goal: [INFO] Execute decorators... [INFO] ANALYSIS SUCCESSFUL, you can browse http://192.168.1.32:9000 [INFO] Purging database... [WARN] SQL Error: 1795, SQLState: 42000 [ERROR] ORA-01795: maximum number of expressions in a list is 1000 [INFO] ------------------------------------------------------------------------ [ERROR] BUILD ERROR [INFO] ------------------------------------------------------------------------ [INFO] Can not execute Sonar Embedded error: org.hibernate.exception.SQLGrammarException: could not execute query ORA-01795: maximum number of expressions in a list is 1000 [INFO] ------------------------------------------------------------------------ [INFO] For more information, run Maven with the -e switch [INFO] ------------------------------------------------------------------------ Thanks, Rogerio. No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.421 / Virus Database: 270.14.8/2425 - Release Date: 10/09/09 08:10:00
	RES: Problem in Sonar 1.11 by Rogerio Baldini :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Some parts of this message have been removed. Learn more about Nabble's security policy. [INFO] Execute decorators... [INFO] ANALYSIS SUCCESSFUL, you can browse http://192.168.1.32:9000 [INFO] Purging database... [WARN] SQL Error: 1795, SQLState: 42000 [ERROR] ORA-01795: maximum number of expressions in a list is 1000 [INFO] ------------------------------------------------------------------------ [ERROR] BUILD ERROR [INFO] ------------------------------------------------------------------------ [INFO] Can not execute Sonar Embedded error: org.hibernate.exception.SQLGrammarException: could not execute query ORA-01795: maximum number of expressions in a list is 1000 [INFO] ------------------------------------------------------------------------ [INFO] Trace org.apache.maven.lifecycle.LifecycleExecutionException: Can not execute Sonar at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:583) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeStandaloneGoal(DefaultLifecycleExecutor.java:512) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoal(DefaultLifecycleExecutor.java:482) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalAndHandleFailures(DefaultLifecycleExecutor.java:330) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeTaskSegments(DefaultLifecycleExecutor.java:227) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.execute(DefaultLifecycleExecutor.java:142) at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:336) at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:129) at org.apache.maven.cli.MavenCli.main(MavenCli.java:287) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.codehaus.classworlds.Launcher.launchEnhanced(Launcher.java:315) at org.codehaus.classworlds.Launcher.launch(Launcher.java:255) at org.codehaus.classworlds.Launcher.mainWithExitCode(Launcher.java:430) at org.codehaus.classworlds.Launcher.main(Launcher.java:375) Caused by: org.apache.maven.plugin.MojoExecutionException: Can not execute Sonar at org.codehaus.mojo.sonar.Bootstraper.executeMojo(Bootstraper.java:87) at org.codehaus.mojo.sonar.Bootstraper.start(Bootstraper.java:65) at org.codehaus.mojo.sonar.SonarMojo.execute(SonarMojo.java:117) at org.apache.maven.plugin.DefaultPluginManager.executeMojo(DefaultPluginManager.java:451) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:558) ... 16 more Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:614) at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:76) at org.sonar.plugins.core.purges.PurgeDisabledResources.getSnapshotIds(PurgeDisabledResources.java:67) at org.sonar.plugins.core.purges.PurgeDisabledResources.purge(PurgeDisabledResources.java:43) at org.sonar.batch.core.FinalizeSnapshotsJob.purge(FinalizeSnapshotsJob.java:106) at org.sonar.batch.core.FinalizeSnapshotsJob.execute(FinalizeSnapshotsJob.java:51) at org.sonar.batch.Batch.executeJobs(Batch.java:91) at org.sonar.batch.Batch.analyse(Batch.java:79) at org.sonar.batch.Batch.start(Batch.java:54) at org.sonar.batch.BatchMojo.executeBatch(BatchMojo.java:138) at org.sonar.batch.BatchMojo.execute(BatchMojo.java:130) at org.apache.maven.plugin.DefaultPluginManager.executeMojo(DefaultPluginManager.java:451) at org.codehaus.mojo.sonar.Bootstraper.executeMojo(Bootstraper.java:82) ... 20 more Caused by: org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.loader.Loader.doList(Loader.java:2235) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129) at org.hibernate.loader.Loader.list(Loader.java:2124) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1149) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:67) ... 31 more Caused by: java.sql.SQLException: ORA-01795: maximum number of expressions in a list is 1000 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:185) at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:503) at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:965) at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:535) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1051) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2984) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3026) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) at org.hibernate.loader.Loader.getResultSet(Loader.java:1812) at org.hibernate.loader.Loader.doQuery(Loader.java:697) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259) at org.hibernate.loader.Loader.doList(Loader.java:2232) ... 39 more [INFO] ------------------------------------------------------------------------ [INFO] Total time: 24 minutes [INFO] Finished at: Fri Oct 09 15:09:49 BRT 2009 [INFO] Final Memory: 117M/762M [INFO] ------------------------------------------------------------------------ Rogério Baldini das Neves jCompany Suite - Product Owner rogerio.baldini@... 31 3555 0050 / 31 9968 6642 De: Freddy Mallet [mailto:freddy.mallet@...] Enviada em: sexta-feira, 9 de outubro de 2009 14:22 Para: user@... Assunto: Re: [sonar-user] Problem in Sonar 1.11 Hi Rogerio, Could you launch a new analysis with the option "-e" to get a full stack trace ? Thanks for your help Freddy On Fri, Oct 9, 2009 at 7:20 PM, Rogerio Baldini das Neves <rogerio.baldini@...> wrote: Ok Jim, I understand the problem. But I was working fine in version 1.10.1, using some project and same oracle… So, it’s a new bug in Sonar, even with this bug in Hibernate+Oracle. Thanks, Rogerio. De: Jim Sellers [mailto:jim.sellers@...] Enviada em: sexta-feira, 9 de outubro de 2009 12:21 Para: user@... Assunto: Re: [sonar-user] Problem in Sonar 1.11 Looks like you're running into the issue when there are more than 1000 items in an IN sql statement. eg. select * from table_name where blah IN('thing1', 'thing2') This is a very old hibernate bug. When ever I'd seen stuff about this, the hibernate guys usually say something along the lines of "we're not changing hibernate because oracle is stupid. Don't use oracle". http://opensource.atlassian.com/projects/hibernate/browse/HHH-1123 Best of luck. Jim On Fri, Oct 9, 2009 at 10:36 AM, Rogerio Baldini das Neves <rogerio.baldini@...> wrote: Hi Guys I’ve updated to Sonar 1.11 and I am getting this error when trying to run sonar goal: [INFO] Execute decorators... [INFO] ANALYSIS SUCCESSFUL, you can browse http://192.168.1.32:9000 [INFO] Purging database... [WARN] SQL Error: 1795, SQLState: 42000 [ERROR] ORA-01795: maximum number of expressions in a list is 1000 [INFO] ------------------------------------------------------------------------ [ERROR] BUILD ERROR [INFO] ------------------------------------------------------------------------ [INFO] Can not execute Sonar Embedded error: org.hibernate.exception.SQLGrammarException: could not execute query ORA-01795: maximum number of expressions in a list is 1000 [INFO] ------------------------------------------------------------------------ [INFO] For more information, run Maven with the -e switch [INFO] ------------------------------------------------------------------------ Thanks, Rogerio. No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.421 / Virus Database: 270.14.8/2425 - Release Date: 10/09/09 08:10:00 No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.421 / Virus Database: 270.14.8/2425 - Release Date: 10/09/09 08:10:00
	Re: Problem in Sonar 1.11 by Freddy Mallet :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Ok Rogério, bug has been analyzed and fixed on the trunk : http://jira.codehaus.org/browse/SONAR-1203. This problem only occurs with Oracle DB when several projects have been deleted from the Sonar web interface before migrating to Sonar 1.11. If our understanding is correct, you just have to execute the following SQL request to fix your problem : delete from projects where enabled=false Thanks for your help Freddy On Fri, Oct 9, 2009 at 9:06 PM, Rogerio Baldini das Neves <rogerio.baldini@...> wrote: [INFO] Execute decorators... [INFO] ANALYSIS SUCCESSFUL, you can browse http://192.168.1.32:9000 [INFO] Purging database... [WARN] SQL Error: 1795, SQLState: 42000 [ERROR] ORA-01795: maximum number of expressions in a list is 1000 [INFO] ------------------------------------------------------------------------ [ERROR] BUILD ERROR [INFO] ------------------------------------------------------------------------ [INFO] Can not execute Sonar Embedded error: org.hibernate.exception.SQLGrammarException: could not execute query ORA-01795: maximum number of expressions in a list is 1000 [INFO] ------------------------------------------------------------------------ [INFO] Trace org.apache.maven.lifecycle.LifecycleExecutionException: Can not execute Sonar at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:583) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeStandaloneGoal(DefaultLifecycleExecutor.java:512) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoal(DefaultLifecycleExecutor.java:482) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalAndHandleFailures(DefaultLifecycleExecutor.java:330) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeTaskSegments(DefaultLifecycleExecutor.java:227) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.execute(DefaultLifecycleExecutor.java:142) at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:336) at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:129) at org.apache.maven.cli.MavenCli.main(MavenCli.java:287) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.codehaus.classworlds.Launcher.launchEnhanced(Launcher.java:315) at org.codehaus.classworlds.Launcher.launch(Launcher.java:255) at org.codehaus.classworlds.Launcher.mainWithExitCode(Launcher.java:430) at org.codehaus.classworlds.Launcher.main(Launcher.java:375) Caused by: org.apache.maven.plugin.MojoExecutionException: Can not execute Sonar at org.codehaus.mojo.sonar.Bootstraper.executeMojo(Bootstraper.java:87) at org.codehaus.mojo.sonar.Bootstraper.start(Bootstraper.java:65) at org.codehaus.mojo.sonar.SonarMojo.execute(SonarMojo.java:117) at org.apache.maven.plugin.DefaultPluginManager.executeMojo(DefaultPluginManager.java:451) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:558) ... 16 more Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:614) at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:76) at org.sonar.plugins.core.purges.PurgeDisabledResources.getSnapshotIds(PurgeDisabledResources.java:67) at org.sonar.plugins.core.purges.PurgeDisabledResources.purge(PurgeDisabledResources.java:43) at org.sonar.batch.core.FinalizeSnapshotsJob.purge(FinalizeSnapshotsJob.java:106) at org.sonar.batch.core.FinalizeSnapshotsJob.execute(FinalizeSnapshotsJob.java:51) at org.sonar.batch.Batch.executeJobs(Batch.java:91) at org.sonar.batch.Batch.analyse(Batch.java:79) at org.sonar.batch.Batch.start(Batch.java:54) at org.sonar.batch.BatchMojo.executeBatch(BatchMojo.java:138) at org.sonar.batch.BatchMojo.execute(BatchMojo.java:130) at org.apache.maven.plugin.DefaultPluginManager.executeMojo(DefaultPluginManager.java:451) at org.codehaus.mojo.sonar.Bootstraper.executeMojo(Bootstraper.java:82) ... 20 more Caused by: org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.loader.Loader.doList(Loader.java:2235) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129) at org.hibernate.loader.Loader.list(Loader.java:2124) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1149) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:67) ... 31 more Caused by: java.sql.SQLException: ORA-01795: maximum number of expressions in a list is 1000 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:185) at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:503) at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:965) at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:535) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1051) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2984) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3026) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) at org.hibernate.loader.Loader.getResultSet(Loader.java:1812) at org.hibernate.loader.Loader.doQuery(Loader.java:697) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259) at org.hibernate.loader.Loader.doList(Loader.java:2232) ... 39 more [INFO] ------------------------------------------------------------------------ [INFO] Total time: 24 minutes [INFO] Finished at: Fri Oct 09 15:09:49 BRT 2009 [INFO] Final Memory: 117M/762M [INFO] ------------------------------------------------------------------------ Rogério Baldini das Neves jCompany Suite - Product Owner rogerio.baldini@... 31 3555 0050 / 31 9968 6642 De: Freddy Mallet [mailto:freddy.mallet@...] Enviada em: sexta-feira, 9 de outubro de 2009 14:22 Para: user@... Assunto: Re: [sonar-user] Problem in Sonar 1.11 Hi Rogerio, Could you launch a new analysis with the option "-e" to get a full stack trace ? Thanks for your help Freddy On Fri, Oct 9, 2009 at 7:20 PM, Rogerio Baldini das Neves <rogerio.baldini@...> wrote: Ok Jim, I understand the problem. But I was working fine in version 1.10.1, using some project and same oracle… So, it’s a new bug in Sonar, even with this bug in Hibernate+Oracle. Thanks, Rogerio. De: Jim Sellers [mailto:jim.sellers@...] Enviada em: sexta-feira, 9 de outubro de 2009 12:21 Para: user@... Assunto: Re: [sonar-user] Problem in Sonar 1.11 Looks like you're running into the issue when there are more than 1000 items in an IN sql statement. eg. select * from table_name where blah IN('thing1', 'thing2') This is a very old hibernate bug. When ever I'd seen stuff about this, the hibernate guys usually say something along the lines of "we're not changing hibernate because oracle is stupid. Don't use oracle". http://opensource.atlassian.com/projects/hibernate/browse/HHH-1123 Best of luck. Jim On Fri, Oct 9, 2009 at 10:36 AM, Rogerio Baldini das Neves <rogerio.baldini@...> wrote: Hi Guys I’ve updated to Sonar 1.11 and I am getting this error when trying to run sonar goal: [INFO] Execute decorators... [INFO] ANALYSIS SUCCESSFUL, you can browse http://192.168.1.32:9000 [INFO] Purging database... [WARN] SQL Error: 1795, SQLState: 42000 [ERROR] ORA-01795: maximum number of expressions in a list is 1000 [INFO] ------------------------------------------------------------------------ [ERROR] BUILD ERROR [INFO] ------------------------------------------------------------------------ [INFO] Can not execute Sonar Embedded error: org.hibernate.exception.SQLGrammarException: could not execute query ORA-01795: maximum number of expressions in a list is 1000 [INFO] ------------------------------------------------------------------------ [INFO] For more information, run Maven with the -e switch [INFO] ------------------------------------------------------------------------ Thanks, Rogerio. No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.421 / Virus Database: 270.14.8/2425 - Release Date: 10/09/09 08:10:00 No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.421 / Virus Database: 270.14.8/2425 - Release Date: 10/09/09 08:10:00
	RES: Problem in Sonar 1.11 by Rogerio Baldini :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Some parts of this message have been removed. Learn more about Nabble's security policy. Ok. It worked... De: Freddy Mallet [mailto:freddy.mallet@...] Enviada em: sábado, 10 de outubro de 2009 09:44 Para: user@... Assunto: Re: [sonar-user] Problem in Sonar 1.11 Ok Rogério, bug has been analyzed and fixed on the trunk : http://jira.codehaus.org/browse/SONAR-1203. This problem only occurs with Oracle DB when several projects have been deleted from the Sonar web interface before migrating to Sonar 1.11. If our understanding is correct, you just have to execute the following SQL request to fix your problem : delete from projects where enabled=false Thanks for your help Freddy On Fri, Oct 9, 2009 at 9:06 PM, Rogerio Baldini das Neves <rogerio.baldini@...> wrote: [INFO] Execute decorators... [INFO] ANALYSIS SUCCESSFUL, you can browse http://192.168.1.32:9000 [INFO] Purging database... [WARN] SQL Error: 1795, SQLState: 42000 [ERROR] ORA-01795: maximum number of expressions in a list is 1000 [INFO] ------------------------------------------------------------------------ [ERROR] BUILD ERROR [INFO] ------------------------------------------------------------------------ [INFO] Can not execute Sonar Embedded error: org.hibernate.exception.SQLGrammarException: could not execute query ORA-01795: maximum number of expressions in a list is 1000 [INFO] ------------------------------------------------------------------------ [INFO] Trace org.apache.maven.lifecycle.LifecycleExecutionException: Can not execute Sonar at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:583) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeStandaloneGoal(DefaultLifecycleExecutor.java:512) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoal(DefaultLifecycleExecutor.java:482) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalAndHandleFailures(DefaultLifecycleExecutor.java:330) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeTaskSegments(DefaultLifecycleExecutor.java:227) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.execute(DefaultLifecycleExecutor.java:142) at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:336) at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:129) at org.apache.maven.cli.MavenCli.main(MavenCli.java:287) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.codehaus.classworlds.Launcher.launchEnhanced(Launcher.java:315) at org.codehaus.classworlds.Launcher.launch(Launcher.java:255) at org.codehaus.classworlds.Launcher.mainWithExitCode(Launcher.java:430) at org.codehaus.classworlds.Launcher.main(Launcher.java:375) Caused by: org.apache.maven.plugin.MojoExecutionException: Can not execute Sonar at org.codehaus.mojo.sonar.Bootstraper.executeMojo(Bootstraper.java:87) at org.codehaus.mojo.sonar.Bootstraper.start(Bootstraper.java:65) at org.codehaus.mojo.sonar.SonarMojo.execute(SonarMojo.java:117) at org.apache.maven.plugin.DefaultPluginManager.executeMojo(DefaultPluginManager.java:451) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:558) ... 16 more Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:614) at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:76) at org.sonar.plugins.core.purges.PurgeDisabledResources.getSnapshotIds(PurgeDisabledResources.java:67) at org.sonar.plugins.core.purges.PurgeDisabledResources.purge(PurgeDisabledResources.java:43) at org.sonar.batch.core.FinalizeSnapshotsJob.purge(FinalizeSnapshotsJob.java:106) at org.sonar.batch.core.FinalizeSnapshotsJob.execute(FinalizeSnapshotsJob.java:51) at org.sonar.batch.Batch.executeJobs(Batch.java:91) at org.sonar.batch.Batch.analyse(Batch.java:79) at org.sonar.batch.Batch.start(Batch.java:54) at org.sonar.batch.BatchMojo.executeBatch(BatchMojo.java:138) at org.sonar.batch.BatchMojo.execute(BatchMojo.java:130) at org.apache.maven.plugin.DefaultPluginManager.executeMojo(DefaultPluginManager.java:451) at org.codehaus.mojo.sonar.Bootstraper.executeMojo(Bootstraper.java:82) ... 20 more Caused by: org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.loader.Loader.doList(Loader.java:2235) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129) at org.hibernate.loader.Loader.list(Loader.java:2124) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1149) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:67) ... 31 more Caused by: java.sql.SQLException: ORA-01795: maximum number of expressions in a list is 1000 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:185) at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:503) at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:965) at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:535) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1051) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2984) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3026) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) at org.hibernate.loader.Loader.getResultSet(Loader.java:1812) at org.hibernate.loader.Loader.doQuery(Loader.java:697) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259) at org.hibernate.loader.Loader.doList(Loader.java:2232) ... 39 more [INFO] ------------------------------------------------------------------------ [INFO] Total time: 24 minutes [INFO] Finished at: Fri Oct 09 15:09:49 BRT 2009 [INFO] Final Memory: 117M/762M [INFO] ------------------------------------------------------------------------ Rogério Baldini das Neves jCompany Suite - Product Owner rogerio.baldini@... 31 3555 0050 / 31 9968 6642 De: Freddy Mallet [mailto:freddy.mallet@...] Enviada em: sexta-feira, 9 de outubro de 2009 14:22 Para: user@... Assunto: Re: [sonar-user] Problem in Sonar 1.11 Hi Rogerio, Could you launch a new analysis with the option "-e" to get a full stack trace ? Thanks for your help Freddy On Fri, Oct 9, 2009 at 7:20 PM, Rogerio Baldini das Neves <rogerio.baldini@...> wrote: Ok Jim, I understand the problem. But I was working fine in version 1.10.1, using some project and same oracle… So, it’s a new bug in Sonar, even with this bug in Hibernate+Oracle. Thanks, Rogerio. De: Jim Sellers [mailto:jim.sellers@...] Enviada em: sexta-feira, 9 de outubro de 2009 12:21 Para: user@... Assunto: Re: [sonar-user] Problem in Sonar 1.11 Looks like you're running into the issue when there are more than 1000 items in an IN sql statement. eg. select * from table_name where blah IN('thing1', 'thing2') This is a very old hibernate bug. When ever I'd seen stuff about this, the hibernate guys usually say something along the lines of "we're not changing hibernate because oracle is stupid. Don't use oracle". http://opensource.atlassian.com/projects/hibernate/browse/HHH-1123 Best of luck. Jim On Fri, Oct 9, 2009 at 10:36 AM, Rogerio Baldini das Neves <rogerio.baldini@...> wrote: Hi Guys I’ve updated to Sonar 1.11 and I am getting this error when trying to run sonar goal: [INFO] Execute decorators... [INFO] ANALYSIS SUCCESSFUL, you can browse http://192.168.1.32:9000 [INFO] Purging database... [WARN] SQL Error: 1795, SQLState: 42000 [ERROR] ORA-01795: maximum number of expressions in a list is 1000 [INFO] ------------------------------------------------------------------------ [ERROR] BUILD ERROR [INFO] ------------------------------------------------------------------------ [INFO] Can not execute Sonar Embedded error: org.hibernate.exception.SQLGrammarException: could not execute query ORA-01795: maximum number of expressions in a list is 1000 [INFO] ------------------------------------------------------------------------ [INFO] For more information, run Maven with the -e switch [INFO] ------------------------------------------------------------------------ Thanks, Rogerio. No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.421 / Virus Database: 270.14.8/2425 - Release Date: 10/09/09 08:10:00 No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.421 / Virus Database: 270.14.8/2425 - Release Date: 10/09/09 08:10:00 No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.421 / Virus Database: 270.14.8/2425 - Release Date: 10/09/09 08:10:00