Uploaded image for project: 'YesCart'
  1. YesCart
  2. YC-343

Errors during ice cat import

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.0.0
    • Fix Version/s: 2.0.0
    • Component/s: impex
    • Labels:
      None

      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

      {sid=productsattributes.csv:7981, line=[17411836,PT235E-03X04CFR,Z930-14T,2183,Y,Yes,Да,]}


      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

      {sid=productsattributes.csv:7982, line=[17411836,PT235E-03X04CFR,Z930-14T,902,100 - 240,100 - 240 V,100 - 240 В,]}


      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

        Attachments

          Activity

            People

            • Assignee:
              azarny Igor Azarny
              Reporter:
              denis Denis Pavlov
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: