Posted by
Jacques Le Roux on
URL: http://ofbiz.116.s1.nabble.com/Error-when-new-creating-party-note-in-SVN-530623-tp145826p145830.html
I still have those changes. When I will have a chance I will put them in
trunk. Editable notes seems a good thing to have
Jacques
> Jason,
>
> OOTB notes are not editable. It's not a big deal to make them editable
> anyway.
> I did that some months ago and I realise now that I should have
commited
> it then. I will have a look to see if I still have it.
>
> Jacques
>
>
> > Thank you Ashish!
> >
> > In deed, I don't need to input anything in Note ID field if I create
a
> new
> > note.
> > The Note ID is generated automatically by system.
> >
> > And another question, I can not change the note on the party profile
> page,
> > right?
> > I just can create. If I want to change, I should go to webtools
page,
> right?
> >
> > Thank you!
> > Jason
> >
> >
> > 2007/4/20, Ashish Vijaywargiya
> <
[hidden email]>:
> > >
> > > Hi Jason,
> > >
> > > This is foreign key constraint error.(NoteID1 that you are
providing
> for
> > > note_id doesn't exists in the NoteData entity.)
> > > You should provide the value in either one of the field.
> > > Value in First field is given if you would like to provide the
same
> note
> > > that you have already created to someone else.
> > > Probably , In future there should be a note lookup adjacent to the
> text
> > > field so that it would be easy for someone to select the
previously
> > > created
> > > note. I will create issue + patch for this ASAP :-)
> > >
> > > Please try to put some value inside the "Note" field .Then see the
> > > NoteData
> > > entity for the generated note_id.
> > > And then put this value in the first field i.e Note_Id and see how
> does it
> > > goes.
> > >
> > > Let us know if you find it difficult to figure out.
> > >
> > > On 4/20/07, Jason Wu <
[hidden email]> wrote:
> > > >
> > > > 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
> > > >
> > >
> > >
> > >
> > > --
> > > Thanks & Regards
> > > Ashish Vijaywargiya
> > > Aditisoft Technology Laboratory
> > >
http://www.adititechlabs.com> > >
[hidden email]
> > > __________________________________
> > > Office : 509.855.4113
> > > Cellphone : +919893479711
> > >
> >