01-23-2016 09:03 AM
The problem is about rewriting contents of a table in SAS Data Integration Studio.
We have a Job scheduled to run every day.
Every morning the table contents is almost empty and contains rows that has nothing to do with the right one. Than if I am running the job manually it works perfectly fine.
I have already tried to redeploy scheduling and make a reverse analysis to understand where this data comes from but it didn’t help.
Any suggestions will be very welcome!
P.S. Didn't find a branch of a forum where can I write questions about SAS DI and have chosen the most close to my mind.
01-23-2016 01:24 PM
01-25-2016 01:33 AM
First of all, if your dataset should only be written from a maintained SAS batch job, I would make sure that only the user that runs the batch job has write access to the dataset (and library, if possible).
Then you need to take a careful look at the damaged dataset before it is overwritten. If possible, use the operating system's move command to create a backup for later inspection that retains the properties.
Look at the time of last modification, and see if you have a job log from the same time. An incorrectly specified job from a completely different context might be the culprit.