[
https://issues.apache.org/jira/browse/OFBIZ-9439?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Michael Brohl reopened OFBIZ-9439:
----------------------------------
The data is missing some content associations and the test code is not
reflecting the new data, will fix this.
> 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)
