DSXchange

Thanks for the replies guys. We have logged a call with our support.

Daren

The errors in the PX jobs have not re-appeared. However, we created some new reporting jobs which use a Server shared container and basic transformer and this message is now appearing for that job: Unable to read Temp_<jobname> from OMD.XML.DIR If it is a known issue with a basic transformer, what i...

Thanks for the replies guys. I have now created and tested the job which: a) Clears down log files based on either a category, project or substring; b) Re-instates auto-purge settings. The code may not be perfect but does what is intended *************************************************************...

Thanks ArndW - I just came to the same conclusion as the initial JobList kept overwriting the job details, so only the last ever log was cleared.

Thanks again for all your help - I have picked up a lot today

Daren

Umm... are you sure that this code is working, even for the other logs? I would use the line TableName = "RT_LOG":FIELD(JobList, "|",2)<5> This uses the 5th field of the data, which contains the job number. The more I look at it, the more I think that the original code would nev...

I have added some logging and interestingly it is setting the TableName variable to be RT_LOGNRO, which is incorrect - it should be 486.

Why is NRO being set within here??

Daren

Hi ArndW, Thanks for that. I made the change and get this extra message in the log - the job still aborts however: JP_99_Clear_Job_Logs..JobControl (): Clearing log from job "JP_01_RTCOL_CEN_LAND_010_ACC_FACTORS". So it seems to be failing on either one of the two last calls? Thanks, Daren

Sorry about the delay in replying.

The transformer is a parallel transformer. We do not use basic transformers in our PX jobs.

I have amended DSIPC_OPEN_TIMEOUT as suggested above to see if that resolves the error in the meantime.

Thanks for the responses so far

Daren

Hi, I did some searching on how to clear job logs en masse and found a number of useful posts. I found some code by Ken Bland (thanks Ken :) ) but I can't seem to get it to work. I am using a Datastage Parallel Job. The code has been cut and paste into the Job Control tab under Job properties and th...

I have a Parallel Transformer, which is probably the same, yes.

I have a Parallel Transformer, which is probably the same, yes.

That is the full message from the director log, replacing jobname with the job I am running. There is no other detail.

Daren

Hi, We have just started receiving warnings messages of the format below in jobs that have been running fine for a number of months. The jobs complete OK but issue these warnings: Unable to read Temp_<jobname> from OMD.XML.DIR Unable to write Temp_<jobname> from OMD.XML.DIR I have tried searching fo...

Thanks, that's what I thought but asked more in hope than anything else

Daren

Hi,

I was just wondering if anyone knew of a command / facility within DS or Orchadmin to rollback a dataset to its state pre-job in the event of a job failure?

Thanks,

Daren