Import Issue [Data into SAS from Relational Database]

[jw0424]

Greetings,

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?

Thanks,

John

[jakarman]

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

[jw0424]

Thank you. It did eventually finish, but I will look into those things if I run into more issues.