Desktop productivity for business analysts and programmers

Weird Enterprise Guide issue

Accepted Solution Solved
Reply
Regular Contributor
Posts: 171
Accepted Solution

Weird Enterprise Guide issue

[ Edited ]

Ok, so we are running a SAS EBI 9.4TS1M3 environment on RHEL 6.7 (Linux x64).  EG is 7.100.0.1966 64-bit. 

 

I have a user that creates projects with Query Builder tasks.  When he creates the tasks they appear and run as normal.  Here is an example using data from SASHELP:

 

%_eg_conditional_dropds(WORK.QUERY_FOR_CARS);

PROC SQL;
   CREATE TABLE WORK.QUERY_FOR_CARS AS 
   SELECT t1.Make, 
          /* Calculation */
            (COUNT(DISTINCT(t1.Model))) AS COUNT_DISTINCT_of_Model
      FROM SASHELP.CARS t1
      GROUP BY t1.Make;
QUIT;

He runs it and has no problems.

 

However, if he saves the project and sends it to someone else to run, the same Query Builder task changes the code to this:

 

%_eg_conditional_dropds(WORK.QUERY_FOR_CARS);

PROC SQL;
EXECUTE (
   CREATE TABLE WORK.QUERY_FOR_CARS AS    SELECT t1.Make, 
          /* COUNT_DISTINCT_of_Model */
            (COUNT(DISTINCT(t1.Model))) AS COUNT_DISTINCT_of_Model
      FROM SASHELP.CARS t1
      GROUP BY t1.Make;) by con1;
QUIT;

Notice how it sandwhiched the original SQL code inside of "EXECUTE(  ) by con1;".

 

Of course, this makes it errors out:

 

ERROR: The CON1 engine cannot be found.
ERROR: A Connection to the con1 DBMS is not currently supported, or is not installed at your site.

Obviously because I have no idea what con1 is supposed to be and where it's coming from.

 

If we do this in reverse (i.e. I create the project with Query Builder task and then send to him) this issue does not occur.

 

I've tried uninstalling EG, removing the EG settings from ..\appdata\Roaming\SAS\EnterpriseGuide\, but that didn't help.

 

Thoughts?


Accepted Solutions
Solution
‎09-01-2016 04:57 PM
Community Manager
Posts: 2,889

Re: Weird Enterprise Guide issue

No goof on your part -- this should be okay to share a 7.12 project with 7.1, but obviously it breaks down in this case.  Hopefully an easy remedy on your end -- we do recommend that everyone on a team use the same version so that you have access to the same features.

View solution in original post


All Replies
Community Manager
Posts: 2,889

Re: Weird Enterprise Guide issue

I suspect these people are running different versions of SAS Enterprise Guide.  Have each user check the Help->About window and note the versions, then (ideally) update the install for the person on the back-level version.

Regular Contributor
Posts: 171

Re: Weird Enterprise Guide issue

Thanks, Chris. I'm such a goof, I thought we were on the same versions, but remembered our desktop support group has several versions of our depot. I thought I was on the latest version (for my testing), but I'm on 7.1 whereas he's on 7.12.

I will test this and give an update.
Solution
‎09-01-2016 04:57 PM
Community Manager
Posts: 2,889

Re: Weird Enterprise Guide issue

No goof on your part -- this should be okay to share a 7.12 project with 7.1, but obviously it breaks down in this case.  Hopefully an easy remedy on your end -- we do recommend that everyone on a team use the same version so that you have access to the same features.

Regular Contributor
Posts: 171

Re: Weird Enterprise Guide issue

You were right. We reinstalled 7.1 on his machine and he can now share his projects with the rest of his team.

Thanks, Chris!
☑ This topic is solved.

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

Discussion stats
  • 4 replies
  • 1201 views
  • 1 like
  • 2 in conversation