profile.database.hostname=xx.xx.xx.xx
profile.database.port=1521
profile.database.username=username
profile.database.password=password
profile.database.driverClassName=oracle.jdbc.driver.OracleDriver
profile.database.url.portdb=jdbc:oracle:thin:@${profile.database.hostname}:${profile.database.port}:${profile.application.name}PortDev
profile.database.url.servdb=jdbc:oracle:thin:@${profile.database.hostname}:${profile.database.port}:${profile.application.name}ServDev
We received the following error during the 'InitializerManager' bean creation, in the cms startup (the bean is defined in class path resource spring/baseSystemConfig.xml):
Grave: Exception sending context initialized event to listener instance of class org.entando.entando.aps.servlet.StartupListener
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'InitializerManager' defined in class path resource [spring/baseSystemConfig.xml]: Invocation of init method failed; nested exception is java.lang.Exception: Error while initializating Db Installer
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1566)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:755)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:757)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:480)
at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:403)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:106)
at org.entando.entando.aps.servlet.StartupListener.contextInitialized(StartupListener.java:30)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5003)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5517)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1574)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1564)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.Exception: Error while initializating Db Installer
at org.entando.entando.aps.system.init.InitializerManager.init(InitializerManager.java:49)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1694)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1633)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1562)
... 22 more
Caused by: java.lang.Exception: Error while initializating Db Installer
at org.entando.entando.aps.system.init.DatabaseManager.installDatabase(DatabaseManager.java:108)
at org.entando.entando.aps.system.init.InitializerManager.init(InitializerManager.java:45)
... 29 more
Caused by: com.agiletec.aps.system.exception.ApsSystemException: Error initializating master DefaultResource
at org.entando.entando.aps.system.init.DatabaseManager.initMasterDefaultResource(DatabaseManager.java:318)
at org.entando.entando.aps.system.init.DatabaseManager.installDatabase(DatabaseManager.java:89)
... 30 more
Caused by: com.agiletec.aps.system.exception.ApsSystemException: Error executing script into db portDataSource
at org.entando.entando.aps.system.init.util.TableDataUtils.valueDatabase(TableDataUtils.java:67)
at org.entando.entando.aps.system.init.DatabaseManager.initMasterDefaultResource(DatabaseManager.java:301)
... 31 more
Caused by: com.agiletec.aps.system.exception.ApsSystemException: Error executing script - QUERY:
INSERT INTO guifragment (code, widgettypecode, plugincode, gui, defaultgui, locked) VALUES ('userprofile_is_IteratorAttribute', NULL, NULL, NULL, '<#assign c=JspTaglibs["http://java.sun.com/jsp/jstl/core"]>
<#assign s=JspTaglibs["/struts-tags"]>
<#assign wp=JspTaglibs["/aps-core"]>
<#assign wpsa=JspTaglibs["/apsadmin-core"]>
<#assign wpsf=JspTaglibs["/apsadmin-form"]>
<#assign i18n_attribute_name ><@s.property value="#i18n_attribute_name" /></#assign>
<@s.if test="#attribute.type == ''Boolean''">
<div class="control-group <@s.property value="%{'' attribute-type-''+#attribute.type+'' ''}" />">
<label class="control-label">
<@wp.i18n key="${i18n_attribute_name}" />
<@wp.fragment code="userprofile_is_front_AttributeInfo" escapeXml=false />
</label>
<div class="controls">
<@wp.fragment code="userprofile_is_front-BooleanAttribute" escapeXml=false />
<@wp.fragment code="userprofile_is_front_attributeInfo-help-block" escapeXml=false />
</div>
</div>
</@s.if>
<@s.elseif test="#attribute.type == ''CheckBox''">
<div class="control-group <@s.property value="%{'' attribute-type-''+#attribute.type+'' ''}" />">
<label class="control-label" for="<@s.property value="#attribute_id" />">
<@wp.i18n key="${i18n_attribute_name}" />
<@wp.fragment code="userprofile_is_front_AttributeInfo" escapeXml=false />
</label>
<div class="controls">
<@wp.fragment code="userprofile_is_front-CheckboxAttribute" escapeXml=false />
<@wp.fragment code="userprofile_is_front_attributeInfo-help-block" escapeXml=false />
</div>
</div>
</@s.elseif>
<@s.elseif test="#attribute.type == ''Composite''">
<div class="well well-small">
<fieldset class=" <@s.property value="%{'' attribute-type-''+#attribute.type+'' ''}" />">
<legend class="margin-medium-top">
<@wp.i18n key="${i18n_attribute_name}" />
<@wp.fragment code="userprofile_is_front_AttributeInfo" escapeXml=false />
</legend>
<@wp.fragment code="userprofile_is_front_attributeInfo-help-block" escapeXml=false />
<@wp.fragment code="userprofile_is_front-CompositeAttribute" escapeXml=false />
</fieldset>
</div>
</@s.elseif>
<@s.elseif test="#attribute.type == ''Date''">
<div class="control-group <@s.property value="%{'' attribute-type-''+#attribute.type+'' ''}" />">
<label class="control-label" for="<@s.property value="#attribute_id" />">
<@wp.i18n key="${i18n_attribute_name}" />
<@wp.fragment code="userprofile_is_front_AttributeInfo" escapeXml=false />
</label>
<div class="controls">
<@wp.fragment code="userprofile_is_front-DateAttribute" escapeXml=false />
<@wp.fragment code="userprofile_is_front_attributeInfo-help-block" escapeXml=false />
</div>
</div>
</@s.elseif>
<@s.elseif test="#attribute.type == ''Enumerator''">
<div class="control-group <@s.property value="%{'' attribute-type-''+#attribute.type+'' ''}" />">
<label class="control-label" for="<@s.property value="#attribute_id" />">
<@wp.i18n key="${i18n_attribute_name}" />
<@wp.fragment code="userprofile_is_front_AttributeInfo" escapeXml=false />
</label>
<div class="controls">
<@wp.fragment code="userprofile_is_front-EnumeratorAttribute" escapeXml=false />
<@wp.fragment code="userprofile_is_front_attributeInfo-help-block" escapeXml=false />
</div>
</div>
</@s.elseif>
<@s.elseif test="#attribute.type == ''EnumeratorMap''">
<div class="control-group <@s.property value="%{'' attribute-type-''+#attribute.type+'' ''}" />">
<label class="control-label" for="<@s.property value="#attribute_id" />">
<@wp.i18n key="${i18n_attribute_name}" />
<@wp.fragment code="userprofile_is_front_AttributeInfo" escapeXml=false />
</label>
<div class="controls">
<@wp.fragment code="userprofile_is_front-EnumeratorMapAttribute" escapeXml=false />
<@wp.fragment code="userprofile_is_front_attributeInfo-help-block" escapeXml=false />
</div>
</div>
</@s.elseif>
<@s.elseif test="#attribute.type == ''Hypertext''">
<div class="control-group <@s.property value="%{'' attribute-type-''+#attribute.type+'' ''}" />">
<label class="control-label" for="<@s.property value="#attribute_id" />">
<@wp.i18n key="${i18n_attribute_name}" />
<@wp.fragment code="userprofile_is_front_AttributeInfo" escapeXml=false />
</label>
<div class="controls">
<@wp.fragment code="userprofile_is_front-HypertextAttribute" escapeXml=false />
<@wp.fragment code="userprofile_is_front_attributeInfo-help-block" escapeXml=false />
</div>
</div>
</@s.elseif>
<@s.elseif test="#attribute.type == ''List''">
<div class="well well-small">
<fieldset class=" <@s.property value="%{'' attribute-type-''+#attribute.type+'' ''}" />">
<legend class="margin-medium-top">
<@wp.i18n key="${i18n_attribute_name}" />
<@wp.fragment code="userprofile_is_front_AttributeInfo" escapeXml=false />
</legend>
<@wp.fragment code="userprofile_is_front_attributeInfo-help-block" escapeXml=false />
<@wp.fragment code="userprofile_is_front-MonolistAttribute" escapeXml=false />
</fieldset>
</div>
</@s.elseif>
<@s.elseif test="#attribute.type == ''Longtext''">
<div class="control-group <@s.property value="%{'' attribute-type-''+#attribute.type+'' ''}" />">
<label class="control-label" for="<@s.property value="#attribute_id" />">
<@wp.i18n key="${i18n_attribute_name}" />
<@wp.fragment code="userprofile_is_front_AttributeInfo" escapeXml=false />
</label>
<div class="controls">
<@wp.fragment code="userprofile_is_front-LongtextAttribute" escapeXml=false />
<@wp.fragment code="userprofile_is_front_attributeInfo-help-block" escapeXml=false />
</div>
</div>
</@s.elseif>
<@s.elseif test="#attribute.type == ''Monolist''">
<div class="well well-small">
<fieldset class=" <@s.property value="%{'' attribute-type-''+#attribute.type+'' ''}" />">
<legend class="margin-medium-top"><@wp.i18n key="${i18n_attribute_name}" />
<@wp.fragment code="userprofile_is_front_AttributeInfo" escapeXml=false />
</legend>
<@wp.fragment code="userprofile_is_front_attributeInfo-help-block" escapeXml=false />
<@wp.fragment code="userprofile_is_front-MonolistAttribute" escapeXml=false />
</fieldset>
</div>
</@s.elseif>
<@s.elseif test="#attribute.type == ''Monotext''">
<div class="control-group <@s.property value="%{'' attribute-type-''+#attribute.type+'' ''}" />">
<label class="control-label" for="<@s.property value="#attribute_id" />">
<@wp.i18n key="${i18n_attribute_name}" />
<@wp.fragment code="userprofile_is_front_AttributeInfo" escapeXml=false />
</label>
<div class="controls">
<@wp.fragment code="userprofile_is_front-MonotextAttribute" escapeXml=false />
<@wp.fragment code="userprofile_is_front_attributeInfo-help-block" escapeXml=false />
</div>
</div>
</@s.elseif>
<@s.elseif test="#attribute.type == ''Number''">
<div class="control-group <@s.property value="%{'' attribute-type-''+#attribute.type+'' ''}" />">
<label class="control-label" for="<@s.property value="#attribute_id" />">
<@wp.i18n key="${i18n_attribute_name}" />
<@wp.fragment code="userprofile_is_front_AttributeInfo" escapeXml=false />
</label>
<div class="controls">
<@wp.fragment code="userprofile_is_front-NumberAttribute" escapeXml=false />
<@wp.fragment code="userprofile_is_front_attributeInfo-help-block" escapeXml=false />
</div>
</div>
</@s.elseif>
<@s.elseif test="#attribute.type == ''Text''">
<div class="control-group <@s.property value="%{'' attribute-type-''+#attribute.type+'' ''}" />">
<label class="control-label" for="<@s.property value="#attribute_id" />">
<@wp.i18n key="${i18n_attribute_name}" />
<@wp.fragment code="userprofile_is_front_AttributeInfo" escapeXml=false />
</label>
<div class="controls">
<@wp.fragment code="userprofile_is_front-MonotextAttribute" escapeXml=false />
<@wp.fragment code="userprofile_is_front_attributeInfo-help-block" escapeXml=false />
</div>
</div>
</@s.elseif>
<@s.elseif test="#attribute.type == ''ThreeState''">
<div class="control-group <@s.property value="%{'' attribute-type-''+#attribute.type+'' ''}" />">
<label class="control-label" for="<@s.property value="#attribute_id" />">
<@wp.i18n key="${i18n_attribute_name}" />
<@wp.fragment code="userprofile_is_front_AttributeInfo" escapeXml=false />
</label>
<div class="controls">
<@wp.fragment code="userprofile_is_front-ThreeStateAttribute" escapeXml=false />
<@wp.fragment code="userprofile_is_front_attributeInfo-help-block" escapeXml=false />
</div>
</div>
</@s.elseif>
<@s.else> <#-- for all other types, insert a simple label and a input[type="text"] -->
<div class="control-group <@s.property value="%{'' attribute-type-''+#attribute.type+'' ''}" />">
<label class="control-label" for="<@s.property value="attribute_id" />">
<@wp.i18n key="${i18n_attribute_name}" />
<@wp.fragment code="userprofile_is_front_AttributeInfo" escapeXml=false />
</label>
<div class="controls">
<@wp.fragment code="userprofile_is_front-MonotextAttribute" escapeXml=false />
<@wp.fragment code="userprofile_is_front_attributeInfo-help-block" escapeXml=false />
</div>
</div>
</@s.else>', 1)
at org.entando.entando.aps.system.init.util.TableDataUtils.executeQueries(TableDataUtils.java:97)
at org.entando.entando.aps.system.init.util.TableDataUtils.valueDatabase(TableDataUtils.java:58)
... 32 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-01704: valore di stringa troppo lungo
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1044)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3665)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1352)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.entando.entando.aps.system.init.util.TableDataUtils.executeQueries(TableDataUtils.java:82)
... 33 more
Please can you help us to solve the problem? thanks in advance for your help.