topic Re: Weird Enterprise Guide issue in SAS Enterprise Guide

Weird Enterprise Guide issue

Timmy2383 — Wed, 31 Aug 2016 15:38:45 GMT

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?

Re: Weird Enterprise Guide issue

ChrisHemedinger — Wed, 31 Aug 2016 15:42:30 GMT

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.

Re: Weird Enterprise Guide issue

Timmy2383 — Wed, 31 Aug 2016 15:48:09 GMT

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.

Re: Weird Enterprise Guide issue

ChrisHemedinger — Wed, 31 Aug 2016 16:01:29 GMT

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.

Re: Weird Enterprise Guide issue

Timmy2383 — Thu, 01 Sep 2016 20:57:42 GMT

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!