Topic Options
Rate This Topic
#109682 - 01/03/05 06:52 AM Incoming test
lars pettersson Offline
Pooh-Bah

Registered: 06/12/01
Posts: 1888
Hi, made a simple test, just a filter on submit in the email message form messagetyp incoming , push field 'from' to another form and a char displayonlyfield, create request, and a filter there make a set field on submit searching for the emailadress 'from' and set userid to a field

but I receive this: messnr 552:

Failure during SQL operation to the database ORA-01401: inserted value too large for column

I can see that the 'from' field is 32000 char long ....why ... (field 18086), so i set the field in my testform to 32000 to, but still receive the message above.

What am I missing ...can't see that the value pushed should be to long for the targetfield

L ars Pettersson
Vattenfall Business Services Nordic AB
ARS Systems Engineer
S-461 88 Trollhättan
Sweden

Phone +46 520 888 35 Mobil +46 70 608 99 95
e-mail: lars.j.pettersson@vattenfall.com
www.vattenfall.se


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)


Top
#109683 - 01/02/05 07:05 PM Re: Incoming test [Re: stephen lumini]
michiel_beijen663 Offline
journeyman

Registered: 03/09/05
Posts: 147
Lars,

Maybe a little too obvious, but just turn on the al/filter/SQL logging
for a second (on your dev box of course), this is quite clarifying
sometimes. There just might be a piece of workflow in your way.

--
Michiel

On Mon, 3 Jan 2005 19:52:33 +0100, lars.j.pettersson@vattenfall.com
wrote:
> Hi, made a simple test, just a filter on submit in the email message form messagetyp incoming , push field 'from' to another form and a char displayonlyfield, create request, and a filter there make a set field on submit searching for the emailadress 'from' and set userid to a field
>
> but I receive this: messnr 552:
>
> Failure during SQL operation to the database ORA-01401: inserted value too large for column
>
> I can see that the 'from' field is 32000 char long ....why ... (field 18086), so i set the field in my testform to 32000 to, but still receive the message above.
>
> What am I missing ...can't see that the value pushed should be to long for the targetfield
>
> L ars Pettersson
> Vattenfall Business Services Nordic AB
> ARS Systems Engineer
> S-461 88 Trollhättan
> Sweden
>
> Phone +46 520 888 35 Mobil +46 70 608 99 95
> e-mail: lars.j.pettersson@vattenfall.com
> www.vattenfall.se
>
>
> UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
> (Support: mailto:support@arslist.org)
>


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)


Top
#109684 - 01/02/05 07:42 PM SV: Incoming test [Re: stephen lumini]
lars pettersson Offline
Pooh-Bah

Registered: 06/12/01
Posts: 1888
Thought of that but ...I have only created 2 filters today, if I disable the push filter, the email is created in the messageform, but if enabled, this error. Only the from field is pushed (doublechecked ...)

Filter 2 works fine if a enter my emailadress and save - my userid is set - so it's filter 1 that is causing this.

Something special with field 18086 so that it can't be pushed to an ordinary charfield with ordinary id ..or ..


run if: 'Message Type' = "Incoming"

Push: 1 = 2, create request

Action set From to $From$

Should work ...


Lars,

Maybe a little too obvious, but just turn on the al/filter/SQL logging
for a second (on your dev box of course), this is quite clarifying
sometimes. There just might be a piece of workflow in your way.

--
Michiel

On Mon, 3 Jan 2005 19:52:33 +0100, lars.j.pettersson@vattenfall.com
wrote:
> Hi, made a simple test, just a filter on submit in the email message form messagetyp incoming , push field 'from' to another form and a char displayonlyfield, create request, and a filter there make a set field on submit searching for the emailadress 'from' and set userid to a field
>
> but I receive this: messnr 552:
>
> Failure during SQL operation to the database ORA-01401: inserted value too large for column
>
> I can see that the 'from' field is 32000 char long ....why ... (field 18086), so i set the field in my testform to 32000 to, but still receive the message above.
>
> What am I missing ...can't see that the value pushed should be to long for the targetfield
>


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)


Top