Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Error Query Builder "No services available"

Reply
Contributor
Posts: 26

Error Query Builder "No services available"

Hello experts,

I'm getting an error with Query Builder when trying to run a query. Bellow I send you the screenshot with the message.

Do you know how to resolve? 

 

Thank you in advance, 

Rodrigo

 

Query Builder Error.png

SAS Super FREQ
Posts: 586

Re: Error Query Builder "No services available"

Posted in reply to rodrigo_pereira

I would suggest that you restart your servers. This topic explains the correct order for a restart:

http://support.sas.com/documentation/cdl/en/bisag/68240/HTML/default/viewer.htm#p0d9d5nzmd8i4yn1usv2...

 

 

Contributor
Posts: 26

Re: Error Query Builder "No services available"

Posted in reply to Madelyn_SAS

Hello Madelyn,

We did the restart but now he have another problem. 

 

All the LASR tables are "Unloaded" and the reload isn't working.

This should be automatic, right? 

 

Thank you,

Rodrigo

SAS Super FREQ
Posts: 586

Re: Error Query Builder "No services available"

Posted in reply to rodrigo_pereira
Contributor
Posts: 26

Re: Error Query Builder "No services available"

Posted in reply to Madelyn_SAS

Hi Madelyn,

In fact it was an authorization issue in some tables problem because the option "load on start" was activated. 

 

We were able to solve to the tables that were loaded automatically. 

 

However we still have the problem for the tables generated by the "Query Builder". We always need to run the query again or this can be done automatically (in VA 7.1). 

 

Thank you,

Rodrigo

Contributor
Posts: 26

Re: Error Query Builder "No services available"

Posted in reply to Madelyn_SAS

Hi again Madelyn,

 

the original problem is ocurring again (from my screenshot). 

The same message appears and we are unable to execute Data Query - the explorations seem to work fine.

 

Do you know why this could be happening? 

 

We did a restart today (and VA worked fine after the restart) and we didn't have any interventation that can justify this abnormal behaviour.

 

Thank you in advance,

Rodrigo

Ask a Question
Discussion stats
  • 5 replies
  • 214 views
  • 2 likes
  • 2 in conversation