Character string buffer too small when access view V_AV_DB_TIMEZONE in RSA Identity Governance and Lifecycle
Originally Published: 2017-11-14
Last Modified: 2023-11-30
Article Number
000041580
Applies To
RSA Product Set: RSA Identity Governance and Lifecycle
RSA Version/Condition: All
 
Issue
select * 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"


 
Cause
The 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.'

 
Resolution
Find 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:

     commit;

4. Now select from the view and there will be no error:

     select * from V_AV_DB_TIMEZONE;

 

Related Articles

Trending Articles

Don't see what you're looking for?