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

[danny_velasquez]

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;

[SASKiwi · Accepted solution]

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.

[danny_velasquez]

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

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

[SASKiwi]

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