Error when new creating party note in SVN 530623

Posted by Jason.Wu on Apr 20, 2007; 4:52am
URL: http://ofbiz.116.s1.nabble.com/Error-when-new-creating-party-note-in-SVN-530623-tp145826.html

Hi,

In the demo env, when I want to create a note for party from Party Profile
page, an error occurred. Sould I config something before?

My SVN is 530623 and database is postgresql.

The Following Errors Occurred:

Problem associating note with party "Exception while inserting the following
entity: [GenericEntity:PartyNote][createdStamp,2007-04-20 11:46:59.343(
java.sql.Timestamp)][createdTxStamp,2007-04-20 11:46:59.343(
java.sql.Timestamp)][lastUpdatedStamp,2007-04-20 11:46:59.343(
java.sql.Timestamp)][lastUpdatedTxStamp,2007-04-20 11:46:59.343(
java.sql.Timestamp)][noteId,NoteID1(java.lang.String)][partyId,approver(
java.lang.String)] (while inserting:
[GenericEntity:PartyNote][createdStamp,2007-04-20 11:46:59.343(
java.sql.Timestamp)][createdTxStamp,2007-04-20 11:46:59.343(
java.sql.Timestamp)][lastUpdatedStamp,2007-04-20 11:46:59.343(
java.sql.Timestamp)][lastUpdatedTxStamp,2007-04-20 11:46:59.343(
java.sql.Timestamp)][noteId,NoteID1(java.lang.String)][partyId,approver(
java.lang.String)] (SQL Exception while executing the following:INSERT INTO
public.PARTY_NOTE (PARTY_ID, NOTE_ID, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?,
?, ?) (ERROR: insert or update on table "party_note" violates foreign key
constraint "party_note_note"
Detail: Key (note_id)=(NoteID1) is not present in table "note_data".)))".

Thanks

Jason