Error: 'ORA-01401: inserted value too large for column' when changing a password. (NETIQKB30535)

fact
VigilEnt Password Manager for Oracle 5.0

fact
VigilEnt Password Manager for Oracle 6.x

fact
VigilEnt Security Agent for Oracle 1.x

symptom
Error: 'ORA-01401: inserted value too large for column' when changing a password.

symptom
Error is produced when VigilEnt Password Manager for Oracle is attempting a password change on a Microsoft Windows 2000 desktop.

symptom
Error occurs through any of the three add-on components: PwdAdmin, PwdClient, or PMACC password change tools. 

cause

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.

fix

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);

Formerly known as NETIQKB30535