sergeluca / Power-Platform-BPM-Toolkit

Power Platform BPM Toolkit
MIT License
68 stars 12 forks source link

BPM Toolkit - ALM - Search and Replace Fails When Updating Workflows in Dataverse Processes Table #11

Closed WorTony closed 3 years ago

WorTony commented 3 years ago

I have created a new E5 Dev Tenant, added the Premium Power Automate licence and created the BPM Toolkit SPO site and Dataverse environments.

Uploaded and updated the ALM Infos.xlsx to the document library in the SPO BPM Toolkit site.

I've ran the BPM Toolkit - ALM - Create BPM Toolkit Structure WF without issue.

I ran the BPM Toolkit - ALM - Search and Replace WF and it had an issue with in the Apply To Each that Lists records in the Processes table. There were 4 instances of an error like this :

"error": { "code": "0x80060467", "message": "Flow client error returned with status code \"BadRequest\" and details \"{\"error\":{\"code\":\"ChildFlowNeverPublished\",\"message\":\"The workflow with id '5be42f27-234b-eb11-a812-000d3abee2a0' cannot be used as a child workflow because it has never been published. Child workflows need to be published at least once before they can be included in a published parent workflow.\"}}\".", "@Microsoft.PowerApps.CDS.ErrorDetails.0": "BadRequest", "@Microsoft.PowerApps.CDS.ErrorDetails.1": "{\"error\":{\"code\":\"ChildFlowNeverPublished\",\"message\":\"The workflow with id '5be42f27-234b-eb11-a812-000d3abee2a0' cannot be used as a child workflow because it has never been published. Child workflows need to be published at least once before they can be included in a published parent workflow.\"}}", "@Microsoft.PowerApps.CDS.HelpLink": "http://go.microsoft.com/fwlink/?LinkID=398563&error=Microsoft.Crm.CrmException%3a80060467&client=platform", "@Microsoft.PowerApps.CDS.InnerError.Message": "Flow client error returned with status code \"BadRequest\" and details \"{\"error\":{\"code\":\"ChildFlowNeverPublished\",\"message\":\"The workflow with id '5be42f27-234b-eb11-a812-000d3abee2a0' cannot be used as a child workflow because it has never been published. Child workflows need to be published at least once before they can be included in a published parent workflow.\"}}\"." } }

1 error for each of these in the filter row of the Dataverse List records activity:

The final error was this:

The 'inputs.parameters' of workflow operation 'Update_a_record' of type 'OpenApiConnection' is not valid. Error details: The resolved string values for the following parameters are invalid, they may not be null or empty: 'recordId'

I ran the BPM Toolkit - ALM - Search and Replace WF again and it failed with a single instance of an error with an error message like this:

The 'inputs.parameters' of workflow operation 'Update_a_record' of type 'OpenApiConnection' is not valid. Error details: The resolved string values for the following parameters are invalid, they may not be null or empty: 'recordId'

It was this name in the filter row of the Dataverse List records activity

BPM Toolkit - Set Final Workflow Status

I looked in the BPM Toolkit solution and there is no such WF listed. There are 3 WFs in the BPM Toolkit solution with Final in the name so I'll give it another go with this BPM Toolkit - Workflow Runtime - Compute final Workflow Status as the name of the last WF in the Pass 1 flows compose activity.

WorTony commented 3 years ago

BTW, the version I'm using is BPM Toolkit Setup_02_07_2021_v2

The BPM Toolkit - Workflow Runtime - Compute final Workflow Status entry is already in the compose activity so it looks like it's missing a WF or so.

There appears to be only 69 WFs in the solution and there are 73 instances in the Search and Replace WF. I've just stepped through the Pass1 compose activity and matched the entries up with the actual WFs in the solution.

I found that these WFs are not referenced in the compose activity:

BPM Toolkit - Audit Get Case Log Proxy BPM Toolkit - Delegation - Create New Delegation Proxy BPM Toolkit - Submit Attachments Proxy BPM Toolkit - Workflow Runtime

I'll pick this up again in the morning.

sergeluca commented 3 years ago

Hi Tony! sorry for this issue. I'm not available for the moment, but I'll check this this w-e and will get back to you

WorTony commented 3 years ago

Hi Serge, no problem and no rush from me as I'm just evaluating what the toolkit does.

Thanks for helping out

sergeluca commented 3 years ago

Hello Tony,

Yes, I can reproduce this, and it is "normal" I would say.

[cid:0cb8c5a2-22c1-4b9c-a9c6-586ac81b4dba] As mentioned in the pdf guide, (point 16, c): edit the Flow "BPM Toolkit - Delegation _ Pending task to delegate", Edit the setting run only users.... Then restart the "search and replace" flow with "pass 1" a second time...

Let me know if that works. It is very important to follow the setup guide line by line because (unfortunately) deploying such a big Power Platform application is a mess. I will provide a new version of the setup guide soon.

Don't hesitate to come back to me

Serge

Serge Luca

Office Applications and Services (Office 365) MVP

Business Applications (Power Automate & PowerApps) MVP

Creator of the open-source Power Platform BPM Toolkit

https://github.com/sergeluca/Power-Platform-BPM-Toolkit

Power Platform Associates, Belgium

P: +32 472 885 928

E: @.**@.>

Bloghttp://sergeluca.wordpress.com/ | Linkedin http://www.linkedin.com/in/sergeluca | Twitter http://www.twitter.com/sergeluca | Webhttp://www.shareql.com/

[cid:620836c3-c517-40d4-8044-06d4af020747]

[cid:b45a4307-e095-4a6d-b40e-d8d6c3925abe]


From: Tony Pounder @.> Sent: Thursday, 9 September 2021 20:57 To: sergeluca/Power-Platform-BPM-Toolkit @.> Cc: Subscribed @.***> Subject: [sergeluca/Power-Platform-BPM-Toolkit] BPM Toolkit - ALM - Search and Replace Fails When Updating Workflows in Dataverse Processes Table (#11)

I have created a new E5 Dev Tenant, added the Premium Power Automate licence and created the BPM Toolkit SPO site and Dataverse environments.

Uploaded and updated the ALM Infos.xlsx to the document library in the SPO BPM Toolkit site.

I've ran the BPM Toolkit - ALM - Create BPM Toolkit Structure WF without issue.

I ran the BPM Toolkit - ALM - Search and Replace WF and it had an issue with in the Apply To Each that Lists records in the Processes table. There were 4 instances of an error like this :

"error": { "code": "0x80060467", "message": "Flow client error returned with status code "BadRequest" and details "{"error":{"code":"ChildFlowNeverPublished","message":"The workflow with id '5be42f27-234b-eb11-a812-000d3abee2a0' cannot be used as a child workflow because it has never been published. Child workflows need to be published at least once before they can be included in a published parent workflow."}}".", @.": "BadRequest", @.": "{"error":{"code":"ChildFlowNeverPublished","message":"The workflow with id '5be42f27-234b-eb11-a812-000d3abee2a0' cannot be used as a child workflow because it has never been published. Child workflows need to be published at least once before they can be included in a published parent workflow."}}", @.": "http://go.microsoft.com/fwlink/?LinkID=398563&error=Microsoft.Crm.CrmException%3a80060467&client=platform", @.": "Flow client error returned with status code "BadRequest" and details "{"error":{"code":"ChildFlowNeverPublished","message":"The workflow with id '5be42f27-234b-eb11-a812-000d3abee2a0' cannot be used as a child workflow because it has never been published. Child workflows need to be published at least once before they can be included in a published parent workflow."}}"." } }

1 error for each of these in the filter row of the Dataverse List records activity:

The final error was this:

The 'inputs.parameters' of workflow operation 'Update_a_record' of type 'OpenApiConnection' is not valid. Error details: The resolved string values for the following parameters are invalid, they may not be null or empty: 'recordId'

I ran the BPM Toolkit - ALM - Search and Replace WF again and it failed with a single instance of an error with an error message like this:

The 'inputs.parameters' of workflow operation 'Update_a_record' of type 'OpenApiConnection' is not valid. Error details: The resolved string values for the following parameters are invalid, they may not be null or empty: 'recordId'

It was this name in the filter row of the Dataverse List records activity

BPM Toolkit - Set Final Workflow Status

I looked in the BPM Toolkit solution and there is no such WF listed. There are 3 WFs in the BPM Toolkit solution with Final in the name so I'll give it another go with this BPM Toolkit - Workflow Runtime - Compute final Workflow Status as the name of the last WF in the Pass 1 flows compose activity.

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHubhttps://github.com/sergeluca/Power-Platform-BPM-Toolkit/issues/11, or unsubscribehttps://github.com/notifications/unsubscribe-auth/ACXEHP3JX5BOB4VXNVN7WQTUBD7SJANCNFSM5DXYWZDA. Triage notifications on the go with GitHub Mobile for iOShttps://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Androidhttps://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

WorTony commented 3 years ago

Hi Serge, Thanks for the reply - I've been following both the video and the PDF and the issue I am experiencing is at step 15.

To recap, the Search and Replace WF is completing and it shows as green, succeeded but when I look at the Apply to Each within Main it shows that iteration 73 fails.

This is the name in the filter row of the Dataverse List records activity "BPM Toolkit - Set Final Workflow Status" and the error shown is "The 'inputs.parameters' of workflow operation 'Update_a_record' of type 'OpenApiConnection' is not valid. Error details: The resolved string values for the following parameters are invalid, they may not be null or empty: 'recordId'"

I looked in the BPM Toolkit solution and there is no such WF named "BPM Toolkit - Set Final Workflow Status".

I think the problem is that the "BPM Toolkit - Set Final Workflow Status WF" is missing from the BPM Toolkit solution.

Tony

sergeluca commented 3 years ago

Hi Tonny,

you are right, in the compose, the Set Final Status is not necessary anymore, it has been replaced by the Compute Final Status.

[cid:5a02a92e-7c1a-4fe2-93f1-054d7d631f5d]

But that said, you should run the workflow again as I mentioned before. Also, I recommend following the pdf setup file (I must update the video). In the end, all flows must be set to on. Even if an error is generated because of the Set Final status workflow.

Kind regards

Serge Luca

Office Applications and Services (Office 365) MVP

Business Applications (Power Automate & PowerApps) MVP

Creator of the open-source Power Platform BPM Toolkit

https://github.com/sergeluca/Power-Platform-BPM-Toolkit

Power Platform Associates, Belgium

P: +32 472 885 928

E: @.**@.>

Bloghttp://sergeluca.wordpress.com/ | Linkedin http://www.linkedin.com/in/sergeluca | Twitter http://www.twitter.com/sergeluca | Webhttp://www.shareql.com/

[cid:89e41ca5-c7b6-49ba-aba5-6d83bc8bbff7]

[cid:a557f530-0e0b-448a-944c-d8c79bafef8c]


From: Tony Pounder @.> Sent: Monday, 13 September 2021 18:19 To: sergeluca/Power-Platform-BPM-Toolkit @.> Cc: serge Luca @.>; Comment @.> Subject: Re: [sergeluca/Power-Platform-BPM-Toolkit] BPM Toolkit - ALM - Search and Replace Fails When Updating Workflows in Dataverse Processes Table (#11)

Hi Serge, Thanks for the reply - I've been following both the video and the PDF and the issue I am experiencing is at step 15.

To recap, the Search and Replace WF is completing and it shows as green, succeeded but when I look at the Apply to Each within Main it shows that iteration 73 fails.

This is the name in the filter row of the Dataverse List records activity "BPM Toolkit - Set Final Workflow Status" and the error shown is "The 'inputs.parameters' of workflow operation 'Update_a_record' of type 'OpenApiConnection' is not valid. Error details: The resolved string values for the following parameters are invalid, they may not be null or empty: 'recordId'"

I looked in the BPM Toolkit solution and there is no such WF named "BPM Toolkit - Set Final Workflow Status".

I think the problem is that the "BPM Toolkit - Set Final Workflow Status WF" is missing from the BPM Toolkit solution.

Tony

— You are receiving this because you commented. Reply to this email directly, view it on GitHubhttps://github.com/sergeluca/Power-Platform-BPM-Toolkit/issues/11#issuecomment-918357293, or unsubscribehttps://github.com/notifications/unsubscribe-auth/ACXEHP2VCKJRXX4SGZ3ORATUBYQCFANCNFSM5DXYWZDA. Triage notifications on the go with GitHub Mobile for iOShttps://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Androidhttps://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

WorTony commented 3 years ago

Hi Serge, just an update for you. I've made it to the 1st draft submission stage and my first case has appeared in there.

I met a couple of other issues along the way but they we're simply down to the actual WF names being different to the PDF/video. I'm calling it a day for now but I'll be back on it. I think this issue can be closed now.

Cheers

Tony @WorTony