V9.3 and sharepoint

Reply
N/A
Posts: 1

V9.3 and sharepoint

Hello,

My datasets are saved on a Sharepoint and I was used to create libraries with SAS 9.2 using the pathway to this sharepoint (as a network location on my computer). Since the migration to 9.3, I get the following error message:

ERROR: Encountered error when the V9 engine tried to determine if LIBRARY has a registered

       secured library object location.

ERROR: An I/O error has occurred.

ERROR: Error in the LIBNAME statement.

Do you know how to solve this problem?

Thank you in advance

Maud

New Contributor
Posts: 2

Re: V9.3 and sharepoint

I too would like help on this issue.  Any luck?

New Contributor
Posts: 2

Re: V9.3 and sharepoint

In talking with some SharePoint gurus in our IT community I discovered that SharePoint was never intended to be used this way.  SharePoint is more for tracking MS files (Word docs, Excel spreadsheets, etc.) and not a good architecture for storing and processing datasets.  The fact that we got it to work with SAS 9.2 was possibly a "back door" entrance that wasn't supposed to be there.  I've since tried to replicate the problem in SAS 9.2 and found it not working either, but with a different error statement.  Perhaps MS has pushed a fix?

Super Contributor
Posts: 334

Re: V9.3 and sharepoint

SAS assess to the excel files on sharepoint has been a problem for us as well, so its not just a SAS dataset issue. The only solutions we have found is have access databases (on the network) linked to the excel files in sharepoint. Be interested in any other experiences that people have with Sharepoint and SAS.

EJ

New Contributor
Posts: 4

Re: V9.3 and sharepoint

See SAS Note 48833 (http://support.sas.com/kb/48833).  What I found by using the Windows Process Monitor tool is that SAS is trying to create a file in the folder specified in the LIBNAME under a .sassl folder.  Sharepoint will not allow files or folders to begin with a dot.  I still have a track open with SAS on this issue.

New Contributor
Posts: 4

Re: V9.3 and sharepoint

Posted in reply to steven_taylor_gmfinancial_com

I was told that this issue was fixed in 9.4 and a 9.3 hot fix is in the works.

New Contributor
Posts: 4

Re: V9.3 and sharepoint

Posted in reply to steven_taylor_gmfinancial_com

The hot fix is available. See SAS Note 48833 (http://support.sas.com/kb/48833). Another issue we had was that our "server" name had two dots (e.g. \\dept.company.com).  We had to use an alias to keep the server from trying to treat it as an internet site even with an UNC.


Ask a Question
Discussion stats
  • 6 replies
  • 942 views
  • 0 likes
  • 4 in conversation