ofbiz-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Le Roux (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (OFBIZ-9439) Lucene tests fail due to problems in the test data
Date Fri, 30 Jun 2017 10:33:00 GMT

    [ https://issues.apache.org/jira/browse/OFBIZ-9439?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16069868#comment-16069868
] 

Jacques Le Roux commented on OFBIZ-9439:
----------------------------------------

bq. There might be cases where one plugin relies on another, but this should be well thought
and not happen by accident.
# Agreed
bq. Regarding data: plugins should only add and reference data to the existing set in the
base application, not to other plugins.
# Agreed, but I fear issues if 2 plugins have initially the same data and they later differ
in time (one replaces the other)
bq. We should then have an automatic mechanism to pull dependencies on other plugins.
# Yes would be the right solution, we NEED something like that because of the point 2

I'll soon answer you on the main issue (OFBIZ-9440)


> 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)

Mime
View raw message