Error when new creating party note in SVN 530623

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

Error when new creating party note in SVN 530623

Jason.Wu
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
Reply | Threaded
Open this post in threaded view
|

Re: Error when new creating party note in SVN 530623

Ashish Vijaywargiya-3
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
Reply | Threaded
Open this post in threaded view
|

Re: Error when new creating party note in SVN 530623

Jason.Wu
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
>
Reply | Threaded
Open this post in threaded view
|

Re: Error when new creating party note in SVN 530623

Jacques Le Roux
Administrator
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
> >
>

Reply | Threaded
Open this post in threaded view
|

Re: Error when new creating party note in SVN 530623

Jacques Le Roux
Administrator
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
> > >
> >