[
https://issues.apache.org/jira/browse/OFBIZ-9439?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Michael Brohl updated OFBIZ-9439:
---------------------------------
Description:
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}
was:
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}
> 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: Bug
> Components: lucene
> Affects Versions: Trunk
> Reporter: Michael Brohl
>
> 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)
