08-04-2014 12:04 PM
I have a data import job that usually runs in just a few minutes that is not completing. [It has been over 30 mins]. Nothing has change in the relational database [postgres] that I know of. The data set size is about the same is it always has been. Is there something I should check, or maybe something that needs to be reset?
08-04-2014 01:37 PM
- Check, if possible the session in postgress is not hanging, becoming not responsive.
- As there should be some processing on sas check it is still a valid process and does not got hang up by shortage of some resource.
The saswork or default directory ($home) are candidates. There are many more of them all different on OS type.
- Sometimes an previous error can have corrupted you db-connection. You have to restart and retry again.
Seeing this being happend by trying to sort the DBMS-table in a SAS way. Proc sort cannot run on a DBMS-table.