**
When trying to push a large field (view form) into another ARform field database input length is 500
it is a character / edit type.
You can manually type in 500 characters no problem

But I am using an active link button for manual testing is it is giving me the following error.
ARERR [306] Value does not fall within the limits specified for the field : (max length - 255) : CSCWS : Problem Description

But the Field is 500

Is there a Limitation of What size you can PUSH ?
I would think If I had a 4000 character field and wanted to push it then it would do it fine..

The Active link says the following.
>Action
Push fields
if 0=1
Create new request
take no action

Field: Problem Description (( "CSRD- " + $Request ID$) + " REQ: ") + SUBSTR($REQUIREMENT$,0,475)

so the Text should look like
CSRD- 03-0345 REQ: << 475 characters from the $REQUIREMENTS$ Field >>

Did I type that incorrect ? it looks right to me ..
This posting was submitted via the Web interface

**
Is the character field in the view form also 500 characters?

Guillaume

-----Original Message-----
From: Zandi Patrick S TSgt AFRL/IFOSS [mailto:Patrick.Zandi@RL.AF.MIL]
Sent: Tuesday, June 10, 2003 9:21 AM
To: ARSLIST@ARSLIST.ORG
Subject: ARERR [306] is there a Max Push size?


**
When trying to push a large field (view form) into another ARform field database input length is 500
it is a character / edit type.
You can manually type in 500 characters no problem

But I am using an active link button for manual testing is it is giving me the following error.
ARERR [306] Value does not fall within the limits specified for the field : (max length - 255) : CSCWS : Problem Description

But the Field is 500

Is there a Limitation of What size you can PUSH ?
I would think If I had a 4000 character field and wanted to push it then it would do it fine..

The Active link says the following.
>Action
Push fields
if 0=1
Create new request
take no action

Field: Problem Description (( "CSRD- " + $Request ID$) + " REQ: ") + SUBSTR($REQUIREMENT$,0,475)

so the Text should look like
CSRD- 03-0345 REQ: << 475 characters from the $REQUIREMENTS$ Field >>

Did I type that incorrect ? it looks right to me ..
This posting was submitted via the Web interface

This posting was submitted via the Web interface

Whats the total database size of the SOURCE and the DESTINATION fields?
Jose Leon



Internet
Patrick.Zandi@RL.AF.MIL@ARSLIST.ORG - 06/10/2003 10:20 AM


Please respond to arslist@ARSLIST.ORG

Sent by: ARSLIST@ARSLIST.ORG

To: ARSLIST

cc:


Subject: ARERR [306] is there a Max Push size?


When trying to push a large field (view form) into another ARform field
database input length is 500
it is a character / edit type.
You can manually type in 500 characters no problem

But I am using an active link button for manual testing is it is giving me
the following error.
ARERR [306] Value does not fall within the limits specified for the field :
(max length - 255) : CSCWS : Problem Description

But the Field is 500

Is there a Limitation of What size you can PUSH ?
I would think If I had a 4000 character field and wanted to push it then it
would do it fine..

The Active link says the following.
>Action
Push fields
if 0=1
Create new request
take no action

Field: Problem Description (( "CSRD- " + $Request ID$) + "
REQ: ") + SUBSTR($REQUIREMENT$,0,475)

so the Text should look like
CSRD- 03-0345 REQ: << 475 characters from the $REQUIREMENTS$ Field >>

Did I type that incorrect ? it looks right to me ..



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org (Support:
mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT SERVICES at
www.QMXS.com

(See attached file: C.htm)



This message and any attachments (the "message") is
intended solely for the addressees and is confidential.
If you receive this message in error, please delete it and
immediately notify the sender. Any use not in accord with
its purpose, any dissemination or disclosure, either whole
or partial, is prohibited except formal approval. The internet
can not guarantee the integrity of this message.
BNP PARIBAS (and its subsidiaries) shall (will) not
therefore be liable for the message if modified.

---------------------------------------------

Ce message et toutes les pieces jointes (ci-apres le
"message") sont etablis a l'intention exclusive de ses
destinataires et sont confidentiels. Si vous recevez ce
message par erreur, merci de le detruire et d'en avertir
immediatement l'expediteur. Toute utilisation de ce
message non conforme a sa destination, toute diffusion
ou toute publication, totale ou partielle, est interdite, sauf
autorisation expresse. L'internet ne permettant pas
d'assurer l'integrite de ce message, BNP PARIBAS (et ses
filiales) decline(nt) toute responsabilite au titre de ce
message, dans l'hypothese ou il aurait ete modifie.

1000 Into 500
I kept it under the limit..
476 characters + 19 = 495
I did put it down to 456 and it did not make a difference..

I wonder....
I originally (once) had this field at 255 in oracle.
I changed it to 500, Is there some Table that remedy is looking at first..
Or does it just try to write to the table and then figure out if it is too
small ?

-----Original Message-----
From: Jose Leon [mailto:jose.leon@AMERICAS.BNPPARIBAS.COM]
Sent: Tuesday, June 10, 2003 11:06 AM
To: ARSLIST@ARSLIST.ORG
Subject: Re: ARERR [306] is there a Max Push size?



Whats the total database size of the SOURCE and the DESTINATION fields? Jose
Leon



Internet
Patrick.Zandi@RL.AF.MIL@ARSLIST.ORG - 06/10/2003 10:20 AM


Please respond to arslist@ARSLIST.ORG

Sent by: ARSLIST@ARSLIST.ORG

To: ARSLIST

cc:


Subject: ARERR [306] is there a Max Push size?


When trying to push a large field (view form) into another ARform field
database input length is 500 it is a character / edit type. You can manually
type in 500 characters no problem

But I am using an active link button for manual testing is it is giving me
the following error. ARERR [306] Value does not fall within the limits
specified for the field : (max length - 255) : CSCWS : Problem Description

But the Field is 500

Is there a Limitation of What size you can PUSH ?
I would think If I had a 4000 character field and wanted to push it then it
would do it fine..

The Active link says the following.
>Action
Push fields
if 0=1
Create new request
take no action

Field: Problem Description (( "CSRD- " + $Request ID$) + "
REQ: ") + SUBSTR($REQUIREMENT$,0,475)

so the Text should look like
CSRD- 03-0345 REQ: << 475 characters from the $REQUIREMENTS$ Field >>

Did I type that incorrect ? it looks right to me ..




UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org (Support:
mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT SERVICES at
www.QMXS.com

(See attached file: C.htm)



This message and any attachments (the "message") is
intended solely for the addressees and is confidential.
If you receive this message in error, please delete it and immediately
notify the sender. Any use not in accord with its purpose, any dissemination
or disclosure, either whole or partial, is prohibited except formal
approval. The internet can not guarantee the integrity of this message. BNP
PARIBAS (and its subsidiaries) shall (will) not therefore be liable for the
message if modified.

---------------------------------------------

Ce message et toutes les pieces jointes (ci-apres le
"message") sont etablis a l'intention exclusive de ses destinataires et sont
confidentiels. Si vous recevez ce message par erreur, merci de le detruire
et d'en avertir immediatement l'expediteur. Toute utilisation de ce message
non conforme a sa destination, toute diffusion ou toute publication, totale
ou partielle, est interdite, sauf autorisation expresse. L'internet ne
permettant pas d'assurer l'integrite de ce message, BNP PARIBAS (et ses
filiales) decline(nt) toute responsabilite au titre de ce message, dans
l'hypothese ou il aurait ete modifie.




UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org (Support:
mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT SERVICES at
www.QMXS.com

**
It is 1000 Characters.
the ARForm Native that it is going into is 500 char

-----Original Message-----
From: Guillaume.Rheault [mailto:Guillaume.Rheault@TARGET.COM]
Sent: Tuesday, June 10, 2003 11:06 AM
To: ARSLIST@ARSLIST.ORG
Subject: Re: ARERR [306] is there a Max Push size?


**
Is the character field in the view form also 500 characters?

Guillaume

-----Original Message-----
From: Zandi Patrick S TSgt AFRL/IFOSS [mailto:Patrick.Zandi@RL.AF.MIL]
Sent: Tuesday, June 10, 2003 9:21 AM
To: ARSLIST@ARSLIST.ORG
Subject: ARERR [306] is there a Max Push size?


**
When trying to push a large field (view form) into another ARform field database input length is 500
it is a character / edit type.
You can manually type in 500 characters no problem

But I am using an active link button for manual testing is it is giving me the following error.
ARERR [306] Value does not fall within the limits specified for the field : (max length - 255) : CSCWS : Problem Description

But the Field is 500

Is there a Limitation of What size you can PUSH ?
I would think If I had a 4000 character field and wanted to push it then it would do it fine..

The Active link says the following.
>Action
Push fields
if 0=1
Create new request
take no action

Field: Problem Description (( "CSRD- " + $Request ID$) + " REQ: ") + SUBSTR($REQUIREMENT$,0,475)

so the Text should look like
CSRD- 03-0345 REQ: << 475 characters from the $REQUIREMENTS$ Field >>

Did I type that incorrect ? it looks right to me ..
This posting was submitted via the Web interface

This posting was submitted via the Web interface

This posting was submitted via the Web interface

I would log into the DB and do a describe on the T table related to your
form,
to ensure the column related to the field is VARCHAR2(500)

-----Original Message-----
From: Zandi Patrick S TSgt AFRL/IFOSS [mailto:Patrick.Zandi@RL.AF.MIL]
Sent: Tuesday, June 10, 2003 12:02 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: ARERR [306] is there a Max Push size?


1000 Into 500
I kept it under the limit..
476 characters + 19 = 495
I did put it down to 456 and it did not make a difference..

I wonder....
I originally (once) had this field at 255 in oracle.
I changed it to 500, Is there some Table that remedy is looking at
first.. Or does it just try to write to the table and then figure out if
it is too small ?

-----Original Message-----
From: Jose Leon [mailto:jose.leon@AMERICAS.BNPPARIBAS.COM]
Sent: Tuesday, June 10, 2003 11:06 AM
To: ARSLIST@ARSLIST.ORG
Subject: Re: ARERR [306] is there a Max Push size?



Whats the total database size of the SOURCE and the DESTINATION fields?
Jose Leon



Internet
Patrick.Zandi@RL.AF.MIL@ARSLIST.ORG - 06/10/2003 10:20 AM


Please respond to arslist@ARSLIST.ORG

Sent by: ARSLIST@ARSLIST.ORG

To: ARSLIST

cc:


Subject: ARERR [306] is there a Max Push size?


When trying to push a large field (view form) into another ARform field
database input length is 500 it is a character / edit type. You can
manually type in 500 characters no problem

But I am using an active link button for manual testing is it is giving
me the following error. ARERR [306] Value does not fall within the
limits specified for the field : (max length - 255) : CSCWS : Problem
Description

But the Field is 500

Is there a Limitation of What size you can PUSH ?
I would think If I had a 4000 character field and wanted to push it then
it would do it fine..

The Active link says the following.
>Action
Push fields
if 0=1
Create new request
take no action

Field: Problem Description (( "CSRD- " + $Request ID$) + "
REQ: ") + SUBSTR($REQUIREMENT$,0,475)

so the Text should look like
CSRD- 03-0345 REQ: << 475 characters from the $REQUIREMENTS$ Field
>>

Did I type that incorrect ? it looks right to me ..





UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com

(See attached file: C.htm)



This message and any attachments (the "message") is
intended solely for the addressees and is confidential.
If you receive this message in error, please delete it and immediately
notify the sender. Any use not in accord with its purpose, any
dissemination or disclosure, either whole or partial, is prohibited
except formal approval. The internet can not guarantee the integrity of
this message. BNP PARIBAS (and its subsidiaries) shall (will) not
therefore be liable for the message if modified.

---------------------------------------------

Ce message et toutes les pieces jointes (ci-apres le
"message") sont etablis a l'intention exclusive de ses destinataires et
sont confidentiels. Si vous recevez ce message par erreur, merci de le
detruire et d'en avertir immediatement l'expediteur. Toute utilisation
de ce message non conforme a sa destination, toute diffusion ou toute
publication, totale ou partielle, est interdite, sauf autorisation
expresse. L'internet ne permettant pas d'assurer l'integrite de ce
message, BNP PARIBAS (et ses
filiales) decline(nt) toute responsabilite au titre de ce message, dans
l'hypothese ou il aurait ete modifie.





UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com

Just checked that.. It C536870920 VARCHAR2; 500; No Scale, Nulls selected
Looks Clean.

Also: sidebar: Rheault, have you ever made your tables in cache.. Like this
ALTER TABLE "ARADMIN"."T262" MODIFY("C536870920" VARCHAR2(500))
CACHE

Just asking... Have you seen benefits.

-----Original Message-----
From: Guillaume.Rheault [mailto:Guillaume.Rheault@TARGET.COM]
Sent: Tuesday, June 10, 2003 1:39 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: ARERR [306] is there a Max Push size?


I would log into the DB and do a describe on the T table related to your
form, to ensure the column related to the field is VARCHAR2(500)

-----Original Message-----
From: Zandi Patrick S TSgt AFRL/IFOSS [mailto:Patrick.Zandi@RL.AF.MIL]
Sent: Tuesday, June 10, 2003 12:02 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: ARERR [306] is there a Max Push size?


1000 Into 500
I kept it under the limit..
476 characters + 19 = 495
I did put it down to 456 and it did not make a difference..

I wonder....
I originally (once) had this field at 255 in oracle.
I changed it to 500, Is there some Table that remedy is looking at first..
Or does it just try to write to the table and then figure out if it is too
small ?

-----Original Message-----
From: Jose Leon [mailto:jose.leon@AMERICAS.BNPPARIBAS.COM]
Sent: Tuesday, June 10, 2003 11:06 AM
To: ARSLIST@ARSLIST.ORG
Subject: Re: ARERR [306] is there a Max Push size?



Whats the total database size of the SOURCE and the DESTINATION fields? Jose
Leon



Internet
Patrick.Zandi@RL.AF.MIL@ARSLIST.ORG - 06/10/2003 10:20 AM


Please respond to arslist@ARSLIST.ORG

Sent by: ARSLIST@ARSLIST.ORG

To: ARSLIST

cc:


Subject: ARERR [306] is there a Max Push size?


When trying to push a large field (view form) into another ARform field
database input length is 500 it is a character / edit type. You can manually
type in 500 characters no problem

But I am using an active link button for manual testing is it is giving me
the following error. ARERR [306] Value does not fall within the limits
specified for the field : (max length - 255) : CSCWS : Problem Description

But the Field is 500

Is there a Limitation of What size you can PUSH ?
I would think If I had a 4000 character field and wanted to push it then it
would do it fine..

The Active link says the following.
>Action
Push fields
if 0=1
Create new request
take no action

Field: Problem Description (( "CSRD- " + $Request ID$) + "
REQ: ") + SUBSTR($REQUIREMENT$,0,475)

so the Text should look like
CSRD- 03-0345 REQ: << 475 characters from the $REQUIREMENTS$ Field
>>

Did I type that incorrect ? it looks right to me ..





UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com

(See attached file: C.htm)



This message and any attachments (the "message") is
intended solely for the addressees and is confidential.
If you receive this message in error, please delete it and immediately
notify the sender. Any use not in accord with its purpose, any dissemination
or disclosure, either whole or partial, is prohibited except formal
approval. The internet can not guarantee the integrity of this message. BNP
PARIBAS (and its subsidiaries) shall (will) not therefore be liable for the
message if modified.

---------------------------------------------

Ce message et toutes les pieces jointes (ci-apres le
"message") sont etablis a l'intention exclusive de ses destinataires et sont
confidentiels. Si vous recevez ce message par erreur, merci de le detruire
et d'en avertir immediatement l'expediteur. Toute utilisation de ce message
non conforme a sa destination, toute diffusion ou toute publication, totale
ou partielle, est interdite, sauf autorisation expresse. L'internet ne
permettant pas d'assurer l'integrite de ce message, BNP PARIBAS (et ses
filiales) decline(nt) toute responsabilite au titre de ce message, dans
l'hypothese ou il aurait ete modifie.





UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org (Support:
mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT SERVICES at
www.QMXS.com

Thats where the problem is.
The SOURCE field is 1000. Even if the data is has a single character
Remedy is looking at 1000 and saying that it's too large to fit into the
DESTINATION field of 500.

Either decrease the database size of the SOURCE (by deleting the field
and recreating it - beware, backup ALL your data first) or increase the
size of the DESTINATION (by the same methods as above - also backup
all the data in this form since deleting fields effectively deletes the
data).

Jose Leon



Internet
Patrick.Zandi@RL.AF.MIL@ARSLIST.ORG - 06/10/2003 01:02 PM


Please respond to arslist@ARSLIST.ORG

Sent by: ARSLIST@ARSLIST.ORG

To: ARSLIST

cc:


Subject: Re: ARERR [306] is there a Max Push size?


1000 Into 500
I kept it under the limit..
476 characters + 19 = 495
I did put it down to 456 and it did not make a difference..

I wonder....
I originally (once) had this field at 255 in oracle.
I changed it to 500, Is there some Table that remedy is looking at first..
Or does it just try to write to the table and then figure out if it is too
small ?

-----Original Message-----
From: Jose Leon [mailto:jose.leon@AMERICAS.BNPPARIBAS.COM]
Sent: Tuesday, June 10, 2003 11:06 AM
To: ARSLIST@ARSLIST.ORG
Subject: Re: ARERR [306] is there a Max Push size?



Whats the total database size of the SOURCE and the DESTINATION fields?
Jose
Leon



Internet
Patrick.Zandi@RL.AF.MIL@ARSLIST.ORG - 06/10/2003 10:20 AM


Please respond to arslist@ARSLIST.ORG

Sent by: ARSLIST@ARSLIST.ORG

To: ARSLIST

cc:


Subject: ARERR [306] is there a Max Push size?


When trying to push a large field (view form) into another ARform field
database input length is 500 it is a character / edit type. You can
manually
type in 500 characters no problem

But I am using an active link button for manual testing is it is giving me
the following error. ARERR [306] Value does not fall within the limits
specified for the field : (max length - 255) : CSCWS : Problem Description

But the Field is 500

Is there a Limitation of What size you can PUSH ?
I would think If I had a 4000 character field and wanted to push it then it
would do it fine..

The Active link says the following.
>Action
Push fields
if 0=1
Create new request
take no action

Field: Problem Description (( "CSRD- " + $Request ID$) + "
REQ: ") + SUBSTR($REQUIREMENT$,0,475)

so the Text should look like
CSRD- 03-0345 REQ: << 475 characters from the $REQUIREMENTS$ Field >>

Did I type that incorrect ? it looks right to me ..





UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org (Support:
mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT SERVICES at
www.QMXS.com

(See attached file: C.htm)



This message and any attachments (the "message") is
intended solely for the addressees and is confidential.
If you receive this message in error, please delete it and immediately
notify the sender. Any use not in accord with its purpose, any
dissemination
or disclosure, either whole or partial, is prohibited except formal
approval. The internet can not guarantee the integrity of this message. BNP
PARIBAS (and its subsidiaries) shall (will) not therefore be liable for the
message if modified.

---------------------------------------------

Ce message et toutes les pieces jointes (ci-apres le
"message") sont etablis a l'intention exclusive de ses destinataires et
sont
confidentiels. Si vous recevez ce message par erreur, merci de le detruire
et d'en avertir immediatement l'expediteur. Toute utilisation de ce message
non conforme a sa destination, toute diffusion ou toute publication, totale
ou partielle, est interdite, sauf autorisation expresse. L'internet ne
permettant pas d'assurer l'integrite de ce message, BNP PARIBAS (et ses
filiales) decline(nt) toute responsabilite au titre de ce message, dans
l'hypothese ou il aurait ete modifie.





UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org (Support:
mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT SERVICES at
www.QMXS.com



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org (Support:
mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT SERVICES at
www.QMXS.com





This message and any attachments (the "message") is
intended solely for the addressees and is confidential.
If you receive this message in error, please delete it and
immediately notify the sender. Any use not in accord with
its purpose, any dissemination or disclosure, either whole
or partial, is prohibited except formal approval. The internet
can not guarantee the integrity of this message.
BNP PARIBAS (and its subsidiaries) shall (will) not
therefore be liable for the message if modified.

---------------------------------------------

Ce message et toutes les pieces jointes (ci-apres le
"message") sont etablis a l'intention exclusive de ses
destinataires et sont confidentiels. Si vous recevez ce
message par erreur, merci de le detruire et d'en avertir
immediatement l'expediteur. Toute utilisation de ce
message non conforme a sa destination, toute diffusion
ou toute publication, totale ou partielle, est interdite, sauf
autorisation expresse. L'internet ne permettant pas
d'assurer l'integrite de ce message, BNP PARIBAS (et ses
filiales) decline(nt) toute responsabilite au titre de ce
message, dans l'hypothese ou il aurait ete modifie.

Issue 1: I would add a field, save the form, delete the field, save the
form, so the DB view gets recreated.

Issue 2: You would see a benefit in caching the table if table scans are
being done frequently on this table, frequently enough that the table
data is kept in memory. This scenario would be perfect for small lookup
tables that are frequently accessed. An alternative would be to
configure the keep pool, and pin the table in memory. At this point, I
am in the process of doing these kind of things over here, and I don't
have stats yet on the benefits

-----Original Message-----
From: Zandi Patrick S TSgt AFRL/IFOSS [mailto:Patrick.Zandi@RL.AF.MIL]
Sent: Tuesday, June 10, 2003 1:20 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: ARERR [306] is there a Max Push size?


Just checked that.. It C536870920 VARCHAR2; 500; No Scale, Nulls
selected Looks Clean.

Also: sidebar: Rheault, have you ever made your tables in cache.. Like
this ALTER TABLE "ARADMIN"."T262" MODIFY("C536870920" VARCHAR2(500))
CACHE

Just asking... Have you seen benefits.

-----Original Message-----
From: Guillaume.Rheault [mailto:Guillaume.Rheault@TARGET.COM]
Sent: Tuesday, June 10, 2003 1:39 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: ARERR [306] is there a Max Push size?


I would log into the DB and do a describe on the T table related to your
form, to ensure the column related to the field is VARCHAR2(500)

-----Original Message-----
From: Zandi Patrick S TSgt AFRL/IFOSS [mailto:Patrick.Zandi@RL.AF.MIL]
Sent: Tuesday, June 10, 2003 12:02 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: ARERR [306] is there a Max Push size?


1000 Into 500
I kept it under the limit..
476 characters + 19 = 495
I did put it down to 456 and it did not make a difference..

I wonder....
I originally (once) had this field at 255 in oracle.
I changed it to 500, Is there some Table that remedy is looking at
first.. Or does it just try to write to the table and then figure out if
it is too small ?

-----Original Message-----
From: Jose Leon [mailto:jose.leon@AMERICAS.BNPPARIBAS.COM]
Sent: Tuesday, June 10, 2003 11:06 AM
To: ARSLIST@ARSLIST.ORG
Subject: Re: ARERR [306] is there a Max Push size?



Whats the total database size of the SOURCE and the DESTINATION fields?
Jose Leon



Internet
Patrick.Zandi@RL.AF.MIL@ARSLIST.ORG - 06/10/2003 10:20 AM


Please respond to arslist@ARSLIST.ORG

Sent by: ARSLIST@ARSLIST.ORG

To: ARSLIST

cc:


Subject: ARERR [306] is there a Max Push size?


When trying to push a large field (view form) into another ARform field
database input length is 500 it is a character / edit type. You can
manually type in 500 characters no problem

But I am using an active link button for manual testing is it is giving
me the following error. ARERR [306] Value does not fall within the
limits specified for the field : (max length - 255) : CSCWS : Problem
Description

But the Field is 500

Is there a Limitation of What size you can PUSH ?
I would think If I had a 4000 character field and wanted to push it then
it would do it fine..

The Active link says the following.
>Action
Push fields
if 0=1
Create new request
take no action

Field: Problem Description (( "CSRD- " + $Request ID$) + "
REQ: ") + SUBSTR($REQUIREMENT$,0,475)

so the Text should look like
CSRD- 03-0345 REQ: << 475 characters from the $REQUIREMENTS$ Field
>>

Did I type that incorrect ? it looks right to me ..





UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com

(See attached file: C.htm)



This message and any attachments (the "message") is
intended solely for the addressees and is confidential.
If you receive this message in error, please delete it and immediately
notify the sender. Any use not in accord with its purpose, any
dissemination or disclosure, either whole or partial, is prohibited
except formal approval. The internet can not guarantee the integrity of
this message. BNP PARIBAS (and its subsidiaries) shall (will) not
therefore be liable for the message if modified.

---------------------------------------------

Ce message et toutes les pieces jointes (ci-apres le
"message") sont etablis a l'intention exclusive de ses destinataires et
sont confidentiels. Si vous recevez ce message par erreur, merci de le
detruire et d'en avertir immediatement l'expediteur. Toute utilisation
de ce message non conforme a sa destination, toute diffusion ou toute
publication, totale ou partielle, est interdite, sauf autorisation
expresse. L'internet ne permettant pas d'assurer l'integrite de ce
message, BNP PARIBAS (et ses
filiales) decline(nt) toute responsabilite au titre de ce message, dans
l'hypothese ou il aurait ete modifie.





UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com




UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com

What I would do is backup all the data (since deleting field effectively
deletes the data).
Then pick one of the fields thats causing the problems and copy the
database field ID
somewhere, delete that field, save the form. Now that the form is saved you
can recreate the
field to whatever name you want, but this time before you save the form
with the new field
PASTE the previous field ID in the database tab for the new field. This is
just a precaution
in case you have any workflow that used to reference that field.

Now go and using the import tool, import the data to that field only using
the unique request IDs.

Jose Leon



Internet
Guillaume.Rheault@TARGET.COM@ARSLIST.ORG - 06/10/2003 02:43 PM


Please respond to arslist@ARSLIST.ORG

Sent by: ARSLIST@ARSLIST.ORG

To: ARSLIST

cc:


Subject: Re: ARERR [306] is there a Max Push size?


Issue 1: I would add a field, save the form, delete the field, save the
form, so the DB view gets recreated.

Issue 2: You would see a benefit in caching the table if table scans are
being done frequently on this table, frequently enough that the table
data is kept in memory. This scenario would be perfect for small lookup
tables that are frequently accessed. An alternative would be to
configure the keep pool, and pin the table in memory. At this point, I
am in the process of doing these kind of things over here, and I don't
have stats yet on the benefits

-----Original Message-----
From: Zandi Patrick S TSgt AFRL/IFOSS [mailto:Patrick.Zandi@RL.AF.MIL]
Sent: Tuesday, June 10, 2003 1:20 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: ARERR [306] is there a Max Push size?


Just checked that.. It C536870920 VARCHAR2; 500; No Scale, Nulls
selected Looks Clean.

Also: sidebar: Rheault, have you ever made your tables in cache.. Like
this ALTER TABLE "ARADMIN"."T262" MODIFY("C536870920" VARCHAR2(500))
CACHE

Just asking... Have you seen benefits.

-----Original Message-----
From: Guillaume.Rheault [mailto:Guillaume.Rheault@TARGET.COM]
Sent: Tuesday, June 10, 2003 1:39 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: ARERR [306] is there a Max Push size?


I would log into the DB and do a describe on the T table related to your
form, to ensure the column related to the field is VARCHAR2(500)

-----Original Message-----
From: Zandi Patrick S TSgt AFRL/IFOSS [mailto:Patrick.Zandi@RL.AF.MIL]
Sent: Tuesday, June 10, 2003 12:02 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: ARERR [306] is there a Max Push size?


1000 Into 500
I kept it under the limit..
476 characters + 19 = 495
I did put it down to 456 and it did not make a difference..

I wonder....
I originally (once) had this field at 255 in oracle.
I changed it to 500, Is there some Table that remedy is looking at
first.. Or does it just try to write to the table and then figure out if
it is too small ?

-----Original Message-----
From: Jose Leon [mailto:jose.leon@AMERICAS.BNPPARIBAS.COM]
Sent: Tuesday, June 10, 2003 11:06 AM
To: ARSLIST@ARSLIST.ORG
Subject: Re: ARERR [306] is there a Max Push size?



Whats the total database size of the SOURCE and the DESTINATION fields?
Jose Leon



Internet
Patrick.Zandi@RL.AF.MIL@ARSLIST.ORG - 06/10/2003 10:20 AM


Please respond to arslist@ARSLIST.ORG

Sent by: ARSLIST@ARSLIST.ORG

To: ARSLIST

cc:


Subject: ARERR [306] is there a Max Push size?


When trying to push a large field (view form) into another ARform field
database input length is 500 it is a character / edit type. You can
manually type in 500 characters no problem

But I am using an active link button for manual testing is it is giving
me the following error. ARERR [306] Value does not fall within the
limits specified for the field : (max length - 255) : CSCWS : Problem
Description

But the Field is 500

Is there a Limitation of What size you can PUSH ?
I would think If I had a 4000 character field and wanted to push it then
it would do it fine..

The Active link says the following.
>Action
Push fields
if 0=1
Create new request
take no action

Field: Problem Description (( "CSRD- " + $Request ID$) + "
REQ: ") + SUBSTR($REQUIREMENT$,0,475)

so the Text should look like
CSRD- 03-0345 REQ: << 475 characters from the $REQUIREMENTS$ Field
>>

Did I type that incorrect ? it looks right to me ..





UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com

(See attached file: C.htm)



This message and any attachments (the "message") is
intended solely for the addressees and is confidential.
If you receive this message in error, please delete it and immediately
notify the sender. Any use not in accord with its purpose, any
dissemination or disclosure, either whole or partial, is prohibited
except formal approval. The internet can not guarantee the integrity of
this message. BNP PARIBAS (and its subsidiaries) shall (will) not
therefore be liable for the message if modified.

---------------------------------------------

Ce message et toutes les pieces jointes (ci-apres le
"message") sont etablis a l'intention exclusive de ses destinataires et
sont confidentiels. Si vous recevez ce message par erreur, merci de le
detruire et d'en avertir immediatement l'expediteur. Toute utilisation
de ce message non conforme a sa destination, toute diffusion ou toute
publication, totale ou partielle, est interdite, sauf autorisation
expresse. L'internet ne permettant pas d'assurer l'integrite de ce
message, BNP PARIBAS (et ses
filiales) decline(nt) toute responsabilite au titre de ce message, dans
l'hypothese ou il aurait ete modifie.





UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com




UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org (Support:
mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT SERVICES at
www.QMXS.com





This message and any attachments (the "message") is
intended solely for the addressees and is confidential.
If you receive this message in error, please delete it and
immediately notify the sender. Any use not in accord with
its purpose, any dissemination or disclosure, either whole
or partial, is prohibited except formal approval. The internet
can not guarantee the integrity of this message.
BNP PARIBAS (and its subsidiaries) shall (will) not
therefore be liable for the message if modified.

---------------------------------------------

Ce message et toutes les pieces jointes (ci-apres le
"message") sont etablis a l'intention exclusive de ses
destinataires et sont confidentiels. Si vous recevez ce
message par erreur, merci de le detruire et d'en avertir
immediatement l'expediteur. Toute utilisation de ce
message non conforme a sa destination, toute diffusion
ou toute publication, totale ou partielle, est interdite, sauf
autorisation expresse. L'internet ne permettant pas
d'assurer l'integrite de ce message, BNP PARIBAS (et ses
filiales) decline(nt) toute responsabilite au titre de ce
message, dans l'hypothese ou il aurait ete modifie.

How about changing the push to do a LEFT($SourceField$,500) to guarantee
that it can never overflow the target.

Fred

-----Original Message-----
From: Zandi Patrick S TSgt AFRL/IFOSS [mailto:Patrick.Zandi@RL.AF.MIL]
Sent: Tuesday, June 10, 2003 12:02 PM
To: ARSLIST@ARSLIST.ORG
Subject: Suspected SPAM: Re: ARERR [306] is there a Max Push size?


1000 Into 500
I kept it under the limit..
476 characters + 19 = 495
I did put it down to 456 and it did not make a difference..

I wonder....
I originally (once) had this field at 255 in oracle.
I changed it to 500, Is there some Table that remedy is looking at
first.. Or does it just try to write to the table and then figure out if
it is too small ?

-----Original Message-----
From: Jose Leon [mailto:jose.leon@AMERICAS.BNPPARIBAS.COM]
Sent: Tuesday, June 10, 2003 11:06 AM
To: ARSLIST@ARSLIST.ORG
Subject: Re: ARERR [306] is there a Max Push size?



Whats the total database size of the SOURCE and the DESTINATION fields?
Jose Leon



Internet
Patrick.Zandi@RL.AF.MIL@ARSLIST.ORG - 06/10/2003 10:20 AM


Please respond to arslist@ARSLIST.ORG

Sent by: ARSLIST@ARSLIST.ORG

To: ARSLIST

cc:


Subject: ARERR [306] is there a Max Push size?


When trying to push a large field (view form) into another ARform field
database input length is 500 it is a character / edit type. You can
manually type in 500 characters no problem

But I am using an active link button for manual testing is it is giving
me the following error. ARERR [306] Value does not fall within the
limits specified for the field : (max length - 255) : CSCWS : Problem
Description

But the Field is 500

Is there a Limitation of What size you can PUSH ?
I would think If I had a 4000 character field and wanted to push it then
it would do it fine..

The Active link says the following.
>Action
Push fields
if 0=1
Create new request
take no action

Field: Problem Description (( "CSRD- " + $Request ID$) + "
REQ: ") + SUBSTR($REQUIREMENT$,0,475)

so the Text should look like
CSRD- 03-0345 REQ: << 475 characters from the $REQUIREMENTS$ Field
>>

Did I type that incorrect ? it looks right to me ..





UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com

(See attached file: C.htm)



This message and any attachments (the "message") is
intended solely for the addressees and is confidential.
If you receive this message in error, please delete it and immediately
notify the sender. Any use not in accord with its purpose, any
dissemination or disclosure, either whole or partial, is prohibited
except formal approval. The internet can not guarantee the integrity of
this message. BNP PARIBAS (and its subsidiaries) shall (will) not
therefore be liable for the message if modified.

---------------------------------------------

Ce message et toutes les pieces jointes (ci-apres le
"message") sont etablis a l'intention exclusive de ses destinataires et
sont confidentiels. Si vous recevez ce message par erreur, merci de le
detruire et d'en avertir immediatement l'expediteur. Toute utilisation
de ce message non conforme a sa destination, toute diffusion ou toute
publication, totale ou partielle, est interdite, sauf autorisation
expresse. L'internet ne permettant pas d'assurer l'integrite de ce
message, BNP PARIBAS (et ses
filiales) decline(nt) toute responsabilite au titre de ce message, dans
l'hypothese ou il aurait ete modifie.





UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com

**
Zandi,

Match the data input length of the source and destination fields... That should resolve your problem...

Regards

Joe DeSouza
Remedy Technical Consultant,
CyberMAK Information Systems,
Kuwait.
Mobile: 00965 9406129
Office: 00965 4847068 Ext.. 113

Food for thought:
You know you're a computer nerd when you know more IP addresses than phone numbers!


----- Original Message -----
From: Zandi Patrick S TSgt AFRL/IFOSS
Newsgroups: public.remedy.arsystem.general
To: ARSLIST@ARSLIST.ORG
Sent: Tuesday, June 10, 2003 5:20 PM
Subject: ARERR [306] is there a Max Push size?

**
When trying to push a large field (view form) into another ARform field database input length is 500
it is a character / edit type.
You can manually type in 500 characters no problem

But I am using an active link button for manual testing is it is giving me the following error.
ARERR [306] Value does not fall within the limits specified for the field : (max length - 255) : CSCWS : Problem Description

But the Field is 500

Is there a Limitation of What size you can PUSH ?
I would think If I had a 4000 character field and wanted to push it then it would do it fine..

The Active link says the following.
>Action
Push fields
if 0=1
Create new request
take no action

Field: Problem Description (( "CSRD- " + $Request ID$) + " REQ: ") + SUBSTR($REQUIREMENT$,0,475)

so the Text should look like
CSRD- 03-0345 REQ: << 475 characters from the $REQUIREMENTS$ Field >>

Did I type that incorrect ? it looks right to me ..
This posting was submitted via the Web interface

This posting was submitted via the Web interface

I tried the Left, get the same answer.
Huh.. Weird. Support ticket time..
Just to make sure..

-----Original Message-----
From: Grooms, Frederick W [mailto:frederick.w.grooms@XO.COM]
Sent: Tuesday, June 10, 2003 4:03 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: ARERR [306] is there a Max Push size?


How about changing the push to do a LEFT($SourceField$,500) to guarantee
that it can never overflow the target.

Fred

-----Original Message-----
From: Zandi Patrick S TSgt AFRL/IFOSS [mailto:Patrick.Zandi@RL.AF.MIL]
Sent: Tuesday, June 10, 2003 12:02 PM
To: ARSLIST@ARSLIST.ORG
Subject: Suspected SPAM: Re: ARERR [306] is there a Max Push size?


1000 Into 500
I kept it under the limit..
476 characters + 19 = 495
I did put it down to 456 and it did not make a difference..

I wonder....
I originally (once) had this field at 255 in oracle.
I changed it to 500, Is there some Table that remedy is looking at first..
Or does it just try to write to the table and then figure out if it is too
small ?

-----Original Message-----
From: Jose Leon [mailto:jose.leon@AMERICAS.BNPPARIBAS.COM]
Sent: Tuesday, June 10, 2003 11:06 AM
To: ARSLIST@ARSLIST.ORG
Subject: Re: ARERR [306] is there a Max Push size?



Whats the total database size of the SOURCE and the DESTINATION fields? Jose
Leon



Internet
Patrick.Zandi@RL.AF.MIL@ARSLIST.ORG - 06/10/2003 10:20 AM


Please respond to arslist@ARSLIST.ORG

Sent by: ARSLIST@ARSLIST.ORG

To: ARSLIST

cc:


Subject: ARERR [306] is there a Max Push size?


When trying to push a large field (view form) into another ARform field
database input length is 500 it is a character / edit type. You can manually
type in 500 characters no problem

But I am using an active link button for manual testing is it is giving me
the following error. ARERR [306] Value does not fall within the limits
specified for the field : (max length - 255) : CSCWS : Problem Description

But the Field is 500

Is there a Limitation of What size you can PUSH ?
I would think If I had a 4000 character field and wanted to push it then it
would do it fine..

The Active link says the following.
>Action
Push fields
if 0=1
Create new request
take no action

Field: Problem Description (( "CSRD- " + $Request ID$) + "
REQ: ") + SUBSTR($REQUIREMENT$,0,475)

so the Text should look like
CSRD- 03-0345 REQ: << 475 characters from the $REQUIREMENTS$ Field
>>

Did I type that incorrect ? it looks right to me ..





UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com

(See attached file: C.htm)



This message and any attachments (the "message") is
intended solely for the addressees and is confidential.
If you receive this message in error, please delete it and immediately
notify the sender. Any use not in accord with its purpose, any dissemination
or disclosure, either whole or partial, is prohibited except formal
approval. The internet can not guarantee the integrity of this message. BNP
PARIBAS (and its subsidiaries) shall (will) not therefore be liable for the
message if modified.

---------------------------------------------

Ce message et toutes les pieces jointes (ci-apres le
"message") sont etablis a l'intention exclusive de ses destinataires et sont
confidentiels. Si vous recevez ce message par erreur, merci de le detruire
et d'en avertir immediatement l'expediteur. Toute utilisation de ce message
non conforme a sa destination, toute diffusion ou toute publication, totale
ou partielle, est interdite, sauf autorisation expresse. L'internet ne
permettant pas d'assurer l'integrite de ce message, BNP PARIBAS (et ses
filiales) decline(nt) toute responsabilite au titre de ce message, dans
l'hypothese ou il aurait ete modifie.





UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org (Support:
mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT SERVICES at
www.QMXS.com

#1 Absolutely no change..
And I changed it to a left($FIELD$,470) so I know I am under the 500

#2 Thanks
#3.. Remedy Ticket Away !

-----Original Message-----
From: Guillaume.Rheault [mailto:Guillaume.Rheault@TARGET.COM]
Sent: Tuesday, June 10, 2003 2:44 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: ARERR [306] is there a Max Push size?


Issue 1: I would add a field, save the form, delete the field, save the
form, so the DB view gets recreated.

Issue 2: You would see a benefit in caching the table if table scans are
being done frequently on this table, frequently enough that the table data
is kept in memory. This scenario would be perfect for small lookup tables
that are frequently accessed. An alternative would be to configure the keep
pool, and pin the table in memory. At this point, I am in the process of
doing these kind of things over here, and I don't have stats yet on the
benefits

-----Original Message-----
From: Zandi Patrick S TSgt AFRL/IFOSS [mailto:Patrick.Zandi@RL.AF.MIL]
Sent: Tuesday, June 10, 2003 1:20 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: ARERR [306] is there a Max Push size?


Just checked that.. It C536870920 VARCHAR2; 500; No Scale, Nulls selected
Looks Clean.

Also: sidebar: Rheault, have you ever made your tables in cache.. Like this
ALTER TABLE "ARADMIN"."T262" MODIFY("C536870920" VARCHAR2(500))
CACHE

Just asking... Have you seen benefits.

-----Original Message-----
From: Guillaume.Rheault [mailto:Guillaume.Rheault@TARGET.COM]
Sent: Tuesday, June 10, 2003 1:39 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: ARERR [306] is there a Max Push size?


I would log into the DB and do a describe on the T table related to your
form, to ensure the column related to the field is VARCHAR2(500)

-----Original Message-----
From: Zandi Patrick S TSgt AFRL/IFOSS [mailto:Patrick.Zandi@RL.AF.MIL]
Sent: Tuesday, June 10, 2003 12:02 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: ARERR [306] is there a Max Push size?


1000 Into 500
I kept it under the limit..
476 characters + 19 = 495
I did put it down to 456 and it did not make a difference..

I wonder....
I originally (once) had this field at 255 in oracle.
I changed it to 500, Is there some Table that remedy is looking at first..
Or does it just try to write to the table and then figure out if it is too
small ?

-----Original Message-----
From: Jose Leon [mailto:jose.leon@AMERICAS.BNPPARIBAS.COM]
Sent: Tuesday, June 10, 2003 11:06 AM
To: ARSLIST@ARSLIST.ORG
Subject: Re: ARERR [306] is there a Max Push size?



Whats the total database size of the SOURCE and the DESTINATION fields? Jose
Leon



Internet
Patrick.Zandi@RL.AF.MIL@ARSLIST.ORG - 06/10/2003 10:20 AM


Please respond to arslist@ARSLIST.ORG

Sent by: ARSLIST@ARSLIST.ORG

To: ARSLIST

cc:


Subject: ARERR [306] is there a Max Push size?


When trying to push a large field (view form) into another ARform field
database input length is 500 it is a character / edit type. You can manually
type in 500 characters no problem

But I am using an active link button for manual testing is it is giving me
the following error. ARERR [306] Value does not fall within the limits
specified for the field : (max length - 255) : CSCWS : Problem Description

But the Field is 500

Is there a Limitation of What size you can PUSH ?
I would think If I had a 4000 character field and wanted to push it then it
would do it fine..

The Active link says the following.
>Action
Push fields
if 0=1
Create new request
take no action

Field: Problem Description (( "CSRD- " + $Request ID$) + "
REQ: ") + SUBSTR($REQUIREMENT$,0,475)

so the Text should look like
CSRD- 03-0345 REQ: << 475 characters from the $REQUIREMENTS$ Field
>>

Did I type that incorrect ? it looks right to me ..





UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com

(See attached file: C.htm)



This message and any attachments (the "message") is
intended solely for the addressees and is confidential.
If you receive this message in error, please delete it and immediately
notify the sender. Any use not in accord with its purpose, any dissemination
or disclosure, either whole or partial, is prohibited except formal
approval. The internet can not guarantee the integrity of this message. BNP
PARIBAS (and its subsidiaries) shall (will) not therefore be liable for the
message if modified.

---------------------------------------------

Ce message et toutes les pieces jointes (ci-apres le
"message") sont etablis a l'intention exclusive de ses destinataires et sont
confidentiels. Si vous recevez ce message par erreur, merci de le detruire
et d'en avertir immediatement l'expediteur. Toute utilisation de ce message
non conforme a sa destination, toute diffusion ou toute publication, totale
ou partielle, est interdite, sauf autorisation expresse. L'internet ne
permettant pas d'assurer l'integrite de ce message, BNP PARIBAS (et ses
filiales) decline(nt) toute responsabilite au titre de ce message, dans
l'hypothese ou il aurait ete modifie.





UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com




UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org (Support:
mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT SERVICES at
www.QMXS.com

#2 Final:
After testing on mid-tier I am seeing HUGE improvements, the JSP
engine just Fly's through now.
Extremely fast almost like HTML.. Just thought I would pass the basic
ramifications on to you all.


-----Original Message-----
From: Zandi Patrick S TSgt AFRL/IFOSS
Sent: Thursday, June 12, 2003 1:00 PM
To: 'arslist@ARSLIST.ORG'
Subject: RE: ARERR [306] is there a Max Push size?


#2 After some playing.. In this arena..
Here is what I did. In the OEM through OMS or not. I went to the
schema, and the
Main tables, and selected the ones used most from other Display forms for
tables..
I cached them under Options, you can select for them to be cached. I
brought up the forms, What used to happen was : the form would display and
at the bottom
of the screen I auto loaded the $USER$ and Pre-Load the tables now
based on their
User NAME (tickets assigned directly to them) and Tickets assigned
to their Group,
All tickets in their group.
The Performance Difference was instant. The form used to come up and you
could Watch at the bottom of the screen them being loaded and the Query
happening. Total of 2 seconds.
Now you cannot even see it. Wham it comes up and the Data is there.

So At this point I would say the Performance increase was Significant.

I had to test this out on dev before I put it too Prod.. Both are happy now.
=8-> Thanks

-----Original Message-----
From: Guillaume.Rheault [mailto:Guillaume.Rheault@TARGET.COM]
Sent: Tuesday, June 10, 2003 2:44 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: ARERR [306] is there a Max Push size?


Issue 1: I would add a field, save the form, delete the field, save the
form, so the DB view gets recreated.

Issue 2: You would see a benefit in caching the table if table scans are
being done frequently on this table, frequently enough that the table data
is kept in memory. This scenario would be perfect for small lookup tables
that are frequently accessed. An alternative would be to configure the keep
pool, and pin the table in memory. At this point, I am in the process of
doing these kind of things over here, and I don't have stats yet on the
benefits

-----Original Message-----
From: Zandi Patrick S TSgt AFRL/IFOSS [mailto:Patrick.Zandi@RL.AF.MIL]
Sent: Tuesday, June 10, 2003 1:20 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: ARERR [306] is there a Max Push size?


Just checked that.. It C536870920 VARCHAR2; 500; No Scale, Nulls selected
Looks Clean.

Also: sidebar: Rheault, have you ever made your tables in cache.. Like this
ALTER TABLE "ARADMIN"."T262" MODIFY("C536870920" VARCHAR2(500))
CACHE

Just asking... Have you seen benefits.

-----Original Message-----
From: Guillaume.Rheault [mailto:Guillaume.Rheault@TARGET.COM]
Sent: Tuesday, June 10, 2003 1:39 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: ARERR [306] is there a Max Push size?


I would log into the DB and do a describe on the T table related to your
form, to ensure the column related to the field is VARCHAR2(500)

-----Original Message-----
From: Zandi Patrick S TSgt AFRL/IFOSS [mailto:Patrick.Zandi@RL.AF.MIL]
Sent: Tuesday, June 10, 2003 12:02 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: ARERR [306] is there a Max Push size?


1000 Into 500
I kept it under the limit..
476 characters + 19 = 495
I did put it down to 456 and it did not make a difference..

I wonder....
I originally (once) had this field at 255 in oracle.
I changed it to 500, Is there some Table that remedy is looking at first..
Or does it just try to write to the table and then figure out if it is too
small ?

-----Original Message-----
From: Jose Leon [mailto:jose.leon@AMERICAS.BNPPARIBAS.COM]
Sent: Tuesday, June 10, 2003 11:06 AM
To: ARSLIST@ARSLIST.ORG
Subject: Re: ARERR [306] is there a Max Push size?



Whats the total database size of the SOURCE and the DESTINATION fields? Jose
Leon



Internet
Patrick.Zandi@RL.AF.MIL@ARSLIST.ORG - 06/10/2003 10:20 AM


Please respond to arslist@ARSLIST.ORG

Sent by: ARSLIST@ARSLIST.ORG

To: ARSLIST

cc:


Subject: ARERR [306] is there a Max Push size?


When trying to push a large field (view form) into another ARform field
database input length is 500 it is a character / edit type. You can manually
type in 500 characters no problem

But I am using an active link button for manual testing is it is giving me
the following error. ARERR [306] Value does not fall within the limits
specified for the field : (max length - 255) : CSCWS : Problem Description

But the Field is 500

Is there a Limitation of What size you can PUSH ?
I would think If I had a 4000 character field and wanted to push it then it
would do it fine..

The Active link says the following.
>Action
Push fields
if 0=1
Create new request
take no action

Field: Problem Description (( "CSRD- " + $Request ID$) + "
REQ: ") + SUBSTR($REQUIREMENT$,0,475)

so the Text should look like
CSRD- 03-0345 REQ: << 475 characters from the $REQUIREMENTS$ Field
>>

Did I type that incorrect ? it looks right to me ..





UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com

(See attached file: C.htm)



This message and any attachments (the "message") is
intended solely for the addressees and is confidential.
If you receive this message in error, please delete it and immediately
notify the sender. Any use not in accord with its purpose, any dissemination
or disclosure, either whole or partial, is prohibited except formal
approval. The internet can not guarantee the integrity of this message. BNP
PARIBAS (and its subsidiaries) shall (will) not therefore be liable for the
message if modified.

---------------------------------------------

Ce message et toutes les pieces jointes (ci-apres le
"message") sont etablis a l'intention exclusive de ses destinataires et sont
confidentiels. Si vous recevez ce message par erreur, merci de le detruire
et d'en avertir immediatement l'expediteur. Toute utilisation de ce message
non conforme a sa destination, toute diffusion ou toute publication, totale
ou partielle, est interdite, sauf autorisation expresse. L'internet ne
permettant pas d'assurer l'integrite de ce message, BNP PARIBAS (et ses
filiales) decline(nt) toute responsabilite au titre de ce message, dans
l'hypothese ou il aurait ete modifie.





UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com




UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org (Support:
mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT SERVICES at
www.QMXS.com

#2 After some playing.. In this arena..
Here is what I did. In the OEM through OMS or not. I went to the
schema, and the
Main tables, and selected the ones used most from other Display forms for
tables..
I cached them under Options, you can select for them to be cached.
I brought up the forms, What used to happen was : the form would display and
at the bottom
of the screen I auto loaded the $USER$ and Pre-Load the tables now
based on their
User NAME (tickets assigned directly to them) and Tickets assigned
to their Group,
All tickets in their group.
The Performance Difference was instant. The form used to come up and you
could Watch at the bottom of the screen them being loaded and the Query
happening. Total of 2 seconds.
Now you cannot even see it. Wham it comes up and the Data is there.

So At this point I would say the Performance increase was Significant.

I had to test this out on dev before I put it too Prod.. Both are happy now.
=8->
Thanks

-----Original Message-----
From: Guillaume.Rheault [mailto:Guillaume.Rheault@TARGET.COM]
Sent: Tuesday, June 10, 2003 2:44 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: ARERR [306] is there a Max Push size?


Issue 1: I would add a field, save the form, delete the field, save the
form, so the DB view gets recreated.

Issue 2: You would see a benefit in caching the table if table scans are
being done frequently on this table, frequently enough that the table data
is kept in memory. This scenario would be perfect for small lookup tables
that are frequently accessed. An alternative would be to configure the keep
pool, and pin the table in memory. At this point, I am in the process of
doing these kind of things over here, and I don't have stats yet on the
benefits

-----Original Message-----
From: Zandi Patrick S TSgt AFRL/IFOSS [mailto:Patrick.Zandi@RL.AF.MIL]
Sent: Tuesday, June 10, 2003 1:20 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: ARERR [306] is there a Max Push size?


Just checked that.. It C536870920 VARCHAR2; 500; No Scale, Nulls selected
Looks Clean.

Also: sidebar: Rheault, have you ever made your tables in cache.. Like this
ALTER TABLE "ARADMIN"."T262" MODIFY("C536870920" VARCHAR2(500))
CACHE

Just asking... Have you seen benefits.

-----Original Message-----
From: Guillaume.Rheault [mailto:Guillaume.Rheault@TARGET.COM]
Sent: Tuesday, June 10, 2003 1:39 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: ARERR [306] is there a Max Push size?


I would log into the DB and do a describe on the T table related to your
form, to ensure the column related to the field is VARCHAR2(500)

-----Original Message-----
From: Zandi Patrick S TSgt AFRL/IFOSS [mailto:Patrick.Zandi@RL.AF.MIL]
Sent: Tuesday, June 10, 2003 12:02 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: ARERR [306] is there a Max Push size?


1000 Into 500
I kept it under the limit..
476 characters + 19 = 495
I did put it down to 456 and it did not make a difference..

I wonder....
I originally (once) had this field at 255 in oracle.
I changed it to 500, Is there some Table that remedy is looking at first..
Or does it just try to write to the table and then figure out if it is too
small ?

-----Original Message-----
From: Jose Leon [mailto:jose.leon@AMERICAS.BNPPARIBAS.COM]
Sent: Tuesday, June 10, 2003 11:06 AM
To: ARSLIST@ARSLIST.ORG
Subject: Re: ARERR [306] is there a Max Push size?



Whats the total database size of the SOURCE and the DESTINATION fields? Jose
Leon



Internet
Patrick.Zandi@RL.AF.MIL@ARSLIST.ORG - 06/10/2003 10:20 AM


Please respond to arslist@ARSLIST.ORG

Sent by: ARSLIST@ARSLIST.ORG

To: ARSLIST

cc:


Subject: ARERR [306] is there a Max Push size?


When trying to push a large field (view form) into another ARform field
database input length is 500 it is a character / edit type. You can manually
type in 500 characters no problem

But I am using an active link button for manual testing is it is giving me
the following error. ARERR [306] Value does not fall within the limits
specified for the field : (max length - 255) : CSCWS : Problem Description

But the Field is 500

Is there a Limitation of What size you can PUSH ?
I would think If I had a 4000 character field and wanted to push it then it
would do it fine..

The Active link says the following.
>Action
Push fields
if 0=1
Create new request
take no action

Field: Problem Description (( "CSRD- " + $Request ID$) + "
REQ: ") + SUBSTR($REQUIREMENT$,0,475)

so the Text should look like
CSRD- 03-0345 REQ: << 475 characters from the $REQUIREMENTS$ Field
>>

Did I type that incorrect ? it looks right to me ..





UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com

(See attached file: C.htm)



This message and any attachments (the "message") is
intended solely for the addressees and is confidential.
If you receive this message in error, please delete it and immediately
notify the sender. Any use not in accord with its purpose, any dissemination
or disclosure, either whole or partial, is prohibited except formal
approval. The internet can not guarantee the integrity of this message. BNP
PARIBAS (and its subsidiaries) shall (will) not therefore be liable for the
message if modified.

---------------------------------------------

Ce message et toutes les pieces jointes (ci-apres le
"message") sont etablis a l'intention exclusive de ses destinataires et sont
confidentiels. Si vous recevez ce message par erreur, merci de le detruire
et d'en avertir immediatement l'expediteur. Toute utilisation de ce message
non conforme a sa destination, toute diffusion ou toute publication, totale
ou partielle, est interdite, sauf autorisation expresse. L'internet ne
permettant pas d'assurer l'integrite de ce message, BNP PARIBAS (et ses
filiales) decline(nt) toute responsabilite au titre de ce message, dans
l'hypothese ou il aurait ete modifie.





UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com




UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org (Support:
mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT SERVICES at
www.QMXS.com