BPM Error The text size provided (1039 characters) is greater than the maximum allowable size of 1024 characters for column h_details

[Nikolaj]

Hello Support,

Can you please help me here. We get this error message for sending External Authorisation. It was working before so i do not know why. 

 

thanks and best regards

Nikolaj

[Victor]

@Nikolaj there is an element on the authorisation node (the details section) where the text length (possibly from a workflow variable) is greater than the maximum text length allowed for that element (the details section). How is the node configured? Specifically the details section of the node?

[Nikolaj]

@Victor we are using varible picker from the PCF

 

Business justification: &[functions.pcf("GuestAccountDetails","h_custom_e")]

Name, Vorname: &[functions.pcf("GuestAccountDetails","h_custom_a")]
Firma: &[functions.pcf("GuestAccountDetails","h_custom_b")]
Mail: &[functions.pcf("GuestAccountDetails","h_custom_c")]
NDA: &[functions.pcf("GuestAccountDetails","h_custom_f")]
Cloud Application: &[functions.pcf("GuestAccountDetails","h_custom_g")]

was there a change because I'm sure that was working before.

But could one of these be the problem

thanks

Nikolaj

[Victor]

@Nikolaj This is simply a case where text in Custom A, B, C, E, F and G, combined together, is more than 1024 in text size. It does not happen for every request because it depends on the content of these fields which can vary (the values are dynamic). It happened that on this occasion, on that request, these fields combined had exceeded the max size.

[Nikolaj]

@Victor ok thanks. can we improve this by a change of the fields or something? what can we do here or is it simple we have to reduce the characters.

Thanks

Nikolaj

 

[Steve Giller]

1 hour ago, Nikolaj said:

can we improve this by a change of the fields or something?

You can set a REGEX on Custom Form fields, this can be used to limit the length of the response.

Assuming you know the maximum length of the Vorname, Firma, Mail, NDA, and Cloud Application responses, you can calculate a maximum size for the Business Justification response and restrict either just that or all of the answers to ensure the combination is never exceeding the maximum length.
 

[Nikolaj]

@Steve Giller thanks i would like to use the REGEX for the field Business...... but I'm not sure how i can do that and on the wiki i just find this here. But the Button ? is not working or i don't know how it works. Can you please help me here. Thanks Nikolaj

• Validate Input with RegEx Expression

Including a RegEx Expression you can control how the user is to input the information into the field. Use the ? button to open the RegEx Selector to help with building your Expression.

[Nikolaj]

@Steve Gillerhere i think i have to type it in but i do not know what exactly. thanks Nikolaj

 

[Steve Giller]

Please check this as I'm far from a REGEX expert, but from memory the REGEX for 1024 characters is:

.{0,1024}

You will need to adjust the 1024 to the required number of characters.

[Nikolaj]

Hi @Steve Giller

i have found the right syntax for it

^[A-Za-z]{1,45}$

Thanks

Nikolaj

[Victor]

@Nikolaj are you sure that is the right syntax? The one you are using only allows letters. This means no other characters (like ; ? . , * _ ^ = + -)  and no numbers... so that expression is fine if you only expect letters in that filed but will not work if the text you expect can also have things like question marks, commas or numbers.

[Nikolaj]

@Victor thanks for your clarification. First i tried the this 

.{0,1024}

but that was not working. i think it is ok just to have only letters here. But i would be intressted how it will look if i just want to limit the characters doesn't matter which. I'm not an expert so maybe you can help me.

Thanks

Nikolaj

[Victor]

@Nikolaj try this:

^.{0,1024}$

Change the number (1024) to the number representing the maximum text length you would allow for that field. For example, if you only want to allow 32 characters to be typed into that field, then the expression you would use is: ^.{0,32}$

[Nikolaj]

Hi @Victor Ok thanks. Works