VigilEnt Password Manager for Oracle 5.0
VigilEnt Password Manager for Oracle 6.x
VigilEnt Security Agent for Oracle 1.x
Error: 'ORA-01401: inserted value too large for column' when changing a password.
Error is produced when VigilEnt Password Manager for Oracle is attempting a password change on a Microsoft Windows 2000 desktop.
Error occurs through any of the three add-on components: PwdAdmin, PwdClient, or PMACC password change tools.
The error results from trying to insert a value that is too large for the OSUSER column, which is a size of 15. The entry from a Microsoft Windows 2000 computer is '
computer name\OS username', (for example,
winmachine\administrator) which is longer than 15 characters.
To resolve this issue, increase the OSUSER column size to 50. This can be done issuing an alter table
sqlcqr.sqlcqr_userdata statement and modifying the column size to 50
as in the following example:
ALTER TABLE sqlcqr.sqlcqr_userdata
MODIFY OSUSER VARCHAR2(50);