#12 Portal Does not startup!

[Anonymous]

Dear Support,

I read about your product with great interest. I took the time to install the portal I followed all the steps one by one by I can not still install the PORTAL
maybe the user guide has something missing?

After following the NEW PORTAL INSTATIATION GUIDE the PORTAL does not start up.

The installation is done on Mac OS with the recommended version in your documentations.

I appreciate your support on this

here is the full log after starting the server

Jan 22, 2010 3:09:16 PM org.apache.tomcat.util.digester.SetPropertiesRule begin
WARNING: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'debug' to '1' did not find a matching property.
Jan 22, 2010 3:09:17 PM org.apache.tomcat.util.digester.SetPropertiesRule begin
WARNING: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.jee.server:myPortalName' did not find a matching property.
Jan 22, 2010 3:09:17 PM org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: .:/Library/Java/Extensions:/System/Library/Java/Extensions:/usr/lib/java
Jan 22, 2010 3:09:17 PM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Jan 22, 2010 3:09:17 PM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8443
Jan 22, 2010 3:09:17 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1541 ms
Jan 22, 2010 3:09:17 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Jan 22, 2010 3:09:17 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.20
com.agiletec.apsadmin.system.tiles.impl.JapsBasicTilesContainer Tiles Conf files:
com.agiletec.apsadmin.system.tiles.impl.JapsBasicTilesContainer /WEB-INF/apsadmin/tiles.xml
com.agiletec.apsadmin.system.tiles.impl.JapsBasicTilesContainer /WEB-INF/plugins/jacms/apsadmin/jacms-tiles.xml
com.agiletec.aps.servlet.StartupListener: INIT @webapp@ - powered by jAPS 2.0
Jan 22, 2010 3:09:19 PM org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring root WebApplicationContext
2010-01-22 15:09:21,768 ERROR (org.springframework.web.context.ContextLoader:215) - Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'ControllerManager' defined in ServletContext resource [/WEB-INF/conf/managers/controller/controllerConfig.xml]: Cannot resolve reference to bean 'RequestValidatorControlService' while setting bean property 'controllerServices' with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'RequestValidatorControlService' defined in ServletContext resource [/WEB-INF/conf/managers/controller/controllerServicesConfig.xml]: Cannot resolve reference to bean 'LangManager' while setting bean property 'langManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'LangManager' defined in ServletContext resource [/WEB-INF/conf/managers/baseManagersConfig.xml]: Cannot resolve reference to bean 'BaseConfigManager' while setting bean property 'configManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'BaseConfigManager' defined in ServletContext resource [/WEB-INF/conf/managers/baseManagersConfig.xml]: Invocation of init method failed; nested exception is com.agiletec.aps.system.exception.ApsSystemException: Errore in caricamento items
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:275)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveManagedList(BeanDefinitionValueResolver.java:287)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:126)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1245)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1010)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:472)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
at java.security.AccessController.doPrivileged(Native Method)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:429)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:728)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:380)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:255)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:199)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:45)
at com.agiletec.aps.servlet.StartupListener.contextInitialized(StartupListener.java:37)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3934)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4429)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:516)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:583)
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.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'RequestValidatorControlService' defined in ServletContext resource [/WEB-INF/conf/managers/controller/controllerServicesConfig.xml]: Cannot resolve reference to bean 'LangManager' while setting bean property 'langManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'LangManager' defined in ServletContext resource [/WEB-INF/conf/managers/baseManagersConfig.xml]: Cannot resolve reference to bean 'BaseConfigManager' while setting bean property 'configManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'BaseConfigManager' defined in ServletContext resource [/WEB-INF/conf/managers/baseManagersConfig.xml]: Invocation of init method failed; nested exception is com.agiletec.aps.system.exception.ApsSystemException: Errore in caricamento items
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:275)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1245)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1010)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:472)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
at java.security.AccessController.doPrivileged(Native Method)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:269)
... 36 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'LangManager' defined in ServletContext resource [/WEB-INF/conf/managers/baseManagersConfig.xml]: Cannot resolve reference to bean 'BaseConfigManager' while setting bean property 'configManager'; nested exception is org.springframework.beans.factory.BeanCreationEJan 22, 2010 3:09:21 PM org.apache.catalina.core.StandardContext listenerStart
SEVERE: Exception sending context initialized event to listener instance of class com.agiletec.aps.servlet.StartupListener
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'ControllerManager' defined in ServletContext resource [/WEB-INF/conf/managers/controller/controllerConfig.xml]: Cannot resolve reference to bean 'RequestValidatorControlService' while setting bean property 'controllerServices' with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'RequestValidatorControlService' defined in ServletContext resource [/WEB-INF/conf/managers/controller/controllerServicesConfig.xml]: Cannot resolve reference to bean 'LangManager' while setting bean property 'langManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'LangManager' defined in ServletContext resource [/WEB-INF/conf/managers/baseManagersConfig.xml]: Cannot resolve reference to bean 'BaseConfigManager' while setting bean property 'configManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'BaseConfigManager' defined in ServletContext resource [/WEB-INF/conf/managers/baseManagersConfig.xml]: Invocation of init method failed; nested exception is com.agiletec.aps.system.exception.ApsSystemException: Errore in caricamento items
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:275)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveManagedList(BeanDefinitionValueResolver.java:287)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:126)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1245)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1010)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:472)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
at java.security.AccessController.doPrivileged(Native Method)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:429)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:728)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:380)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:255)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:199)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:45)
at com.agiletec.aps.servlet.StartupListener.contextInitialized(StartupListener.java:37)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3934)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4429)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:516)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:583)
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.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'RequestValidatorControlService' defined in ServletContext resource [/WEB-INF/conf/managers/controller/controllerServicesConfig.xml]: Cannot resolve reference to bean 'LangManager' while setting bean property 'langManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'LangManager' defined in ServletContext resource [/WEB-INF/conf/managers/baseManagersConfig.xml]: Cannot resolve reference to bean 'BaseConfigManager' while setting bean property 'configManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'BaseConfigManager' defined in ServletContext resource [/WEB-INF/conf/managers/baseManagersConfig.xml]: Invocation of init method failed; nested exception is com.agiletec.aps.system.exception.ApsSystemException: Errore in caricamento items
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:275)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1245)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1010)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:472)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
at java.security.AccessController.doPrivileged(Native Method)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:269)
... 36 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'LangManager' defined in ServletContext resource [/WEB-INF/conf/managers/baseManagersConfig.xml]: Cannot resolve reference to bean 'BaseConfigManager' while setting bean property 'configManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'BaseConfigManager' defined in ServletContext resource [/WEB-INF/conf/managers/baseManagersConfig.xml]: Invocation of init method failed; nested exception is com.agiletec.aps.system.exception.ApsSystemException: Errore in caricamento items
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:275)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1245)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1010)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:472)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
at java.security.AccessController.doPrivileged(Native Method)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:269)
... 49 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'BaseConfigManager' defined in ServletContext resource [/WEB-INF/conf/managers/baseManagersConfig.xml]: Invocation of init method failed; nested exception is com.agiletec.aps.system.exception.ApsSystemException: Errore in caricamento items
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1338)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:473)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
at java.security.AccessController.doPrivileged(Native Method)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:269)
... 62 more
Caused by: com.agiletec.aps.system.exception.ApsSystemException: Errore in caricamento items
at com.agiletec.aps.system.services.baseconfig.BaseConfigManager.loadConfigItems(BaseConfigManager.java:108)
at com.agiletec.aps.system.services.baseconfig.BaseConfigManager.init(BaseConfigManager.java:51)
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.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1414)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1375)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1335)
... 72 more
Caused by: java.lang.RuntimeException: Errore in caricamento items configurazione - versione production
at com.agiletec.aps.system.services.AbstractDAO.processDaoException(AbstractDAO.java:47)
at com.agiletec.aps.system.services.baseconfig.ConfigItemDAO.loadVersionItems(ConfigItemDAO.java:61)
at com.agiletec.aps.system.services.baseconfig.BaseConfigManager.loadConfigItems(BaseConfigManager.java:106)
... 80 more
Caused by: org.postgresql.util.PSQLException: ERROR: relation "sysconfig" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1608)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1343)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:194)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at com.agiletec.aps.system.services.baseconfig.ConfigItemDAO.loadVersionItems(ConfigItemDAO.java:54)
... 81 more
xception: Error creating bean with name 'BaseConfigManager' defined in ServletContext resource [/WEB-INF/conf/managers/baseManagersConfig.xml]: Invocation of init method failed; nested exception is com.agiletec.aps.system.exception.ApsSystemException: Errore in caricamento items
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:275)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1245)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1010)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:472)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
at java.security.AccessController.doPrivileged(Native Method)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:269)
... 49 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'BaseConfigManager' defined in ServletContext resource [/WEB-INF/conf/managers/baseManagersConfig.xml]: Invocation of init method failed; nested exception is com.agiletec.aps.system.exception.ApsSystemException: Errore in caricamento items
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1338)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:473)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
at java.security.AccessController.doPrivileged(Native Method)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:269)
... 62 more
Caused by: com.agiletec.aps.system.exception.ApsSystemException: Errore in caricamento items
at com.agiletec.aps.system.services.baseconfig.BaseConfigManager.loadConfigItems(BaseConfigManager.java:108)
at com.agiletec.aps.system.services.baseconfig.BaseConfigManager.init(BaseConfigManager.java:51)
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.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1414)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1375)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1335)
... 72 more
Caused by: java.lang.RuntimeException: Errore in caricamento items configurazione - versione production
at com.agiletec.aps.system.services.AbstractDAO.processDaoException(AbstractDAO.java:47)
at com.agiletec.aps.system.services.baseconfig.ConfigItemDAO.loadVersionItems(ConfigItemDAO.java:61)
at com.agiletec.aps.system.services.baseconfig.BaseConfigManager.loadConfigItems(BaseConfigManager.java:106)
... 80 more
Caused by: org.postgresql.util.PSQLException: ERROR: relation "sysconfig" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1608)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1343)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:194)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at com.agiletec.aps.system.services.baseconfig.ConfigItemDAO.loadVersionItems(ConfigItemDAO.java:54)
... 81 more
Jan 22, 2010 3:09:22 PM org.apache.catalina.core.StandardContext start
SEVERE: Error listenerStart
Jan 22, 2010 3:09:22 PM org.apache.catalina.core.StandardContext start
SEVERE: Context [/myPortalName] startup failed due to previous errors
Jan 22, 2010 3:09:22 PM org.apache.catalina.core.ApplicationContext log
INFO: Closing Spring root WebApplicationContext
Jan 22, 2010 3:09:22 PM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
Jan 22, 2010 3:09:22 PM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8443
Jan 22, 2010 3:09:22 PM org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
Jan 22, 2010 3:09:22 PM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/62 config=null
Jan 22, 2010 3:09:22 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 4969 ms

[Andrea]

Hi :)

Reading your log i've seen
"ERROR: relation "sysconfig" does not exist"

Are you sure did you restore successfully the db? (both dbPort and dbServ)

and please check again jdbc parameters in context.xml

--
Andrea

[Anonymous]

Hi Andrea,

Thanks for your feedback.

I did check the context.xml. The database connection is correct

I get the following when I created the database (this is a first install).

Buildfile: /Users/Marwan/Documents/workspace/myPortalName/build.xml
PG db create:
[echo] Creating jAPS2Port....
[exec] CREATE DATABASE "jAPS2Port" OWNER agile ENCODING 'UTF-8';
[echo] Creating jAPS2Serv....
[exec] CREATE DATABASE "jAPS2Serv" OWNER agile ENCODING 'UTF-8';
BUILD SUCCESSFUL
Total time: 1 second

Then I login using pgAdmin and I can see those databases and I can login to them using pgAdmin3 client.

What else could have gone wrong? How can I check that the schema are created successfully and
the data populated in the database?

I appreciate your support.

Kind Regards

Marwan

[Wiz of Id]

Hi marwan,
this seems to me a configuration issue :)
Can you please subscribe one o both the mailing lists at this page: https://sourceforge.net/projects/japs/support ?
Then, we the community can all assist you in analysing and solving the issue :)

And please, let me suggest you to report the more information you can about your development environment, and the issue itself.
That is, O.S. (name and version), JDK version, and so on... or (ad I can guess reading you first message) just an URL or other unique pointer to the document and pages you cited,

Thank you very much for using jAPS 2.0 :)

William Ghelfi - Tzente s.r.l.

[Anonymous]

I have now created one under the SUPPORT, it is a shame if no one can help me to install the PORTAL.

I am impressed so far with it offers but unfortunatly no real help so far.

here is the ID of this ticket.

Can not install Portal - ID: 2940367

Marwan...

[Chabbani]

It seems my efforts is wasted. Nobody seem to care to help in making a fresh first install of the Portal. I did paste also this in the SUPPORT AREA. It look like I have to find another OPENSOURCE solution, This is pretty useless so far.

[Nobody/Anonymous]

Hi Chabbani, it's seems your db was not populate. After using pg db create use pg db full update to popultae your db.
Regards

Rinaldo

[Chabbani]

Thank you for the response.

Indeed this is the problem, the DB instance is created, but the ANT script does the following after execution,
I expect to run out of the box with no issues.

Where are the scripts are located and can I run them manually to do a first DB population?

Buildfile: /Users/Marwan/Documents/workspace/myPortalName/build.xml
PG db drop:
[echo] Dropping jAPS2Port....
[echo] Dropping jAPS2Serv....
PG db create:
[echo] Creating jAPS2Port....
[exec] CREATE DATABASE "jAPS2Port" OWNER agile ENCODING 'UTF-8';
[echo] Creating jAPS2Serv....
[exec] CREATE DATABASE "jAPS2Serv" OWNER agile ENCODING 'UTF-8';
PG db restore:
[echo] Restoring jAPS2Port....
[exec] pg_restore: connecting to database for restore
[exec] pg_restore: creating SCHEMA public
[exec] pg_restore: creating COMMENT SCHEMA public
[exec] pg_restore: creating PROCEDURAL LANGUAGE plpgsql
[exec] pg_restore: [archiver (db)] Error while PROCESSING TOC:
[exec] pg_restore: [archiver (db)] Error from TOC entry 289; 2612 16386 PROCEDURAL LANGUAGE plpgsql postgres
[exec] pg_restore: [archiver (db)] could not execute query: ERROR: language "plpgsql" already exists
[exec] Command was:
[exec] CREATE PROCEDURAL LANGUAGE plpgsql;
[exec] pg_restore: setting owner and privileges for SCHEMA public
[exec] pg_restore: setting owner and privileges for COMMENT SCHEMA public
[exec] pg_restore: setting owner and privileges for ACL public
[exec] pg_restore: WARNING: no privileges could be revoked for "public"
[exec] pg_restore: WARNING: no privileges could be revoked for "public"
[exec] pg_restore: WARNING: no privileges were granted for "public"
[exec] pg_restore: WARNING: no privileges were granted for "public"
[exec] pg_restore: setting owner and privileges for PROCEDURAL LANGUAGE plpgsql
[exec] WARNING: errors ignored on restore: 1
[exec] Result: 1
[echo] Restoring jAPS2Serv....
[exec] pg_restore: connecting to database for restore
[exec] pg_restore: creating SCHEMA public
[exec] pg_restore: creating COMMENT SCHEMA public
[exec] pg_restore: creating PROCEDURAL LANGUAGE plpgsql
[exec] pg_restore: [archiver (db)] Error while PROCESSING TOC:
[exec] pg_restore: [archiver (db)] Error from TOC entry 289; 2612 16386 PROCEDURAL LANGUAGE plpgsql postgres
[exec] pg_restore: [archiver (db)] could not execute query: ERROR: language "plpgsql" already exists
[exec] Command was:
[exec] CREATE PROCEDURAL LANGUAGE plpgsql;
[exec] pg_restore: setting owner and privileges for SCHEMA public
[exec] pg_restore: setting owner and privileges for COMMENT SCHEMA public
[exec] pg_restore: setting owner and privileges for ACL public
[exec] pg_restore: WARNING: no privileges could be revoked for "public"
[exec] pg_restore: WARNING: no privileges could be revoked for "public"
[exec] pg_restore: WARNING: no privileges were granted for "public"
[exec] pg_restore: WARNING: no privileges were granted for "public"
[exec] pg_restore: setting owner and privileges for PROCEDURAL LANGUAGE plpgsql
[exec] WARNING: errors ignored on restore: 1
[exec] Result: 1
PG db full update:
[echo] Databases full update [done]
BUILD SUCCESSFUL
Total time: 20 seconds

[Zuanni]

> Where are the scripts are located and can I run them manually to do a
> first DB population?

The scripts are under the folder <ProjectName>/db/tar/ , one for db Port <ProjectName>Port.backup and another one for <ProjectName>Serv.backup.

Which version of Postgres are you using?
I see the message in your log trying to restore to a server 8.1 scripts created from a 8.3 version.

In my opinion this is not a Bug, can I ask you to post this request on the mailing list of the projects?

[Roberta Quaresima]

Dear Chabbani,

we have evaluated the request you have posted on the bug tracker and, as many people of the community and the jAPS Team have written, we belive that is not a bug, but a problem with the environment configuration.
To close the bug, I would invite you to subscribe to japs-dev mailing list and continue the discussion there.

The devs mailing list - is dedicated to the developers who want to discuss technical aspects of jAPS Platform.

You can subscribe to the lists through this adress https://lists.sourceforge.net/lists/listinfo/japs-devs.
To put questions to the mailing lists you can use the following emails: japs-devs@lists.sourceforge.net

Thank you for your interest in jAPS 2.0 Platform and to join to jAPS Community.

Roberta