When testing an information map or running a query from SAS Web Report Studio, the generated code might contain an extraneous WHERE clause that prevents results from being returned. The syntax might look something like this:

(WHERE=(1 eq 2)) 

This extra clause is not related to any filter defined in the information map or in the report. Instead, the clause might be inserted when SAS solutions are installed or when the environment contains multiple metadata repositories and one of those repositories is offline. This WHERE clause is added to the query to ensure security on the data when a repository is offline.

The only way to resolve this problem is to delete the offline repository or bring it back online.

Operating System and Release Information