404 Error on deployment step - BPM Toolkit - ALM - Search and Replace - Pass1

[lorganisateur]

Hi,

I started the deployment of BPM Toolkit (version : BPM Toolkit Setup_02_07_2021_v2). I had an issue with Search and Replace step ( I tried to run it multiple times but always the same error) . It looks like flow is not able to find and update the process from CDS Process table… Error Status : 400 Error Message : Flow save failed with code 'DynamicOperationRequestClientFailure' and message 'The dynamic operation request to API 'sharepointonline' operation 'GetTable' failed with status code 'NotFound'

{
    "statusCode": 400,
    "headers": {
       ...
    },
    "body": {
        "error": {
            "code": "0x80060467",
            "message": "Flow client error returned with status code \"BadRequest\" and details \"{\"error\":{\"code\":\"InvalidOpenApiFlow\",\"message\":\"Flow save failed with code 'DynamicOperationRequestClientFailure' and message 'The dynamic operation request to API 'sharepointonline' operation 'GetTable' failed with status code 'NotFound'. This may indicate invalid input parameters. Error response: {\\r\\n  \\\"error\\\": {\\r\\n    \\\"code\\\": 404,\\r\\n    \\\"source\\\": \\\"france-001.azure-apim.net\\\",\\r\\n    \\\"clientRequestId\\\": \\\"784ca6af-c624-438d-b091-1d5086741889\\\",\\r\\n    \\\"message\\\": \\\"The response is not in a JSON format.\\\",\\r\\n    \\\"innerError\\\": \\\"404 FILE NOT FOUND\\\"\\r\\n  }\\r\\n}'.\"}}\".",
            "@Microsoft.PowerApps.CDS.ErrorDetails.0": "BadRequest",
            "@Microsoft.PowerApps.CDS.ErrorDetails.1": "{\"error\":{\"code\":\"InvalidOpenApiFlow\",\"message\":\"Flow save failed with code 'DynamicOperationRequestClientFailure' and message 'The dynamic operation request to API 'sharepointonline' operation 'GetTable' failed with status code 'NotFound'. This may indicate invalid input parameters. Error response: {\\r\\n  \\\"error\\\": {\\r\\n    \\\"code\\\": 404,\\r\\n    \\\"source\\\": \\\"france-001.azure-apim.net\\\",\\r\\n    \\\"clientRequestId\\\": \\\"784ca6af-c624-438d-b091-1d5086741889\\\",\\r\\n    \\\"message\\\": \\\"The response is not in a JSON format.\\\",\\r\\n    \\\"innerError\\\": \\\"404 FILE NOT FOUND\\\"\\r\\n  }\\r\\n}'.\"}}",
            "@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\":\"InvalidOpenApiFlow\",\"message\":\"Flow save failed with code 'DynamicOperationRequestClientFailure' and message 'The dynamic operation request to API 'sharepointonline' operation 'GetTable' failed with status code 'NotFound'. This may indicate invalid input parameters. Error response: {\\r\\n  \\\"error\\\": {\\r\\n    \\\"code\\\": 404,\\r\\n    \\\"source\\\": \\\"france-001.azure-apim.net\\\",\\r\\n    \\\"clientRequestId\\\": \\\"784ca6af-c624-438d-b091-1d5086741889\\\",\\r\\n    \\\"message\\\": \\\"The response is not in a JSON format.\\\",\\r\\n    \\\"innerError\\\": \\\"404 FILE NOT FOUND\\\"\\r\\n  }\\r\\n}'.\"}}\"."
        }
    }
}

Do you have any clue ? I would appreciate your help Thanks,

[sergeluca]

Hello,

Did the system create all the SharePoint list s? basically is the Excel ALM document filled with new guids ? We can organize a Teasm meeting today if you want. It is 1 PM Brussels time, let me know when we can "meet" today

[lorganisateur]

Hi Serge, Yes everything seems correct until this step. Lists are created and the Excel document is filled. It will be a pleasure if your are available for teams meeting. I'm based in Paris, I suggest to have a call around 3pm if it ok for you. You can reach me on : slim.cheikhrouhou@gmail.com Thank you, Slim

[lorganisateur]

Many Thanks for your prompt support Serge. After updating the Excel file with the right site url, I was able to progress on the Pass1. I had a second issue with the "BPM Toolkit - Workflow Runtime" so I updated it manually. After that Pass 2 has successfully completed Thank you Dr Flow