can't compile any job in the project

ray.wurlod · Post by **ray.wurlod** » Wed Jan 06, 2010 3:30 pm

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?

datability_user · Post by **datability_user** » Sat Jan 09, 2010 1:08 am

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.

kalyanvinnakota · Post by **kalyanvinnakota** » Sat Jan 09, 2010 3:12 am

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

datability_user · Post by **datability_user** » Sat Jan 09, 2010 5:19 am

Thanks Kalyan, the privileges were fine and we have no problem with it. what other things i have to try/check.

chulett · Post by **chulett** » Sat Jan 09, 2010 9:00 am

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?

datability_user · Post by **datability_user** » Sun Jan 10, 2010 1:07 am

Hi Guys,

Sorry i forget to answer this question,
as i know the answer is no, but it has reached 85%.

thanks.

datability_user · Post by **datability_user** » Sat Jan 23, 2010 6:08 am

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

chulett · Post by **chulett** » Sat Jan 23, 2010 8:37 am

Did they say why they recommended this?

datability_user · Post by **datability_user** » Tue Jan 26, 2010 12:36 am

The only thing that they say is it's the quickest solution.

ray.wurlod · Post by **ray.wurlod** » Tue Jan 26, 2010 5:10 am

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.

datability_user · Post by **datability_user** » Tue Jan 26, 2010 5:45 am

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.