Failed to open RT_LOG37 file
Posted: Fri Nov 11, 2011 1:13 am
I having the below problem in Director
When I am opening the director it showing the error: failed to open RT_Log37 file
the director list it is not listing one of the job(let suppose JOB A) and for one job(say JOB B) it showing error getting jobstatus
I fired the query under datastage administrator command SELECT JOBNO FROM DS_JOBS WHERE NAME like <JOB A>
When I am firing LIST DS_JOBS WITH JOBNO = 37 this it is showing that the job is present on server
Also I have cleared the logs of the jobs with clear.file RT_LOG37
Also I tried for the DS.REINDEX ALL but same error
Then I tried with to create copy and compile it again the JOB B is now showing correct thing but JOB A is showing the problem of ERROR NOT GETTING JOBSTATUS
Please help and suggest!!!!
When I am opening the director it showing the error: failed to open RT_Log37 file
the director list it is not listing one of the job(let suppose JOB A) and for one job(say JOB B) it showing error getting jobstatus
I fired the query under datastage administrator command SELECT JOBNO FROM DS_JOBS WHERE NAME like <JOB A>
When I am firing LIST DS_JOBS WITH JOBNO = 37 this it is showing that the job is present on server
Also I have cleared the logs of the jobs with clear.file RT_LOG37
Also I tried for the DS.REINDEX ALL but same error
Then I tried with to create copy and compile it again the JOB B is now showing correct thing but JOB A is showing the problem of ERROR NOT GETTING JOBSTATUS
Please help and suggest!!!!