Error message when entering a sales order


#1

When trying to enter a sales order through e-Commerce website or directly through the scipio ordering function, I get the following write error:
Any thoughts what this is?

The Following Errors Occurred:

Did not complete the order, the following occurred: ERROR : Could not create order (write error :org.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Failure in create operation for entity [NoteData]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:NoteData][createdStamp,2018-10-12 19:52:06.155(java.sql.Timestamp)][createdTxStamp,2018-10-12 19:52:06.092(java.sql.Timestamp)][lastUpdatedStamp,2018-10-12 19:52:06.155(java.sql.Timestamp)][lastUpdatedTxStamp,2018-10-12 19:52:06.092(java.sql.Timestamp)][moreInfoItemId,WSFPORD-1(java.lang.String)][moreInfoItemName,orderId(java.lang.String)][moreInfoUrl,/ordermgr/control/orderview(java.lang.String)][noteDateTime,2018-10-12 19:52:06.155(java.sql.Timestamp)][noteId,10001(java.lang.String)][noteInfo,An order has been created(java.lang.String)][noteName,SYSTEMNOTE(java.lang.String)][noteParty,admin(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.NOTE_DATA (NOTE_ID, NOTE_NAME, NOTE_INFO, NOTE_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, NOTE_PARTY, MORE_INFO_URL, MORE_INFO_ITEM_ID, MORE_INFO_ITEM_NAME) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table ‘NOTE_DATA’ caused a violation of foreign key constraint ‘NOTE_DATA_PTY’ for key (admin). The statement has been rolled back.)). Rolling back transaction.org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:NoteData][createdStamp,2018-10-12 19:52:06.155(java.sql.Timestamp)][createdTxStamp,2018-10-12 19:52:06.092(java.sql.Timestamp)][lastUpdatedStamp,2018-10-12 19:52:06.155(java.sql.Timestamp)][lastUpdatedTxStamp,2018-10-12 19:52:06.092(java.sql.Timestamp)][moreInfoItemId,WSFPORD-1(java.lang.String)][moreInfoItemName,orderId(java.lang.String)][moreInfoUrl,/ordermgr/control/orderview(java.lang.String)][noteDateTime,2018-10-12 19:52:06.155(java.sql.Timestamp)][noteId,10001(java.lang.String)][noteInfo,An order has been created(java.lang.String)][noteName,SYSTEMNOTE(java.lang.String)][noteParty,admin(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.NOTE_DATA (NOTE_ID, NOTE_NAME, NOTE_INFO, NOTE_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, NOTE_PARTY, MORE_INFO_URL, MORE_INFO_ITEM_ID, MORE_INFO_ITEM_NAME) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table ‘NOTE_DATA’ caused a violation of foreign key constraint ‘NOTE_DATA_PTY’ for key (admin). The statement has been rolled back.)) (Error while inserting: [GenericEntity:NoteData][createdStamp,2018-10-12 19:52:06.155(java.sql.Timestamp)][createdTxStamp,2018-10-12 19:52:06.092(java.sql.Timestamp)][lastUpdatedStamp,2018-10-12 19:52:06.155(java.sql.Timestamp)][lastUpdatedTxStamp,2018-10-12 19:52:06.092(java.sql.Timestamp)][moreInfoItemId,WSFPORD-1(java.lang.String)][moreInfoItemName,orderId(java.lang.String)][moreInfoUrl,/ordermgr/control/orderview(java.lang.String)][noteDateTime,2018-10-12 19:52:06.155(java.sql.Timestamp)][noteId,10001(java.lang.String)][noteInfo,An order has been created(java.lang.String)][noteName,SYSTEMNOTE(java.lang.String)][noteParty,admin(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.NOTE_DATA (NOTE_ID, NOTE_NAME, NOTE_INFO, NOTE_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, NOTE_PARTY, MORE_INFO_URL, MORE_INFO_ITEM_ID, MORE_INFO_ITEM_NAME) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table ‘NOTE_DATA’ caused a violation of foreign key constraint ‘NOTE_DATA_PTY’ for key (admin). The statement has been rolled back.))) (The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Failure in create operation for entity [NoteData]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:NoteData][createdStamp,2018-10-12 19:52:06.155(java.sql.Timestamp)][createdTxStamp,2018-10-12 19:52:06.092(java.sql.Timestamp)][lastUpdatedStamp,2018-10-12 19:52:06.155(java.sql.Timestamp)][lastUpdatedTxStamp,2018-10-12 19:52:06.092(java.sql.Timestamp)][moreInfoItemId,WSFPORD-1(java.lang.String)][moreInfoItemName,orderId(java.lang.String)][moreInfoUrl,/ordermgr/control/orderview(java.lang.String)][noteDateTime,2018-10-12 19:52:06.155(java.sql.Timestamp)][noteId,10001(java.lang.String)][noteInfo,An order has been created(java.lang.String)][noteName,SYSTEMNOTE(java.lang.String)][noteParty,admin(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.NOTE_DATA (NOTE_ID, NOTE_NAME, NOTE_INFO, NOTE_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, NOTE_PARTY, MORE_INFO_URL, MORE_INFO_ITEM_ID, MORE_INFO_ITEM_NAME) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table ‘NOTE_DATA’ caused a violation of foreign key constraint ‘NOTE_DATA_PTY’ for key (admin). The statement has been rolled back.)). Rolling back transaction.org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:NoteData][createdStamp,2018-10-12 19:52:06.155(java.sql.Timestamp)][createdTxStamp,2018-10-12 19:52:06.092(java.sql.Timestamp)][lastUpdatedStamp,2018-10-12 19:52:06.155(java.sql.Timestamp)][lastUpdatedTxStamp,2018-10-12 19:52:06.092(java.sql.Timestamp)][moreInfoItemId,WSFPORD-1(java.lang.String)][moreInfoItemName,orderId(java.lang.String)][moreInfoUrl,/ordermgr/control/orderview(java.lang.String)][noteDateTime,2018-10-12 19:52:06.155(java.sql.Timestamp)][noteId,10001(java.lang.String)][noteInfo,An order has been created(java.lang.String)][noteName,SYSTEMNOTE(java.lang.String)][noteParty,admin(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.NOTE_DATA (NOTE_ID, NOTE_NAME, NOTE_INFO, NOTE_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, NOTE_PARTY, MORE_INFO_URL, MORE_INFO_ITEM_ID, MORE_INFO_ITEM_NAME) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table ‘NOTE_DATA’ caused a violation of foreign key constraint ‘NOTE_DATA_PTY’ for key (admin). The statement has been rolled back.)) (Error while inserting: [GenericEntity:NoteData][createdStamp,2018-10-12 19:52:06.155(java.sql.Timestamp)][createdTxStamp,2018-10-12 19:52:06.092(java.sql.Timestamp)][lastUpdatedStamp,2018-10-12 19:52:06.155(java.sql.Timestamp)][lastUpdatedTxStamp,2018-10-12 19:52:06.092(java.sql.Timestamp)][moreInfoItemId,WSFPORD-1(java.lang.String)][moreInfoItemName,orderId(java.lang.String)][moreInfoUrl,/ordermgr/control/orderview(java.lang.String)][noteDateTime,2018-10-12 19:52:06.155(java.sql.Timestamp)][noteId,10001(java.lang.String)][noteInfo,An order has been created(java.lang.String)][noteName,SYSTEMNOTE(java.lang.String)][noteParty,admin(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.NOTE_DATA (NOTE_ID, NOTE_NAME, NOTE_INFO, NOTE_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, NOTE_PARTY, MORE_INFO_URL, MORE_INFO_ITEM_ID, MORE_INFO_ITEM_NAME) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table ‘NOTE_DATA’ caused a violation of foreign key constraint ‘NOTE_DATA_PTY’ for key (admin). The statement has been rolled back.))))).


#2

There is no admin party in the DB. You can go here and import under “complete xml document”:

<entity-engine-xml>
    <Party partyId="admin" partyTypeId="PERSON"/>
    <Person firstName="THE" lastName="ADMINISTRATOR" middleName="PRIVILEGED" partyId="admin" personalTitle="Mr."/>
    <PartyRole partyId="admin" roleTypeId="BUYER"/>
    <PartyRole partyId="admin" roleTypeId="MANAGER"/>
    <PartyRole partyId="admin" roleTypeId="ORDER_CLERK"/>
    <PartyRole partyId="admin" roleTypeId="SHIPMENT_CLERK"/>
    <PartyRole partyId="admin" roleTypeId="SALES_REP"/>
    <PartyRole partyId="admin" roleTypeId="_NA_"/>

    <UserLogin userLoginId="admin" partyId="admin"/>
</entity-engine-xml>

https://localhost:8443/admin/control/EntityImport

or create him in https://localhost:8443/partymgr/control/editperson?create_new=Y&partyId=admin
and link to admin userlogin on security