URL field not taking full length of url

anvitha ash
Tera Contributor

‎10-30-2023 12:25 PM

Hello, 

 

We have a table in which we have multiple URL fields with the same configuration(length - 1024)

 

Field1: below is the image, which is accepting more than 200char URL

anvithaash_0-1698692943952.png

 

Field2: below is the image, which is accepting only 40char URL

anvithaash_1-1698693140587.png

 

Below is the example how this 2 fields with same configuration is behaving. Field1 is taking entire URL, where Field2 is taking partial URL

 

anvithaash_2-1698693674663.png

 

Can someone please help me with the scenario. Thanks in advance 😊

 

 

 

0 Helpfuls
  • 521 Views
9 REPLIES 9

Jace Benson
Mega Sage
In response to Jace Benson

‎10-30-2023 12:52 PM

If the data is being filled in via an import set, it also could be the import set column writing to the second URL field on the import set has a lengh of 40.

0 Helpfuls

anvitha ash
Tera Contributor
In response to Jace Benson

‎10-30-2023 12:58 PM

Url is coming from run script. Even I tried to enter the url manually but still it's taking upto 40 chars 

0 Helpfuls

Jace Benson
Mega Sage
In response to anvitha ash

‎10-30-2023 01:04 PM

With out more details, it's not easy to help.  I recreated what I thought you had on my PDI on a new table and it works as I'd expect, which is both fields work.

JaceBenson_0-1698696263268.png

 

0 Helpfuls

Tony Chatfield1
Kilo Patron

‎10-30-2023 12:52 PM

Hi, unfortunately your post does not make your configuration very clear.

I am guessing that the first 2 images show the underpinning 'Type' of the Dictionary entries? (URL)

and probably have minimal relevance for your issue, as your concern is the Max length value for the 2 fields.

 

Taking a quick look in a PDI, the Max length seems to be is auto set to 1024 if the max Length is left empty on creation of URL type field, but it is possible to define a value during creation, also if the data type was changed to URL from another value then Max length does not look to be auto updated.
I would suggest that you start by reviewing the xml records for the 2 fields involved, to confirm the size of the Max length fields, then if this is the issue you can probably fix the incorrect field by setting the type to string, updating the Max Length and then resetting type to URL.

 

If this is not your issue then you might want to consider providing clear and specific details of your configuration, as a couple of partial screenshots do not add a lot of diagnostic value.

anvitha ash
Tera Contributor

‎11-01-2023 07:08 AM

@Jace Benson @Tony Chatfield1 , Thanks for all the way.

 

Got the solution and is working properly. I am pasting the troubleshooting steps 

 

  1.  Open the Dictionary record for the URL field
  2.  Change the Type to "String" (don't save yet)
  3.  The Max Length field will appear.
  4. Change the Max Length to 2,083 (or whatever you want)
  5. Change the Type back to URL
  6. Now you can save your changes