Error while opening thejob, DS_JOBOBJECTS
Moderators: chulett, rschirm, roy
Error while opening thejob, DS_JOBOBJECTS
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.
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.
Thanks,
Madhavi
Madhavi
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.
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.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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
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: 9
- Joined: Thu Apr 13, 2006 3:29 pm
[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
Can u pls list out the commands to be executed
I am not able to see the full msg u posted
-
- Participant
- Posts: 9
- Joined: Thu Apr 13, 2006 3:29 pm
[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.
[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.
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.
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.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
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.
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.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Participant
- Posts: 9
- Joined: Thu Apr 13, 2006 3:29 pm
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
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
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.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 9
- Joined: Thu Apr 13, 2006 3:29 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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).
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).
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.