News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Data Integration into ...

Finance | Project Operations, Human Resources, ...

Suggested answer

Data Integration into CDM Dataverse Tables

(0) Share

Report

Report

Posted on by PowerChewie

5

Hello!

I'm getting an error 0x80042f0a while using the Data Integration tool to sync data from our SQL server to Dynamics HR cdm_ tables.

Reason: Bad Request, Header x-ms-client-request-id XXXX, Error code: 0x80042f0a, Message: Principal team (Id=XXXXX, type=9, teamType=0, privilegeCount=0), is missing prvReadcdm_worker privilege (Id=XXXXXX) on OTC=10306 for entity 'cdm_worker'. context.Caller=90f17155-6562-eb11-a812-000d3ae94095

Is it because we should be syncing into the Virtual Tables instead of the cdm_ tables?

or is it because we can't add new workers thru the Data Integration tool?

Also, how do you handle nulls, it keeps throwing an error that it exceeds the character limit.

Any light into this would be greatly appreciated.

All responses Img

All responses (2)

Answers Img

Answers (0)

huijij 19,811 on at

Like (0)

Report

RE: Data Integration into CDM Dataverse Tables

Hi sir，

Glad to hear that, please verify your answer to close the thread.
Suggested answer

PowerChewie 5 on at

Like (0)

Report

RE: Data Integration into CDM Dataverse Tables

As suggested in another post the Team needs permissions to Read that Dataverse table, in this case cdm_worker. I used the WebAPI to determine whose Team's Id that was. I then assigned a custom role to the team with Read access to the Dataverse table and now it works no problem.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans