DSXchange

Hi,

We are unable to login to Datastage Designer/Director clients

The errors we are getting are -

1. DSR.ADMIN: Failed to add user to UV_USERS file.
2. ACCESS DENIED: INTERNAL SQL ERROR FAILED TO REGISTER THIS USER FOR SQL

However when we try to login using the admin id we are able to do so. The issue is coming only for the developers.

When tried to compile the jobs after logging in via admin we got the following errors -

1. Record J\1009\ROOT on file DS_JOBOBJECTS cannot be written
2. Error calling subroutine: DSR_JOB (Action=5); check Datastage is set up correctly in project
(Subroutine failed to complete successfully (30107))
3. (40503) A call to OLE server has failed, or a runtime error occured within the OLE server itself


We recycled the Engine and Domain server but still the issue persists.

Please let us know what might be the cause and what are the possible solutions to the problem.

OS details for the UNIX server : AIX 3 oslevel - 5.3.0.0

What happened between when it was working and when it isn't working?

I've just taken Brad through a very similar situation, which was resolved within the last few days. Why not search for UV_USERS ?

ray.wurlod wrote:What happened between when it was working and when it isn't working?

I've just taken Brad through a very similar situation, which was resolved within the last few days. Why not search for UV_USERS ?

Ray,

It was working fine the day before and we started getting the slowdown issue. Sessions were getting hanged and all. From next day we were not able to login to the DS clients (except for some users).

chulett wrote:viewtopic.php?t=136178

Thanks craig!!!

We'll try the solution and let you know.

Hi,

The users have full permissions to access the projects but still the issue persists.

Please find more explanation -
The dstage group users are not able to write data to the file system.
At directory level, it shows that these groups have read, write and exectute permissions.

To check this we logged into Unix and tried the following using one of the user ids -

pwd
/opt/ibm/IS/InformationServer/Server/Projects
drwxrwxr-x 3677 dsadm dstage 90112 Sep 27 15:01 Proj1
drwxrwxr-x 6808 dsadm dstage 163840 Sep 24 02:31 Proj2
drwxrwxr-x 10418 dsadm dstage 245760 Sep 27 16:52 Proj3

But the users fail to create files within these folders -
We tried the following -
touch temp.txt
touch: 0652-046 Cannot create temp.txt.
pwd
/opt/ibm/IS/InformationServer/Server/Projects/Proj1

Kindly let us know why these groups are unable to create files.

Please complete the picture with an id command to prove that you're in the dstage group, and a df command to show whether the disk is full. After the touch command it would have been good to echo ? to get the exit status of touch.

Lots of help out there from AIX folks when you google for "touch: 0652-046". Usually seems to be a corrupt filesystem but do the search yourself and run some of the tests they suggest.