Cannot create an Organization with a name with more than 75 characters in DB2

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.0.X, 7.1.X, Master
• Fix Version/s: 7.0.0 DXP FP80, 7.0.10.11 DXP SP11, 7.0.X, 7.1.10 DXP FP10, 7.1.10.2 SP2, 7.1.3 CE GA4, 7.1.X, Master
• Component/s: Environments > Databases, User Management > Users & Organizations
• Labels:
  • ee-ts
  • liferay-dxp-70-sp11
  • liferay-dxp-71-sp2
  • liferay-fixpack-de-80-7010
  • liferay-fixpack-dxp-10-7110
• Branch Version/s:
  7.1.x, 7.0.x
• Backported to Branch:
  Committed
• Story Points: 0.25
• Fix Priority: 3
• Databases:
  DB2 10.1, DB2 10.5, DB2 9.7
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/69973

Description:

When attempting to create an Organization with a name over 75 characters, DB2 throws an error due to column length.  However, the name column in the Organization table is 100 characters, so there is no issue there.  The problem is with the User_ table, specifically the screenName column, which is only 75 characters.  When creating the Org, LR attempts to validate the friendlyURL against the Group and User tables.  This change was added over 10 years ago, and now when creating new users, they are added to the Group table as well, so the solution will be to not check against the User table as it is no longer needed.

Steps to Reproduce: 
1. Start up 7.0 on DB2
2. Go to Control Panel > Users and Organizations > Organizations > Add Organization with more than 75 characters
Expected Behavior: Names less than 100 characters will work
Actual Behavior: Name with more than 75 characters fails

Testing: 
Reproduced in 7.0.x-private - e155e30109b919834298fde6de84400214025d94
Reproduced in master-private - ae556a3047d963040004456b0c58d2eb6d15381d