000035733 - Character string buffer too small when access view V_AV_DB_TIMEZONE in RSA Identity Governance and Lifecycle

Document created by RSA Customer Support Employee on Dec 15, 2017
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000035733
Applies ToRSA Product Set: RSA Identity Governance and Lifecycle
RSA Version/Condition: All
Issueselect * from V_AV_DB_TIMEZONE results in the following error:

ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "AVUSER.UTILITIES_PKG", line 1414
06502. 00000 -  "PL/SQL: numeric or value error%s"

CauseThe value of the parameter setting 'isSoftAppliance' in T_SYSTEM_SETTINGS is greater than one character in length. The value of this setting is expected to be one character, either "N" or "Y" and nothing else. In this case, the value was set to 'yes.'
ResolutionFind out what the value is and then modify it to "Y" or 'N" depending on whether your machine is or is not a "Soft Appliance."
1. Find out the current value:
     select * from T_SYSTEM_SETTINGS where parameter='isSoftAppliance';
2. Modify the setting to either "Y" or "N". In this case, because the setting was 'yes', modify the value to "Y".
     update T_SYSTEM_SETTINGS set value='Y' where parameter='isSoftAppliance';
3.  Commit the change:
4. Now select from the view and there will be no error:
     select * from V_AV_DB_TIMEZONE;