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-9678) Missing foreign key constraint for fields userLoginId & userPrefGroupTypeId in UserPreference entity
Date Sat, 23 Sep 2017 09:15:00 GMT

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

Mime
View raw message