Hi All,
When we try to create hash files , the job is aborting with the following error message :
" GSAP_LOOKUP_CreateLkpForRegJobs..XrefSctyOvrdHash.ToBuildSctyOvrdHash: DSD.UVOpen
The system cannot move the file to a different disk drive. (17): G:\Ascential\DataStage\Projects\DEV_ZGP0GSAS\mkdb007352aa
mkdbfile: unable to move temp file to file H:\DEV_ZGP0GSAS\Hash\\PreAggXrefSctyOvrdHash "
Can anyone of you help me ?
Regards
VC
Error while Hash file creation
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 106
- Joined: Thu Jun 08, 2006 8:51 am
-
- Participant
- Posts: 83
- Joined: Tue Dec 19, 2006 8:38 am
Re: Error while Hash file creation
Hi ,chitravallivenkat wrote:Hi All,
When we try to create hash files , the job is aborting with the following error message :
" GSAP_LOOKUP_CreateLkpForRegJobs..XrefSctyOvrdHash.ToBuildSctyOvrdHash: DSD.UVOpen
The system cannot move the file to a different disk drive. (17): G:\Ascential\DataStage\Projects\DEV_ZGP0GSAS\mkdb007352aa
mkdbfile: unable to move temp file to file H:\DEV_ZGP0GSAS\Hash\\PreAggXrefSctyOvrdHash "
Can anyone of you help me ?
Regards
VC
Have you before created hashed file in the Loc H:\DEV_ZGP0GSAS\Hash\\PreAggXrefSctyOvrdHash [/b]
IF yes check there is enough space ..
Thanks
George
-
- Participant
- Posts: 106
- Joined: Thu Jun 08, 2006 8:51 am
Re: Error while Hash file creation
Hi,
We have created the file earlier but after getting this error we deleted all the files from the directory and still we are getting this error...
We have created the file earlier but after getting this error we deleted all the files from the directory and still we are getting this error...
-
- Participant
- Posts: 83
- Joined: Tue Dec 19, 2006 8:38 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Is H:\ a network drive? I don't believe it's possible to use mkdbfile to create a hashed file on a network drive.
I'm also a little concerned about how there is a double "\" in the pathname.
I'm also a little concerned about how there is a double "\" in the pathname.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 106
- Joined: Thu Jun 08, 2006 8:51 am
Hi,
Actually this hash file is created long time back and we were using it for the last 2 months and then it was not giving any error.Today only i got this error while running this job.if i change the filename it will not give error.The folder is in the machine where datastage is installed.
Regards
VC
Actually this hash file is created long time back and we were using it for the last 2 months and then it was not giving any error.Today only i got this error while running this job.if i change the filename it will not give error.The folder is in the machine where datastage is installed.
Regards
VC
Have had this before
had a phantom running you have to cancel all processes running against the file. You may have to go into administrator (or uv) do a list.readu to determine user id and processes and end processes and release user.