topic Re: VSCode "ERROR: Job did not complete in allotted time" in SAS Programming

VSCode "ERROR: Job did not complete in allotted time"

danny_velasquez — Tue, 27 Sep 2022 22:48:41 GMT

I am tested VS Code SAS Programming and the sql proc shows me the following error.

VSCode "ERROR: Job did not complete in allotted time"

Code VScode:

proc sql;
    connect to oracle as cnxora_ (user='xxxx' pw='xxxx' path='xxx' connection=global);
    
   
    create table work.tmp_ as
    select * from connection to  cnxora_ (
    SELECT * FROM XXXXX);
    
    disconnect from cnxora_;
    run;
    

    proc print data=work.tmp_;
    run;
    

Re: VSCode "ERROR: Job did not complete in allotted time"

SASKiwi — Wed, 28 Sep 2022 02:01:45 GMT

If the same program works OK in another SAS IDE like SAS Studio or EG then it's safe to assume this is a VSCode-specific problem. If not the problem is likely to be a database connection timeout.

Re: VSCode "ERROR: Job did not complete in allotted time"

danny_velasquez — Sat, 01 Oct 2022 16:54:22 GMT

The program responds well in SAS StudioV, taking about 20s to complete.

Thanks, it's probably a SAS tools bug in VSCode.

Re: VSCode "ERROR: Job did not complete in allotted time"

SASKiwi — Sat, 01 Oct 2022 21:43:06 GMT

@danny_velasquez - Worth reporting in a track to Tech Support then.