topic Re: Not positioned on a valid row in SAS Studio

Not positioned on a valid row

aj34321 — Fri, 13 May 2016 03:39:47 GMT

Hi All,

One of our SAS user is facing a strange problem. He opens DI Studio and tries to run a job and this fails giving error "Not positioned on a valid row"

I also tried executing simply proc setinit; run; and this also resulted the same error.

Not sure where what went wrong.

Request if someone can advice on this.

Re: Not positioned on a valid row

SASKiwi — Fri, 13 May 2016 03:57:03 GMT

Possibly this problem - what SAS version and maintenance level are you using?

http://support.sas.com/kb/55/906.html

Re: Not positioned on a valid row

LinusH — Sat, 14 May 2016 09:10:16 GMT

SInce this happens when submitting code maybe the usage note is not spot on.
Is this the only user that experience this?
Can he open data sets?
Pehaps checking the object spawner log and the local singles studio log might give some clues.
Also a reinstall is a quite easy task the might be worth trying.

Re: Not positioned on a valid row

aj34321 — Tue, 24 May 2016 02:36:58 GMT

Hey Linus, Thanks for our advice.

The problem was the user missed out one semicolon on one of the lines in autoexec which throwing exception which caused the issues.

After semicolon the issue was fixed.

Re: Not positioned on a valid row

LinusH — Tue, 24 May 2016 06:00:34 GMT

Good to know!
Thanks for getting back to us.