Several months ago my company started rolling out 64-bit machines. Previously we had local installs of SAS 9.1, we now have EG 5.1 installed and are trying to connect to a server which is already being used from a different site. I went to the other site and logged in on one of their machines, so we know it is not our logins. The message received is "An unexpected error has occurred while accessing metadata
A connection could not be made to the SAS Metadata Server but is required for the current operation. Please see your administrator."
I have been working with IT but we have no idea what is wrong, is this a message that people know about? I've attached the full error log in case someone has had the issue before.
Thanks, any help or suggestions much appreciated
This new error tells me that there is likely an issue with Integration Technologies. If you used ITConfig2 to test the workspace server, you should get an error too.
What version of the IntTech client is installed on the EG machine (C:\Program Files\SASHome\Integration Technologies\installs)? Here's the link to download the latest IntTech client for SAS 9.3: https://support.sas.com/downloads/package.htm?pid=1035
Hi @tnimmo0,
So, you are trying to connect to a remote SAS server, not a local SAS server, correct? What version of SAS is your remote server? Still SAS 9.1?
The error you shared indicates that EG was unable to connect to a metadata server at host sasuk.company.corp and port 8561. So, here is what I would suggest trying:
If you are not able to connect to your metadata server from ITConfig2.exe either, there is probably an issue with your connection information or metadata server. If you are able to connect to your metadata server from ITConfig2.exe, confirm you are specifying the same information in your EG connection profile (click link in bottom-right corner of EG, on status bar, to bring up Connections dialog to confirm your active connection profile).
Casey
Register today and join us virtually on June 16!
sasglobalforum.com | #SASGF
View now: on-demand content for SAS users
Thanks Casey,
The server is running 9.3.
I recieved the below error when running in ITConfig2:
System.Runtime.InteropServices.COMException (0x80042002): <connectionAttempts></connectionAttempts>
at SASObjectManager.ObjectFactoryMulti2Class.CreateObjectByServer(String Name, Boolean synchronous, ServerDef pIServerDef, String LoginName, String Password)
at SAS.BI.Itconfig.Library.ServerTests.SASServerTest.CreateConnectionWithObjectFactoryMulti()
at SAS.BI.Itconfig.Library.ServerTests.SASServerTest.CreateConnection()
I know its not the connection profile as I travelled up to our other offices and logged in fine on one of their computers.
Must be something to do with the server.
Thanks for your help.
This new error tells me that there is likely an issue with Integration Technologies. If you used ITConfig2 to test the workspace server, you should get an error too.
What version of the IntTech client is installed on the EG machine (C:\Program Files\SASHome\Integration Technologies\installs)? Here's the link to download the latest IntTech client for SAS 9.3: https://support.sas.com/downloads/package.htm?pid=1035
I think I love you people, IT and I have been trying for months to get this thing working.
Ok, its not completely working, I have a new error, but its the first time that my login has appeared in the corner!
the new error is the 'sas.iomprovider.1' provider is not registered on the local machine
After some searching of these forums, it appears something wasn't present during installation, which sounds easier to sort out than the previous issue.
thank you
Glad to hear that things are progressing!
The new error likely means that the SAS Providers for OLE DB were not installed with EG. Install this on the same computer as Enterprise Guide. Here's the link to download: https://support.sas.com/downloads/package.htm?pid=969
Hopefully a Helpful Hint:The version of EG (5.1) you are using is fairly old. As soon as you get past these install errors, I highly recommend that you install the latest hot fix to ensure that you don't encounter issues that have been resolved in an update. Link to download the last 5.1 hot fix: http://ftp.sas.com/techsup/download/hotfix/HF2/G35.html#G35023
Happy Monday!
All working now, thank you very much!
Can start doing some work on my own machine now!
Could you please tell me steps how to resolve the issue ,,,even one of our user is not able to connect sas eg in his machine but able to connect it from other machine .sas eg version is 7.11
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.