this looks like a field type definition is messed up.
which DB are you using.
Case Torres sent the following on 1/11/2008 9:08 AM:
> 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))))".
>
> ---
>
>
