Skip, Also on this point, the sales guy wants to be able to give the note some title. Also, it chokes on any alpha chars. But if I leave it blank it goes thru.
The Following Errors Occurred: Problem associating note with party "Exception while inserting the following entity: [GenericEntity:PartyNote][createdStamp,2008-01-11 14:30:43.352(java.sql.Timestamp)][createdTxStamp,2008-01-11 14:30:43.351(java.sql.Timestamp)][lastUpdatedStamp,2008-01-11 14:30:43.352(java.sql.Timestamp)][lastUpdatedTxStamp,2008-01-11 14:30:43.351(java.sql.Timestamp)][noteId,dfsd(java.lang.String)][partyId,100 01(java.lang.String)] (while inserting: [GenericEntity:PartyNote][createdStamp,2008-01-11 14:30:43.352(java.sql.Timestamp)][createdTxStamp,2008-01-11 14:30:43.351(java.sql.Timestamp)][lastUpdatedStamp,2008-01-11 14:30:43.352(java.sql.Timestamp)][lastUpdatedTxStamp,2008-01-11 14:30:43.351(java.sql.Timestamp)][noteId,dfsd(java.lang.String)][partyId,100 01(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)=(dfsd) is not present in table "note_data".)))". Case Torres [EMAIL PROTECTED] > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Friday, January 11, 2008 11:49 AM > To: [email protected]; [EMAIL PROTECTED] > Subject: RE: Creating party_note, note_id error > > Case > > I looked at this a while ago and as I recall, the noteid is > created for you if you pass null. I seem to remember > submitting a jira which removed the notid field from the UI > so this happens. > > Skip > > -----Original Message----- > From: Case Torres [mailto:[EMAIL PROTECTED] > Sent: Friday, January 11, 2008 9:08 AM > To: [email protected] > Subject: Creating party_note, note_id error > > > Hi, > > Release 4, version: 602199 > > I was trying to create a note for a party in party manager > and received the error below. > The two fields to be filled in are "Note Id" and "Note". > The Note Id form field is 25 chars long, with no max set but > the database field is set at 20 chars so the user gets an > ugly sql error message. > It seems the easiest fix is to make the form field max 20 > chars but I'm not sure how to do this given the following form code. > > Any suggestions??? Thanks, Case > > <form name="AddPartyNote" type="single" target="createPartyNote" > focus-field-name="noteId"> > <auto-fields-service service-name="createPartyNote"/> > <field name="partyId"><hidden/></field> > <field name="note"><textarea cols="70" rows="10"/></field> > <field name="submitButton" title="${uiLabelMap.CommonSave}" > widget-style="smallSubmit"><submit button-type="text-link"/></field> > <field name="cancelLink" title="" > widget-style="smallSubmit"><hyperlink > target="${donePage}?partyId=${partyId}" also-hidden="false" > description="${uiLabelMap.CommonCancelDone}"/></field> > </form> > > > > ------ > SQL ERROR: > > Problem associating note with party "Exception while > inserting the following > entity: [GenericEntity:PartyNote][createdStamp,2008-01-10 > 13:07:25.774(java.sql.Timestamp)][createdTxStamp,2008-01-10 > 13:07:25.773(java.sql.Timestamp)][lastUpdatedStamp,2008-01-10 > 13:07:25.774(java.sql.Timestamp)][lastUpdatedTxStamp,2008-01-10 > 13:07:25.773(java.sql.Timestamp)][noteId,New product > discussion(java.lang.String)][partyId,12692(java.lang.String)] (while > inserting: [GenericEntity:PartyNote][createdStamp,2008-01-10 > 13:07:25.774(java.sql.Timestamp)][createdTxStamp,2008-01-10 > 13:07:25.773(java.sql.Timestamp)][lastUpdatedStamp,2008-01-10 > 13:07:25.774(java.sql.Timestamp)][lastUpdatedTxStamp,2008-01-10 > 13:07:25.773(java.sql.Timestamp)][noteId,New product > discussion(java.lang.String)][partyId,12692(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: value too long for type > character varying(20))))". > > --- > > > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.5.516 / Virus Database: 269.17.13/1210 - Release > Date: 1/5/2008 > 11:46 AM > > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.5.516 / Virus Database: 269.17.13/1210 - Release > Date: 1/5/2008 > 11:46 AM >
