Page 1 of 1
Posted: Wed Jan 06, 2010 3:30 pm
by ray.wurlod
Does the "no link to overflow group" in DS_JOBOBJECTS still occur? (This would mean that the problem existed before you backed it up.) Run UVFIXFILE against DS_JOBOBJECTS and let us know the results.
Did the file system on which DataStage projects are installed become full at any point?
Posted: Sat Jan 09, 2010 1:08 am
by datability_user
Hello Ray and thanks:
sorry for late replay (our weekend thu&Friday) .
this is the result out of:
$ fixtool -file /ascential/Ascential/DataStage/Projects/Project1/DS_JOBOBJECTS
Filename: /ascential/Ascential/DataStage/Projects/Project1/DS_JOBOBJECTS
Start Diagnostics.
0 Errors found in physical structure.
0 Errors found in file header.
0 Errors found in file groups.
4 Other errors found in file.
70598 records processed.
4 Errors on file.
Fixtool Completed.
UVFIXFILE output:
Beginning TRACE of DS_JOBOBJECTS.
TRACE of DS_JOBOBJECTS Completed.
Warning: file load discrepancy detected.
Scanning free buffer chain.
Scan Complete.
Scanning overflow buffers
Warning: No link to overflow group 13814.
Warning: No link to overflow group 13815.
Warning: No link to overflow group 13816.
Warning: No link to overflow group 13867.
Scan Complete.
12317 group(s) processed.
18105 group buffer (s) processed.
54863 records processed.
Number of data bytes = 16342996.
can you suggest any steps to do.
thanks.
Posted: Sat Jan 09, 2010 3:12 am
by kalyanvinnakota
Can you try checking the privileges of files associated with the job(ex: RT_LOG, RT_CONFIG etc). I am trying many options as part of SOD conflict in our project and I tried removing write privilege to group for the RT_LOG file.
As soon as anyone in the group try to access this job or see the log in director, the same error comes up(Datastage not set up correctly).
-Regards,
Kalyan
Posted: Sat Jan 09, 2010 5:19 am
by datability_user
Thanks Kalyan, the privileges were fine and we have no problem with it. what other things i have to try/check.
Posted: Sat Jan 09, 2010 9:00 am
by chulett
This an important question that still really needs to be answered:
ray.wurlod wrote:Did the file system on which DataStage projects are installed become full at any point?
Posted: Sun Jan 10, 2010 1:07 am
by datability_user
Hi Guys,
Sorry i forget to answer this question,
as i know the answer is no, but it has reached 85%.
thanks.
Posted: Sat Jan 23, 2010 6:08 am
by datability_user
Hi,
for your knowledge and records.
The recommendation from IBM is to reinstall DS and import the exported file.
It's almost impossible to do this right now, because it's a production server.
Thanx
Posted: Sat Jan 23, 2010 8:37 am
by chulett
Did they say
why they recommended this?
Posted: Tue Jan 26, 2010 12:36 am
by datability_user
The only thing that they say is it's the quickest solution.
Posted: Tue Jan 26, 2010 5:10 am
by ray.wurlod
That's probably true given the structural damage to DS_JOBOBJECTS, which would take a substantial amount of an expert's time to repair. It may be able to be repaired using fixtool, it may not.
Posted: Tue Jan 26, 2010 5:45 am
by datability_user
We have a migration plan to 8.1 EE within 2 months, so as work around we copied and rename the daily jobs and compile/run them for the time being, and we will do the same as needed till the migration takes place.
thanks to all of you and i will update this thread with any news if any.