java.lang.reflect.InvocationTargetException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • I was able to reproduce this exception reliably by doing the following on the 2.4.1 quickstart! ant hsql & cd uPortal_rel-2-4-1 modify properties/PersonDirs.xml: Set the uidquery to the following: -------------------- <uidquery>SELECT FIRST_NAME||' '||LAST_NAME AS FIRST_LAST, FIRST_NAME, LAST_NAME, EMAIL , 'test' as template FROM UP_PERSON_DIR WHERE USER_NAME=?</uidquery> --Add the following to map template to the template user name -------------------- <attribute><alias>uPortalTemplateUserName</alias> <name>template</name></attribute> -------------------- ant md5passwd -Dusername=test # enter password ant md5passwd -Dusername=test1 # enter password cd .. ant tomcatstart # browse to http://localhost:8080/uPortal # login as test and logout (do not do anything else such as modify the layout) # login as test1 # you will get Cannot Start uPortal along with the following exceptions in the log: ERROR [http-8080-Processor25] layout.AggregatedUserLayoutStore.[] Jan/18 08:44:58 - Error getting aggregated layout for user org.jasig.portal.security.provider.PersonImpl@145e460 org.jasig.portal.PortalException: AggregatedUserLayoutStore::getAggregatedLayout(): No INIT_NODE_ID in UP_USER_LAYOUT_AGGR for 17 and LAYOUT_ID 1 at org.jasig.portal.layout.AggregatedUserLayoutStore.getAggregatedLayout(AggregatedUserLayoutStore.java:1889) at org.jasig.portal.layout.AggregatedLayoutManager.loadUserLayout(AggregatedLayoutManager.java:1081) at org.jasig.portal.layout.AggregatedLayoutManager.<init>(AggregatedLayoutManager.java:120) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:274) at org.jasig.portal.layout.UserLayoutManagerFactory.getUserLayoutManager(UserLayoutManagerFactory.java:85) at org.jasig.portal.UserPreferencesManager.<init>(UserPreferencesManager.java:233) at org.jasig.portal.UserInstance.writeContent(UserInstance.java:174) at org.jasig.portal.PortalSessionManager.doGet(PortalSessionManager.java:276) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) at java.lang.Thread.run(Thread.java:534) ERROR [http-8080-Processor25] portal.ExceptionHelper.[] Jan/18 08:44:58 - Programming error java.lang.reflect.InvocationTargetException at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:274) at org.jasig.portal.layout.UserLayoutManagerFactory.getUserLayoutManager(UserLayoutManagerFactory.java:85) at org.jasig.portal.UserPreferencesManager.<init>(UserPreferencesManager.java:233) at org.jasig.portal.UserInstance.writeContent(UserInstance.java:174) at org.jasig.portal.PortalSessionManager.doGet(PortalSessionManager.java:276) Caused by: org.jasig.portal.PortalException: null [based on exception: AggregatedUserLayoutStore::getAggregatedLayout(): No INIT_NODE_ID in UP_USER_LAYOUT_AGGR for 17 and LAYOUT_ ID 1] at org.jasig.portal.layout.AggregatedLayoutManager.loadUserLayout(AggregatedLayoutManager.java:1101) at org.jasig.portal.layout.AggregatedLayoutManager.<init>(AggregatedLayoutManager.java:120) ... 34 more
    via by Brad Johnson,
  • I was able to reproduce this exception reliably by doing the following on the 2.4.1 quickstart! ant hsql & cd uPortal_rel-2-4-1 modify properties/PersonDirs.xml: Set the uidquery to the following: -------------------- <uidquery>SELECT FIRST_NAME||' '||LAST_NAME AS FIRST_LAST, FIRST_NAME, LAST_NAME, EMAIL , 'test' as template FROM UP_PERSON_DIR WHERE USER_NAME=?</uidquery> --Add the following to map template to the template user name -------------------- <attribute><alias>uPortalTemplateUserName</alias> <name>template</name></attribute> -------------------- ant md5passwd -Dusername=test # enter password ant md5passwd -Dusername=test1 # enter password cd .. ant tomcatstart # browse to http://localhost:8080/uPortal # login as test and logout (do not do anything else such as modify the layout) # login as test1 # you will get Cannot Start uPortal along with the following exceptions in the log: ERROR [http-8080-Processor25] layout.AggregatedUserLayoutStore.[] Jan/18 08:44:58 - Error getting aggregated layout for user org.jasig.portal.security.provider.PersonImpl@145e460 org.jasig.portal.PortalException: AggregatedUserLayoutStore::getAggregatedLayout(): No INIT_NODE_ID in UP_USER_LAYOUT_AGGR for 17 and LAYOUT_ID 1 at org.jasig.portal.layout.AggregatedUserLayoutStore.getAggregatedLayout(AggregatedUserLayoutStore.java:1889) at org.jasig.portal.layout.AggregatedLayoutManager.loadUserLayout(AggregatedLayoutManager.java:1081) at org.jasig.portal.layout.AggregatedLayoutManager.<init>(AggregatedLayoutManager.java:120) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:274) at org.jasig.portal.layout.UserLayoutManagerFactory.getUserLayoutManager(UserLayoutManagerFactory.java:85) at org.jasig.portal.UserPreferencesManager.<init>(UserPreferencesManager.java:233) at org.jasig.portal.UserInstance.writeContent(UserInstance.java:174) at org.jasig.portal.PortalSessionManager.doGet(PortalSessionManager.java:276) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) at java.lang.Thread.run(Thread.java:534) ERROR [http-8080-Processor25] portal.ExceptionHelper.[] Jan/18 08:44:58 - Programming error java.lang.reflect.InvocationTargetException at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:274) at org.jasig.portal.layout.UserLayoutManagerFactory.getUserLayoutManager(UserLayoutManagerFactory.java:85) at org.jasig.portal.UserPreferencesManager.<init>(UserPreferencesManager.java:233) at org.jasig.portal.UserInstance.writeContent(UserInstance.java:174) at org.jasig.portal.PortalSessionManager.doGet(PortalSessionManager.java:276) Caused by: org.jasig.portal.PortalException: null [based on exception: AggregatedUserLayoutStore::getAggregatedLayout(): No INIT_NODE_ID in UP_USER_LAYOUT_AGGR for 17 and LAYOUT_ ID 1] at org.jasig.portal.layout.AggregatedLayoutManager.loadUserLayout(AggregatedLayoutManager.java:1101) at org.jasig.portal.layout.AggregatedLayoutManager.<init>(AggregatedLayoutManager.java:120) ... 34 more
    via by Brad Johnson,
  • I have downloaded uportal 2.4.patch from cvs,and I have the exception ,when I started uPortal INFO: Server startup in 20653 ms INFO [http-9091-Processor25] portal.RDBMServices.[] Aug/31 11:31:37 - MySQL/com.mysql.jdbc.Driver (mysql-connector-java-3.1.7 ( $Date: 2005/01/25 19:11:41 $, $Revision: 1.27.4.54 $ )) database/driver supports: Prepared statements=true, Outer joins=true, Transactions=true, '{ts' metasyntax=true, TO_DATE()=false INFO [http-9091-Processor25] groups.GroupServiceConfiguration.[] Aug/31 11:31:38 - Group services: Parsing group service configuration. INFO [http-9091-Processor25] groups.RDBMEntityGroupStore.[] Aug/31 11:31:38 - RDBMEntityGroupStore.initialize(): Node separator set to . INFO [http-9091-Processor25] properties.PropertiesManager.[] Aug/31 11:31:39 - Property [org.jasig.portal.concurrency.IEntityCachingService.org.jasig.portal.groups.IEntity.maxCacheSize] was requested but not found. INFO [http-9091-Processor25] properties.PropertiesManager.[] Aug/31 11:31:39 - Property [org.jasig.portal.concurrency.IEntityCachingService.org.jasig.portal.groups.IEntity.MaxIdleTime] was requested but not found. INFO [http-9091-Processor25] properties.PropertiesManager.[] Aug/31 11:31:39 - Property [org.jasig.portal.concurrency.IEntityCachingService.org.jasig.portal.groups.IEntity.sweepInterval] was requested but not found. INFO [http-9091-Processor25] properties.PropertiesManager.[] Aug/31 11:31:39 - Property [org.jasig.portal.concurrency.IEntityCachingService.org.jasig.portal.groups.IEntityGroup.maxCacheSize] was requested but not found. INFO [http-9091-Processor25] properties.PropertiesManager.[] Aug/31 11:31:39 - Property [org.jasig.portal.concurrency.IEntityCachingService.org.jasig.portal.groups.IEntityGroup.MaxIdleTime] was requested but not found. INFO [http-9091-Processor25] properties.PropertiesManager.[] Aug/31 11:31:39 - Property [org.jasig.portal.concurrency.IEntityCachingService.org.jasig.portal.groups.IEntityGroup.sweepInterval] was requested but not found. INFO [http-9091-Processor25] properties.PropertiesManager.[] Aug/31 11:31:39 - Property [org.jasig.portal.concurrency.IEntityCachingService.org.jasig.portal.ChannelDefinition.maxCacheSize] was requested but not found. INFO [http-9091-Processor25] properties.PropertiesManager.[] Aug/31 11:31:39 - Property [org.jasig.portal.concurrency.IEntityCachingService.org.jasig.portal.ChannelDefinition.MaxIdleTime] was requested but not found. INFO [http-9091-Processor25] properties.PropertiesManager.[] Aug/31 11:31:39 - Property [org.jasig.portal.concurrency.IEntityCachingService.org.jasig.portal.ChannelDefinition.sweepInterval] was requested but not found. ERROR [http-9091-Processor25] layout.AggregatedUserLayoutStore.[] Aug/31 11:31:39 - Error getting aggregated layout for user org.jasig.portal.security.provider.PersonImpl@3461d1 java.sql.SQLException: You have an error in your SQL syntax near 'UNION SELECT UF.NODE_ID,UF.NEXT_NODE_ID,UF.CHLD_NODE_ID,UF.PREV_NODE_ID,UF.PRNT_' at line 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2847) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622) at com.mysql.jdbc.Connection.execSQL(Connection.java:2370) at com.mysql.jdbc.Connection.execSQL(Connection.java:2297) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1183) at org.jasig.portal.layout.AggregatedUserLayoutStore.getAggregatedLayout(AggregatedUserLayoutStore.java:1944) at org.jasig.portal.layout.AggregatedLayoutManager.loadUserLayout(AggregatedLayoutManager.java:1081) at org.jasig.portal.layout.AggregatedLayoutManager.<init>(AggregatedLayoutManager.java:120) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:274) at org.jasig.portal.layout.UserLayoutManagerFactory.getUserLayoutManager(UserLayoutManagerFactory.java:85) at org.jasig.portal.GuestUserPreferencesManager.registerSession(GuestUserPreferencesManager.java:198) at org.jasig.portal.GuestUserInstance.registerSession(GuestUserInstance.java:98) at org.jasig.portal.UserInstanceManager.getUserInstance(UserInstanceManager.java:92) at org.jasig.portal.PortalSessionManager.doGet(PortalSessionManager.java:242) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) at java.lang.Thread.run(Thread.java:534) ERROR [http-9091-Processor25] layout.AggregatedLayoutManager.[] Aug/31 11:31:39 - Exception loading user layout java.sql.SQLException: You have an error in your SQL syntax near 'UNION SELECT UF.NODE_ID,UF.NEXT_NODE_ID,UF.CHLD_NODE_ID,UF.PREV_NODE_ID,UF.PRNT_' at line 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2847) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622) at com.mysql.jdbc.Connection.execSQL(Connection.java:2370) at com.mysql.jdbc.Connection.execSQL(Connection.java:2297) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1183) at org.jasig.portal.layout.AggregatedUserLayoutStore.getAggregatedLayout(AggregatedUserLayoutStore.java:1944) at org.jasig.portal.layout.AggregatedLayoutManager.loadUserLayout(AggregatedLayoutManager.java:1081) at org.jasig.portal.layout.AggregatedLayoutManager.<init>(AggregatedLayoutManager.java:120) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:274) at org.jasig.portal.layout.UserLayoutManagerFactory.getUserLayoutManager(UserLayoutManagerFactory.java:85) at org.jasig.portal.GuestUserPreferencesManager.registerSession(GuestUserPreferencesManager.java:198) at org.jasig.portal.GuestUserInstance.registerSession(GuestUserInstance.java:98) at org.jasig.portal.UserInstanceManager.getUserInstance(UserInstanceManager.java:92) at org.jasig.portal.PortalSessionManager.doGet(PortalSessionManager.java:242) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) at java.lang.Thread.run(Thread.java:534) ERROR [http-9091-Processor25] portal.ExceptionHelper.[] Aug/31 11:31:39 - Programming error java.lang.reflect.InvocationTargetException at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:274) at org.jasig.portal.layout.UserLayoutManagerFactory.getUserLayoutManager(UserLayoutManagerFactory.java:85) at org.jasig.portal.GuestUserPreferencesManager.registerSession(GuestUserPreferencesManager.java:198) at org.jasig.portal.GuestUserInstance.registerSession(GuestUserInstance.java:98) at org.jasig.portal.UserInstanceManager.getUserInstance(UserInstanceManager.java:92) at org.jasig.portal.PortalSessionManager.doGet(PortalSessionManager.java:242) Caused by: org.jasig.portal.PortalException: Exception loading user layout: null [based on exception: You have an error in your SQL syntax near 'UNION SELECT UF.NODE_ID,UF.NEXT_NODE_ID,UF.CHLD_NODE_ID,UF.PREV_NODE_ID,UF.PRNT_' at line 1] [based on exception: null [based on exception: You have an error in your SQL syntax near 'UNION SELECT UF.NODE_ID,UF.NEXT_NODE_ID,UF.CHLD_NODE_ID,UF.PREV_NODE_ID,UF.PRNT_' at line 1]] at org.jasig.portal.layout.AggregatedLayoutManager.loadUserLayout(AggregatedLayoutManager.java:1101) at org.jasig.portal.layout.AggregatedLayoutManager.<init>(AggregatedLayoutManager.java:120) ... 35 more I have found the place in SQL in AggregatedUserLayoutStore // The query for getting information of the fragments String sqlFragment = "SELECT UF.NODE_ID,UF.NEXT_NODE_ID,UF.CHLD_NODE_ID,UF.PREV_NODE_ID,UF.PRNT_NODE_ID,UF.CHAN_ID,UF.NAME,UF.TYPE,UF.HIDDEN,"+ "UF.UNREMOVABLE,UF.IMMUTABLE,UF.PRIORITY,UF.FRAGMENT_ID"; if (RDBMServices.supportsOuterJoins) { sqlFragment += ",UFP.PARAM_NAME,UFP.PARAM_VALUE FROM UP_LAYOUT_STRUCT_AGGR ULS, " + fragmentJoinQuery; } else { sqlFragment += " FROM UP_FRAGMENTS UF, UP_LAYOUT_STRUCT_AGGR ULS WHERE "; } sqlFragment += "(ULS.USER_ID="+userId+" AND ULS.FRAGMENT_ID=UF.FRAGMENT_ID)"; if (pushFragmentIds!=null){ sqlFragment += " UNION SELECT UF.NODE_ID,UF.NEXT_NODE_ID,UF.CHLD_NODE_ID,UF.PREV_NODE_ID,UF.PRNT_NODE_ID,UF.CHAN_ID,UF.NAME,UF.TYPE,UF.HIDDEN,"+ "UF.UNREMOVABLE,UF.IMMUTABLE,UF.PRIORITY,UF.FRAGMENT_ID" + " FROM UP_FRAGMENTS UF WHERE UF.FRAGMENT_ID IN ("+pushFragmentIds+")"; } log.debug(sqlFragment); And I also has found in Mysql Docs that UNION is implemented in MySQL 4.0.0. that's mean that uPortal won't correct work whith Mysql 3.x?? Thanks.
    via by Vladimir Potapov,
  • I have downloaded uportal 2.4.patch from cvs,and I have the exception ,when I started uPortal INFO: Server startup in 20653 ms INFO [http-9091-Processor25] portal.RDBMServices.[] Aug/31 11:31:37 - MySQL/com.mysql.jdbc.Driver (mysql-connector-java-3.1.7 ( $Date: 2005/01/25 19:11:41 $, $Revision: 1.27.4.54 $ )) database/driver supports: Prepared statements=true, Outer joins=true, Transactions=true, '{ts' metasyntax=true, TO_DATE()=false INFO [http-9091-Processor25] groups.GroupServiceConfiguration.[] Aug/31 11:31:38 - Group services: Parsing group service configuration. INFO [http-9091-Processor25] groups.RDBMEntityGroupStore.[] Aug/31 11:31:38 - RDBMEntityGroupStore.initialize(): Node separator set to . INFO [http-9091-Processor25] properties.PropertiesManager.[] Aug/31 11:31:39 - Property [org.jasig.portal.concurrency.IEntityCachingService.org.jasig.portal.groups.IEntity.maxCacheSize] was requested but not found. INFO [http-9091-Processor25] properties.PropertiesManager.[] Aug/31 11:31:39 - Property [org.jasig.portal.concurrency.IEntityCachingService.org.jasig.portal.groups.IEntity.MaxIdleTime] was requested but not found. INFO [http-9091-Processor25] properties.PropertiesManager.[] Aug/31 11:31:39 - Property [org.jasig.portal.concurrency.IEntityCachingService.org.jasig.portal.groups.IEntity.sweepInterval] was requested but not found. INFO [http-9091-Processor25] properties.PropertiesManager.[] Aug/31 11:31:39 - Property [org.jasig.portal.concurrency.IEntityCachingService.org.jasig.portal.groups.IEntityGroup.maxCacheSize] was requested but not found. INFO [http-9091-Processor25] properties.PropertiesManager.[] Aug/31 11:31:39 - Property [org.jasig.portal.concurrency.IEntityCachingService.org.jasig.portal.groups.IEntityGroup.MaxIdleTime] was requested but not found. INFO [http-9091-Processor25] properties.PropertiesManager.[] Aug/31 11:31:39 - Property [org.jasig.portal.concurrency.IEntityCachingService.org.jasig.portal.groups.IEntityGroup.sweepInterval] was requested but not found. INFO [http-9091-Processor25] properties.PropertiesManager.[] Aug/31 11:31:39 - Property [org.jasig.portal.concurrency.IEntityCachingService.org.jasig.portal.ChannelDefinition.maxCacheSize] was requested but not found. INFO [http-9091-Processor25] properties.PropertiesManager.[] Aug/31 11:31:39 - Property [org.jasig.portal.concurrency.IEntityCachingService.org.jasig.portal.ChannelDefinition.MaxIdleTime] was requested but not found. INFO [http-9091-Processor25] properties.PropertiesManager.[] Aug/31 11:31:39 - Property [org.jasig.portal.concurrency.IEntityCachingService.org.jasig.portal.ChannelDefinition.sweepInterval] was requested but not found. ERROR [http-9091-Processor25] layout.AggregatedUserLayoutStore.[] Aug/31 11:31:39 - Error getting aggregated layout for user org.jasig.portal.security.provider.PersonImpl@3461d1 java.sql.SQLException: You have an error in your SQL syntax near 'UNION SELECT UF.NODE_ID,UF.NEXT_NODE_ID,UF.CHLD_NODE_ID,UF.PREV_NODE_ID,UF.PRNT_' at line 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2847) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622) at com.mysql.jdbc.Connection.execSQL(Connection.java:2370) at com.mysql.jdbc.Connection.execSQL(Connection.java:2297) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1183) at org.jasig.portal.layout.AggregatedUserLayoutStore.getAggregatedLayout(AggregatedUserLayoutStore.java:1944) at org.jasig.portal.layout.AggregatedLayoutManager.loadUserLayout(AggregatedLayoutManager.java:1081) at org.jasig.portal.layout.AggregatedLayoutManager.<init>(AggregatedLayoutManager.java:120) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:274) at org.jasig.portal.layout.UserLayoutManagerFactory.getUserLayoutManager(UserLayoutManagerFactory.java:85) at org.jasig.portal.GuestUserPreferencesManager.registerSession(GuestUserPreferencesManager.java:198) at org.jasig.portal.GuestUserInstance.registerSession(GuestUserInstance.java:98) at org.jasig.portal.UserInstanceManager.getUserInstance(UserInstanceManager.java:92) at org.jasig.portal.PortalSessionManager.doGet(PortalSessionManager.java:242) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) at java.lang.Thread.run(Thread.java:534) ERROR [http-9091-Processor25] layout.AggregatedLayoutManager.[] Aug/31 11:31:39 - Exception loading user layout java.sql.SQLException: You have an error in your SQL syntax near 'UNION SELECT UF.NODE_ID,UF.NEXT_NODE_ID,UF.CHLD_NODE_ID,UF.PREV_NODE_ID,UF.PRNT_' at line 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2847) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622) at com.mysql.jdbc.Connection.execSQL(Connection.java:2370) at com.mysql.jdbc.Connection.execSQL(Connection.java:2297) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1183) at org.jasig.portal.layout.AggregatedUserLayoutStore.getAggregatedLayout(AggregatedUserLayoutStore.java:1944) at org.jasig.portal.layout.AggregatedLayoutManager.loadUserLayout(AggregatedLayoutManager.java:1081) at org.jasig.portal.layout.AggregatedLayoutManager.<init>(AggregatedLayoutManager.java:120) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:274) at org.jasig.portal.layout.UserLayoutManagerFactory.getUserLayoutManager(UserLayoutManagerFactory.java:85) at org.jasig.portal.GuestUserPreferencesManager.registerSession(GuestUserPreferencesManager.java:198) at org.jasig.portal.GuestUserInstance.registerSession(GuestUserInstance.java:98) at org.jasig.portal.UserInstanceManager.getUserInstance(UserInstanceManager.java:92) at org.jasig.portal.PortalSessionManager.doGet(PortalSessionManager.java:242) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) at java.lang.Thread.run(Thread.java:534) ERROR [http-9091-Processor25] portal.ExceptionHelper.[] Aug/31 11:31:39 - Programming error java.lang.reflect.InvocationTargetException at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:274) at org.jasig.portal.layout.UserLayoutManagerFactory.getUserLayoutManager(UserLayoutManagerFactory.java:85) at org.jasig.portal.GuestUserPreferencesManager.registerSession(GuestUserPreferencesManager.java:198) at org.jasig.portal.GuestUserInstance.registerSession(GuestUserInstance.java:98) at org.jasig.portal.UserInstanceManager.getUserInstance(UserInstanceManager.java:92) at org.jasig.portal.PortalSessionManager.doGet(PortalSessionManager.java:242) Caused by: org.jasig.portal.PortalException: Exception loading user layout: null [based on exception: You have an error in your SQL syntax near 'UNION SELECT UF.NODE_ID,UF.NEXT_NODE_ID,UF.CHLD_NODE_ID,UF.PREV_NODE_ID,UF.PRNT_' at line 1] [based on exception: null [based on exception: You have an error in your SQL syntax near 'UNION SELECT UF.NODE_ID,UF.NEXT_NODE_ID,UF.CHLD_NODE_ID,UF.PREV_NODE_ID,UF.PRNT_' at line 1]] at org.jasig.portal.layout.AggregatedLayoutManager.loadUserLayout(AggregatedLayoutManager.java:1101) at org.jasig.portal.layout.AggregatedLayoutManager.<init>(AggregatedLayoutManager.java:120) ... 35 more I have found the place in SQL in AggregatedUserLayoutStore // The query for getting information of the fragments String sqlFragment = "SELECT UF.NODE_ID,UF.NEXT_NODE_ID,UF.CHLD_NODE_ID,UF.PREV_NODE_ID,UF.PRNT_NODE_ID,UF.CHAN_ID,UF.NAME,UF.TYPE,UF.HIDDEN,"+ "UF.UNREMOVABLE,UF.IMMUTABLE,UF.PRIORITY,UF.FRAGMENT_ID"; if (RDBMServices.supportsOuterJoins) { sqlFragment += ",UFP.PARAM_NAME,UFP.PARAM_VALUE FROM UP_LAYOUT_STRUCT_AGGR ULS, " + fragmentJoinQuery; } else { sqlFragment += " FROM UP_FRAGMENTS UF, UP_LAYOUT_STRUCT_AGGR ULS WHERE "; } sqlFragment += "(ULS.USER_ID="+userId+" AND ULS.FRAGMENT_ID=UF.FRAGMENT_ID)"; if (pushFragmentIds!=null){ sqlFragment += " UNION SELECT UF.NODE_ID,UF.NEXT_NODE_ID,UF.CHLD_NODE_ID,UF.PREV_NODE_ID,UF.PRNT_NODE_ID,UF.CHAN_ID,UF.NAME,UF.TYPE,UF.HIDDEN,"+ "UF.UNREMOVABLE,UF.IMMUTABLE,UF.PRIORITY,UF.FRAGMENT_ID" + " FROM UP_FRAGMENTS UF WHERE UF.FRAGMENT_ID IN ("+pushFragmentIds+")"; } log.debug(sqlFragment); And I also has found in Mysql Docs that UNION is implemented in MySQL 4.0.0. that's mean that uPortal won't correct work whith Mysql 3.x?? Thanks.
    via by Vladimir Potapov,
  • When logged in as a non template user, the user is not able to succussfully create a fragement. After creating a user in the db via Ant, logging in as the new user, adding content to a new fragment, saving the fragment, and clicking on the link to go back to the fragment manager, I receive and error report with the following error message: null [based on exception: AggregatedUserLayoutStore::getAggregatedLayout(): No INIT_NODE_ID in UP_USER_LAYOUT_AGGR for 16 and LAYOUT_ID 1] I also receive the following stack trace in catalina: org.jasig.portal.PortalException: AggregatedUserLayoutStore::getAggregatedLayout(): No INIT_NODE_ID in UP_USER_LAYOUT_AGGR for 16 and LAYOUT_ID 1 at org.jasig.portal.layout.AggregatedUserLayoutStore.getAggregatedLayout (AggregatedUserLayoutStore.java:1881) at org.jasig.portal.layout.AggregatedLayoutManager.loadUserLayout (AggregatedLayoutManager.java:1081) at org.jasig.portal.layout.channels.CFragmentManager.analyzeParameters (CFragmentManager.java:242) at org.jasig.portal.layout.channels.CFragmentManager.renderXML (CFragmentManager.java:276) at org.jasig.portal.ChannelRenderer$Worker.run (ChannelRenderer.java:528) at org.jasig.portal.utils.threading.Worker.run(Worker.java:88) If I attempt to log back in as this user, I will receive an error stating "Cannot start uPortal". The error occurs in AggregatedUserLayoutStore:1874 when the following statement is ran against the database: SELECT INIT_NODE_ID FROM UP_USER_LAYOUT_AGGR WHERE USER_ID=" + userId + " AND LAYOUT_ID = " + layoutId The problem is that there is no row in UP_USER_LAYOUT_AGGR for the new userId. If I manually enter the row into the table for the new user, the problem is fixed and the user can create fragments. This error does not occur when using template user such as 'demo'. Please let me know if you have any questions. Thanks, Dave Grimwood
    via by David Grimwood,
    • java.lang.reflect.InvocationTargetException at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:274) at org.jasig.portal.layout.UserLayoutManagerFactory.getUserLayoutManager(UserLayoutManagerFactory.java:85) at org.jasig.portal.UserPreferencesManager.<init>(UserPreferencesManager.java:233) at org.jasig.portal.UserInstance.writeContent(UserInstance.java:174) at org.jasig.portal.PortalSessionManager.doGet(PortalSessionManager.java:276) Caused by: org.jasig.portal.PortalException: null [based on exception: AggregatedUserLayoutStore::getAggregatedLayout(): No INIT_NODE_ID in UP_USER_LAYOUT_AGGR for 17 and LAYOUT_ ID 1] at org.jasig.portal.layout.AggregatedLayoutManager.loadUserLayout(AggregatedLayoutManager.java:1101) at org.jasig.portal.layout.AggregatedLayoutManager.<init>(AggregatedLayoutManager.java:120) ... 8 more
    No Bugmate found.