You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Case Torres <Ca...@casetorrestech.com> on 2008/01/11 18:08:07 UTC
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))))".
---
Re: Creating party_note, note_id error
Posted by BJ Freeman <bj...@free-man.net>.
sorry did not have my coffe
figure it is beyond my knowledge at this point.
:)
BJ Freeman sent the following on 1/11/2008 9:48 AM:
> 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))))".
>>
>> ---
>>
>>
>
>
>
>
RE: Creating party_note, note_id error
Posted by Case Torres <Ca...@casetorrestech.com>.
Postgres 8.2.4
Case Torres
case@casetorrestech.com
> -----Original Message-----
> From: BJ Freeman [mailto:bjfree@free-man.net]
> Sent: Friday, January 11, 2008 9:48 AM
> To: user@ofbiz.apache.org
> Subject: Re: Creating party_note, note_id error
>
> 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))))".
> >
> > ---
> >
> >
>
Re: Creating party_note, note_id error
Posted by BJ Freeman <bj...@free-man.net>.
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))))".
>
> ---
>
>
Re: Creating party_note, note_id error
Posted by BJ Freeman <bj...@free-man.net>.
remember a fix related to notes in trunk.
have to research commits.
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))))".
>
> ---
>
>
RE: Creating party_note, note_id error
Posted by "skip@thedevers" <sk...@thedevers.org>.
Easy enough to add a title field, but you'll have to modify the servicedef
as well as add the new field to the entitydef.
Skip
-----Original Message-----
From: Case Torres [mailto:Case@casetorrestech.com]
Sent: Friday, January 11, 2008 2:43 PM
To: user@ofbiz.apache.org
Subject: RE: Creating party_note, note_id error
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
case@casetorrestech.com
> -----Original Message-----
> From: skip@thedevers [mailto:skip@thedevers.org]
> Sent: Friday, January 11, 2008 11:49 AM
> To: user@ofbiz.apache.org; Case@casetorrestech.com
> 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:Case@casetorrestech.com]
> Sent: Friday, January 11, 2008 9:08 AM
> To: user@ofbiz.apache.org
> 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
>
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
RE: Creating party_note, note_id error
Posted by Case Torres <Ca...@casetorrestech.com>.
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
case@casetorrestech.com
> -----Original Message-----
> From: skip@thedevers [mailto:skip@thedevers.org]
> Sent: Friday, January 11, 2008 11:49 AM
> To: user@ofbiz.apache.org; Case@casetorrestech.com
> 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:Case@casetorrestech.com]
> Sent: Friday, January 11, 2008 9:08 AM
> To: user@ofbiz.apache.org
> 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
>
Re: Creating party_note, note_id error
Posted by BJ Freeman <bj...@free-man.net>.
that is considered a enhacement
if you take it out of the service then you much change all the call that
service.
however those in power may decide to do it anyway.
Case Torres sent the following on 1/11/2008 3:23 PM:
> But there is not a note id field in the trunk version.
>
> Case Torres
> case@casetorrestech.com
>
>
>
>> -----Original Message-----
>> From: BJ Freeman [mailto:bjfree@free-man.net]
>> Sent: Friday, January 11, 2008 3:16 PM
>> To: user@ofbiz.apache.org
>> Subject: Re: Creating party_note, note_id error
>>that
>> no,
>> if it is null it will autosign a ID
>> but leave the ability to assign an ID.
>> I would put a jira in for the 25 char display on the widget
>> but 20 char for the ID not sure where the bug is.
>>
>>
>> Case Torres sent the following on 1/11/2008 2:46 PM:
>>> I guess I'll just comment out the note_id field in the form.
>>> But this field should be eliminated from the from in the Release 4
>>> version, no?
>>>
>>> Thanks, Case
>>>
>>> Case Torres
>>> case@casetorrestech.com
>>>
>>>
>>>
>>>> -----Original Message-----
>>>> From: skip@thedevers [mailto:skip@thedevers.org]
>>>> Sent: Friday, January 11, 2008 11:49 AM
>>>> To: user@ofbiz.apache.org; Case@casetorrestech.com
>>>> 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:Case@casetorrestech.com]
>>>> Sent: Friday, January 11, 2008 9:08 AM
>>>> To: user@ofbiz.apache.org
>>>> 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
>>>>
>>>
>>>
>>>
>
>
>
>
RE: Creating party_note, note_id error
Posted by Case Torres <Ca...@casetorrestech.com>.
But there is not a note id field in the trunk version.
Case Torres
case@casetorrestech.com
> -----Original Message-----
> From: BJ Freeman [mailto:bjfree@free-man.net]
> Sent: Friday, January 11, 2008 3:16 PM
> To: user@ofbiz.apache.org
> Subject: Re: Creating party_note, note_id error
>
> no,
> if it is null it will autosign a ID
> but leave the ability to assign an ID.
> I would put a jira in for the 25 char display on the widget
> but 20 char for the ID not sure where the bug is.
>
>
> Case Torres sent the following on 1/11/2008 2:46 PM:
> > I guess I'll just comment out the note_id field in the form.
> > But this field should be eliminated from the from in the Release 4
> > version, no?
> >
> > Thanks, Case
> >
> > Case Torres
> > case@casetorrestech.com
> >
> >
> >
> >> -----Original Message-----
> >> From: skip@thedevers [mailto:skip@thedevers.org]
> >> Sent: Friday, January 11, 2008 11:49 AM
> >> To: user@ofbiz.apache.org; Case@casetorrestech.com
> >> 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:Case@casetorrestech.com]
> >> Sent: Friday, January 11, 2008 9:08 AM
> >> To: user@ofbiz.apache.org
> >> 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
> >>
> >
> >
> >
> >
>
Re: Creating party_note, note_id error
Posted by BJ Freeman <bj...@free-man.net>.
no,
if it is null it will autosign a ID
but leave the ability to assign an ID.
I would put a jira in for the 25 char display on the widget but 20 char
for the ID
not sure where the bug is.
Case Torres sent the following on 1/11/2008 2:46 PM:
> I guess I'll just comment out the note_id field in the form.
> But this field should be eliminated from the from in the Release 4 version,
> no?
>
> Thanks, Case
>
> Case Torres
> case@casetorrestech.com
>
>
>
>> -----Original Message-----
>> From: skip@thedevers [mailto:skip@thedevers.org]
>> Sent: Friday, January 11, 2008 11:49 AM
>> To: user@ofbiz.apache.org; Case@casetorrestech.com
>> 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:Case@casetorrestech.com]
>> Sent: Friday, January 11, 2008 9:08 AM
>> To: user@ofbiz.apache.org
>> 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
>>
>
>
>
>
RE: Creating party_note, note_id error
Posted by "skip@thedevers" <sk...@thedevers.org>.
No, I did not eliminate the field, I only put in a hint to not put in an Id
unless you really needed one and modified the service so that it treats the
noteid as a null if it is empty. In your case, you want to remove it
altogether.
Skip
-----Original Message-----
From: Case Torres [mailto:Case@casetorrestech.com]
Sent: Friday, January 11, 2008 2:47 PM
To: user@ofbiz.apache.org
Subject: RE: Creating party_note, note_id error
I guess I'll just comment out the note_id field in the form.
But this field should be eliminated from the from in the Release 4 version,
no?
Thanks, Case
Case Torres
case@casetorrestech.com
> -----Original Message-----
> From: skip@thedevers [mailto:skip@thedevers.org]
> Sent: Friday, January 11, 2008 11:49 AM
> To: user@ofbiz.apache.org; Case@casetorrestech.com
> 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:Case@casetorrestech.com]
> Sent: Friday, January 11, 2008 9:08 AM
> To: user@ofbiz.apache.org
> 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
>
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
RE: Creating party_note, note_id error
Posted by Case Torres <Ca...@casetorrestech.com>.
I guess I'll just comment out the note_id field in the form.
But this field should be eliminated from the from in the Release 4 version,
no?
Thanks, Case
Case Torres
case@casetorrestech.com
> -----Original Message-----
> From: skip@thedevers [mailto:skip@thedevers.org]
> Sent: Friday, January 11, 2008 11:49 AM
> To: user@ofbiz.apache.org; Case@casetorrestech.com
> 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:Case@casetorrestech.com]
> Sent: Friday, January 11, 2008 9:08 AM
> To: user@ofbiz.apache.org
> 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
>
RE: Creating party_note, note_id error
Posted by "skip@thedevers" <sk...@thedevers.org>.
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:Case@casetorrestech.com]
Sent: Friday, January 11, 2008 9:08 AM
To: user@ofbiz.apache.org
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