BookmarkSubscribeRSS Feed
PAN1
Calcite | Level 5

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

3 REPLIES 3
jakarman
Barite | Level 11

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 --<-----
PAN1
Calcite | Level 5

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.

jakarman
Barite | Level 11

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 --<-----

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 1192 views
  • 0 likes
  • 2 in conversation