Page 1 of 2
Weird Error Message
Posted: Tue Jul 26, 2005 9:31 am
by I_Server_Whale
Hi All,
We had to do fresh install of Datastage. Before the re-install, we exported our project into a .dsx file. Then, we completed the fresh install on the Windows Server and clients.
Now, we import the project back. I tried to edit one of my jobs and tried to save it. It let me edit it, but not save it.
These are the messages I get:
Code: Select all
Record J\8\V0 on file DS_JOBOBJECTS cannot be written
Code: Select all
Record J\8\V0S2P2 on file DS_JOBOBJECTS cannot be written
Code: Select all
Record J\8\V0S1 on file DS_JOBOBJECTS cannot be written
Code: Select all
Record J\8\V0S1P1 on file DS_JOBOBJECTS cannot be written
Code: Select all
Record J\8\V0S0P1 on file DS_JOBOBJECTS cannot be written
Anyone have any idea of what these messages mean?
Any help is tremendously appreciated.
Thanks much,
Naveen.
Posted: Tue Jul 26, 2005 9:34 am
by pnchowdary
Hi NaveenD,
Did you by any chance make the project read only while exporting ?.
Posted: Tue Jul 26, 2005 9:47 am
by pramod_au
Please check which user id is used to edit these jobs..
Thanks
Pramod
Posted: Tue Jul 26, 2005 9:48 am
by elavenil
It seems to me the objects in DS_JOBOBJECTS are made readonly. Pls verify the objects are readonly by executing this command in Administrator. SELECT DISTINCT READONLY FROM DS_JOBOBJECTS.
If it returs 'RO' that indicates the all the objects are made readonly. Pls change the 'RO' to non-readonly then try editing the job.
HTWH.
Regards
Saravanan
Posted: Tue Jul 26, 2005 9:50 am
by Sainath.Srinivasan
You can change the readonly flag in the dsx - I think it is to make 1 to 0 (Or is it vice-vesa ? )
Posted: Tue Jul 26, 2005 9:53 am
by I_Server_Whale
Hi Sarvanan,
It return "NRO". So, the jobs are not read-only I guess. Any more ideas on how to tackle this issue?
Thanks much for your help,
Naveen.
Posted: Tue Jul 26, 2005 10:00 am
by kduke
Are you out of disk space?
Posted: Tue Jul 26, 2005 10:08 am
by elavenil
Hi Naveen,
The objects are not readonly. Can you check the DSX file for the strings (like 'J\8\V0S0P1') and check these DSRECORD are made as 'READONLY'. If readonly is yes, then you can find entry as READONLY "0".
Regards
Saravanan
Posted: Tue Jul 26, 2005 10:31 am
by I_Server_Whale
Hi Sarvanan,
I did open the DSX file in notepad and checked for the string. It did not return anything for J\8\V0S0P1. But it does list V0S0P1 under 'Output Pins'. And the READONLY is '0'. Does this mean that the jobs are read-only? How can I rectify this? Please help me out!
Thanks much,
Naveen.
Hi Kim,
How do I check if I'm running out of Disk space? Our DS Server is installed on a Windows Server on E:\ drive of 299GB total space of which 297 GB is free.
Thanks much,
Naveen.
Posted: Tue Jul 26, 2005 10:34 am
by pnchowdary
Hi NaveenD,
You can change the READONLY value from "0" to "1" and it should work.
Posted: Tue Jul 26, 2005 10:40 am
by elavenil
If you find ReadOnly "0" means those objects are not readonly. Did you check the projects folder whether you have write permissions on that folder.
Regards
Saravanan
Posted: Tue Jul 26, 2005 11:27 am
by I_Server_Whale
Hi Sarvanan,
I will check about the permissions and let you know. Thanks for your help. I appreciate it.
regards,
Naveen.
Posted: Tue Jul 26, 2005 12:28 pm
by kduke
The READONLY field has "NRO" or "RO" in it which stands for Not Read Only or Read Only. It is in the DS_JOBOBJECTS.
Posted: Tue Jul 26, 2005 4:09 pm
by I_Server_Whale
PROBLEM SOLVED!!!! :D
Thank you guys for all your help. Thanks much.
Actually, the error messages were due to no access being granted to the project directory for the DS users (DSDevelopers).
After the admin granted the access, it is all normal now. Got to get back to work. Thanks again,
Naveen.
Posted: Thu Apr 12, 2007 6:26 am
by sidharth
Hi,
I am facing similar problem. When i try to import a dsx file to another project, i get a similar error and.
Could someone let me know how to grant access to the project directory ?
Many Thanks,
Sidhartha