topic Re: Unable to save projects to SAS folders in SAS Programming

Unable to save projects to SAS folders

KBACHU — Tue, 13 Jan 2015 15:48:16 GMT

I am getting the error message 'Unable to access the midtier service registry' when I try to save the data to Metadata folders. I am able to save it to the physical path on the servers, but not the metadata folders. Can anyone please advice?

Re: Unable to save projects to SAS folders

KBACHU — Tue, 13 Jan 2015 15:50:29 GMT

Actually, I am trying to save Enterprise Guide projects, not the data. I found the below sasnote, but the issue is not with EG as I am able to do the same on different servers.

52662 - You cannot save a SAS® Enterprise Guide® 5.1 project to the SAS Folders tree in SAS® 9.4 TS1M0 and TS1M1

Re: Unable to save projects to SAS folders

mohamed_zaki — Tue, 13 Jan 2015 15:53:42 GMT

What is your environment version SAS, SAS Enterprise Guide?

Re: Unable to save projects to SAS folders

KBACHU — Tue, 13 Jan 2015 15:56:05 GMT

SAS Enterprise Guide 5.1 and SAS 9.3 on AIX.

Re: Unable to save projects to SAS folders

gergely_batho — Tue, 13 Jan 2015 21:44:36 GMT

Do you have the same messages in the logs?

Does the user have write access to that metadata location? (Can you crete a new folder there, or save/create something else?)

Re: Unable to save projects to SAS folders

KBACHU — Tue, 13 Jan 2015 23:30:08 GMT

Yes, Users do have necessary permissions to the Metadata folders. I can create a new folder under 'My Folder' but not able to rename it or write any projects to it.

Regarding the logs, I enabled logging in EG and I see similar error messages.

Re: Unable to save projects to SAS folders

Kurt_Bremser — Wed, 14 Jan 2015 06:37:59 GMT

One problem I had came from a too large time difference between the server and the client, but I rather don't think that is behind your problem. Looks like a case for SAS TS.

Re: Unable to save projects to SAS folders

sasprofile — Sun, 22 Mar 2015 01:29:58 GMT

Hi,

am getting same issue in Enterprise guide 5.1 on SAS 9.2,throws an error

Am unexpected error has occured while accessing the SAS Middle-tier Web services.

Unable to access the services registry on the SAS middle-tier

am not able to rename or folder after i have created in SAS Folders on EG.

I checked the permissions in the Metadata level in SAS Management console,and it has all permissions.but still not able to save.

please help.

Re: Unable to save projects to SAS folders

sasprofile — Sun, 22 Mar 2015 10:45:48 GMT

KBACHU,

am getting same error in Enterprise guide 5.1 on SAS 9.2

Am unexpected error has occured while accessing the SAS Middle-tier Web services.

Unable to access the services registry on the SAS middle-tier

am not able to rename or delete folder after i have created in SAS Folders on EG.

I checked the permissions in the Metadata level in SAS Management console,and it has all permissions.but still not able to save.

Did you find the solution after you got this error,were you able to fix the issue.

please can you share the solution.

Re: Unable to save projects to SAS folders

sasprofile — Sun, 22 Mar 2015 11:02:25 GMT

Hi,

am getting same error in Enterprise guide 5.1 on SAS 9.2.

An unexpected error has occured while accessing the SAS Middle-tier Web services.

Unable to access the services registry on the SAS middle-tier

am not able to rename or delete folder after i have created in SAS Folders on EG.

I checked the permissions in the Metadata level in SAS Management console,and it has all permissions.but still not able to save.

everything worked fine till couple of days back,we were able to save everything in EG under sas folders.

Its not getting saved and throwing error since from yesterday.both the dev and production are on same server.

and am able to save project in EG in production but why not Devlopmemt all of sudden.

am not getting any idea,please help.

Re: Unable to save projects to SAS folders

KBACHU — Mon, 23 Mar 2015 12:53:48 GMT

Can you send me the content of the error message? I wanted to see if I have got the same mesaage. Also, please check if you have multiple web services deployed with the same name. The issue which I have came across was because of two werb services with the same name. Deleting one web service fixed the issue.
SAS Folders > system > services > web services

Re: Unable to save projects to SAS folders

sasprofile — Mon, 23 Mar 2015 14:54:19 GMT

KBACHU,

Thank you so much for your prompt response,I really appreciate that.as you said I have checked under SAS Folder>systems>services in Management console.

but the services folder was empty i dont see anything in that.below is the error message i got when am trying to save the project.

An Unexpected error has occured while accessing the SAS middle-tier Web services

Unable tp access the service registry on the SAS middle tier.
------------------------------------------------------
Unable to access the midtier service registry
Unable to access the midtier service registry
The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.
The remote certificate is invalid according to the validation procedure.

-------------------------- Technical Information Follows --------------------------

Exception Details:
----------------------------------------
Exception type: SAS.EC.Directory.WebServices.WebServicesException
Message:         Unable to access the midtier service registry
Source:          EC.Directory
Target Site:     GetServices

Stack Trace:
   at SAS.EC.Directory.WebServices.SASServiceRegistry.GetServices()
   at SAS.EC.Directory.WebServices.SASServiceRegistry.GetURI(String service)
   at SAS.EC.Directory.Metadata.OMSProvider.GetSecuredServiceURI(String name, AuthenticationManager authMgr)
   at SAS.EG.SDS.Model.OMBase.InitDAV()
   at SAS.EG.SDS.Model.ProjectBase.Update()
   at SAS.EG.ProjectElements.LinkedRegisteredProjectFile.Flush(IProvideMetadataDependencies projectDependencyProvider)
   at SAS.EG.ProjectElements.ProjectFile.Save(IProvideMetadataDependencies projectDependencyProvider)
   at SAS.EG.ProjectElements.ProjectCollection.Save(Boolean resetModified, Boolean forRecovery)
   at SAS.EG.ProjectElements.ProjectCollection.SaveAs(SaveAsPath sap, DNADecoder dec)
   at SAS.EG.MainForm.SaveAsProject(Boolean UseLocalPathOnly)

Inner Exception Details:
----------------------------------------
Exception type: SAS.EC.Directory.WebServices.WebServicesException
Message:         Unable to access the midtier service registry
Source:          EC.Directory
Target Site:     GetServices

Inner Exception Details:
----------------------------------------
Exception type: System.Net.WebException
Message:         The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.
Source:          System.Web.Services
Target Site:     GetWebResponse

Inner Exception Details:
----------------------------------------
Exception type: System.Security.Authentication.AuthenticationException
Message:         The remote certificate is invalid according to the validation procedure
Source:          System
Target Site:     StartSendAuthResetSignal

Stack Trace:
   at System.Net.Security.SslState.StartSendAuthResetSignal(ProtocolToken message, AsyncProtocolRequest asyncRequest, Exception exception)
   at System.Net.Security.SslState.CheckCompletionBeforeNextReceive(ProtocolToken message, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.StartSendBlob(Byte[] incoming, Int32 count, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.ProcessReceivedBlob(Byte[] buffer, Int32 count, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.StartReadFrame(Byte[] buffer, Int32 readBytes, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.StartReceiveBlob(Byte[] buffer, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.CheckCompletionBeforeNextReceive(ProtocolToken message, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.StartSendBlob(Byte[] incoming, Int32 count, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.ProcessReceivedBlob(Byte[] buffer, Int32 count, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.StartReadFrame(Byte[] buffer, Int32 readBytes, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.StartReceiveBlob(Byte[] buffer, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.CheckCompletionBeforeNextReceive(ProtocolToken message, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.StartSendBlob(Byte[] incoming, Int32 count, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.ProcessReceivedBlob(Byte[] buffer, Int32 count, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.StartReadFrame(Byte[] buffer, Int32 readBytes, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.StartReceiveBlob(Byte[] buffer, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.CheckCompletionBeforeNextReceive(ProtocolToken message, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.StartSendBlob(Byte[] incoming, Int32 count, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.ProcessReceivedBlob(Byte[] buffer, Int32 count, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.StartReadFrame(Byte[] buffer, Int32 readBytes, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.StartReceiveBlob(Byte[] buffer, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.CheckCompletionBeforeNextReceive(ProtocolToken message, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.StartSendBlob(Byte[] incoming, Int32 count, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.ProcessReceivedBlob(Byte[] buffer, Int32 count, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.StartReadFrame(Byte[] buffer, Int32 readBytes, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.StartReceiveBlob(Byte[] buffer, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.CheckCompletionBeforeNextReceive(ProtocolToken message, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.StartSendBlob(Byte[] incoming, Int32 count, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.ForceAuthentication(Boolean receiveFirst, Byte[] buffer, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.ProcessAuthentication(LazyAsyncResult lazyResult)
   at System.Net.TlsStream.CallProcessAuthentication(Object state)
   at System.Threading.ExecutionContext.runTryCode(Object userData)
   at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean ignoreSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Net.TlsStream.ProcessAuthentication(LazyAsyncResult result)
   at System.Net.TlsStream.Write(Byte[] buffer, Int32 offset, Int32 size)
   at System.Net.PooledStream.Write(Byte[] buffer, Int32 offset, Int32 size)
   at System.Net.ConnectStream.WriteHeaders(Boolean async)

Re: Unable to save projects to SAS folders

KBACHU — Mon, 23 Mar 2015 15:44:04 GMT

I dont think, the problem is with the sastruct credentails as you were able to validate sas content server successfully. Do you know if all the users are having the problem or just you? I am thinking that it might be problem with the Enterprise Guide installation as EG uses .net framework to communicate with web based applications. Try doing the same on a different computer or try reinstalling enterprise guide.

Karthik

Re: Unable to save projects to SAS folders

sasprofile — Mon, 23 Mar 2015 15:56:41 GMT

Karthik,

Intially a user got this issue.then I have checked on my system same error i got.

and i don't think so it might be a SAS EG installation problem,because most of our users use EG which is published on Citrix,just they login into Citrix and work with EG.

and even i tried with EG on Citrix,same error am getting.

Re: Unable to save projects to SAS folders

PaulHomes — Tue, 24 Mar 2015 04:44:22 GMT

From the stack trace you posted, it looks to me like you're having problems with your SSL certificate on the mid-tier web server (where the SAS Content Server provides WebDAV services for the platform to store documents) . Have you verified the SSL certificate hasn't expired, or that everything has been put in place to ensure the certificate chain to the CA is trusted?

Re: Unable to save projects to SAS folders

sasprofile — Wed, 25 Mar 2015 19:01:18 GMT

Paul Homes,

Thank you for your valuable advice,I appreciate that.

I found the SSL certificate is not expired not it has been renewed.

but IE browser level,I am getting an error I have installed some certificate by clicking in the certificate error on top right of the browser.after doing that i tested again saving project,but this time am getting a different error,not sure what is this error again.

any idea about this error,how it can be fixed ?

An Unexpected error has occured

Unable to store the project in DAV.
-----------------------------------
-----------------------------------

Client found response content type of 'text/html; charset=UTF-8', but expected 'text/xml'.
The request failed with the error message:
--
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Draft//EN">
<HTML>
<HEAD>
<TITLE>Error 500--Internal Server Error</TITLE>
<META NAME="GENERATOR" CONTENT="WebLogic Server">
</HEAD>
<BODY bgcolor="white">
<FONT FACE=Helvetica><BR CLEAR=all>
<TABLE border=0 cellspacing=5><TR><TD><BR CLEAR=all>
<FONT FACE="Helvetica" COLOR="black" SIZE="3"><H2>Error 500--Internal Server Error</H2>
</FONT></TD></TR>
</TABLE>
<TABLE border=0 width=100% cellpadding=10><TR><TD VALIGN=top WIDTH=100% BGCOLOR=white><FONT FACE="Courier New"><FONT FACE="Helvetica" SIZE="3"><H3>From RFC 2068 <i>Hypertext Transfer Protocol -- HTTP/1.1</i>:</H3>
</FONT><FONT FACE="Helvetica" SIZE="3"><H4>10.5.1 500 Internal Server Error</H4>
</FONT><P><FONT FACE="Courier New">The server encountered an unexpected condition which prevented it from fulfilling the request.</FONT></P>
</FONT></TD></TR>
</TABLE>

</BODY>
</HTML>

--.
Client found response content type of 'text/html; charset=UTF-8', but expected 'text/xml'.
The request failed with the error message:
--
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Draft//EN">
<HTML>
<HEAD>
<TITLE>Error 500--Internal Server Error</TITLE>
<META NAME="GENERATOR" CONTENT="WebLogic Server">
</HEAD>
<BODY bgcolor="white">
<FONT FACE=Helvetica><BR CLEAR=all>
<TABLE border=0 cellspacing=5><TR><TD><BR CLEAR=all>
<FONT FACE="Helvetica" COLOR="black" SIZE="3"><H2>Error 500--Internal Server Error</H2>
</FONT></TD></TR>
</TABLE>
<TABLE border=0 width=100% cellpadding=10><TR><TD VALIGN=top WIDTH=100% BGCOLOR=white><FONT FACE="Courier New"><FONT FACE="Helvetica" SIZE="3"><H3>From RFC 2068 <i>Hypertext Transfer Protocol -- HTTP/1.1</i>:</H3>
</FONT><FONT FACE="Helvetica" SIZE="3"><H4>10.5.1 500 Internal Server Error</H4>
</FONT><P><FONT FACE="Courier New">The server encountered an unexpected condition which prevented it from fulfilling the request.</FONT></P>
</FONT></TD></TR>
</TABLE>

</BODY>
</HTML>

--.

-------------------------- Technical Information Follows --------------------------

Exception Details:
----------------------------------------
Exception type: SAS.EG.SDS.SDSException
Message: Client found response content type of 'text/html; charset=UTF-8', but expected 'text/xml'.
The request failed with the error message:
--
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Draft//EN">
<HTML>
<HEAD>
<TITLE>Error 500--Internal Server Error</TITLE>
<META NAME="GENERATOR" CONTENT="WebLogic Server">
</HEAD>
<BODY bgcolor="white">
<FONT FACE=Helvetica><BR CLEAR=all>
<TABLE border=0 cellspacing=5><TR><TD><BR CLEAR=all>
<FONT FACE="Helvetica" COLOR="black" SIZE="3"><H2>Error 500--Internal Server Error</H2>
</FONT></TD></TR>
</TABLE>
<TABLE border=0 width=100% cellpadding=10><TR><TD VALIGN=top WIDTH=100% BGCOLOR=white><FONT FACE="Courier New"><FONT FACE="Helvetica" SIZE="3"><H3>From RFC 2068 <i>Hypertext Transfer Protocol -- HTTP/1.1</i>:</H3>
</FONT><FONT FACE="Helvetica" SIZE="3"><H4>10.5.1 500 Internal Server Error</H4>
</FONT><P><FONT FACE="Courier New">The server encountered an unexpected condition which prevented it from fulfilling the request.</FONT></P>
</FONT></TD></TR>
</TABLE>

</BODY>
</HTML>

--.
Source: SAS.EG.SDS.Model
Target Site: Update

Stack Trace:
   at SAS.EG.SDS.Model.ProjectBase.Update()
   at SAS.EG.ProjectElements.LinkedRegisteredProjectFile.Flush(IProvideMetadataDependencies projectDependencyProvider)
   at SAS.EG.ProjectElements.ProjectFile.Save(IProvideMetadataDependencies projectDependencyProvider)
   at SAS.EG.ProjectElements.ProjectCollection.Save(Boolean resetModified, Boolean forRecovery)
   at SAS.EG.ProjectElements.ProjectCollection.SaveAs(SaveAsPath sap, DNADecoder dec)
   at SAS.EG.MainForm.SaveAsProject(Boolean UseLocalPathOnly)

Inner Exception Details:
----------------------------------------
Exception type: System.InvalidOperationException
Message: Client found response content type of 'text/html; charset=UTF-8', but expected 'text/xml'.
The request failed with the error message:
--
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Draft//EN">
<HTML>
<HEAD>
<TITLE>Error 500--Internal Server Error</TITLE>
<META NAME="GENERATOR" CONTENT="WebLogic Server">
</HEAD>
<BODY bgcolor="white">
<FONT FACE=Helvetica><BR CLEAR=all>
<TABLE border=0 cellspacing=5><TR><TD><BR CLEAR=all>
<FONT FACE="Helvetica" COLOR="black" SIZE="3"><H2>Error 500--Internal Server Error</H2>
</FONT></TD></TR>
</TABLE>
<TABLE border=0 width=100% cellpadding=10><TR><TD VALIGN=top WIDTH=100% BGCOLOR=white><FONT FACE="Courier New"><FONT FACE="Helvetica" SIZE="3"><H3>From RFC 2068 <i>Hypertext Transfer Protocol -- HTTP/1.1</i>:</H3>
</FONT><FONT FACE="Helvetica" SIZE="3"><H4>10.5.1 500 Internal Server Error</H4>
</FONT><P><FONT FACE="Courier New">The server encountered an unexpected condition which prevented it from fulfilling the request.</FONT></P>
</FONT></TD></TR>
</TABLE>

</BODY>
</HTML>

--.
Source: System.Web.Services
Target Site: ReadResponse

Stack Trace:
   at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
   at SAS.EC.Directory.WebServices.DAVService.DAVService.itemExists(String objectPath)
   at SAS.EG.SDS.Model.ProjectBase.Update()

Re: Unable to save projects to SAS folders

PaulHomes — Thu, 26 Mar 2015 04:38:48 GMT

I wouldn't just dismiss the certificate error the browser gave you. If the SSL certificate is a problem for your browser, it may well also a problem for the connections SAS apps and clients make on your behalf to the mid-tier. What was the message your browser presented when it complained about the SSL certificate? Was it related to trust? Did you have to install your CA certificate as trusted for your browser? If the certificate is self-signed or signed by an intermediate CA then it will need to be installed in all the appropriate key stores. I would suggest methodically checking the various components involved. There are some standard Java SSL related system properties you can set for troubleshooting what is going on.

If you haven't seen it yet, have a read of the the Using Secure Sockets Layer (SSL) for Web Applications section of SAS(R) 9.2 Intelligence Platform: Web Application Administration Guide, Fourth Edition

For the HTTP 500 error you are getting I'd look in the WebLogic server logs for more information.

BTW This looks like the same question as

Re: Unable to save projects to SAS folders

sasprofile — Thu, 26 Mar 2015 14:02:10 GMT

below is the error I got when I entered a url in the IE browser

There is a problem with this website's security certificate.

The security certificate presented by this website was not issued by a trusted certificate authority.

Security certificate problems may indicate an attempt to fool you or intercept any data you send to the server.

We recommend that you close this webpage and do not continue to this website.

Click here to close this webpage.

Continue to this website (not recommended).

More information

If you arrived at this page by clicking a link, check the website address in the address bar to be sure that it is the address you were expecting.
When going to a website with an address such as https://example.com, try adding the 'www' to the address, https://www.example.com.
If you choose to ignore this error and continue, do not enter private information into the website.

For more information, see "Certificate Errors" in Internet Explorer Help.
----------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------
Clicked on Continue to this website (not recommended).

Clicked on Certificate error on right handside on the browser bar

Then Clicked on view certificates

pop up window with name "certificate" appeared

Then clicked on Install certificate

It took me to next page Welcome to the Certificate Import wizard

It gave 2 below options to select

1)Automtaically select the certificate store based on the type of certificate

-->Certificare stored selected Automaticall determined by the wizard

-->Content Certificate

2)Place all certificate in the following store

-->Clicked browse and selected Trusted Root certification Authorities

I installed the certificate and now it is giving a different error which I shared you in previous note.

The SSL certificate has not expired and it has not been renewed recently.

Re: Unable to save projects to SAS folders

PaulHomes — Mon, 30 Mar 2015 08:54:02 GMT

Whilst you have asked your browser to ignore the certificate error, other people in your organization, and other software components, may run into this issue too, since the CA for your certificate may not be in their trusted CAs list. Since your certificate was not issued by a well known trusted CA you will most likely need to verify the custom/intermediate CA cert is installed in all the appropriate locations (and take steps to install it if required).

Is it a self-signed cert, one signed by an internal corporate CA, or one that was signed by an intermediate CA of a well known certificate provider?

In the meantime, have you looked in your WebLogic logs to find the root cause of the HTTP 500 error? Is it also a certificate trust issue or some other problem?