Advertisement
Guest User

Untitled

a guest
Dec 12th, 2017
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. 2017-12-12 15:33:12,816 [TP-Processor2] [214007217ECB5316107F9DFAAF52D318] DEBUG com.epl.backoffice.security.PasswordExpirationInterceptor - INTERCEPT: StorageContainersEditAjaxAction
  2. 2017-12-12 15:33:12,816 [TP-Processor2] [214007217ECB5316107F9DFAAF52D318] DEBUG com.epl.service.PropertyService - Getting property 'TABLE_MAX_ROWS_PER_PAGE'
  3. 2017-12-12 15:33:12,816 [TP-Processor2] [214007217ECB5316107F9DFAAF52D318] DEBUG com.epl.service.PropertyService - Getting property 'MAX_EXPORT_TO_EXCEL'
  4. 2017-12-12 15:33:12,817 [TP-Processor2] [214007217ECB5316107F9DFAAF52D318] DEBUG com.opensymphony.xwork2.interceptor.ParametersInterceptor - Setting params NONE
  5. 2017-12-12 15:33:12,817 [TP-Processor2] [214007217ECB5316107F9DFAAF52D318] DEBUG com.opensymphony.xwork2.interceptor.ParametersInterceptor - Setting params altBarcode => [  ] altBoxId => [  ] containerTypeId => [ 121 ] forConfirmationDialog => [ true ] id => [ 204788 ] label => [  ] positionType => [ relative ] taskId => [ 17475 ] templateData => [ {"elements":[{"templateName":null,"materialType":null,"materialTypeId":null,"templateTypeId":null,"templateUsedCount":null,"level":null,"levelId":null,"dataType":null,"required":"Y","categoryName":null,"templateType":null,"targetTable":null,"value":"1","order":null,"source":null,"sourceId":null,"sourceAlias":null,"attributeValueId":null,"valueOrder":null,"valuesCount":null,"confirmed":null,"deleteValueFlag":null,"valueId":null,"metaIndexId":null,"workRequestId":null,"parent":null,"sectionNum":null,"sectionName":null,"sectionExpanded":null,"linkedItemId":null,"linkedItemDescription":null,"typeName":"Alphanumeric","defaultValue":null,"inactiveStyle":null,"displayInfo":null,"templateInstanceId":null,"multiValueParent":false,"fileColumnName":null,"fileColumnNum":0,"uploadId":null,"uploadEntityTypeId":null,"uploadMapColumnId":null,"templateAttributeDataTypeId":null,"templateAttributeDataTypeName":null,"templateAttributeDataTypeAlias":null,"templateAttributeAlias":"alphanumeric_335420033","id":6581,"name":"manufacturer","templateId":5769,"dataTypeId":null,"label":"manufacturer","categoryId":null,"templateSectionId":null,"sortOrder":null,"alias":null,"field":"56581","fieldSource":"source-56581"},{"templateName":null,"materialType":null,"materialTypeId":null,"templateTypeId":null,"templateUsedCount":null,"level":null,"levelId":null,"dataType":null,"required":"Y","categoryName":null,"templateType":null,"targetTable":null,"value":"A","order":null,"source":null,"sourceId":null,"sourceAlias":null,"attributeValueId":null,"valueOrder":null,"valuesCount":null,"confirmed":null,"deleteValueFlag":null,"valueId":null,"metaIndexId":null,"workRequestId":null,"parent":null,"sectionNum":null,"sectionName":null,"sectionExpanded":null,"linkedItemId":null,"linkedItemDescription":null,"typeName":"List","defaultValue":null,"inactiveStyle":null,"displayInfo":null,"templateInstanceId":null,"multiValueParent":false,"fileColumnName":null,"fileColumnNum":0,"uploadId":null,"uploadEntityTypeId":null,"uploadMapColumnId":null,"templateAttributeDataTypeId":null,"templateAttributeDataTypeName":null,"templateAttributeDataTypeAlias":null,"templateAttributeAlias":"list_519384351","id":6582,"name":"type","templateId":5769,"dataTypeId":null,"label":"type","categoryId":null,"templateSectionId":null,"sortOrder":null,"alias":null,"listValues":"A,B,C","field":"56582","fieldSource":"source-56582"},{"templateName":null,"materialType":null,"materialTypeId":null,"templateTypeId":null,"templateUsedCount":null,"level":null,"levelId":null,"dataType":null,"required":null,"categoryName":null,"templateType":null,"targetTable":null,"value":null,"order":null,"source":null,"sourceId":null,"sourceAlias":null,"attributeValueId":null,"valueOrder":null,"valuesCount":null,"confirmed":null,"deleteValueFlag":null,"valueId":null,"metaIndexId":null,"workRequestId":null,"parent":null,"sectionNum":null,"sectionName":null,"sectionExpanded":null,"linkedItemId":null,"linkedItemDescription":null,"typeName":"Numeric","defaultValue":null,"inactiveStyle":null,"displayInfo":null,"templateInstanceId":null,"multiValueParent":false,"fileColumnName":null,"fileColumnNum":0,"uploadId":null,"uploadEntityTypeId":null,"uploadMapColumnId":null,"templateAttributeDataTypeId":null,"templateAttributeDataTypeName":null,"templateAttributeDataTypeAlias":null,"templateAttributeAlias":"numeric_532010795","id":6583,"name":"serial number","templateId":5769,"dataTypeId":null,"label":"serial number","categoryId":null,"templateSectionId":null,"sortOrder":null,"alias":null,"doubleEntry":"Y","field":"56583","fieldSource":"source-56583"},{"templateName":null,"materialType":null,"materialTypeId":null,"templateTypeId":null,"templateUsedCount":null,"level":null,"levelId":null,"dataType":null,"required":null,"categoryName":null,"templateType":null,"targetTable":null,"value":null,"order":null,"source":null,"sourceId":null,"sourceAlias":null,"attributeValueId":null,"valueOrder":null,"valuesCount":null,"confirmed":null,"deleteValueFlag":null,"valueId":null,"metaIndexId":null,"workRequestId":null,"parent":null,"sectionNum":null,"sectionName":null,"sectionExpanded":null,"linkedItemId":null,"linkedItemDescription":null,"typeName":"Alphanumeric","defaultValue":null,"inactiveStyle":null,"displayInfo":null,"templateInstanceId":null,"multiValueParent":false,"fileColumnName":null,"fileColumnNum":0,"uploadId":null,"uploadEntityTypeId":null,"uploadMapColumnId":null,"templateAttributeDataTypeId":null,"templateAttributeDataTypeName":null,"templateAttributeDataTypeAlias":null,"templateAttributeAlias":"alphanumeric_1309961095","id":6584,"name":"color","templateId":5769,"dataTypeId":null,"label":"color","categoryId":null,"templateSectionId":null,"sortOrder":null,"alias":null,"mandatory":"Y","field":"56584","fieldSource":"source-56584"}],"name":"container test template 2","format":"{manufacturer}{type}","typeId":5,"id":5769,"text":"","activeFlag":"Y","confirmed":"Y"} ] volume => [ 0.25 ]
  6. 2017-12-12 15:33:12,842 [TP-Processor2] [214007217ECB5316107F9DFAAF52D318] DEBUG com.epl.backoffice.webapp.AjaxBaseAction - Action name: com.epl.backoffice.webapp.wr.edit.index.storage.StorageContainersEditAjaxAction
  7. 2017-12-12 15:33:12,843 [TP-Processor2] [214007217ECB5316107F9DFAAF52D318] DEBUG com.epl.service.PropertyService - Getting property 'BO_PRINT_SETUP_DEFAULT_OPTION'
  8. 2017-12-12 15:33:12,843 [TP-Processor2] [214007217ECB5316107F9DFAAF52D318] DEBUG com.epl.util.SecurityUtils - Validate user 9/ops1 has privilege BO_STORAGE_CONTAINERS_EDIT on account null
  9. 2017-12-12 15:33:12,843 [TP-Processor2] [214007217ECB5316107F9DFAAF52D318] DEBUG com.epl.util.SecurityUtils - User has privilege
  10. 2017-12-12 15:33:12,848 [TP-Processor2] [214007217ECB5316107F9DFAAF52D318] DEBUG com.epl.service.template.TemplateDataManager - Saving template data for entity: Template target: CONTAINER, target id: 204788
  11. 2017-12-12 15:33:12,848 [TP-Processor2] [214007217ECB5316107F9DFAAF52D318] DEBUG com.epl.service.template.TemplateDataManager - Validating entry data for saving template data
  12. 2017-12-12 15:33:12,850 [TP-Processor2] [214007217ECB5316107F9DFAAF52D318] DEBUG com.epl.service.template.TemplateDataManager - Saving template attributes
  13. 2017-12-12 15:33:12,858 [TP-Processor2] [214007217ECB5316107F9DFAAF52D318] ERROR com.epl.backoffice.webapp.AjaxBaseAction - doExecute exception
  14. org.springframework.dao.DuplicateKeyException:
  15. ### Error updating database.  Cause: java.sql.SQLException: Cannot insert duplicate key row in object 'dbo.TEMPLATE_INSTANCE_ATTR_VAL' with unique index 'IDX_TEMPLATE_INSTANCE_ATTR_VAL'. The duplicate key value is (61081, 6581, <NULL>).
  16. ### The error may exist in class path resource [com/epl/xml/TemplateInstanceAttrValMapper.xml]
  17. ### The error may involve com.epl.dao.TemplateInstanceAttrValMapper.insertSelective-Inline
  18. ### The error occurred while setting parameters
  19. ### SQL: insert into TEMPLATE_INSTANCE_ATTR_VAL      ( ID,                INSTANCE_ID,                       ATTRIBUTE_ID,                       VALUE )       values ( ?,                ?,                       ?,                       ? )
  20. ### Cause: java.sql.SQLException: Cannot insert duplicate key row in object 'dbo.TEMPLATE_INSTANCE_ATTR_VAL' with unique index 'IDX_TEMPLATE_INSTANCE_ATTR_VAL'. The duplicate key value is (61081, 6581, <NULL>).
  21. ; SQL []; Cannot insert duplicate key row in object 'dbo.TEMPLATE_INSTANCE_ATTR_VAL' with unique index 'IDX_TEMPLATE_INSTANCE_ATTR_VAL'. The duplicate key value is (61081, 6581, <NULL>).; nested exception is java.sql.SQLException: Cannot insert duplicate key row in object 'dbo.TEMPLATE_INSTANCE_ATTR_VAL' with unique index 'IDX_TEMPLATE_INSTANCE_ATTR_VAL''dbo.TEMPLATE_INSTANCE_ATTR_VAL' with unique index 'IDX_TEMPLATE_INSTANCE_ATTR_VAL'. The duplicate key value is (61081, 6581, <NULL>).
  22.         at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
  23.         at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988)
  24.         at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)
  25.         at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671)
  26.         at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:613)
  27.         at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:572)
  28.         at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedStatement.java:784)
  29.         at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
  30.         at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
  31.         at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:46)
  32.         at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)
  33.         at org.apache.ibatis.executor.ReuseExecutor.doUpdate(ReuseExecutor.java:52)
  34.         at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
  35.         at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
  36.         at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:198)
  37.         at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:185)
  38.         at sun.reflect.GeneratedMethodAccessor40667.invoke(Unknown Source)
  39.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  40.         at java.lang.reflect.Method.invoke(Method.java:498)
  41.         at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)
  42.         ... 144 more
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement