Having developed our App and got it working smoothly, the time comes to deploy to live, the Export / Import does not work.
It is rejecting a perfectly sound Flow.
This is the error:
Import failed for one more package resources.
One or more resources didn't import. See the error details to resolve the issues, and try importing again.
One or more resources might have been skipped during the import. See the import details to find out which resources were created, updated or skipped.
Flow save failed with code 'MultipleErrorsOccurred' and message 'The dynamic operation request to API 'sql' operation 'GetProcedure_V2' failed with status code 'BadRequest'. This may indicate invalid input parameters. Error response: { "status": 400, "message": "Invalid connection settings\r\n inner exception: Not a valid data source.\r\nclientRequestId: fa5d2101-01c7-489c-95a2-d2d0105f706c", "error": { "message": "Invalid connection settings\r\n inner exception: Not a valid data source." }, "source": "sql-uks.logic-ase-uksouth.p.azurewebsites.net" };The dynamic operation request to API 'sql' operation 'GetProcedure_V2' failed with status code 'BadRequest'. This may indicate invalid input parameters. Error response: { "status": 400, "message": "Invalid connection settings\r\n inner exception: Not a valid data source.\r\nclientRequestId: fa5d2101-01c7-489c-95a2-d2d0105f706c", "error": { "message": "Invalid connection settings\r\n inner exception: Not a valid data source." }, "source": "sql-uks.logic-ase-uksouth.p.azurewebsites.net" }'.
There is no problem with this flow. I have even recreated it on the new environment and tested it. But, it is part of the solution and the App cannot be imported without it.
All the other Flows following it are rejected too, with the same error message. All the previous flows (in this solution) have imported OK, and use the same connections.
This flow has no parameters, so how can it be a parameter issue?
What am I to do here? Delete and recreate every single flow and rebuild the app again for every single flow?
This makes the whole development / deployment cycle totally unworkable.
There are 42 flows in this solution and it is rejecting 29 of them for no good reason!!!
I have deleted all 29 flows from the Datasources in the App, and re added evry one of them.
It made no difference whatsoever.
Now what?
I tried deleting the first offending flow, and recreating it from scratch. Tested it & imported it on it's own.
This import also failed with errors but I was able to then edit the flow & save it.
The problem appears to be that the Server name has changed.
Well you would expect it to. It's a different server.
Solved! Go to Solution.
I have found a workaround that worked. The problem causing the import to fail was the fact that I was selecting a different SQL connector. Obviously, I am going from DEV to LIVE.
I added a Connector to the DEV SQL Server, and imported it using that. This time the Import worked. Now I just need to edit the flows to point to the Live SQL Server.
I have now wasted a whole day on this without making any progress whatsoever.
Is there a better way?
Hello!
This issue need further investigation, Please open a case with Microsoft support on https://admin.powerplatform.microsoft.com/support
Thank you
@pagonzaThanks for the suggestion. You may have hit on something. When I followed the link to raise a support request, the Environment I am trying to import into is not listed. Only 2 Environments are listed and we have 4. Maybe that is the problem.
I have found a workaround that worked. The problem causing the import to fail was the fact that I was selecting a different SQL connector. Obviously, I am going from DEV to LIVE.
I added a Connector to the DEV SQL Server, and imported it using that. This time the Import worked. Now I just need to edit the flows to point to the Live SQL Server.
User | Count |
---|---|
236 | |
113 | |
94 | |
59 | |
31 |
User | Count |
---|---|
286 | |
132 | |
106 | |
63 | |
57 |