0% found this document useful (0 votes)
5 views18 pages

Report SQL

The execution of the DataRemediationD365 Leads process failed due to a lack of user permissions, specifically the absence of roles required to access the CRM entity 'lead'. The error occurred during the pre-execute phase, resulting in multiple error messages indicating the need for the prvReadEntity privilege. The process had a total duration of 6.617 seconds and was initiated by the user 'SERVICE-NOW\svc_sqluser'.

Uploaded by

agatwork04
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
5 views18 pages

Report SQL

The execution of the DataRemediationD365 Leads process failed due to a lack of user permissions, specifically the absence of roles required to access the CRM entity 'lead'. The error occurred during the pre-execute phase, resulting in multiple error messages indicating the need for the prvReadEntity privilege. The process had a total duration of 6.617 seconds and was initiated by the user 'SERVICE-NOW\svc_sqluser'.

Uploaded by

agatwork04
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Messages

on USWUS2SALEOPD01 at 24-11-2025 14:25:07

This report displays messages for the executions or validations.

View Overview

Execution Information

Operation ID 4292700 (Execution)

Name DataRemediation\DataRemediationD365\[Link]

Environment -

Status Failed

Error Messages

Message Type Action Message Time

OnError View Context 24-11-2025 00:42:06

OnError View Context 24-11-2025 00:42:06

1 / 18 Use scroll wheel or PAGE UP & PAGE DOWN to move through pages.
Duration (sec) 6.617

Start Time 24-11-2025 00:42:01

End Time 24-11-2025 00:42:07

Caller SERVICE-NOW\svc_sqluser

Message Message Source Name Subcomponent Name

Process Leads:Error: Dynamics CRM Destination failed Process Leads [Link]


the pre-execute phase and returned error code
0x80131500.

Process Leads:Error: Process Leads Dynamics CRM Destination [53]


[Link]
eException: CRM service call returned an error: An error
has occurred when retrieving metadata for CRM entity
'lead': CRM service call returned an error:
TryGetMaxPrivilegeDepthForUserAcrossBusinessUnits:
The user with id 5bd32077-bad8-eb11-
bacb-000d3a1861ee has not been assigned any roles.
They need a role with the prvReadEntity privilege. (Error
Code: -2147209463, Detail Message:
TryGetMaxPrivilegeDepthForUserAcrossBusinessUnits:
The user with id 5bd32077-bad8-eb11-
bacb-000d3a1861ee has not been assigned any roles.
They need a role with the prvReadEntity privilege.) (Error
Code: -2147209463, Detail Message:
TryGetMaxPrivilegeDepthForUserAcrossBusinessUnits:
The user with id 5bd32077-bad8-eb11-
bacb-000d3a1861ee has not been assigned any roles.
They need a role with the prvReadEntity privilege.) --->
[Link]
eException: CRM service call returned an error:
TryGetMaxPrivilegeDepthForUserAcrossBusinessUnits:
The user with id 5bd32077-bad8-eb11-
bacb-000d3a1861ee has not been assigned any roles.
They need a role with the prvReadEntity privilege. (Error
Code: -2147209463, Detail Message:
TryGetMaxPrivilegeDepthForUserAcrossBusinessUnits:
The user with id 5bd32077-bad8-eb11-
bacb-000d3a1861ee has not been assigned any roles.
They need a role with the prvReadEntity privilege.) --->
[Link]`1
[[Link].Soap2011
.[Link]]:
TryGetMaxPrivilegeDepthForUserAcrossBusinessUnits:
The user with id 5bd32077-bad8-eb11-
bacb-000d3a1861ee has not been assigned any roles.
They need a role with the prvReadEntity privilege.

2 / 18 Use scroll wheel or PAGE UP & PAGE DOWN to move through pages.
Execution Path

\Package1\Process Leads

\Package1\Process Leads

3 / 18 Use scroll wheel or PAGE UP & PAGE DOWN to move through pages.
All Messages

Filter: Message Type: All; (4 more)

Message Type Message Time

OnPostExecute 24-11-2025 00:42:06

4 / 18 Use scroll wheel or PAGE UP & PAGE DOWN to move through pages.
Server stack trace:
at
[Link]
eply(ProxyOperationRuntime operation, ProxyRpc& rpc)
at [Link]
(String action, Boolean oneway, ProxyOperationRuntime
operation, Object[] ins, Object[] outs, TimeSpan timeout)
at
[Link]
okeService(IMethodCallMessage methodCall,
ProxyOperationRuntime operation)
at
[Link]
oke(IMessage message)

Exception rethrown at [0]:


at
[Link]
rnMessage(IMessage reqMsg, IMessage retMsg)
at
[Link]
ke(MessageData& msgData, Int32 type)
at
[Link].Soap2011
.[Link]
(OrganizationRequest request)
at ppw`[Link][dg](Func`1 itv)
at [Link]()
at [Link][dg](Func`1 itv, Func`2 itw, Int32 itx, pyw ity)
--- End of inner exception stack trace ---
at [Link][dg](Func`1 itv, Func`2 itw, Int32 itx, pyw ity)
at [Link](OrganizationRequest itv, Boolean itw,
Nullable`1 itx, PipelineComponent ity, Nullable`1 itz, Int32
iua)
at [Link](String itv, Boolean itw)
--- End of inner exception stack trace ---
at [Link](String itv, Boolean itw)
at [Link](String itv, Boolean itw, Boolean itx)
at [Link](String itv, String itw, Boolean& itx)
at pcy`[Link](String itv, cp itw)
at pcy`[Link](IDTSExternalMetadataColumn100 itv, Int32
itw, Boolean itx)
at
[Link]
`[Link]()
at [Link]`1..ctor(IEnumerable`1
collection)
at [Link][TSource]
(IEnumerable`1 source)
at pcy`2..ctor(pcs itv, pdf itw)
at ppr..ctor(ppo itv, pcs itw, ppd itx)
at pos..ctor(ppo itv, pcs itw, ppd itx)
at [Link](pcs itv)
at
[Link]
[Link]()
at
[Link]
[Link](IDTSManagedComponentWrapper100
wrapper)

Message Message Source Name Subcomponent Name

Package1:Finished, 12:42:06 AM, Elapsed time: Package1


00:00:02.937.

5 / 18 Use scroll wheel or PAGE UP & PAGE DOWN to move through pages.
Execution Path

\Package1

6 / 18 Use scroll wheel or PAGE UP & PAGE DOWN to move through pages.
OnWarning 24-11-2025 00:42:06

OnPostExecute 24-11-2025 00:42:06

OnTaskFailed 24-11-2025 00:42:06

OnInformation 24-11-2025 00:42:06

OnInformation 24-11-2025 00:42:06

OnInformation 24-11-2025 00:42:06

OnInformation 24-11-2025 00:42:06

OnInformation 24-11-2025 00:42:06

OnInformation 24-11-2025 00:42:06

OnError 24-11-2025 00:42:06

OnError 24-11-2025 00:42:06

7 / 18 Use scroll wheel or PAGE UP & PAGE DOWN to move through pages.
Package1:Warning: SSIS Warning Code Package1
DTS_W_MAXIMUMERRORCOUNTREACHED. The
Execution method succeeded, but the number of errors
raised (2) reached the maximum allowed (1); resulting in
failure. This occurs when the number of errors reaches the
number specified in MaximumErrorCount. Change the
MaximumErrorCount or fix the errors.

Process Leads:Finished, 12:42:06 AM, Elapsed time: Process Leads


00:00:02.531.

Process Leads:The task, 'Process Leads', failed. Process Leads

Process Leads:Information: Cleanup phase is beginning. Process Leads [Link]

Process Leads:Information: "Pass 1" wrote 0 rows. Process Leads [Link]

Process Leads:Information: "Pass" wrote 0 rows. Process Leads [Link]

Process Leads:Information: "OLE DB Destination 1" wrote Process Leads [Link]


0 rows.

Process Leads:Information: "OLE DB Destination" wrote 0 Process Leads [Link]


rows.

Process Leads:Information: Post Execute phase is Process Leads [Link]


beginning.

Process Leads:Error: Dynamics CRM Destination failed Process Leads [Link]


the pre-execute phase and returned error code
0x80131500.

Process Leads:Error: Process Leads Dynamics CRM Destination [53]


[Link]
eException: CRM service call returned an error: An error
has occurred when retrieving metadata for CRM entity
'lead': CRM service call returned an error:
TryGetMaxPrivilegeDepthForUserAcrossBusinessUnits:
The user with id 5bd32077-bad8-eb11-
bacb-000d3a1861ee has not been assigned any roles.
They need a role with the prvReadEntity privilege. (Error
Code: -2147209463, Detail Message:
TryGetMaxPrivilegeDepthForUserAcrossBusinessUnits:
The user with id 5bd32077-bad8-eb11-
bacb-000d3a1861ee has not been assigned any roles.
They need a role with the prvReadEntity privilege.) (Error
Code: -2147209463, Detail Message:
TryGetMaxPrivilegeDepthForUserAcrossBusinessUnits:
The user with id 5bd32077-bad8-eb11-
bacb-000d3a1861ee has not been assigned any roles.
They need a role with the prvReadEntity privilege.) --->
[Link]
eException: CRM service call returned an error:
TryGetMaxPrivilegeDepthForUserAcrossBusinessUnits:
The user with id 5bd32077-bad8-eb11-
bacb-000d3a1861ee has not been assigned any roles.
They need a role with the prvReadEntity privilege. (Error
Code: -2147209463, Detail Message:
TryGetMaxPrivilegeDepthForUserAcrossBusinessUnits:
The user with id 5bd32077-bad8-eb11-
bacb-000d3a1861ee has not been assigned any roles.
They need a role with the prvReadEntity privilege.) --->
[Link]`1
[[Link].Soap2011
.[Link]]:
TryGetMaxPrivilegeDepthForUserAcrossBusinessUnits:
The user with id 5bd32077-bad8-eb11-
bacb-000d3a1861ee has not been assigned any roles.
They need a role with the prvReadEntity privilege.

8 / 18 Use scroll wheel or PAGE UP & PAGE DOWN to move through pages.
\Package1

\Package1\Process Leads

\Package1\Process Leads

\Package1\Process Leads

\Package1\Process Leads

\Package1\Process Leads

\Package1\Process Leads

\Package1\Process Leads

\Package1\Process Leads

\Package1\Process Leads

\Package1\Process Leads

9 / 18 Use scroll wheel or PAGE UP & PAGE DOWN to move through pages.
OnInformation 24-11-2025 00:42:04

OnInformation 24-11-2025 00:42:04

OnPostValidate 24-11-2025 00:42:04

OnInformation 24-11-2025 00:42:04

OnPreValidate 24-11-2025 00:42:04

10 / 18 Use scroll wheel or PAGE UP & PAGE DOWN to move through pages.
Server stack trace:
at
[Link]
eply(ProxyOperationRuntime operation, ProxyRpc& rpc)
at [Link]
(String action, Boolean oneway, ProxyOperationRuntime
operation, Object[] ins, Object[] outs, TimeSpan timeout)
at
[Link]
okeService(IMethodCallMessage methodCall,
ProxyOperationRuntime operation)
at
[Link]
oke(IMessage message)

Exception rethrown at [0]:


at
[Link]
rnMessage(IMessage reqMsg, IMessage retMsg)
at
[Link]
ke(MessageData& msgData, Int32 type)
at
[Link].Soap2011
.[Link]
(OrganizationRequest request)
at ppw`[Link][dg](Func`1 itv)
at [Link]()
at [Link][dg](Func`1 itv, Func`2 itw, Int32 itx, pyw ity)
--- End of inner exception stack trace ---
at [Link][dg](Func`1 itv, Func`2 itw, Int32 itx, pyw ity)
at [Link](OrganizationRequest itv, Boolean itw,
Nullable`1 itx, PipelineComponent ity, Nullable`1 itz, Int32
iua)
at [Link](String itv, Boolean itw)
--- End of inner exception stack trace ---
at [Link](String itv, Boolean itw)
at [Link](String itv, Boolean itw, Boolean itx)
at [Link](String itv, String itw, Boolean& itx)
at pcy`[Link](String itv, cp itw)
at pcy`[Link](IDTSExternalMetadataColumn100 itv, Int32
itw, Boolean itx)
at
[Link]
`[Link]()
at [Link]`1..ctor(IEnumerable`1
collection)
at [Link][TSource]
(IEnumerable`1 source)
at pcy`2..ctor(pcs itv, pdf itw)
at ppr..ctor(ppo itv, pcs itw, ppd itx)
at pos..ctor(ppo itv, pcs itw, ppd itx)
at [Link](pcs itv)
at
[Link]
[Link]()
at
[Link]
[Link](IDTSManagedComponentWrapper100
wrapper)

Process Leads:Information: Pre-Execute phase is Process Leads [Link]


beginning.

Process Leads:Information: Prepare for Execute phase is Process Leads [Link]


beginning.

Process Leads:Validation is complete. Process Leads

Process Leads:Information: Validation phase is beginning. Process Leads [Link]

Process Leads:Validation has started. Process Leads

11 / 18 Use scroll wheel or PAGE UP & PAGE DOWN to move through pages.
\Package1\Process Leads

\Package1\Process Leads

\Package1\Process Leads

\Package1\Process Leads

\Package1\Process Leads

12 / 18 Use scroll wheel or PAGE UP & PAGE DOWN to move through pages.
OnPreExecute 24-11-2025 00:42:04

OnPostExecute 24-11-2025 00:42:04

OnPostValidate 24-11-2025 00:42:04

OnPreValidate 24-11-2025 00:42:04

OnPreExecute 24-11-2025 00:42:04

OnPostExecute 24-11-2025 00:42:04

OnPostValidate 24-11-2025 00:42:03

OnPreValidate 24-11-2025 00:42:03

OnPreExecute 24-11-2025 00:42:03

OnPreExecute 24-11-2025 00:42:03

OnPostValidate 24-11-2025 00:42:03

OnPostValidate 24-11-2025 00:42:03

OnPreValidate 24-11-2025 00:42:03

OnPostValidate 24-11-2025 00:42:03

OnPreValidate 24-11-2025 00:42:03

OnPostValidate 24-11-2025 00:42:03

OnPostValidate 24-11-2025 00:42:03

OnInformation 24-11-2025 00:42:03

OnPreValidate 24-11-2025 00:42:03

OnPostValidate 24-11-2025 00:42:03

OnPreValidate 24-11-2025 00:42:03

OnPostValidate 24-11-2025 00:42:03

OnPreValidate 24-11-2025 00:42:03

OnPostValidate 24-11-2025 00:42:03

OnPreValidate 24-11-2025 00:42:03

OnPreValidate 24-11-2025 00:42:03

OnPostValidate 24-11-2025 00:42:03

OnInformation 24-11-2025 00:42:03

OnPreValidate 24-11-2025 00:42:03

OnPostValidate 24-11-2025 00:42:03

13 / 18 Use scroll wheel or PAGE UP & PAGE DOWN to move through pages.
Process Leads:Start, 12:42:04 AM. Process Leads

Check if File exists:Finished, 12:42:04 AM, Elapsed time: Check if File exists
00:00:00.032.

Check if File exists:Validation is complete. Check if File exists

Check if File exists:Validation has started. Check if File exists

Check if File exists:Start, 12:42:04 AM. Check if File exists

Truncate Ref Tables:Finished, 12:42:04 AM, Elapsed time: Truncate Ref Tables
00:00:00.110.

Truncate Ref Tables:Validation is complete. Truncate Ref Tables

Truncate Ref Tables:Validation has started. Truncate Ref Tables

Truncate Ref Tables:Start, 12:42:03 AM. Truncate Ref Tables

Package1:Start, 12:42:03 AM. Package1

Package1:Validation is complete. Package1

Truncate Ref Tables:Validation is complete. Truncate Ref Tables

Truncate Ref Tables:Validation has started. Truncate Ref Tables

Send Notif Email:Validation is complete. Send Notif Email

Send Notif Email:Validation has started. Send Notif Email

Process Passed:Validation is complete. Process Passed

Remove Failed Records:Validation is complete. Remove Failed Records

Remove Failed Records:Information: Validation phase is Remove Failed Records [Link]


beginning.

Remove Failed Records:Validation has started. Remove Failed Records

Move to Archive Folder:Validation is complete. Move to Archive Folder

Move to Archive Folder:Validation has started. Move to Archive Folder

Create Email Link File Passed:Validation is complete. Create Email Link File Passed

Create Email Link File Passed:Validation has started. Create Email Link File Passed

Check for passed records:Validation is complete. Check for passed records

Check for passed records:Validation has started. Check for passed records

Process Passed:Validation has started. Process Passed

Process Leads:Validation is complete. Process Leads

Process Leads:Information: Validation phase is beginning. Process Leads [Link]

Process Leads:Validation has started. Process Leads

Process Errors:Validation is complete. Process Errors

14 / 18 Use scroll wheel or PAGE UP & PAGE DOWN to move through pages.
\Package1\Process Leads

\Package1\Check if File exists

\Package1\Check if File exists

\Package1\Check if File exists

\Package1\Check if File exists

\Package1\Truncate Ref Tables

\Package1\Truncate Ref Tables

\Package1\Truncate Ref Tables

\Package1\Truncate Ref Tables

\Package1

\Package1

\Package1\Truncate Ref Tables

\Package1\Truncate Ref Tables

\Package1\Send Notif Email

\Package1\Send Notif Email

\Package1\Process Passed

\Package1\Process Passed
\Remove Failed Records

\Package1\Process Passed
\Remove Failed Records

\Package1\Process Passed
\Remove Failed Records

\Package1\Process Passed\Move
to Archive Folder

\Package1\Process Passed\Move
to Archive Folder

\Package1\Process Passed
\Create Email Link File Passed

\Package1\Process Passed
\Create Email Link File Passed

\Package1\Process Passed\Check
for passed records

\Package1\Process Passed\Check
for passed records

\Package1\Process Passed

\Package1\Process Leads

\Package1\Process Leads

\Package1\Process Leads

\Package1\Process Errors

15 / 18 Use scroll wheel or PAGE UP & PAGE DOWN to move through pages.
OnPostValidate 24-11-2025 00:42:03

OnInformation 24-11-2025 00:42:03

OnPreValidate 24-11-2025 00:42:03

OnPostValidate 24-11-2025 00:42:03

OnPreValidate 24-11-2025 00:42:03

OnPostValidate 24-11-2025 00:42:03

OnPreValidate 24-11-2025 00:42:03

OnPreValidate 24-11-2025 00:42:03

OnPostValidate 24-11-2025 00:42:03

OnPreValidate 24-11-2025 00:42:03

OnPostValidate 24-11-2025 00:42:03

OnPreValidate 24-11-2025 00:42:03

OnPreValidate 24-11-2025 00:42:03

16 / 18 Use scroll wheel or PAGE UP & PAGE DOWN to move through pages.
Upload failed data:Validation is complete. Upload failed data

Upload failed data:Information: Validation phase is Upload failed data [Link]


beginning.

Upload failed data:Validation has started. Upload failed data

Create Email Link File Failed:Validation is complete. Create Email Link File Failed

Create Email Link File Failed:Validation has started. Create Email Link File Failed

Check if there are errors:Validation is complete. Check if there are errors

Check if there are errors:Validation has started. Check if there are errors

Process Errors:Validation has started. Process Errors

Delete Import FIle:Validation is complete. Delete Import FIle

Delete Import FIle:Validation has started. Delete Import FIle

Check if File exists:Validation is complete. Check if File exists

Check if File exists:Validation has started. Check if File exists

Package1:Validation has started. Package1

17 / 18 Use scroll wheel or PAGE UP & PAGE DOWN to move through pages.
\Package1\Process Errors\Upload
failed data

\Package1\Process Errors\Upload
failed data

\Package1\Process Errors\Upload
failed data

\Package1\Process Errors\Create
Email Link File Failed

\Package1\Process Errors\Create
Email Link File Failed

\Package1\Process Errors\Check
if there are errors

\Package1\Process Errors\Check
if there are errors

\Package1\Process Errors

\Package1\Delete Import FIle

\Package1\Delete Import FIle

\Package1\Check if File exists

\Package1\Check if File exists

\Package1

18 / 18 Use scroll wheel or PAGE UP & PAGE DOWN to move through pages.

You might also like