Details
Description
Igor there are some errors in logs when importing new demo data. Could you please have a look?
Uploading file import-EN,RU.zip to server
File import-EN,RU.zip uploaded to server successfully
Import in progress
Job with token [f08af35b-2fa0-4ab0-beaa-14899db0c97b] started
f08af35b-2fa0-4ab0-beaa-14899db0c97b
row : CsvImportTupleImpl
descriptor /development/projects/java/yc/manager/server/target/yes-manager/WEB-INF/import-descriptor/productsattributes-demo.xml
error could not execute statement
org.hibernate.exception.ConstraintViolationException: could not execute statement
at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:74)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:136)
at org.hibernate.engine.query.spi.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:204)
at org.hibernate.internal.SessionImpl.executeNativeUpdate(SessionImpl.java:1312)
at org.hibernate.internal.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:401)
at org.yes.cart.dao.impl.GenericDAOHibernateImpl.executeNativeUpdate(GenericDAOHibernateImpl.java:772)
at org.yes.cart.bulkimport.csv.impl.CsvBulkImportServiceImpl.executeNativeInsert(CsvBulkImportServiceImpl.java:301)
at org.yes.cart.bulkimport.csv.impl.CsvBulkImportServiceImpl.doImport(CsvBulkImportServiceImpl.java:261)
at org.yes.cart.bulkimport.csv.impl.CsvBulkImportServiceImpl.doImport(CsvBulkImportServiceImpl.java:204)
at org.yes.cart.bulkimport.csv.impl.CsvBulkImportServiceImpl.doImport(CsvBulkImportServiceImpl.java:166)
at org.yes.cart.bulkimport.csv.impl.CsvBulkImportServiceImpl.doImport(CsvBulkImportServiceImpl.java:135)
at sun.reflect.GeneratedMethodAccessor545.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at com.sun.proxy.$Proxy128.doImport(Unknown Source)
at org.yes.cart.bulkimport.service.impl.ImportDirectorImplService.doDataImport(ImportDirectorImplService.java:235)
at org.yes.cart.bulkimport.service.impl.ImportDirectorImplService.doImportInternal(ImportDirectorImplService.java:125)
at org.yes.cart.bulkimport.service.impl.ImportDirectorImplService$2.run(ImportDirectorImplService.java:193)
at org.yes.cart.service.async.SingletonJobRunner$1.run(SingletonJobRunner.java:82)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at java.lang.Thread.run(Thread.java:695)
Caused by: java.sql.SQLIntegrityConstraintViolationException: Column 'PRODUCT_ID' cannot accept a NULL value.
at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.executeUpdate(Unknown Source)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:133)
... 28 more
Caused by: org.apache.derby.client.am.SqlException: Column 'PRODUCT_ID' cannot accept a NULL value.
at org.apache.derby.client.am.Statement.completeExecute(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parseEXCSQLSTTreply(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.readExecute(Unknown Source)
at org.apache.derby.client.net.StatementReply.readExecute(Unknown Source)
at org.apache.derby.client.net.NetPreparedStatement.readExecute_(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.readExecute(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.flowExecute(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.executeUpdateX(Unknown Source)
... 31 more
additional info could not execute statement
object is null
master object is null
ERROR: during import row : CsvImportTupleImpl
descriptor /development/projects/java/yc/manager/server/target/yes-manager/WEB-INF/import-descriptor/productsattributes-demo.xml
error could not execute statement
org.hibernate.exception.ConstraintViolationException: could not execute statement
at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:74)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:136)
at org.hibernate.engine.query.spi.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:204)
at org.hibernate.internal.SessionImpl.executeNativeUpdate(SessionImpl.java:1312)
at org.hibernate.internal.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:401)
at org.yes.cart.dao.impl.GenericDAOHibernateImpl.executeNativeUpdate(GenericDAOHibernateImpl.java:772)
at org.yes.cart.bulkimport.csv.impl.CsvBulkImportServiceImpl.executeNativeInsert(CsvBulkImportServiceImpl.java:301)
at org.yes.cart.bulkimport.csv.impl.CsvBulkImportServiceImpl.doImport(CsvBulkImportServiceImpl.java:261)
at org.yes.cart.bulkimport.csv.impl.CsvBulkImportServiceImpl.doImport(CsvBulkImportServiceImpl.java:204)
at org.yes.cart.bulkimport.csv.impl.CsvBulkImportServiceImpl.doImport(CsvBulkImportServiceImpl.java:166)
at org.yes.cart.bulkimport.csv.impl.CsvBulkImportServiceImpl.doImport(CsvBulkImportServiceImpl.java:135)
at sun.reflect.GeneratedMethodAccessor545.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at com.sun.proxy.$Proxy128.doImport(Unknown Source)
at org.yes.cart.bulkimport.service.impl.ImportDirectorImplService.doDataImport(ImportDirectorImplService.java:235)
at org.yes.cart.bulkimport.service.impl.ImportDirectorImplService.doImportInternal(ImportDirectorImplService.java:125)
at org.yes.cart.bulkimport.service.impl.ImportDirectorImplService$2.run(ImportDirectorImplService.java:193)
at org.yes.cart.service.async.SingletonJobRunner$1.run(SingletonJobRunner.java:82)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at java.lang.Thread.run(Thread.java:695)
Caused by: java.sql.SQLIntegrityConstraintViolationException: Column 'PRODUCT_ID' cannot accept a NULL value.
at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.executeUpdate(Unknown Source)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:133)
... 28 more
Caused by: org.apache.derby.client.am.SqlException: Column 'PRODUCT_ID' cannot accept a NULL value.
at org.apache.derby.client.am.Statement.completeExecute(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parseEXCSQLSTTreply(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.readExecute(Unknown Source)
at org.apache.derby.client.net.StatementReply.readExecute(Unknown Source)
at org.apache.derby.client.net.NetPreparedStatement.readExecute_(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.readExecute(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.flowExecute(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.executeUpdateX(Unknown Source)
... 31 more
additional info could not execute statement
object is null
master object is null
> Importing tuple: productsattributes.csv:12226