BookmarkSubscribeRSS Feed
JohnWinMcLean
Fluorite | Level 6

How can we address the following error message when trying to connect to a shared repository:

 

"The file location is currently associated to a different repository."


SAS DM Studio25.png
3 REPLIES 3
audrey
SAS Employee

That could mean you're trying to create a New repository, but the file location you are selecting already contains the folders of an existing repository. You should be able to create your repository without using the File location, it is optional, or using a different path. And then, if you want the newly created repository to use these files, edit the repository to add the path to this folder.

 

Hope this helps.

www.sas.comsupport.sas.com
SAS®... THE POWER TO KNOW®
JohnWinMcLean
Fluorite | Level 6
Thanks for your reply.
We were able to connect to the shared repository, however now one of our team cannot see the fields or field descriptions via the business rules manager for the repository.
Initially, once they connected there was a set of fields listed, but not the ones we established when we first created the database. It was almost like business rules manager was pointing a different database.
Where can we see the settings for the business rule manager and where it is specifying which database to look for?
We are using a MS ACCESS database we created named PSRC25_Control Repository on a network (LAN) directory.
Thanks for your help !
audrey
SAS Employee

Business Rule Manager stores its objects (fields, rules, tasks, profiles, etc) in the database that you defined under "Database connection" when creating the repository. In your case, if you can't see your previously created objects, it might be that you created several repositories and are currently not connected to the one that has your objetcs, or you registered several repositories in your Data Management Studio, and you're not opening the correct one in Business Rule Manager.

 

You can see the list of registered repositories in the Administration riser, under Repository Definitions, and which ones you are currently connected to.

 

As a side note, I dont' think MS Access is a supported database format for repository storage, it could be a problem.

 

Hope this helps. If not, you might want to contact Technical Support (support@sas.com).

 

 

www.sas.comsupport.sas.com
SAS®... THE POWER TO KNOW®

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 1107 views
  • 0 likes
  • 2 in conversation