Architecting, installing and maintaining your SAS environment

Issues with running DI studio jobs in SAS 9.4

Reply
Occasional Contributor
Posts: 9

Issues with running DI studio jobs in SAS 9.4

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.

Please help

Valued Guide
Posts: 3,208

Re: Issues with running DI studio jobs in SAS 9.4

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.   

---->-- ja karman --<-----
Occasional Contributor
Posts: 9

Re: Issues with running DI studio jobs in SAS 9.4

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.

Valued Guide
Posts: 3,208

Re: Issues with running DI studio jobs in SAS 9.4

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?

---->-- ja karman --<-----
Ask a Question
Discussion stats
  • 3 replies
  • 449 views
  • 0 likes
  • 2 in conversation