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
