Architecting, installing and maintaining your SAS environment

SAS Guide unable to connect to metadata

Reply
Contributor
Posts: 24

SAS Guide unable to connect to metadata

Hello guys,

 

I'm stuck in a weird situation. Recently I updated my SAS guide from 7.1 to 7.15 because users are having problems with the excel 2016 format. With 7.1 I was able to connect correctly, but since I installed the 7.15 version I'm not even able to connect to metadata.

 

This is weird because Management console can connect, and also I tried with the integration technologies tools and the connection was correct.

 

When I try to connect using SAS EG I get the message that ask me to check the port and the machine that I'm trying to connect.

 

Any suggestion of what can I try?

Super User
Posts: 3,866

Re: SAS Guide unable to connect to metadata

Posted in reply to iscgonzalez

I suggest you turn on EG logging to see what if happening in more detail:

http://documentation.sas.com/?docsetId=bidaag&docsetTarget=p0gxmv2av4gkvun1vhamsvtrs6tv.htm&docsetVe...

 

Also I suggest opening a track with SAS Tech Support.

Trusted Advisor
Posts: 1,758

Re: SAS Guide unable to connect to metadata

Posted in reply to iscgonzalez

Hello @iscgonzalez,

 

a track with SAS TS is a very good idea, as proposed by @SASKiwi.

 

I am wondering how that upgrade went and based on what. I mean:

- What kind of error do you get?

- How are you installing EG: locally on a PC, on Citrix, on another virtualization software such as AppV or ThinApp? 

- Have you modified the connection details in your EG profile to that server?

 

 

Besides checking logs in Metadata, you could also check the events in windows (Event Viewer) and you could enable the longing on EG and see the logs on EG ( http://support.sas.com/kb/55/414.html ).

Contributor
Posts: 24

Re: SAS Guide unable to connect to metadata

Posted in reply to JuanS_OCS
I've found that the problem comes when I install EG using the 64 bit Native mode. I thought that if I had a x64 bit OS that would be the best option. It works with the 32 bit compatibility mode.
SAS Employee
Posts: 296

Re: SAS Guide unable to connect to metadata

Posted in reply to iscgonzalez

Still, it's an interesting question. Regardless of the bitness of EG and/or Windows and/or Office, you should at least get a successful connection to the Metadata server.

 

Open a Windows command prompt and then type:

 

telnet <<Metadata host name>> <<port>>

 

The above two values need to be EXACTLY what you use in Enterprise Guide. If you do this, what error(s) do you get ?

Contributor
Posts: 24

Re: SAS Guide unable to connect to metadata

I've checked the ports and connections, I checked them with telnet and with SAS integration technologies tool. With both I get correct connections to metadata and to workspace.

 

SAS Employee
Posts: 296

Re: SAS Guide unable to connect to metadata

Posted in reply to iscgonzalez

I agree. We need to see the error to be able to assist.

 

What version is your Metadata server ?

Contributor
Posts: 23

Re: SAS Guide unable to connect to metadata

Posted in reply to iscgonzalez

You can also validate the User and its credentials on both servers by using SAS Integration Technologies Configuration Wizard.

 

Metadata Server

WorkSpace Server

 

Contributor
Posts: 25

Re: SAS Guide unable to connect to metadata

Posted in reply to iscgonzalez

Can you paste the error message in detail? Maybe someone can take a look at the error message and identify what's wrong.

 

Thanks,

SK

Ask a Question
Discussion stats
  • 8 replies
  • 256 views
  • 1 like
  • 6 in conversation