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