Desktop productivity for business analysts and programmers

Query Builder - "Validate Query Builder" - Taking too long/hangin up project SAS EG

Accepted Solution Solved
Reply
New Contributor
Posts: 4
Accepted Solution

Query Builder - "Validate Query Builder" - Taking too long/hangin up project SAS EG

Hello, 

 

I am running SAS EG Version 7.15 (7.100.5.5850) (32-bit) and started to notice that when I was testing some tables with small queries using the Query Builder (for quick testing), it is hanging up my project. It has happened to me a handful of times and I have to have our IT department kill my connection to the server and start over. 

 

I noticed that when I 1) open a query builder, with no joins, of a single table 2) click and drag, or double click, a field to the "Select Data" box, the process of "Validate Query Builder" happens in under a second (appears on the bottom left corner under "Details", and then I am able to work. It does this on every query. In these scenarios, for some reason this process hangs up and all I see is the "Validate Query Builder". There is no solution that I can see, and was hoping someone else had experience this and had a solution that I could try.

 

Thank you!


Accepted Solutions
Solution
‎01-02-2018 08:31 AM
SAS Employee
Posts: 199

Re: Query Builder - "Validate Query Builder" - Taking too long/hangin up project SAS EG

[ Edited ]

Hi @cedpme

 

Are you having the issue with every tables, whether you're using SAS datasets or DBMS tables?

 

Did you try to unselect the "Automatically validate query whenever changes are made" option from Tools => Options => Query ?

Hope that helps.

 

Cheers,
Damo

View solution in original post


All Replies
Solution
‎01-02-2018 08:31 AM
SAS Employee
Posts: 199

Re: Query Builder - "Validate Query Builder" - Taking too long/hangin up project SAS EG

[ Edited ]

Hi @cedpme

 

Are you having the issue with every tables, whether you're using SAS datasets or DBMS tables?

 

Did you try to unselect the "Automatically validate query whenever changes are made" option from Tools => Options => Query ?

Hope that helps.

 

Cheers,
Damo

New Contributor
Posts: 4

Re: Query Builder - "Validate Query Builder" - Taking too long/hangin up project SAS EG

[ Edited ]

Hi @Damo, I appreciate your quick response to my issue. I did not know there was that option. I just unticked it and will followup if this does not solve it. 

 

SAS Community saves the day, once again!

 

Regards.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 232 views
  • 0 likes
  • 2 in conversation