Field label not showing up correctly. Field label is showing up as the column name. Field is a new field added to a extended custom table.

timothy_hamano · ‎10-03-2014

in my DEV instance I created a new ticketing application. It was all created in a update set, it was tested and working exactly as designed. I completed the update set and transferred it to my PROD instance . . . I do not have a QA instance. When I started testing the PROD instance of the new application, the form view looks correct, but some of the fields on the form are show the field column name, not the label that it is supposed to be showing. I will attach a few screen shots.

from the DEV side:

from the DEV side from the form

what shows up in my PROD side:

what shows up in PROD on the form

when I right-click and 'personalize label' I get:

Mark Stanger · ‎10-03-2014

Check the Labels table (sys_documentation) for a label for that field and table combination. You should be able to see the field labels in a related list at the bottom of the dictionary entry, if it's not there then you can navigate directly to the sys_documentation table and view from there. My guess is that the actual Label entry doesn't exist and you'll need to recreate it and then update the 'Column label' field to match.

View solution in original post

urmilla · ‎04-11-2017

Thanks Anurag for that update. That sure is a whole lot of re-work. Do you have any idea why this issue usually occurs?

nthumma · ‎04-11-2017

urmilla

Can you answer this questions?

1) Is your custom table extended from any OOB table?

2) how many fields on your custom table?

3) how many string fields are there on your custom table?

urmilla · ‎04-11-2017

Yes It has been extended from the Task table. It currently has 243 custom fields out of which 18 are string fields.

nthumma · ‎04-11-2017

This issue might happen in three scenarios

1) if you deleted a field and re-create new field with the same name.

2)If you have too many string fields, MYSQL has some limitation on the number of VARCHAR fields on a table.

3)if you exceed Max no of columns allowed combination task table and the custom table is '589'.

I think your issue is related to 3), I strongly suggest to contact HI.

urmilla · ‎04-11-2017

Along with the task table the number of fields on my custom table is 309 only. Most of my fields on the table are choice fields. We are recapturing them with different column names hoping that this workaround will work as I see it has been mentioned in a couple of threads already. Will update if even that does not work.