This was originally included in[ SO-82|https://jira.onap.org/projects/SO/issues/SO-82] as a comment but that says its delivered but I still see this issue.

The issue seems to be that the beans in /mso-catalog-db/src/main/java/org/openecomp/mso/db/catalog/beans have not been updated to match the definition of the schema. 

There seemed to be to issues 

1) most of the tables in /docker-entrypoint-initdb.d/db-sql-scripts/main-schemas/MySQL-Catalog-schema.sql

have the definition

CREATION_TIMESTAMP datetime not null

and the bean mapping has the construct 

<property name="created" type="timestamp" generated="insert" update="false" insert="false" >

but this construct is not setting the value 

a quick but not exhaustive google (always dangerous) search found me

http://docs.jboss.org/hibernate/core/3.6/reference/en-US/html_single/#mapping-generated 

which makes some odd statement about timestamp (this could be irrelavent)

2) there seems to be a problem with VnfResCustomToVfModuleCustom

the schema has 3 parameters but the bean and hibernate mapping only has two.

The 3th filed is used in the constraints in the schema so is needed

All this data should be filled in in the asdc-controller/src/main/java/org/openecomp/mso/asdc/installer/heat/ToscaResourceInstaller.java

The exceptions I see are 

08:46:46,517 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (pool-14-thread-7) SQL Error: 1364, SQLState: HY000
08:46:46,517 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (pool-14-thread-7) Field 'CREATION_TIMESTAMP' doesn't have a default value
Query is: insert into TOSCA_CSAR (NAME, VERSION, ARTIFACT_CHECKSUM, URL, DESCRIPTION, ARTIFACT_UUID) values (?, ?, ?, ?, ?, ?), parameters ['service-Vafrmicroservice-csar.csar','1','YTVhOTAwMDY4OGI0YjRkNDFmMWVmMzQ2ZTRkNmE2NzI=','/sdc/v1/catalog/services/Vafrmicroservice/1.0/artifacts/service-Vafrmicroservice-csar.csar','TOSCA definition package of the asset','921cd4e4-b5a3-454a-8312-d514d7c429b5']

2017-10-04T08:54:45.217Z|93cba094-9555-43af-adc7-749993215b9f|pool-32-thread-1|NotificationHandler||||ERROR|DataError|Exception caught during installation of AFRMICROVSP. Transaction rollback|MSO-ASDC-9300E Exception: org.hibernate.exception.GenericJDBCException: could not execute statement - at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54) - at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126) - at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112) - at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:211) - at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:62) - at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3124) - at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3581) - at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:104) - at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:463) - at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:349) - at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:350) - at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:56) - at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1222) - at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:425) - at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.beforeTransactionCommit(JdbcTransaction.java:101) - at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(AbstractTransactionImpl.java:177) - at org.openecomp.mso.db.catalog.CatalogDatabase.commit(CatalogDatabase.java:140) - at org.openecomp.mso.asdc.installer.heat.ToscaResourceInstaller.installTheResource(ToscaResourceInstaller.java:553) - at org.openecomp.mso.asdc.client.ASDCController.deployResourceStructure(ASDCController.java:451) - at org.openecomp.mso.asdc.client.ASDCController.processResourceNotification(ASDCController.java:611) - at org.openecomp.mso.asdc.client.ASDCController.treatNotification(ASDCController.java:568) - at org.openecomp.mso.asdc.client.ASDCController$ASDCNotificationCallBack.activateCallback(ASDCController.java:95) - at org.openecomp.sdc.impl.NotificationConsumer.run(NotificationConsumer.java:71) - at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) - at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) - at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) - at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) - at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) - at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) - at java.lang.Thread.run(Thread.java:748) - Caused by: java.sql.SQLException: Field 'CREATION_TIMESTAMP' doesn't have a default value - Query is: insert into TOSCA_CSAR (NAME, VERSION, ARTIFACT_CHECKSUM, URL, DESCRIPTION, ARTIFACT_UUID) values (?, ?, ?, ?, ?, ?), parameters ['service-Vafrmicroservice-csar.csar','1','YTVhOTAwMDY4OGI0YjRkNDFmMWVmMzQ2ZTRkNmE2NzI=','/sdc/v1/catalog/services/Vafrmicroservice/1.0/artifacts/service-Vafrmicroservice-csar.csar','TOSCA definition package of the asset','921cd4e4-b5a3-454a-8312-d514d7c429b5'] - at org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:138) - at org.mariadb.jdbc.internal.util.ExceptionMapper.throwException(ExceptionMapper.java:71) - at org.mariadb.jdbc.MariaDbStatement.executeQueryEpilog(MariaDbStatement.java:226) - at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeInternal(MariaDbServerPreparedStatement.java:411) - at org.mariadb.jdbc.MariaDbServerPreparedStatement.execute(MariaDbServerPreparedStatement.java:359) - at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeUpdate(MariaDbServerPreparedStatement.java:348) - at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:537) - at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:208) - ... 26 more - Caused by: org.mariadb.jdbc.internal.util.dao.QueryException: Field 'CREATION_TIMESTAMP' doesn't have a default value - Query is: insert into TOSCA_CSAR (NAME, VERSION, ARTIFACT_CHECKSUM, URL, DESCRIPTION, ARTIFACT_UUID) values (?, ?, ?, ?, ?, ?), parameters ['service-Vafrmicroservice-csar.csar','1','YTVhOTAwMDY4OGI0YjRkNDFmMWVmMzQ2ZTRkNmE2NzI=','/sdc/v1/catalog/services/Vafrmicroservice/1.0/artifacts/service-Vafrmicroservice-csar.csar','TOSCA definition package of the asset','921cd4e4-b5a3-454a-8312-d514d7c429b5'] - at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1112) - at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executePreparedQuery(AbstractQueryProtocol.java:601) - at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeInternal(MariaDbServerPreparedStatement.java:398) - ... 30 more -
2017-10-04T08:54:48.228Z|93cba094-9555-43af-adc7-749993215b9f|pool-32-thread-1|NotificationHandler||ASDC|processResourceNotification|ERROR|BusinessProcesssError|Exception in processResourceNotification|MSO-ASDC-9300E Exception: Exception caught during Installation of artifact
2017-10-04T08:54:48.229Z|93cba094-9555-43af-adc7-749993215b9f|pool-32-thread-1|NotificationHandler||ASDC|processResourceNotification|ERROR|BusinessProcesssError|Exception in processResourceNotification|MSO-ASDC-9300E Exception: org.openecomp.mso.asdc.client.exceptions.ArtifactInstallerException: Exception caught during installation of AFRMICROVSP. Transaction rollback. - at org.openecomp.mso.asdc.installer.heat.ToscaResourceInstaller.installTheResource(ToscaResourceInstaller.java:573) - at org.openecomp.mso.asdc.client.ASDCController.deployResourceStructure(ASDCController.java:451) - at org.openecomp.mso.asdc.client.ASDCController.processResourceNotification(ASDCController.java:611) - at org.openecomp.mso.asdc.client.ASDCController.treatNotification(ASDCController.java:568) - at org.openecomp.mso.asdc.client.ASDCController$ASDCNotificationCallBack.activateCallback(ASDCController.java:95) - at org.openecomp.sdc.impl.NotificationConsumer.run(NotificationConsumer.java:71) - at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) - at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) - at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) - at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) - at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) - at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) - at java.lang.Thread.run(Thread.java:748) - Caused by: org.hibernate.exception.GenericJDBCException: could not execute statement - at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54) - at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126) - at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112) - at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:211) - at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:62) - at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3124) - at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3581) - at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:104) - at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:463) - at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:349) - at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:350) - at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:56) - at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1222) - at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:425) - at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.beforeTransactionCommit(JdbcTransaction.java:101) - at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(AbstractTransactionImpl.java:177) - at org.openecomp.mso.db.catalog.CatalogDatabase.commit(CatalogDatabase.java:140) - at org.openecomp.mso.asdc.installer.heat.ToscaResourceInstaller.installTheResource(ToscaResourceInstaller.java:553) - ... 12 more - Caused by: java.sql.SQLException: Field 'CREATION_TIMESTAMP' doesn't have a default value - Query is: insert into TOSCA_CSAR (NAME, VERSION, ARTIFACT_CHECKSUM, URL, DESCRIPTION, ARTIFACT_UUID) values (?, ?, ?, ?, ?, ?), parameters ['service-Vafrmicroservice-csar.csar','1','YTVhOTAwMDY4OGI0YjRkNDFmMWVmMzQ2ZTRkNmE2NzI=','/sdc/v1/catalog/services/Vafrmicroservice/1.0/artifacts/service-Vafrmicroservice-csar.csar','TOSCA definition package of the asset','921cd4e4-b5a3-454a-8312-d514d7c429b5'] - at org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:138) - at org.mariadb.jdbc.internal.util.ExceptionMapper.throwException(ExceptionMapper.java:71) - at org.mariadb.jdbc.MariaDbStatement.executeQueryEpilog(MariaDbStatement.java:226) - at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeInternal(MariaDbServerPreparedStatement.java:411) - at org.mariadb.jdbc.MariaDbServerPreparedStatement.execute(MariaDbServerPreparedStatement.java:359) - at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeUpdate(MariaDbServerPreparedStatement.java:348) - at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:537) - at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:208) - ... 26 more - Caused by: org.mariadb.jdbc.internal.util.dao.QueryException: Field 'CREATION_TIMESTAMP' doesn't have a default value - Query is: insert into TOSCA_CSAR (NAME, VERSION, ARTIFACT_CHECKSUM, URL, DESCRIPTION, ARTIFACT_UUID) values (?, ?, ?, ?, ?, ?), parameters ['service-Vafrmicroservice-csar.csar','1','YTVhOTAwMDY4OGI0YjRkNDFmMWVmMzQ2ZTRkNmE2NzI=','/sdc/v1/catalog/services/Vafrmicroservice/1.0/artifacts/service-Vafrmicroservice-csar.csar','TOSCA definition package of the asset','921cd4e4-b5a3-454a-8312-d514d7c429b5'] - at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1112) - at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executePreparedQuery(AbstractQueryProtocol.java:601) - at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeInternal(MariaDbServerPreparedStatement.java:398) - ... 30 more -