DataStage error upon login: DSR.ADMIN: Failed to add user to UV_USERS file

When user first logs in, they get following error message:
DSR.ADMIN: Failed to add user to UV_USERS file.
ACCESS DENIED: INTERNAL SQL ERROR FAILED TO REGISTER THIS USER FOR SQL.



Solution :

If you are seeing sql errors in errlog file, go back to DSEngine as dsadm and run:

bin/mksecure -nobobo sql/catalog/UV_USERS

and try it again. If it works, then do
bin/mksecure sql/catalog/UV_USERS

that will resync the UV_USERS file.



Reference : IBM