By type
Policy api config file: /opt/app/policy/api/etc/mounted/apiParameters.yaml
overriding logback.xml
. ____ _ __ _ _
/\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
\\/ ___)| |_)| | | | | || (_| | ) ) ) )
' |____| .__|_| |_|_| |_\__, | / / / /
=========|_|==============|___/=/_/_/_/
:: Spring Boot :: (v2.5.0)
[2022-09-04T03:38:25.916+00:00|INFO|PolicyApiApplication|main] Starting PolicyApiApplication using Java 11.0.11 on onap-policy-api-7f94f67944-k85gx with PID 7 (/app/api.jar started by policy in /opt/app/policy/api/bin)
[2022-09-04T03:38:25.923+00:00|INFO|PolicyApiApplication|main] No active profile set, falling back to default profiles: default
[2022-09-04T03:38:29.981+00:00|INFO|RepositoryConfigurationDelegate|main] Bootstrapping Spring Data JPA repositories in DEFAULT mode.
[2022-09-04T03:38:30.285+00:00|INFO|RepositoryConfigurationDelegate|main] Finished Spring Data repository scanning in 274 ms. Found 6 JPA repository interfaces.
[2022-09-04T03:38:32.983+00:00|INFO|TomcatWebServer|main] Tomcat initialized with port(s): 6969 (https)
[2022-09-04T03:38:33.004+00:00|INFO|Http11NioProtocol|main] Initializing ProtocolHandler ["https-jsse-nio-6969"]
[2022-09-04T03:38:33.005+00:00|INFO|StandardService|main] Starting service [Tomcat]
[2022-09-04T03:38:33.005+00:00|INFO|StandardEngine|main] Starting Servlet engine: [Apache Tomcat/9.0.62]
[2022-09-04T03:38:33.170+00:00|INFO|[/]|main] Initializing Spring embedded WebApplicationContext
[2022-09-04T03:38:33.171+00:00|INFO|ServletWebServerApplicationContext|main] Root WebApplicationContext: initialization completed in 7073 ms
[2022-09-04T03:38:34.973+00:00|INFO|LogHelper|main] HHH000204: Processing PersistenceUnitInfo [name: default]
[2022-09-04T03:38:35.130+00:00|INFO|Version|main] HHH000412: Hibernate ORM core version 5.4.31.Final
[2022-09-04T03:38:35.502+00:00|INFO|Version|main] HCANN000001: Hibernate Commons Annotations {5.1.2.Final}
[2022-09-04T03:38:35.758+00:00|INFO|HikariDataSource|main] HikariPool-1 - Starting...
[2022-09-04T03:38:36.305+00:00|INFO|HikariDataSource|main] HikariPool-1 - Start completed.
[2022-09-04T03:38:36.359+00:00|INFO|Dialect|main] HHH000400: Using dialect: org.hibernate.dialect.MariaDB103Dialect
[2022-09-04T03:38:39.866+00:00|INFO|JtaPlatformInitiator|main] HHH000490: Using JtaPlatform implementation: [org.hibernate.engine.transaction.jta.platform.internal.NoJtaPlatform]
[2022-09-04T03:38:39.894+00:00|INFO|LocalContainerEntityManagerFactoryBean|main] Initialized JPA EntityManagerFactory for persistence unit 'default'
[2022-09-04T03:38:44.615+00:00|WARN|SqlExceptionHelper|main] SQL Error: 1054, SQLState: 42S22
[2022-09-04T03:38:44.615+00:00|ERROR|SqlExceptionHelper|main] (conn=1662) Unknown column 'targets0_.toscaPolicyTypeName' in 'field list'
[2022-09-04T03:38:45.677+00:00|WARN|SqlExceptionHelper|main] SQL Error: 1054, SQLState: 42S22
[2022-09-04T03:38:45.677+00:00|ERROR|SqlExceptionHelper|main] (conn=1662) Unknown column 'targets0_.toscaPolicyTypeName' in 'field list'
[2022-09-04T03:38:45.701+00:00|WARN|AnnotationConfigServletWebServerApplicationContext|main] Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'apiDatabaseInitializer': Invocation of init method failed; nested exception is PfModelRuntimeException(errorResponse=ErrorResponse(responseCode=Internal Server Error, errorMessage=error copying concept key class: org.onap.policy.models.tosca.simple.concepts.JpaToscaPolicyType, errorDetails=[error copying concept key class: org.onap.policy.models.tosca.simple.concepts.JpaToscaPolicyType, null, could not extract ResultSet, (conn=1662) Unknown column 'targets0_.toscaPolicyTypeName' in 'field list', Unknown column 'targets0_.toscaPolicyTypeName' in 'field list', Unknown column 'targets0_.toscaPolicyTypeName' in 'field list'], warningDetails=null), object=null)
[2022-09-04T03:38:45.704+00:00|INFO|LocalContainerEntityManagerFactoryBean|main] Closing JPA EntityManagerFactory for persistence unit 'default'
[2022-09-04T03:38:45.710+00:00|INFO|HikariDataSource|main] HikariPool-1 - Shutdown initiated...
[2022-09-04T03:38:45.761+00:00|INFO|HikariDataSource|main] HikariPool-1 - Shutdown completed.
[2022-09-04T03:38:45.768+00:00|INFO|StandardService|main] Stopping service [Tomcat]
[2022-09-04T03:38:45.817+00:00|INFO|ConditionEvaluationReportLoggingListener|main]
Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
[2022-09-04T03:38:45.887+00:00|ERROR|SpringApplication|main] Application run failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'apiDatabaseInitializer': Invocation of init method failed; nested exception is PfModelRuntimeException(errorResponse=ErrorResponse(responseCode=Internal Server Error, errorMessage=error copying concept key class: org.onap.policy.models.tosca.simple.concepts.JpaToscaPolicyType, errorDetails=[error copying concept key class: org.onap.policy.models.tosca.simple.concepts.JpaToscaPolicyType, null, could not extract ResultSet, (conn=1662) Unknown column 'targets0_.toscaPolicyTypeName' in 'field list', Unknown column 'targets0_.toscaPolicyTypeName' in 'field list', Unknown column 'targets0_.toscaPolicyTypeName' in 'field list'], warningDetails=null), object=null)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:160)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:440)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1796)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:620)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542)
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:953)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:918)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583)
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:145)
at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:758)
at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:438)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:337)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1336)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1325)
at org.onap.policy.api.main.PolicyApiApplication.main(PolicyApiApplication.java:32)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.base/java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49)
at org.springframework.boot.loader.Launcher.launch(Launcher.java:108)
at org.springframework.boot.loader.Launcher.launch(Launcher.java:58)
at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:88)
Caused by: org.onap.policy.models.base.PfModelRuntimeException: error copying concept key class: org.onap.policy.models.tosca.simple.concepts.JpaToscaPolicyType
at org.onap.policy.models.base.PfUtils.makeCopy(PfUtils.java:187)
at org.onap.policy.models.base.PfConceptContainer.(PfConceptContainer.java:142)
at org.onap.policy.models.tosca.simple.concepts.JpaToscaPolicyTypes.(JpaToscaPolicyTypes.java:91)
at org.onap.policy.models.tosca.simple.concepts.JpaToscaServiceTemplate.(JpaToscaServiceTemplate.java:167)
at org.onap.policy.models.tosca.utils.ToscaServiceTemplateUtils.addFragment(ToscaServiceTemplateUtils.java:64)
at org.onap.policy.api.main.service.ToscaServiceTemplateService.createPolicyType(ToscaServiceTemplateService.java:126)
at org.onap.policy.api.main.service.ToscaServiceTemplateService$$FastClassBySpringCGLIB$$bd14ffe8.invoke()
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:779)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:64)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:64)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:692)
at org.onap.policy.api.main.service.ToscaServiceTemplateService$$EnhancerBySpringCGLIB$$e8b589dd.createPolicyType()
at org.onap.policy.api.main.startstop.ApiDatabaseInitializer.preloadServiceTemplate(ApiDatabaseInitializer.java:145)
at org.onap.policy.api.main.startstop.ApiDatabaseInitializer.initializeApiDatabase(ApiDatabaseInitializer.java:91)
at org.onap.policy.api.main.startstop.ApiDatabaseInitializer.loadData(ApiDatabaseInitializer.java:67)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.base/java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:389)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:333)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:157)
... 26 common frames omitted
Caused by: java.lang.reflect.InvocationTargetException: null
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.base/java.lang.reflect.Constructor.newInstance(Unknown Source)
at org.onap.policy.models.base.PfUtils.makeCopy(PfUtils.java:182)
... 62 common frames omitted
Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:67)
at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.getResultSet(AbstractLoadPlanBasedLoader.java:390)
at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeQueryStatement(AbstractLoadPlanBasedLoader.java:163)
at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:104)
at org.hibernate.loader.collection.plan.AbstractLoadPlanBasedCollectionInitializer.initialize(AbstractLoadPlanBasedCollectionInitializer.java:87)
at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:710)
at org.hibernate.event.internal.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:76)
at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:93)
at org.hibernate.internal.SessionImpl.initializeCollection(SessionImpl.java:2163)
at org.hibernate.collection.internal.AbstractPersistentCollection$4.doWork(AbstractPersistentCollection.java:589)
at org.hibernate.collection.internal.AbstractPersistentCollection.withTemporarySessionIfNeeded(AbstractPersistentCollection.java:264)
at org.hibernate.collection.internal.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:585)
at org.hibernate.collection.internal.AbstractPersistentCollection.read(AbstractPersistentCollection.java:149)
at org.hibernate.collection.internal.PersistentBag.iterator(PersistentBag.java:387)
at java.base/java.util.Spliterators$IteratorSpliterator.estimateSize(Unknown Source)
at java.base/java.util.Spliterator.getExactSizeIfKnown(Unknown Source)
at java.base/java.util.stream.AbstractPipeline.copyInto(Unknown Source)
at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(Unknown Source)
at java.base/java.util.stream.ReduceOps$ReduceOp.evaluateSequential(Unknown Source)
at java.base/java.util.stream.AbstractPipeline.evaluate(Unknown Source)
at java.base/java.util.stream.ReferencePipeline.collect(Unknown Source)
at org.onap.policy.models.base.PfUtils.mapList(PfUtils.java:117)
at org.onap.policy.models.base.PfUtils.mapList(PfUtils.java:129)
at org.onap.policy.models.tosca.simple.concepts.JpaToscaPolicyType.(JpaToscaPolicyType.java:92)
... 67 common frames omitted
Caused by: java.sql.SQLSyntaxErrorException: (conn=1662) Unknown column 'targets0_.toscaPolicyTypeName' in 'field list'
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:153)
at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:274)
at org.mariadb.jdbc.ClientSidePreparedStatement.executeInternal(ClientSidePreparedStatement.java:229)
at org.mariadb.jdbc.ClientSidePreparedStatement.execute(ClientSidePreparedStatement.java:149)
at org.mariadb.jdbc.ClientSidePreparedStatement.executeQuery(ClientSidePreparedStatement.java:163)
at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57)
... 90 common frames omitted
Caused by: org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException: Unknown column 'targets0_.toscaPolicyTypeName' in 'field list'
at org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException.of(MariaDbSqlException.java:34)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:194)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:177)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:321)
at org.mariadb.jdbc.ClientSidePreparedStatement.executeInternal(ClientSidePreparedStatement.java:220)
... 95 common frames omitted
Caused by: java.sql.SQLException: Unknown column 'targets0_.toscaPolicyTypeName' in 'field list'
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1683)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1545)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1508)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:318)
... 96 common frames omitted
Policy api config file: /opt/app/policy/api/etc/mounted/apiParameters.yaml
overriding logback.xml
. ____ _ __ _ _
/\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
\\/ ___)| |_)| | | | | || (_| | ) ) ) )
' |____| .__|_| |_|_| |_\__, | / / / /
=========|_|==============|___/=/_/_/_/
:: Spring Boot :: (v2.5.0)
[2022-09-04T03:38:25.916+00:00|INFO|PolicyApiApplication|main] Starting PolicyApiApplication using Java 11.0.11 on onap-policy-api-7f94f67944-k85gx with PID 7 (/app/api.jar started by policy in /opt/app/policy/api/bin)
[2022-09-04T03:38:25.923+00:00|INFO|PolicyApiApplication|main] No active profile set, falling back to default profiles: default
[2022-09-04T03:38:29.981+00:00|INFO|RepositoryConfigurationDelegate|main] Bootstrapping Spring Data JPA repositories in DEFAULT mode.
[2022-09-04T03:38:30.285+00:00|INFO|RepositoryConfigurationDelegate|main] Finished Spring Data repository scanning in 274 ms. Found 6 JPA repository interfaces.
[2022-09-04T03:38:32.983+00:00|INFO|TomcatWebServer|main] Tomcat initialized with port(s): 6969 (https)
[2022-09-04T03:38:33.004+00:00|INFO|Http11NioProtocol|main] Initializing ProtocolHandler ["https-jsse-nio-6969"]
[2022-09-04T03:38:33.005+00:00|INFO|StandardService|main] Starting service [Tomcat]
[2022-09-04T03:38:33.005+00:00|INFO|StandardEngine|main] Starting Servlet engine: [Apache Tomcat/9.0.62]
[2022-09-04T03:38:33.170+00:00|INFO|[/]|main] Initializing Spring embedded WebApplicationContext
[2022-09-04T03:38:33.171+00:00|INFO|ServletWebServerApplicationContext|main] Root WebApplicationContext: initialization completed in 7073 ms
[2022-09-04T03:38:34.973+00:00|INFO|LogHelper|main] HHH000204: Processing PersistenceUnitInfo [name: default]
[2022-09-04T03:38:35.130+00:00|INFO|Version|main] HHH000412: Hibernate ORM core version 5.4.31.Final
[2022-09-04T03:38:35.502+00:00|INFO|Version|main] HCANN000001: Hibernate Commons Annotations {5.1.2.Final}
[2022-09-04T03:38:35.758+00:00|INFO|HikariDataSource|main] HikariPool-1 - Starting...
[2022-09-04T03:38:36.305+00:00|INFO|HikariDataSource|main] HikariPool-1 - Start completed.
[2022-09-04T03:38:36.359+00:00|INFO|Dialect|main] HHH000400: Using dialect: org.hibernate.dialect.MariaDB103Dialect
[2022-09-04T03:38:39.866+00:00|INFO|JtaPlatformInitiator|main] HHH000490: Using JtaPlatform implementation: [org.hibernate.engine.transaction.jta.platform.internal.NoJtaPlatform]
[2022-09-04T03:38:39.894+00:00|INFO|LocalContainerEntityManagerFactoryBean|main] Initialized JPA EntityManagerFactory for persistence unit 'default'
[2022-09-04T03:38:44.615+00:00|WARN|SqlExceptionHelper|main] SQL Error: 1054, SQLState: 42S22
[2022-09-04T03:38:44.615+00:00|ERROR|SqlExceptionHelper|main] (conn=1662) Unknown column 'targets0_.toscaPolicyTypeName' in 'field list'
[2022-09-04T03:38:45.677+00:00|WARN|SqlExceptionHelper|main] SQL Error: 1054, SQLState: 42S22
[2022-09-04T03:38:45.677+00:00|ERROR|SqlExceptionHelper|main] (conn=1662) Unknown column 'targets0_.toscaPolicyTypeName' in 'field list'
[2022-09-04T03:38:45.701+00:00|WARN|AnnotationConfigServletWebServerApplicationContext|main] Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'apiDatabaseInitializer': Invocation of init method failed; nested exception is PfModelRuntimeException(errorResponse=ErrorResponse(responseCode=Internal Server Error, errorMessage=error copying concept key class: org.onap.policy.models.tosca.simple.concepts.JpaToscaPolicyType, errorDetails=[error copying concept key class: org.onap.policy.models.tosca.simple.concepts.JpaToscaPolicyType, null, could not extract ResultSet, (conn=1662) Unknown column 'targets0_.toscaPolicyTypeName' in 'field list', Unknown column 'targets0_.toscaPolicyTypeName' in 'field list', Unknown column 'targets0_.toscaPolicyTypeName' in 'field list'], warningDetails=null), object=null)
[2022-09-04T03:38:45.704+00:00|INFO|LocalContainerEntityManagerFactoryBean|main] Closing JPA EntityManagerFactory for persistence unit 'default'
[2022-09-04T03:38:45.710+00:00|INFO|HikariDataSource|main] HikariPool-1 - Shutdown initiated...
[2022-09-04T03:38:45.761+00:00|INFO|HikariDataSource|main] HikariPool-1 - Shutdown completed.
[2022-09-04T03:38:45.768+00:00|INFO|StandardService|main] Stopping service [Tomcat]
[2022-09-04T03:38:45.817+00:00|INFO|ConditionEvaluationReportLoggingListener|main]
Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
[2022-09-04T03:38:45.887+00:00|ERROR|SpringApplication|main] Application run failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'apiDatabaseInitializer': Invocation of init method failed; nested exception is PfModelRuntimeException(errorResponse=ErrorResponse(responseCode=Internal Server Error, errorMessage=error copying concept key class: org.onap.policy.models.tosca.simple.concepts.JpaToscaPolicyType, errorDetails=[error copying concept key class: org.onap.policy.models.tosca.simple.concepts.JpaToscaPolicyType, null, could not extract ResultSet, (conn=1662) Unknown column 'targets0_.toscaPolicyTypeName' in 'field list', Unknown column 'targets0_.toscaPolicyTypeName' in 'field list', Unknown column 'targets0_.toscaPolicyTypeName' in 'field list'], warningDetails=null), object=null)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:160)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:440)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1796)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:620)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542)
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:953)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:918)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583)
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:145)
at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:758)
at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:438)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:337)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1336)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1325)
at org.onap.policy.api.main.PolicyApiApplication.main(PolicyApiApplication.java:32)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.base/java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49)
at org.springframework.boot.loader.Launcher.launch(Launcher.java:108)
at org.springframework.boot.loader.Launcher.launch(Launcher.java:58)
at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:88)
Caused by: org.onap.policy.models.base.PfModelRuntimeException: error copying concept key class: org.onap.policy.models.tosca.simple.concepts.JpaToscaPolicyType
at org.onap.policy.models.base.PfUtils.makeCopy(PfUtils.java:187)
at org.onap.policy.models.base.PfConceptContainer.(PfConceptContainer.java:142)
at org.onap.policy.models.tosca.simple.concepts.JpaToscaPolicyTypes.(JpaToscaPolicyTypes.java:91)
at org.onap.policy.models.tosca.simple.concepts.JpaToscaServiceTemplate.(JpaToscaServiceTemplate.java:167)
at org.onap.policy.models.tosca.utils.ToscaServiceTemplateUtils.addFragment(ToscaServiceTemplateUtils.java:64)
at org.onap.policy.api.main.service.ToscaServiceTemplateService.createPolicyType(ToscaServiceTemplateService.java:126)
at org.onap.policy.api.main.service.ToscaServiceTemplateService$$FastClassBySpringCGLIB$$bd14ffe8.invoke()
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:779)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:64)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:64)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:692)
at org.onap.policy.api.main.service.ToscaServiceTemplateService$$EnhancerBySpringCGLIB$$e8b589dd.createPolicyType()
at org.onap.policy.api.main.startstop.ApiDatabaseInitializer.preloadServiceTemplate(ApiDatabaseInitializer.java:145)
at org.onap.policy.api.main.startstop.ApiDatabaseInitializer.initializeApiDatabase(ApiDatabaseInitializer.java:91)
at org.onap.policy.api.main.startstop.ApiDatabaseInitializer.loadData(ApiDatabaseInitializer.java:67)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.base/java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:389)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:333)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:157)
... 26 common frames omitted
Caused by: java.lang.reflect.InvocationTargetException: null
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.base/java.lang.reflect.Constructor.newInstance(Unknown Source)
at org.onap.policy.models.base.PfUtils.makeCopy(PfUtils.java:182)
... 62 common frames omitted
Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:67)
at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.getResultSet(AbstractLoadPlanBasedLoader.java:390)
at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeQueryStatement(AbstractLoadPlanBasedLoader.java:163)
at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:104)
at org.hibernate.loader.collection.plan.AbstractLoadPlanBasedCollectionInitializer.initialize(AbstractLoadPlanBasedCollectionInitializer.java:87)
at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:710)
at org.hibernate.event.internal.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:76)
at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:93)
at org.hibernate.internal.SessionImpl.initializeCollection(SessionImpl.java:2163)
at org.hibernate.collection.internal.AbstractPersistentCollection$4.doWork(AbstractPersistentCollection.java:589)
at org.hibernate.collection.internal.AbstractPersistentCollection.withTemporarySessionIfNeeded(AbstractPersistentCollection.java:264)
at org.hibernate.collection.internal.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:585)
at org.hibernate.collection.internal.AbstractPersistentCollection.read(AbstractPersistentCollection.java:149)
at org.hibernate.collection.internal.PersistentBag.iterator(PersistentBag.java:387)
at java.base/java.util.Spliterators$IteratorSpliterator.estimateSize(Unknown Source)
at java.base/java.util.Spliterator.getExactSizeIfKnown(Unknown Source)
at java.base/java.util.stream.AbstractPipeline.copyInto(Unknown Source)
at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(Unknown Source)
at java.base/java.util.stream.ReduceOps$ReduceOp.evaluateSequential(Unknown Source)
at java.base/java.util.stream.AbstractPipeline.evaluate(Unknown Source)
at java.base/java.util.stream.ReferencePipeline.collect(Unknown Source)
at org.onap.policy.models.base.PfUtils.mapList(PfUtils.java:117)
at org.onap.policy.models.base.PfUtils.mapList(PfUtils.java:129)
at org.onap.policy.models.tosca.simple.concepts.JpaToscaPolicyType.(JpaToscaPolicyType.java:92)
... 67 common frames omitted
Caused by: java.sql.SQLSyntaxErrorException: (conn=1662) Unknown column 'targets0_.toscaPolicyTypeName' in 'field list'
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:153)
at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:274)
at org.mariadb.jdbc.ClientSidePreparedStatement.executeInternal(ClientSidePreparedStatement.java:229)
at org.mariadb.jdbc.ClientSidePreparedStatement.execute(ClientSidePreparedStatement.java:149)
at org.mariadb.jdbc.ClientSidePreparedStatement.executeQuery(ClientSidePreparedStatement.java:163)
at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57)
... 90 common frames omitted
Caused by: org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException: Unknown column 'targets0_.toscaPolicyTypeName' in 'field list'
at org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException.of(MariaDbSqlException.java:34)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:194)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:177)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:321)
at org.mariadb.jdbc.ClientSidePreparedStatement.executeInternal(ClientSidePreparedStatement.java:220)
... 95 common frames omitted
Caused by: java.sql.SQLException: Unknown column 'targets0_.toscaPolicyTypeName' in 'field list'
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1683)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1545)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1508)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:318)
... 96 common frames omitted