OFBiz › OFBiz - User

Creating party_note, note_id error

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

14 messages Options

CaseT

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))))".

---

BJ Freeman

Re: Creating party_note, note_id error

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))))".
>
> ---
>
>

BJ Freeman

Re: Creating party_note, note_id error

In reply to this post by CaseT

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:

BJ Freeman

Re: Creating party_note, note_id error

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))))".
>>
>> ---
>>
>>
>
>
>
>

SkipDever

RE: Creating party_note, note_id error

In reply to this post by CaseT

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:[hidden email]]
Sent: Friday, January 11, 2008 9:08 AM
To: [hidden email]
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

CaseT

RE: Creating party_note, note_id error

In reply to this post by BJ Freeman

Postgres 8.2.4

Case Torres
[hidden email]

> -----Original Message-----
> From: BJ Freeman [mailto:[hidden email]]
> Sent: Friday, January 11, 2008 9:48 AM
> To: [hidden email]
> 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))))".
> >
> > ---
> >
> >
>

CaseT

RE: Creating party_note, note_id error

In reply to this post by SkipDever

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
[hidden email]

> -----Original Message-----
> From: skip@thedevers [mailto:[hidden email]]
> Sent: Friday, January 11, 2008 11:49 AM
> To: [hidden email]; [hidden email]
> 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:[hidden email]]
> Sent: Friday, January 11, 2008 9:08 AM
> To: [hidden email]
> 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
>

CaseT

RE: Creating party_note, note_id error

In reply to this post by SkipDever

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
[hidden email]

BJ Freeman

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
> [hidden email]
>
>
>
>> -----Original Message-----
>> From: skip@thedevers [mailto:[hidden email]]
>> Sent: Friday, January 11, 2008 11:49 AM
>> To: [hidden email]; [hidden email]
>> 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:[hidden email]]
>> Sent: Friday, January 11, 2008 9:08 AM
>> To: [hidden email]
>> 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
>>
>
>
>
>

CaseT

RE: Creating party_note, note_id error

But there is not a note id field in the trunk version.

Case Torres
[hidden email]

> -----Original Message-----
> From: BJ Freeman [mailto:[hidden email]]
> Sent: Friday, January 11, 2008 3:16 PM
> To: [hidden email]
> 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
> > [hidden email]
> >
> >
> >
> >> -----Original Message-----
> >> From: skip@thedevers [mailto:[hidden email]]
> >> Sent: Friday, January 11, 2008 11:49 AM
> >> To: [hidden email]; [hidden email]
> >> 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:[hidden email]]
> >> Sent: Friday, January 11, 2008 9:08 AM
> >> To: [hidden email]
> >> 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
> >>
> >
> >
> >
> >
>

Jacques Le Roux

Re: Creating party_note, note_id error

Administrator

In reply to this post by CaseT

Not sure why, one more time, this one did not get thru... (but I know my SMTP provider is a crap)

Jacques

----- Original Message -----
From: "Jacques Le Roux" <[hidden email]>
To: <[hidden email]>
Sent: Friday, January 11, 2008 10:21 PM
Subject: Re: Creating party_note, note_id error

> Yes and as it was not a bug fix it was not backported. You may found what you need here
>
> http://svn.apache.org/viewvc?view=rev&revision=589084
> or here http://tinyurl.com/3a9l7h
>
> Jacques
>
> From: "skip@thedevers" <[hidden email]>
>> 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:[hidden email]]
>> Sent: Friday, January 11, 2008 9:08 AM
>> To: [hidden email]
>> 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
>>
>>

BJ Freeman

Re: Creating party_note, note_id error

In reply to this post by CaseT

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
> [hidden email]
>
>
>
>> -----Original Message-----
>> From: BJ Freeman [mailto:[hidden email]]
>> Sent: Friday, January 11, 2008 3:16 PM
>> To: [hidden email]
>> 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
>>> [hidden email]
>>>
>>>
>>>
>>>> -----Original Message-----
>>>> From: skip@thedevers [mailto:[hidden email]]
>>>> Sent: Friday, January 11, 2008 11:49 AM
>>>> To: [hidden email]; [hidden email]
>>>> 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:[hidden email]]
>>>> Sent: Friday, January 11, 2008 9:08 AM
>>>> To: [hidden email]
>>>> 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
>>>>
>>>
>>>
>>>
>
>
>
>

SkipDever

RE: Creating party_note, note_id error

In reply to this post by CaseT

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:[hidden email]]
Sent: Friday, January 11, 2008 2:43 PM
To: [hidden email]
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
[hidden email]

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

SkipDever

RE: Creating party_note, note_id error

In reply to this post by CaseT

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:[hidden email]]
Sent: Friday, January 11, 2008 2:47 PM
To: [hidden email]
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
[hidden email]