Error while opening thejob, DS_JOBOBJECTS

[pmadhavi]

Hi

We are working on DS7.5 for a peoplesoft upgrade project.
Its working fine till yesterday. Today when we try to open any job, it is throwing "Can not open file DS_JOBOBJECTS"

Pls suggest what has to be done.

[DSguru2B]

try using the search,
heres ONE to start with.

[dwandbi]

If someone has deleted jobs by mistake. You can import Data stage job components from backup repository if you have exported them into a .dsx file.

thanks,
tom

[kcbland]

Actually, failure to open DS_JOBOBJECTS means that the physical repository file that contains all job information is missing. The repository is corrupted. The Routines and Table Definitions are stored in a different file, if you can get an export of them for safety.

Your only choice is to either do a file system level recovery from backup of the entire project folder contents, or create a new project and import your last export of jobs into that project.

You might not even be able to delete the project because it's internal parts are messed up. Consider trying DS.TOOLS corruption correction features in the project to get it into a state where you can delete it, but take the safe route and consider the project lost.

[ray.wurlod]

Let's find out what the problem is. Open the Administrator client then open the Command window for the project. Execute the following commands one at a time, and post the results. Commands are case sensitive - use only upper case.

Code: Select all

COUNT DS_JOBOBJECTS
UVFIXFILE DS_JOBOBJECTS

[developer_DS]

[quote="ray.wurlod"]Let's find out what the problem is. Open the Administrator client then open the Command window for the project. Execute the following commands one at a time, and post the results. Commands are case ...[/quote]

Can u pls list out the commands to be executed
I am not able to see the full msg u posted

[developer_DS]

[quote="ray.wurlod"]Let's find out what the problem is. Open the Administrator client then open the Command window for the project. Execute the following commands one at a time, and post the results. Commands are case sensitive - use only upper case.
[code]COUNT DS_JOBOBJECTS
UVFIXFILE DS_JOBOBJECTS[/code][/quote]

We tried executing the commands.
It is showing Unable to open file DS_JOBOBJECTS.
And also it says the file got corrupted.

Pls let us know what has to be done next.

[chulett]

I believe that Ray would like you to post the actual results (copy/paste) of each command rather than paraphrasing them.

[DSguru2B]

The user probably needs to purchase charter membership in-order to view the commands.
DS_DEVELOPER: To get such a valuable advice from Ray and other valuable premium members, you need to pay off about an hour of your work to view the content.

[DSguru2B]

The user probably needs to purchase charter membership in-order to view the commands.
DS_DEVELOPER: To get such a valuable advice from Ray and other valuable premium members, you need to pay off about an hour of your work to view the content.

[developer_DS]

First I executed the command COUNT DS_JOBOBJECTS
and the result we got is as follows:

Warning: Internal file corruption detected during file open!
File must be repaired, possible truncation.
hsize: 2048
bsize: 2048
fsize: 65883136
Unable to open "DS_JOBOBJECTS" file.

Next I executed the command UVFIXFILE DS_JOBOBJECTS
and the result we got is as follows:

Waring: "DS_JOBOBJECTS/OVER.30" has been truncated.
Waring: Internal file corruption detected during file open!
File must be repaired, possible truncation.
hsize: 2048
bsize: 2048
fsize: 65883136
Warning: Unable to set GROUP LOCKS on DS_JOBOBJECTS.

Begining TRACE of DS_JOBOBJECTS.

ERROR: Processing Primary group 13652, overflow group 0.
Record length discrepancy at address 0x0laaa67c.
Encoded size = 27960176, calculated size =388.
Calculated BLINK = 0x0laaa2f4 (27960052).

ID "" doesn't hash to primary group 13652.
TRACE of DS_OBJECTS completed

Warning: file load discrepancy detected.

Scanning overflow buffers.
Warning: No link to overflow group 6572.
Warning: No link to overflow group 7359.
Warning: No link to overflow group 7360.
Warning: No link to overflow group 7361.
Warning: No link to overflow group 29823.
Warning: No link to overflow group 29824.
Warning: No link to overflow group 29825.
Warning: No link to overflow group 30155.
Warning: No link to overflow group 30156.
Warning: No link to overflow group 32158.
.................
...............


Scan complete.

13784 groups processed.
20093 group buffers processed.
Number of databytes = 22825652


Is this info enough to find out the problem? pls let me know

[kcbland]

The good news is you still don't know the extent of corruption, did it cause referential integrity issues with other storage tables. You're wasting time when you should have just recovered the project as I recommended earlier. You could have job designs that are missing, unable to even open, etc. The truncation messages are telling you that parts of the files were destroyed. It could have been a few bits from many jobs.

[developer_DS]

Yesterday we executed the DS.TOOLS command from DS Administrator as u suggested. But it is of no use.
Still we are getting the same error.

[kcbland]

From the beginning I've said consider the project lost and take the safe route.

[ray.wurlod]

The COUNT command is a quick test to see whether the entire file can be processed. In this case it can not, because at least one backward link (BLINK) pointer has become corrupted.

The best repair at this time is to make sure no-one is using DataStage and no DataStage jobs are running then, at the operating system level rename the project directory and restore the entire project from system backup. And hope like crazy that DS_JOBOBJECTS became corrupted after it was backed up!

Do that, and get back to us.

The ability to read premium content costs less than $1 per week. This post will become premium content after Easter (in case you can't sign up during that period).