Weird Error Message

[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.

[pnchowdary]

Hi NaveenD,

Did you by any chance make the project read only while exporting ?.

[pramod_au]

Please check which user id is used to edit these jobs..

Thanks
Pramod

[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

[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 ? )

[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.

[kduke]

Are you out of disk space?

[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

[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.

[pnchowdary]

Hi NaveenD,

You can change the READONLY value from "0" to "1" and it should work.

[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

[I_Server_Whale]

Hi Sarvanan,

I will check about the permissions and let you know. Thanks for your help. I appreciate it.

regards,
Naveen.

[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.

[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.

[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