[
https://issues.apache.org/jira/browse/OFBIZ-9678?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16177670#comment-16177670
]
Jacques Le Roux commented on OFBIZ-9678:
----------------------------------------
Hi Aditya I think we have issues with recent data model changes, see
https://ci.apache.org/builders/ofbiz-trunk-framework/builds/471
and while loading
{code}
2017-09-23 11:05:42,654 |main |EntitySaxReader
|I| Transaction Timeout set to 2 hours (7200 seconds)
2017-09-23 11:05:42,865 |main |GenericDelegator
|E| Failure in create operation for entity [UserPreference]:
org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:UserPreference][createdStamp,2017-09-23
11:05:42.86(java.sql.Timestamp)][createdTxStamp,2017-09-23
11:05:42.654(java.sql.Timestamp)][lastUpdatedStamp,2017-09-23
11:05:42.86(java.sql.Timestamp)
][lastUpdatedTxStamp,2017-09-23
11:05:42.654(java.sql.Timestamp)][userLoginId,_NA_(java.lang.String)][userPrefGroupTypeId,GLOBAL_PREFERENCES(java.lang.String)][userPrefTypeId,VISUAL_THEME(java.lang.String)][u
serPrefValue,DEFAULT(java.lang.String)] (SQL Exception while executing the
following:INSERT INTO OFBIZ.USER_PREFERENCE (USER_LOGIN_ID, USER_PREF_TYPE_ID,
USER_PREF_GROUP_TYPE_ID, USER_PREF_VALUE, USER_PREF_DA
TA_TYPE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table
'USER_PREFERENCE' caused a violation of foreign key constraint 'UP_USER
_LOGIN' for key (_NA_). The statement has been rolled back.)). Rolling back
transaction.
2017-09-23 11:05:42,865 |main |TransactionUtil
|W| Calling transaction setRollbackOnly; this stack trace shows where this is
happening:
java.lang.Exception: Failure in create operation for entity [UserPreference]:
org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:UserPreference][createdStamp,2017-09-23 11:0
5:42.86(java.sql.Timestamp)][createdTxStamp,2017-09-23
11:05:42.654(java.sql.Timestamp)][lastUpdatedStamp,2017-09-23
11:05:42.86(java.sql.Timestamp)][lastUpdatedTxStamp,2017-09-23
11:05:42.654(java.sql.Timest
amp)][userLoginId,_NA_(java.lang.String)][userPrefGroupTypeId,GLOBAL_PREFERENCES(java.lang.String)][userPrefTypeId,VISUAL_THEME(java.lang.String)][userPrefValue,DEFAULT(java.lang.String)]
(SQL Exception while
executing the following:INSERT INTO OFBIZ.USER_PREFERENCE (USER_LOGIN_ID,
USER_PREF_TYPE_ID, USER_PREF_GROUP_TYPE_ID, USER_PREF_VALUE,
USER_PREF_DATA_TYPE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_
STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table
'USER_PREFERENCE' caused a violation of foreign key constraint 'UP_USER_LOGIN'
for key (_NA_). The statement has been rolled back.
)). Rolling back transaction.
{code}
I'm not yet sure, but not only here but maybe also with
https://ci.apache.org/builders/ofbiz-trunk-framework/builds/472 checking...
> Missing foreign key constraint for fields userLoginId & userPrefGroupTypeId
> in UserPreference entity
> ----------------------------------------------------------------------------------------------------
>
> Key: OFBIZ-9678
> URL: https://issues.apache.org/jira/browse/OFBIZ-9678
> Project: OFBiz
> Issue Type: Sub-task
> Components: ALL COMPONENTS
> Reporter: Aditya Sharma
> Assignee: Jacques Le Roux
> Fix For: Upcoming Release
>
> Attachments: OFBIZ-9678.patch
>
>
> UserPreference.userLoginId is related to UserLogin.userLoginId.
> UserPreference.userPrefGroupTypeId is related to
> UserPrefGroupType.userPrefGroupTypeId.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
