IV74861: ERROR IN COUNTRY PHONE NUMBER. RUSSIA CODE +7 IS DUPLICATED WITH TAJIKISTANI, WHICH IS +992

APAR status

• Closed as unreproducible.

Error description

• OnPrem 2.2 and 2.3
  
  there is an error in country phone number.
  Russia code (+7) is duplicated with (+7) Tajikistani, which is
  wrong,
  because Tajikistani country code is (+992)
  So all our users with Russian mobile numbers are listed as
  Tajikistani.
  Please see the screenshots.
  Can we fix it somehow? Without RPM or waiting for new release?
  DB SQL
  fix?
  I checked Saas 2.3 version - bug remains there also.
  

Local fix

• use scripts to update the DB:\
  CPS-14574_fix_for_Tajikistan_implementation.dat.sql
  ---------------------------------------------------
  update vpn2.country
  set COUNTRY_CODE_FOR_SMS = 992
  where COUNTRY_NAME = 'Tajikistan';
  
  
  CPS-14574_fix_for_Tajikistan_validation.dat.sql
  -----------------------------------------------
  select count(*)
  from vpn2.country
  where COUNTRY_NAME = 'Tajikistan'
  and COUNTRY_CODE_FOR_SMS = 992;
  
  For the issue with Tajikistan, we can have a quick fix. Please
  follow the below steps,
  
      Login into vpn2 database as a system user.
      Run the attached sql file
  "CPS-14574_fix_for_Tajikistan_implementation.dat.sql".
      Run the attached sql file
  "CPS-14574_fix_for_Tajikistan_validation.dat.sql" and make sure
  that it returns 1 as result.
      Commit the changes and log out of the database.
      Restart the "user-management" application to observe the
  changes.
  

Problem summary

• Hotfix was provided for fixing the issue on 2.3 and a fix was
  made in 2.4 release.
  

Problem conclusion

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  MBLFRST PRTCT D

• Fixed component ID

  5725R1100

Applicable component levels

• R230 PSY

     UP