Hi,

I've installed several times now AGS with patch 6.0p2.
During the installation everything goes smoothly. When I start the
server, I am able login and use the tool for a few time, until the
browser gives me this:

-The page isn't redirecting properly
Firefox has detected that the server is redirecting the request for this
address in a way that will never complete. -

My browser is set to accept cookies.
MY INSTALLATION DETAILS:
_O.S:_ Microsoft Windows XP Professional version 2002 service pack 3
_DB:_MySQL 5.6.11
_Application_Server:_ Tomcat 6 (same result with Tomcat 7)
_jdk:_1.6.0_43

The exception on tomcat is the following:

ERROR QuartzScheduler_QuartzSchedulerThread
org.quartz.core.ErrorLogger:2156 - An error occured while scanning for
the next trigger to fire.
org.quartz.JobPersistenceException: Couldn't acquire next trigger: You
have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near 'OPTION
SQL_SELECT_LIMIT=1' at line 1 [See nested exception:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorEx ception: You have an
error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near 'OPTION
SQL_SELECT_LIMIT=1' at line 1]
at
org.quartz.impl.jdbcjobstore.JobStoreSupport.acqui reNextTrigger(JobStoreSupport.java:2700)
at
org.quartz.impl.jdbcjobstore.JobStoreSupport$35.ex ecute(JobStoreSupport.java:2658)
at
org.quartz.impl.jdbcjobstore.JobStoreSupport.execu teInNonManagedTXLock(JobStoreSupport.java:3662)
at
org.quartz.impl.jdbcjobstore.JobStoreSupport.acqui reNextTrigger(JobStoreSupport.java:2654)
at
org.quartz.core.QuartzSchedulerThread.run(QuartzSc hedulerThread.java:235)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorEx ception:
You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near 'OPTION
SQL_SELECT_LIMIT=1' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native
Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInsta nce(NativeConstructorAccessorImpl.java:39)
at
sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Construc tor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:40 9)
at com.mysql.jdbc.Util.getInstance(Util.java:384)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3566)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3498)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:19 59)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :2113)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionIm pl.java:2562)
at
com.mysql.jdbc.StatementImpl.executeSimpleNonQuery (StatementImpl.java:1561)
at
com.mysql.jdbc.PreparedStatement.executeQuery(Prep aredStatement.java:2262)
at
org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeQuery(DelegatingPreparedStatement.java:91 )
at
org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selec tTriggerToAcquire(StdJDBCDelegate.java:2920)
at
org.quartz.impl.jdbcjobstore.JobStoreSupport.acqui reNextTrigger(JobStoreSupport.java:2669)
... 4 more
2013-05-15 08:37:57,161 ERROR main
sailpoint.persistence.HibernatePersistenceManager: 261 - Unable to change
isolation level to READ_COMMITTED
2013-05-15 08:37:57,176 WARN main
org.hibernate.util.JDBCExceptionReporter:100 - SQL Error: 1064,
SQLState: 42000
2013-05-15 08:37:57,176 ERROR main
org.hibernate.util.JDBCExceptionReporter:101 - You have an error in your
SQL syntax; check the manual that corresponds to your MySQL server
version for the right syntax to use near 'OPTION
SQL_SELECT_LIMIT=DEFAULT' at line 1
2013-05-15 08:37:57,176 ERROR main sailpoint.server.Servicer:142 -
Unable to initialize server thread
sailpoint.tools.GeneralException: could not execute query
at
sailpoint.server.InternalContext.getObject(Interna lContext.java:549)
at sailpoint.server.Servicer.configure(Servicer.java: 122)
at sailpoint.server.Environment.start(Environment.jav a:387)
at sailpoint.server.SystemStarter.springInit(SystemSt arter.java:59)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.springframework.beans.factory.support.Abstract AutowireCapableBeanFactory.invokeCustomInitMethod( AbstractAutowireCapableBeanFactory.java:1093)
at
org.springframework.beans.factory.support.Abstract AutowireCapableBeanFactory.invokeInitMethods(Abstr actAutowireCapableBeanFactory.java:1063)
at
org.springframework.beans.factory.support.Abstract AutowireCapableBeanFactory.createBean(AbstractAuto wireCapableBeanFactory.java:363)
at
org.springframework.beans.factory.support.Abstract BeanFactory.getBean(AbstractBeanFactory.java:226)
at
org.springframework.beans.factory.support.Abstract BeanFactory.getBean(AbstractBeanFactory.java:147)
at
org.springframework.beans.factory.support.DefaultL istableBeanFactory.preInstantiateSingletons(Defaul tListableBeanFactory.java:275)
at
org.springframework.context.support.AbstractApplic ationContext.refresh(AbstractApplicationContext.ja va:320)
at
org.springframework.context.support.ClassPathXmlAp plicationContext.<init>(ClassPathXmlApplicationCon text.java:87)
at
org.springframework.context.support.ClassPathXmlAp plicationContext.<init>(ClassPathXmlApplicationCon text.java:72)
at
org.springframework.context.support.ClassPathXmlAp plicationContext.<init>(ClassPathXmlApplicationCon text.java:63)
at sailpoint.spring.SpringStarter.start(SpringStarter .java:326)
at
sailpoint.web.StartupContextListener.contextInitia lized(StartupContextListener.java:85)
at
org.apache.catalina.core.StandardContext.listenerS tart(StandardContext.java:4205)
at
org.apache.catalina.core.StandardContext.start(Sta ndardContext.java:4704)
at
org.apache.catalina.core.ContainerBase.addChildInt ernal(ContainerBase.java:799)
at
org.apache.catalina.core.ContainerBase.addChild(Co ntainerBase.java:779)
at
org.apache.catalina.core.StandardHost.addChild(Sta ndardHost.java:601)
at
org.apache.catalina.startup.HostConfig.deployDirec tory(HostConfig.java:1079)
at
org.apache.catalina.startup.HostConfig.deployDirec tories(HostConfig.java:1002)
at
org.apache.catalina.startup.HostConfig.deployApps( HostConfig.java:506)
at org.apache.catalina.startup.HostConfig.start(HostC onfig.java:1315)
at
org.apache.catalina.startup.HostConfig.lifecycleEv ent(HostConfig.java:324)
at
org.apache.catalina.util.LifecycleSupport.fireLife cycleEvent(LifecycleSupport.java:142)
at
org.apache.catalina.core.ContainerBase.start(Conta inerBase.java:1061)
at org.apache.catalina.core.StandardHost.start(Standa rdHost.java:840)
at
org.apache.catalina.core.ContainerBase.start(Conta inerBase.java:1053)
at
org.apache.catalina.core.StandardEngine.start(Stan dardEngine.java:463)
at
org.apache.catalina.core.StandardService.start(Sta ndardService.java:525)
at
org.apache.catalina.core.StandardServer.start(Stan dardServer.java:754)
at org.apache.catalina.startup.Catalina.start(Catalin a.java:595)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootst rap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstr ap.java:414)
Caused by: sailpoint.tools.GeneralException: could not execute query
at
sailpoint.persistence.HibernatePersistenceManager. getObjects(HibernatePersistenceManager.java:1680)
at
sailpoint.persistence.ClassPersistenceManager.getO bjects(ClassPersistenceManager.java:272)
at
sailpoint.server.InternalContext.getObjects(Intern alContext.java:802)
at
sailpoint.server.InternalContext.getObject(Interna lContext.java:537)
... 43 more
Caused by: org.hibernate.exception.SQLGrammarException: could not
execute query
at
org.hibernate.exception.SQLStateConverter.convert( SQLStateConverter.java:92)
at
org.hibernate.exception.JDBCExceptionHelper.conver t(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:229 7)
at org.hibernate.loader.Loader.listUsingQueryCache(Lo ader.java:2204)
at org.hibernate.loader.Loader.list(Loader.java:2164)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoa der.java:448)
at
org.hibernate.hql.ast.QueryTranslatorImpl.list(Que ryTranslatorImpl.java:363)
at
org.hibernate.engine.query.HQLQueryPlan.performLis t(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.ja va:1258)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:1 02)
at
sailpoint.persistence.HibernatePersistenceManager. getObjects(HibernatePersistenceManager.java:1676)
... 46 more

I made a grep -r "OPTION SQL_SELECT_LIMIT=DEFAULT" in order to find the
file(s) that contained the faulty string, but nothing appeared in the
results.
Although the o.s that I'm using is not listed in the supported ones, it
is the same that I used for the training of IIQ5.5.

Has anyone seen the same problem? Any ideas on how to proceed?

Thanks,

Charlie


--
cvattani
------------------------------------------------------------------------
cvattani's Profile: https://forums.netiq.com/member.php?userid=4974
View this thread: https://forums.netiq.com/showthread.php?t=47758