DataStage logon error

yc · Post by yc » Mon Sep 12, 2005 7:59 am

Hi,

Getting the following error on logon to Designer/Director/Manager and checking the Omit checkbox :

DSR.ADMIN: Failed to add user to UV_USERS file.

Code: Select all

ACCESS DENIED: INTERNAL SQL ERROR FAILED TO REGISTER THIS USER FOR SQL

If I clear the Omit checkbox and login with the same account, the logon is OK.

What's wrong ?

Error on Datastage7.5.1A on Windows 2003 for the server and Windows 2000 SP4 for the client.
User account has full acces on DS server directory.

ray.wurlod · Post by **ray.wurlod** » Mon Sep 12, 2005 3:52 pm

Welcome aboard! :D

This error is failure of an internal GRANT CONNECT TO username; SQL statement. That it occurs is a bug. You can work around it by logging in as the user who installed DataStage, and executing the GRANT statement explicitly.

singhald · Post by **singhald** » Mon Sep 12, 2005 4:23 pm

hi

if u have created a user name and gave password to the user
so u have to give valid user name and password to the datastage client.

u can'nt omit this,

otherwise u have to remove user from datastage client

deepak

yc · Post by yc » Tue Sep 13, 2005 5:20 am

Yesterday : access denied
Today : access granted

Nothing were done. I don't understand...

An other problem :
The server administrator can run jobs without problem.
The production manager can start jobs, but I have the following error :

Code: Select all

ds_loadlibrary: Win32 error in LoadLibrary of oraoci9.dll - Access is denied.

The production manager has RW access in the DS server engine & project.