08-11-2015 09:44 AM
We are facing some issues with running SAS 9.4 jobs deployed on AIX servers. The issue is that after creating a flow with a combination of jobs, we are unable to run the SAS generated script using an external scheduler.
The script runs fine on the host. It seems that out of all the jobs in the flow, only the ones which last for long, say more than 3 minutes abend. The error log for the individual job says that the data set has low space on the disk. We increased the space to almost 400 GB yet getting the same error.
08-11-2015 02:41 PM
At wat area the message is indicating low space? It could be another one as the one being increased.
The external script is running the sas-code that is out of the area of DO studio. DI studio should have generated the sas-code the external scheduler is running.
08-12-2015 08:47 AM
We are trying to copy a table from and external SQL DB. We have a table loader transformation which copies the whole table along with the metadata on the SAS server.
The job runs fine until the target data set is abended and then, a temporary WORK data set is created. The space issue occurs when the contents are to be written on the apended data set.
We have checked for the server space and increased another 100 GB even though we had about 150 GB free and the table is about 25 GB.
08-12-2015 03:02 PM
Look at you SQL what is happening. Is it this one? SAS(R) Data Integration Studio 4.9: User's Guide "About the Table Loader Transformation"
Or this one SAS(R) Data Integration Studio 4.9: User's Guide (Creating a Table That Appends Two or More Source Tables) Anyway the processing can be done in several ways in SAS base generated code SAS(R) Data Integration Studio 4.9: User's Guide Selecting a Load Technique in the Table Loader.
I would expect the table to be copied to saswork first and than going to a final destination or staging one. That can be and usually are several different file-systems. The error and root cause can sometimes be misleading. Do you have any logs / messages to share?
As you are saying the temporary (sas work?) is fine where is the destination dataset to be appended going to? What technique SAS-base code is used for that appending?