Skip to Content
0

Error in adding central repository in CMC - Data Services

May 22, 2017 at 07:39 AM

63

avatar image
Former Member

Hello -

I'm trying to configure a central repository in the CMC - Data Services. The user I'm using to configure central repository is a Domain Service Account which has only READ only access to the central repository. Test connection was successful. However, when I hit save, I'm encountering this error below:

  • Error msg: com.acta.util.ActaException: [The INSERT permission was denied on the object 'AL_MACHINE_INFO', database 'repo_central', schema 'dbo'.]

Can you please advise the minimum DB rights that the domain system user should have on the Central Repository DB in order to configure it successfully in CMC - Data Services?

Another question is, when configuring the central repository in CMC, does it really, update/insert the table in the central repository?

Installation Details:

Information platform services 4.2 SP3 (14.2.3.2132) - en

SAP Data Services 4.2 SP8 (14.2.8.1354) - en

Both IPS and DS are install in Windows 2012 R2 server

DB is on Windows 2012 R2 server, MS SQL Server 2012 SP2

Thanks for your help

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Dirk Venken
May 22, 2017 at 11:32 AM
0

Database read access is never sufficient. You need write access to the repository tables. BTW, that's true for local repositories, too.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member May 23, 2017 at 05:19 AM
0

Thanks Dirk. Do you know if there is a KBA which I can find the minimum access required for Central and Local Respositories?

Share
10 |10000 characters needed characters left characters exceeded