DS Job Corrupted : Errors when writing record OshExecuter.osh to file

DS Job Corrupted : Errors when writing record OshExecuter.osh to file

When you are trying to move jobs or import into Higher regions such as Quality control, User Testing and Integration regions and you receive the following error:

Error writing record OshExecuter.sh to file RT_SC – error number is 40019

Below are the possible items that might corrupt the jobs

  • Full disk space in the /tmp UVTEMP directory or the DataStage project directory.
  • A 32-bit hash file becomes larger than 2GB
  • Power outages of the server
  • System crashes
  • Rebooting the server while a job is running
  • Virus scan locked the RT file running while job is running
  • Backup running while job is running
  • Failures on the system

To find out whether the Job is corrupted or not – please use below steps

  1. Log on to DataStage Administrator client
  2. In the projects tab, select the corrupted project
  3. Click Command
  4. Issue the following command: LIST <FILENAME> F1 DET.SUP

 If the file is corrupted you receive an error message else the job is not corrupted you can see some number that indicates the number of records in the file and if we see that the file RT_SC file is corrupted you can re-create the job.

Author: Kuntamukkala Ravi

ETL Consultant by Profession, Webmaster by Passion

Leave a Reply

Your email address will not be published. Required fields are marked *