topic Import Issue [Data into SAS from Relational Database] in SAS Visual Analytics

Import Issue [Data into SAS from Relational Database]

jw0424 — Mon, 04 Aug 2014 16:04:02 GMT

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

Re: Import Issue [Data into SAS from Relational Database]

jakarman — Mon, 04 Aug 2014 17:37:11 GMT

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

Re: Import Issue [Data into SAS from Relational Database]

jw0424 — Mon, 04 Aug 2014 19:44:58 GMT

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