[jira] [Commented] (OFBIZ-9439) Lucene tests fail due to problems in the test data
Locked
[jira] [Commented] (OFBIZ-9439) Lucene tests fail due to problems in the test data
 
|
[ https://issues.apache.org/jira/browse/OFBIZ-9439?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16069705#comment-16069705 ] Jacques Le Roux commented on OFBIZ-9439: ---------------------------------------- I Michael, I think we will cross this type of issue again and again, I mean not only with the lucene component (which was initially part of the content application cf. r1518925). So I wonder if we should not create a commonplugins component where we would put all cases which end with duplicated data, model, etc. This component would be always pulled if at least one of the OOTB plugins would be pulled and automatically loaded before other plugins, like datamodel in application, here also for common data. Is that worth a discussion? > Lucene tests fail due to problems in the test data > -------------------------------------------------- > > Key: OFBIZ-9439 > URL: https://issues.apache.org/jira/browse/OFBIZ-9439 > Project: OFBiz > Issue Type: Sub-task > Components: lucene > Affects Versions: Trunk > Reporter: Michael Brohl > Assignee: Michael Brohl > Fix For: Upcoming Release > > > While working on OFBIZ-9391 the tests fail with the following errors: > {code:java} > 2017-06-29 18:58:29,700 |main |EntitySaxReader |I| Beginning import from URL: file:/Users/mbrohl/Projects/apache-ofbiz/trunk/ofbiz/plugins/lucene/testdef/data/LuceneTestsData.xml > 2017-06-29 18:58:29,701 |main |EntitySaxReader |I| Transaction Timeout set to 2 hours (7200 seconds) > 2017-06-29 18:58:29,739 |main |GenericDelegator |E| Failure in create operation for entity [Content]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:Content][contentId,CNTGIZMOSLRG(java.lang.String)][contentName,Large Gizmos(java.lang.String)][contentTypeId,WEB_SITE_PUB_PT(java.lang.String)][createdByUserLogin,admin(java.lang.String)][createdDate,2001-05-13 12:00:00.0(java.sql.Timestamp)][createdStamp,2017-06-29 18:58:29.729(java.sql.Timestamp)][createdTxStamp,2017-06-29 18:58:29.701(java.sql.Timestamp)][dataResourceId,CNTGIZMOSLRG(java.lang.String)][description,Large Widgets(java.lang.String)][lastUpdatedStamp,2017-06-29 18:58:29.729(java.sql.Timestamp)][lastUpdatedTxStamp,2017-06-29 18:58:29.701(java.sql.Timestamp)][localeString,en_US(java.lang.String)][mimeTypeId,text/html(java.lang.String)][ownerContentId,CNTGIZMOS(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.CONTENT (CONTENT_ID, CONTENT_TYPE_ID, OWNER_CONTENT_ID, DECORATOR_CONTENT_ID, INSTANCE_OF_CONTENT_ID, DATA_RESOURCE_ID, TEMPLATE_DATA_RESOURCE_ID, DATA_SOURCE_ID, STATUS_ID, PRIVILEGE_ENUM_ID, SERVICE_NAME, CUSTOM_METHOD_ID, CONTENT_NAME, DESCRIPTION, LOCALE_STRING, MIME_TYPE_ID, CHARACTER_SET_ID, CHILD_LEAF_COUNT, CHILD_BRANCH_COUNT, CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'CONTENT' caused a violation of foreign key constraint 'CONTENT_PCNTNT' for key (CNTGIZMOS). The statement has been rolled back.)). Rolling back transaction. > 2017-06-29 18:58:29,739 |main |TransactionUtil |W| Calling transaction setRollbackOnly; this stack trace shows where this is happening: > java.lang.Exception: Failure in create operation for entity [Content]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:Content][contentId,CNTGIZMOSLRG(java.lang.String)][contentName,Large Gizmos(java.lang.String)][contentTypeId,WEB_SITE_PUB_PT(java.lang.String)][createdByUserLogin,admin(java.lang.String)][createdDate,2001-05-13 12:00:00.0(java.sql.Timestamp)][createdStamp,2017-06-29 18:58:29.729(java.sql.Timestamp)][createdTxStamp,2017-06-29 18:58:29.701(java.sql.Timestamp)][dataResourceId,CNTGIZMOSLRG(java.lang.String)][description,Large Widgets(java.lang.String)][lastUpdatedStamp,2017-06-29 18:58:29.729(java.sql.Timestamp)][lastUpdatedTxStamp,2017-06-29 18:58:29.701(java.sql.Timestamp)][localeString,en_US(java.lang.String)][mimeTypeId,text/html(java.lang.String)][ownerContentId,CNTGIZMOS(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.CONTENT (CONTENT_ID, CONTENT_TYPE_ID, OWNER_CONTENT_ID, DECORATOR_CONTENT_ID, INSTANCE_OF_CONTENT_ID, DATA_RESOURCE_ID, TEMPLATE_DATA_RESOURCE_ID, DATA_SOURCE_ID, STATUS_ID, PRIVILEGE_ENUM_ID, SERVICE_NAME, CUSTOM_METHOD_ID, CONTENT_NAME, DESCRIPTION, LOCALE_STRING, MIME_TYPE_ID, CHARACTER_SET_ID, CHILD_LEAF_COUNT, CHILD_BRANCH_COUNT, CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'CONTENT' caused a violation of foreign key constraint 'CONTENT_PCNTNT' for key (CNTGIZMOS). The statement has been rolled back.)). Rolling back transaction. > at org.apache.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:361) [ofbiz.jar:?] > at org.apache.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:302) [ofbiz.jar:?] > at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:905) [ofbiz.jar:?] > at org.apache.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1316) [ofbiz.jar:?] > at org.apache.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:258) [ofbiz.jar:?] > at org.apache.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:228) [ofbiz.jar:?] > at org.apache.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:199) [ofbiz.jar:?] > at org.apache.ofbiz.testtools.EntityXmlAssertTest.countTestCases(EntityXmlAssertTest.java:61) [ofbiz.jar:?] > at junit.framework.TestResult.startTest(TestResult.java:150) [junit-dep-4.10.jar:?] > at org.apache.ofbiz.testtools.EntityXmlAssertTest.run(EntityXmlAssertTest.java:70) [ofbiz.jar:?] > at junit.framework.TestSuite.runTest(TestSuite.java:243) [junit-dep-4.10.jar:?] > at junit.framework.TestSuite.run(TestSuite.java:238) [junit-dep-4.10.jar:?] > at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:152) [ofbiz.jar:?] > at org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:148) [ofbiz.jar:?] > at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:73) [ofbiz.jar:?] > at org.apache.ofbiz.base.start.StartupControlPanel.loadStartupLoaders(StartupControlPanel.java:222) [ofbiz.jar:?] > at org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:72) [ofbiz.jar:?] > at org.apache.ofbiz.base.start.Start.main(Start.java:84) [ofbiz.jar:?] > 2017-06-29 18:58:29,740 |main |GenericDelegator |E| Failure in storeAll operation: org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:Content][contentId,CNTGIZMOSLRG(java.lang.String)][contentName,Large Gizmos(java.lang.String)][contentTypeId,WEB_SITE_PUB_PT(java.lang.String)][createdByUserLogin,admin(java.lang.String)][createdDate,2001-05-13 12:00:00.0(java.sql.Timestamp)][createdStamp,2017-06-29 18:58:29.729(java.sql.Timestamp)][createdTxStamp,2017-06-29 18:58:29.701(java.sql.Timestamp)][dataResourceId,CNTGIZMOSLRG(java.lang.String)][description,Large Widgets(java.lang.String)][lastUpdatedStamp,2017-06-29 18:58:29.729(java.sql.Timestamp)][lastUpdatedTxStamp,2017-06-29 18:58:29.701(java.sql.Timestamp)][localeString,en_US(java.lang.String)][mimeTypeId,text/html(java.lang.String)][ownerContentId,CNTGIZMOS(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.CONTENT (CONTENT_ID, CONTENT_TYPE_ID, OWNER_CONTENT_ID, DECORATOR_CONTENT_ID, INSTANCE_OF_CONTENT_ID, DATA_RESOURCE_ID, TEMPLATE_DATA_RESOURCE_ID, DATA_SOURCE_ID, STATUS_ID, PRIVILEGE_ENUM_ID, SERVICE_NAME, CUSTOM_METHOD_ID, CONTENT_NAME, DESCRIPTION, LOCALE_STRING, MIME_TYPE_ID, CHARACTER_SET_ID, CHILD_LEAF_COUNT, CHILD_BRANCH_COUNT, CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'CONTENT' caused a violation of foreign key constraint 'CONTENT_PCNTNT' for key (CNTGIZMOS). The statement has been rolled back.)) (Error while inserting: [GenericEntity:Content][contentId,CNTGIZMOSLRG(java.lang.String)][contentName,Large Gizmos(java.lang.String)][contentTypeId,WEB_SITE_PUB_PT(java.lang.String)][createdByUserLogin,admin(java.lang.String)][createdDate,2001-05-13 12:00:00.0(java.sql.Timestamp)][createdStamp,2017-06-29 18:58:29.729(java.sql.Timestamp)][createdTxStamp,2017-06-29 18:58:29.701(java.sql.Timestamp)][dataResourceId,CNTGIZMOSLRG(java.lang.String)][description,Large Widgets(java.lang.String)][lastUpdatedStamp,2017-06-29 18:58:29.729(java.sql.Timestamp)][lastUpdatedTxStamp,2017-06-29 18:58:29.701(java.sql.Timestamp)][localeString,en_US(java.lang.String)][mimeTypeId,text/html(java.lang.String)][ownerContentId,CNTGIZMOS(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.CONTENT (CONTENT_ID, CONTENT_TYPE_ID, OWNER_CONTENT_ID, DECORATOR_CONTENT_ID, INSTANCE_OF_CONTENT_ID, DATA_RESOURCE_ID, TEMPLATE_DATA_RESOURCE_ID, DATA_SOURCE_ID, STATUS_ID, PRIVILEGE_ENUM_ID, SERVICE_NAME, CUSTOM_METHOD_ID, CONTENT_NAME, DESCRIPTION, LOCALE_STRING, MIME_TYPE_ID, CHARACTER_SET_ID, CHILD_LEAF_COUNT, CHILD_BRANCH_COUNT, CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'CONTENT' caused a violation of foreign key constraint 'CONTENT_PCNTNT' for key (CNTGIZMOS). The statement has been rolled back.))). Rolling back transaction. > org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:Content][contentId,CNTGIZMOSLRG(java.lang.String)][contentName,Large Gizmos(java.lang.String)][contentTypeId,WEB_SITE_PUB_PT(java.lang.String)][createdByUserLogin,admin(java.lang.String)][createdDate,2001-05-13 12:00:00.0(java.sql.Timestamp)][createdStamp,2017-06-29 18:58:29.729(java.sql.Timestamp)][createdTxStamp,2017-06-29 18:58:29.701(java.sql.Timestamp)][dataResourceId,CNTGIZMOSLRG(java.lang.String)][description,Large Widgets(java.lang.String)][lastUpdatedStamp,2017-06-29 18:58:29.729(java.sql.Timestamp)][lastUpdatedTxStamp,2017-06-29 18:58:29.701(java.sql.Timestamp)][localeString,en_US(java.lang.String)][mimeTypeId,text/html(java.lang.String)][ownerContentId,CNTGIZMOS(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.CONTENT (CONTENT_ID, CONTENT_TYPE_ID, OWNER_CONTENT_ID, DECORATOR_CONTENT_ID, INSTANCE_OF_CONTENT_ID, DATA_RESOURCE_ID, TEMPLATE_DATA_RESOURCE_ID, DATA_SOURCE_ID, STATUS_ID, PRIVILEGE_ENUM_ID, SERVICE_NAME, CUSTOM_METHOD_ID, CONTENT_NAME, DESCRIPTION, LOCALE_STRING, MIME_TYPE_ID, CHARACTER_SET_ID, CHILD_LEAF_COUNT, CHILD_BRANCH_COUNT, CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'CONTENT' caused a violation of foreign key constraint 'CONTENT_PCNTNT' for key (CNTGIZMOS). The statement has been rolled back.)) (Error while inserting: [GenericEntity:Content][contentId,CNTGIZMOSLRG(java.lang.String)][contentName,Large Gizmos(java.lang.String)][contentTypeId,WEB_SITE_PUB_PT(java.lang.String)][createdByUserLogin,admin(java.lang.String)][createdDate,2001-05-13 12:00:00.0(java.sql.Timestamp)][createdStamp,2017-06-29 18:58:29.729(java.sql.Timestamp)][createdTxStamp,2017-06-29 18:58:29.701(java.sql.Timestamp)][dataResourceId,CNTGIZMOSLRG(java.lang.String)][description,Large Widgets(java.lang.String)][lastUpdatedStamp,2017-06-29 18:58:29.729(java.sql.Timestamp)][lastUpdatedTxStamp,2017-06-29 18:58:29.701(java.sql.Timestamp)][localeString,en_US(java.lang.String)][mimeTypeId,text/html(java.lang.String)][ownerContentId,CNTGIZMOS(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.CONTENT (CONTENT_ID, CONTENT_TYPE_ID, OWNER_CONTENT_ID, DECORATOR_CONTENT_ID, INSTANCE_OF_CONTENT_ID, DATA_RESOURCE_ID, TEMPLATE_DATA_RESOURCE_ID, DATA_SOURCE_ID, STATUS_ID, PRIVILEGE_ENUM_ID, SERVICE_NAME, CUSTOM_METHOD_ID, CONTENT_NAME, DESCRIPTION, LOCALE_STRING, MIME_TYPE_ID, CHARACTER_SET_ID, CHILD_LEAF_COUNT, CHILD_BRANCH_COUNT, CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'CONTENT' caused a violation of foreign key constraint 'CONTENT_PCNTNT' for key (CNTGIZMOS). The statement has been rolled back.))) > at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:906) ~[ofbiz.jar:?] > at org.apache.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1316) [ofbiz.jar:?] > at org.apache.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:258) [ofbiz.jar:?] > at org.apache.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:228) [ofbiz.jar:?] > at org.apache.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:199) [ofbiz.jar:?] > at org.apache.ofbiz.testtools.EntityXmlAssertTest.countTestCases(EntityXmlAssertTest.java:61) [ofbiz.jar:?] > at junit.framework.TestResult.startTest(TestResult.java:150) [junit-dep-4.10.jar:?] > at org.apache.ofbiz.testtools.EntityXmlAssertTest.run(EntityXmlAssertTest.java:70) [ofbiz.jar:?] > at junit.framework.TestSuite.runTest(TestSuite.java:243) [junit-dep-4.10.jar:?] > at junit.framework.TestSuite.run(TestSuite.java:238) [junit-dep-4.10.jar:?] > at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:152) [ofbiz.jar:?] > at org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:148) [ofbiz.jar:?] > at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:73) [ofbiz.jar:?] > at org.apache.ofbiz.base.start.StartupControlPanel.loadStartupLoaders(StartupControlPanel.java:222) [ofbiz.jar:?] > at org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:72) [ofbiz.jar:?] > at org.apache.ofbiz.base.start.Start.main(Start.java:84) [ofbiz.jar:?] > Caused by: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:Content][contentId,CNTGIZMOSLRG(java.lang.String)][contentName,Large Gizmos(java.lang.String)][contentTypeId,WEB_SITE_PUB_PT(java.lang.String)][createdByUserLogin,admin(java.lang.String)][createdDate,2001-05-13 12:00:00.0(java.sql.Timestamp)][createdStamp,2017-06-29 18:58:29.729(java.sql.Timestamp)][createdTxStamp,2017-06-29 18:58:29.701(java.sql.Timestamp)][dataResourceId,CNTGIZMOSLRG(java.lang.String)][description,Large Widgets(java.lang.String)][lastUpdatedStamp,2017-06-29 18:58:29.729(java.sql.Timestamp)][lastUpdatedTxStamp,2017-06-29 18:58:29.701(java.sql.Timestamp)][localeString,en_US(java.lang.String)][mimeTypeId,text/html(java.lang.String)][ownerContentId,CNTGIZMOS(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.CONTENT (CONTENT_ID, CONTENT_TYPE_ID, OWNER_CONTENT_ID, DECORATOR_CONTENT_ID, INSTANCE_OF_CONTENT_ID, DATA_RESOURCE_ID, TEMPLATE_DATA_RESOURCE_ID, DATA_SOURCE_ID, STATUS_ID, PRIVILEGE_ENUM_ID, SERVICE_NAME, CUSTOM_METHOD_ID, CONTENT_NAME, DESCRIPTION, LOCALE_STRING, MIME_TYPE_ID, CHARACTER_SET_ID, CHILD_LEAF_COUNT, CHILD_BRANCH_COUNT, CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'CONTENT' caused a violation of foreign key constraint 'CONTENT_PCNTNT' for key (CNTGIZMOS). The statement has been rolled back.)) > at org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:178) ~[ofbiz.jar:?] > at org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:115) ~[ofbiz.jar:?] > at org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) ~[ofbiz.jar:?] > at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:883) ~[ofbiz.jar:?] > ... 15 more > Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO OFBIZ.CONTENT (CONTENT_ID, CONTENT_TYPE_ID, OWNER_CONTENT_ID, DECORATOR_CONTENT_ID, INSTANCE_OF_CONTENT_ID, DATA_RESOURCE_ID, TEMPLATE_DATA_RESOURCE_ID, DATA_SOURCE_ID, STATUS_ID, PRIVILEGE_ENUM_ID, SERVICE_NAME, CUSTOM_METHOD_ID, CONTENT_NAME, DESCRIPTION, LOCALE_STRING, MIME_TYPE_ID, CHARACTER_SET_ID, CHILD_LEAF_COUNT, CHILD_BRANCH_COUNT, CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'CONTENT' caused a violation of foreign key constraint 'CONTENT_PCNTNT' for key (CNTGIZMOS). The statement has been rolled back.) > at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:434) ~[ofbiz.jar:?] > at org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:173) ~[ofbiz.jar:?] > at org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:115) ~[ofbiz.jar:?] > at org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) ~[ofbiz.jar:?] > at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:883) ~[ofbiz.jar:?] > ... 15 more > Caused by: java.sql.SQLIntegrityConstraintViolationException: INSERT on table 'CONTENT' caused a violation of foreign key constraint 'CONTENT_PCNTNT' for key (CNTGIZMOS). The statement has been rolled back. > at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) ~[derby-10.11.1.1.jar:?] > at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) ~[derby-10.11.1.1.jar:?] > at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) ~[derby-10.11.1.1.jar:?] > at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) ~[derby-10.11.1.1.jar:?] > at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) ~[derby-10.11.1.1.jar:?] > at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) ~[derby-10.11.1.1.jar:?] > at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) ~[derby-10.11.1.1.jar:?] > at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) ~[derby-10.11.1.1.jar:?] > at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown Source) ~[derby-10.11.1.1.jar:?] > at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) ~[derby-10.11.1.1.jar:?] > at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) ~[commons-dbcp2-2.1.jar:2.1] > at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) ~[commons-dbcp2-2.1.jar:2.1] > at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:430) ~[ofbiz.jar:?] > at org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:173) ~[ofbiz.jar:?] > at org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:115) ~[ofbiz.jar:?] > at org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) ~[ofbiz.jar:?] > at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:883) ~[ofbiz.jar:?] > ... 15 more > Caused by: org.apache.derby.iapi.error.StandardException: INSERT on table 'CONTENT' caused a violation of foreign key constraint 'CONTENT_PCNTNT' for key (CNTGIZMOS). The statement has been rolled back. > at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.11.1.1.jar:?] > at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.11.1.1.jar:?] > at org.apache.derby.impl.sql.execute.ForeignKeyRIChecker.doCheck(Unknown Source) ~[derby-10.11.1.1.jar:?] > at org.apache.derby.impl.sql.execute.RISetChecker.doFKCheck(Unknown Source) ~[derby-10.11.1.1.jar:?] > at org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown Source) ~[derby-10.11.1.1.jar:?] > at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source) ~[derby-10.11.1.1.jar:?] > at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source) ~[derby-10.11.1.1.jar:?] > at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) ~[derby-10.11.1.1.jar:?] > at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) ~[derby-10.11.1.1.jar:?] > at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) ~[derby-10.11.1.1.jar:?] > at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown Source) ~[derby-10.11.1.1.jar:?] > at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) ~[derby-10.11.1.1.jar:?] > at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) ~[commons-dbcp2-2.1.jar:2.1] > at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) ~[commons-dbcp2-2.1.jar:2.1] > at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:430) ~[ofbiz.jar:?] > at org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:173) ~[ofbiz.jar:?] > at org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:115) ~[ofbiz.jar:?] > at org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) ~[ofbiz.jar:?] > at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:883) ~[ofbiz.jar:?] > ... 15 more > 2017-06-29 18:58:29,741 |main |TransactionUtil |I| Transaction rollback only not set, rollback only is already set. > {code} -- This message was sent by Atlassian JIRA (v6.4.14#64029) |
«
Return to OFBiz - Notifications
|
1 view|%1 views
| Free forum by Nabble | Edit this page |