Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[ALM Accelerator - BUG]: Connection Sharing Permissions #6739

Closed
sefa-phaag opened this issue Sep 27, 2023 · 3 comments · Fixed by #6785
Closed

[ALM Accelerator - BUG]: Connection Sharing Permissions #6739

sefa-phaag opened this issue Sep 27, 2023 · 3 comments · Fixed by #6785
Assignees
@mikefactorial
Labels
alm-accelerator ALM Accelerator Components and Apps bug Something isn't working
Milestone
CoE Starter Kit -...

Comments

@sefa-phaag
Copy link

sefa-phaag commented Sep 27, 2023 •
edited by RajeevPentyala

Describe the issue

When importing a managed solution to the validation environment, it is failing with an error that reads, "Error calling /modifyPermissionsForServicePrincipal, StatusCode: Forbidden, please verify that user a1b7ceaa-fbb8-ed11-83fe-0022482809bb has at least Can use + share Permission on connection e66cab61334940aeb5765e948a1100ff'."

I have marked the Share box next to the connection in the Configure Deployment Settings dialog for the Validation environment and I can confirm that the connection is shared with the service principal in the target environment, but it only has the, "Can use," permission, which is apparently insufficient. The only thing I can think of for this connection versus others that I have been able to deploy successfully is that it is used by a virtual entity to connect to an on-premises SQL server.

Here is the full log:

2023-09-27T18:57:03.8222166Z ##[section]Starting: Import Managed Solution as Update
2023-09-27T18:57:03.8329879Z ==============================================================================
2023-09-27T18:57:03.8330023Z Task         : Power Platform Import Solution
2023-09-27T18:57:03.8330119Z Description  : Power Platform Import Solution
2023-09-27T18:57:03.8330219Z Version      : 2.0.42
2023-09-27T18:57:03.8330284Z Author       : Microsoft
2023-09-27T18:57:03.8330350Z Help         : https://aka.ms/buildtoolsdoc Ideas, feedback: https://github.com/microsoft/powerplatform-build-tools/discussions
2023-09-27T18:57:03.8330509Z ==============================================================================
2023-09-27T18:57:04.0704997Z Discovered environment url from explicit input parameter 'Environment': https://sefa-validation.crm.dynamics.com/
2023-09-27T18:57:04.0733770Z [
2023-09-27T18:57:04.0734306Z   'authN to env. authType:SPN authScheme:None; cloudInstance: Public; envUrl: https://sefa-validation.crm.dynamics.com/'
2023-09-27T18:57:04.0734756Z ]
2023-09-27T18:57:11.8287623Z [
2023-09-27T18:57:11.8288372Z   "'***' authenticated successfully."
2023-09-27T18:57:11.8288560Z ]
2023-09-27T18:57:11.8288793Z [ 'Validating connection...' ]
2023-09-27T18:57:11.8289046Z [ 'Connected to... SEFA Validation' ]
2023-09-27T18:57:11.8289412Z [ 'Connected as ***' ]
2023-09-27T18:57:11.9074952Z [ 'Authentication profile created' ]
2023-09-27T18:57:11.9191504Z [
2023-09-27T18:57:11.9192409Z   '    * DATAVERSE                                https://sefa-validation.crm.dynamics.com/ : ***     Public'
2023-09-27T18:57:11.9192654Z ]
2023-09-27T18:57:11.9192910Z [ '' ]
2023-09-27T18:57:12.1159488Z [
2023-09-27T18:57:12.1160851Z   "The Authentication Result: '***' authenticated successfully.,Validating connection...,Connected to... SEFA Validation,Connected as ***,Authentication profile created,    * DATAVERSE                                https://sefa-validation.crm.dynamics.com/ : ***     Public,"
2023-09-27T18:57:12.1161273Z ]
2023-09-27T18:57:12.1189777Z [
2023-09-27T18:57:12.1190812Z   'Calling pac cli inputs: solution import --path D:\\a\\1\\drop\\SISProjectTracker_1.0.20230927.1_managed.zip --async true --import-as-holding false --force-overwrite true --publish-changes false --skip-dependency-check false --convert-to-managed false --max-async-wait-time 120 --activate-plugins true --skip-lower-version false --settings-file D:\\a\\1\\drop\\deploymentSettings-Validation.json'
2023-09-27T18:57:12.1191367Z ]
2023-09-27T18:57:14.1965646Z [ 'Connected to... SEFA Validation' ]
2023-09-27T18:57:14.1978224Z [ 'Connected as ***' ]
2023-09-27T18:57:14.2223154Z [ '' ]
2023-09-27T18:57:14.2224005Z [ 'Solution Importing...' ]
2023-09-27T18:57:31.3427072Z [ '' ]
2023-09-27T18:57:31.3428379Z [
2023-09-27T18:57:31.3429224Z   'Waiting for asynchronous operation 72654ab4-675d-ee11-be6f-0022482809bb to complete with timeout of 02:00:00'
2023-09-27T18:57:31.3429653Z ]
2023-09-27T18:57:31.3429947Z [ '' ]
2023-09-27T18:57:31.3430224Z [
2023-09-27T18:57:31.3430670Z   'Processing asynchronous operation... execution time: 00:00:00 and 0.00% complete'
2023-09-27T18:57:31.3430965Z ]
2023-09-27T18:57:35.5847421Z [ '' ]
2023-09-27T18:57:35.5849872Z [
2023-09-27T18:57:35.5850584Z   'Processing asynchronous operation... execution time: 00:00:04 and 0.06% complete'
2023-09-27T18:57:35.5851023Z ]
2023-09-27T18:57:39.6674625Z [ '' ]
2023-09-27T18:57:39.6675155Z [
2023-09-27T18:57:39.6675933Z   'Processing asynchronous operation... execution time: 00:00:08 and 0.12% complete'
2023-09-27T18:57:39.6676178Z ]
2023-09-27T18:57:43.7373401Z [ '' ]
2023-09-27T18:57:43.7373947Z [
2023-09-27T18:57:43.7374769Z   'Processing asynchronous operation... execution time: 00:00:12 and 0.17% complete'
2023-09-27T18:57:43.7375017Z ]
2023-09-27T18:57:47.8041909Z [ '' ]
2023-09-27T18:57:47.8044540Z [
2023-09-27T18:57:47.8045289Z   'Processing asynchronous operation... execution time: 00:00:16 and 0.23% complete'
2023-09-27T18:57:47.8045534Z ]
2023-09-27T18:57:51.8695685Z [ '' ]
2023-09-27T18:57:51.8696239Z [
2023-09-27T18:57:51.8696926Z   'Processing asynchronous operation... execution time: 00:00:20 and 0.29% complete'
2023-09-27T18:57:51.8697300Z ]
2023-09-27T18:57:55.9338104Z [ '' ]
2023-09-27T18:57:55.9340807Z [
2023-09-27T18:57:55.9341571Z   'Processing asynchronous operation... execution time: 00:00:24 and 0.34% complete'
2023-09-27T18:57:55.9341819Z ]
2023-09-27T18:57:59.9999400Z [ '' ]
2023-09-27T18:58:00.0000038Z [
2023-09-27T18:58:00.0004407Z   'Processing asynchronous operation... execution time: 00:00:28 and 0.40% complete'
2023-09-27T18:58:00.0005186Z ]
2023-09-27T18:58:04.0684543Z [ '' ]
2023-09-27T18:58:04.0685160Z [
2023-09-27T18:58:04.0685958Z   'Processing asynchronous operation... execution time: 00:00:32 and 0.45% complete'
2023-09-27T18:58:04.0686202Z ]
2023-09-27T18:58:08.1441473Z [ '' ]
2023-09-27T18:58:08.1442070Z [
2023-09-27T18:58:08.1442934Z   'Processing asynchronous operation... execution time: 00:00:36 and 0.51% complete'
2023-09-27T18:58:08.1443352Z ]
2023-09-27T18:58:12.2136952Z [ '' ]
2023-09-27T18:58:12.2137478Z [
2023-09-27T18:58:12.2138286Z   'Processing asynchronous operation... execution time: 00:00:40 and 0.57% complete'
2023-09-27T18:58:12.2138513Z ]
2023-09-27T18:58:16.2785983Z [ '' ]
2023-09-27T18:58:16.2786508Z [
2023-09-27T18:58:16.2787755Z   'Processing asynchronous operation... execution time: 00:00:44 and 0.62% complete'
2023-09-27T18:58:16.2788072Z ]
2023-09-27T18:58:20.3514492Z [ '' ]
2023-09-27T18:58:20.3515030Z [
2023-09-27T18:58:20.3515752Z   'Processing asynchronous operation... execution time: 00:00:49 and 0.68% complete'
2023-09-27T18:58:20.3516121Z ]
2023-09-27T18:58:24.4274905Z [ '' ]
2023-09-27T18:58:24.4275482Z [
2023-09-27T18:58:24.4276639Z   'Processing asynchronous operation... execution time: 00:00:53 and 0.74% complete'
2023-09-27T18:58:24.4276930Z ]
2023-09-27T18:58:28.4885882Z [ '' ]
2023-09-27T18:58:28.4886427Z [
2023-09-27T18:58:28.4887209Z   'Processing asynchronous operation... execution time: 00:00:57 and 0.79% complete'
2023-09-27T18:58:28.4887602Z ]
2023-09-27T18:58:32.5582676Z [ '' ]
2023-09-27T18:58:32.5583274Z [
2023-09-27T18:58:32.5587861Z   'Processing asynchronous operation... execution time: 00:01:01 and 0.85% complete'
2023-09-27T18:58:32.5588179Z ]
2023-09-27T18:58:36.6470853Z [ '' ]
2023-09-27T18:58:36.6471500Z [
2023-09-27T18:58:36.6472242Z   'Processing asynchronous operation... execution time: 00:01:05 and 0.91% complete'
2023-09-27T18:58:36.6472485Z ]
2023-09-27T18:58:40.7204113Z [ '' ]
2023-09-27T18:58:40.7204630Z [
2023-09-27T18:58:40.7205410Z   'Processing asynchronous operation... execution time: 00:01:09 and 0.96% complete'
2023-09-27T18:58:40.7205626Z ]
2023-09-27T18:58:44.7869594Z [ '' ]
2023-09-27T18:58:44.7872212Z [
2023-09-27T18:58:44.7872911Z   'Processing asynchronous operation... execution time: 00:01:13 and 1.02% complete'
2023-09-27T18:58:44.7873293Z ]
2023-09-27T18:58:48.8523044Z [ '' ]
2023-09-27T18:58:48.8526787Z [
2023-09-27T18:58:48.8527548Z   'Processing asynchronous operation... execution time: 00:01:17 and 1.08% complete'
2023-09-27T18:58:48.8527905Z ]
2023-09-27T18:58:52.9173993Z [ '' ]
2023-09-27T18:58:52.9174556Z [
2023-09-27T18:58:52.9175442Z   'Processing asynchronous operation... execution time: 00:01:21 and 1.13% complete'
2023-09-27T18:58:52.9175918Z ]
2023-09-27T18:58:57.1396331Z [ '' ]
2023-09-27T18:58:57.1396792Z [
2023-09-27T18:58:57.1397459Z   'Processing asynchronous operation... execution time: 00:01:25 and 1.19% complete'
2023-09-27T18:58:57.1397693Z ]
2023-09-27T18:59:01.1585391Z [ '' ]
2023-09-27T18:59:02.1590864Z [
2023-09-27T18:59:02.1591647Z   'Processing asynchronous operation... execution time: 00:01:29 and 1.25% complete'
2023-09-27T18:59:02.1591971Z ]
2023-09-27T18:59:05.6631896Z [ '' ]
2023-09-27T18:59:05.6632295Z [
2023-09-27T18:59:05.6632940Z   'Processing asynchronous operation... execution time: 00:01:33 and 1.30% complete'
2023-09-27T18:59:05.6633276Z ]
2023-09-27T18:59:09.2127101Z [ '' ]
2023-09-27T18:59:09.2127779Z [
2023-09-27T18:59:09.2128699Z   'Processing asynchronous operation... execution time: 00:01:37 and 1.36% complete'
2023-09-27T18:59:09.2128947Z ]
2023-09-27T18:59:13.2774662Z [ '' ]
2023-09-27T18:59:13.2775238Z [
2023-09-27T18:59:13.2776431Z   'Processing asynchronous operation... execution time: 00:01:41 and 1.42% complete'
2023-09-27T18:59:13.2776724Z ]
2023-09-27T18:59:17.3416897Z [ '' ]
2023-09-27T18:59:17.3417479Z [
2023-09-27T18:59:17.3418656Z   'Processing asynchronous operation... execution time: 00:01:45 and 1.47% complete'
2023-09-27T18:59:17.3418978Z ]
2023-09-27T18:59:21.4082632Z [ '' ]
2023-09-27T18:59:21.4083137Z [
2023-09-27T18:59:21.4084381Z   'Processing asynchronous operation... execution time: 00:01:50 and 1.53% complete'
2023-09-27T18:59:21.4084684Z ]
2023-09-27T18:59:25.4854576Z [ '' ]
2023-09-27T18:59:25.4855275Z [
2023-09-27T18:59:25.4855912Z   'Processing asynchronous operation... execution time: 00:01:54 and 1.59% complete'
2023-09-27T18:59:25.4856187Z ]
2023-09-27T18:59:29.5653299Z [ '' ]
2023-09-27T18:59:29.5653853Z [
2023-09-27T18:59:29.5654587Z   'Processing asynchronous operation... execution time: 00:01:58 and 1.64% complete'
2023-09-27T18:59:29.5654865Z ]
2023-09-27T18:59:33.6500570Z [ '' ]
2023-09-27T18:59:33.6501144Z [
2023-09-27T18:59:33.6501825Z   'Processing asynchronous operation... execution time: 00:02:02 and 1.70% complete'
2023-09-27T18:59:33.6502211Z ]
2023-09-27T18:59:37.7344448Z [ '' ]
2023-09-27T18:59:37.7345012Z [
2023-09-27T18:59:37.7345676Z   'Processing asynchronous operation... execution time: 00:02:06 and 1.76% complete'
2023-09-27T18:59:37.7346023Z ]
2023-09-27T18:59:41.8120503Z [ '' ]
2023-09-27T18:59:41.8121053Z [
2023-09-27T18:59:41.8121801Z   'Processing asynchronous operation... execution time: 00:02:10 and 1.81% complete'
2023-09-27T18:59:41.8122019Z ]
2023-09-27T18:59:45.9020334Z [ '' ]
2023-09-27T18:59:45.9020965Z [
2023-09-27T18:59:45.9021734Z   'Processing asynchronous operation... execution time: 00:02:14 and 1.87% complete'
2023-09-27T18:59:45.9022001Z ]
2023-09-27T18:59:49.9813469Z [ '' ]
2023-09-27T18:59:49.9814073Z [
2023-09-27T18:59:49.9815000Z   'Processing asynchronous operation... execution time: 00:02:18 and 1.93% complete'
2023-09-27T18:59:49.9815271Z ]
2023-09-27T18:59:54.0602971Z [ '' ]
2023-09-27T18:59:54.0603562Z [
2023-09-27T18:59:54.0604402Z   'Processing asynchronous operation... execution time: 00:02:22 and 1.98% complete'
2023-09-27T18:59:54.0604661Z ]
2023-09-27T18:59:58.1377283Z [ '' ]
2023-09-27T18:59:58.1377848Z [
2023-09-27T18:59:58.1378571Z   'Processing asynchronous operation... execution time: 00:02:26 and 2.04% complete'
2023-09-27T18:59:58.1378955Z ]
2023-09-27T19:00:02.2168884Z [ '' ]
2023-09-27T19:00:02.2169541Z [
2023-09-27T19:00:02.2170211Z   'Processing asynchronous operation... execution time: 00:02:30 and 2.10% complete'
2023-09-27T19:00:02.2170492Z ]
2023-09-27T19:00:06.2923644Z [ '' ]
2023-09-27T19:00:06.2924212Z [
2023-09-27T19:00:06.2925001Z   'Processing asynchronous operation... execution time: 00:02:34 and 2.15% complete'
2023-09-27T19:00:06.2925227Z ]
2023-09-27T19:00:10.4180703Z [ '' ]
2023-09-27T19:00:10.4181309Z [
2023-09-27T19:00:10.4182217Z   'Processing asynchronous operation... execution time: 00:02:39 and 2.21% complete'
2023-09-27T19:00:10.4182433Z ]
2023-09-27T19:00:14.5013116Z [ '' ]
2023-09-27T19:00:14.5013729Z [
2023-09-27T19:00:14.5014506Z   'Processing asynchronous operation... execution time: 00:02:43 and 2.27% complete'
2023-09-27T19:00:14.5014744Z ]
2023-09-27T19:00:18.5877340Z [ '' ]
2023-09-27T19:00:18.5877911Z [
2023-09-27T19:00:18.5878720Z   'Processing asynchronous operation... execution time: 00:02:47 and 2.32% complete'
2023-09-27T19:00:18.5878968Z ]
2023-09-27T19:00:22.6712586Z [ '' ]
2023-09-27T19:00:22.6713125Z [
2023-09-27T19:00:22.6713895Z   'Processing asynchronous operation... execution time: 00:02:51 and 2.38% complete'
2023-09-27T19:00:22.6714137Z ]
2023-09-27T19:00:26.7570647Z [ '' ]
2023-09-27T19:00:26.7571206Z [
2023-09-27T19:00:26.7576317Z   'Processing asynchronous operation... execution time: 00:02:55 and 2.44% complete'
2023-09-27T19:00:26.7576584Z ]
2023-09-27T19:00:30.8413417Z [ '' ]
2023-09-27T19:00:30.8414016Z [
2023-09-27T19:00:30.8414792Z   'Processing asynchronous operation... execution time: 00:02:59 and 2.49% complete'
2023-09-27T19:00:30.8415032Z ]
2023-09-27T19:00:34.9231300Z [ '' ]
2023-09-27T19:00:34.9231733Z [
2023-09-27T19:00:34.9232483Z   'Processing asynchronous operation... execution time: 00:03:03 and 2.55% complete'
2023-09-27T19:00:34.9232814Z ]
2023-09-27T19:00:39.0070708Z [ '' ]
2023-09-27T19:00:39.0071258Z [
2023-09-27T19:00:39.0071931Z   'Processing asynchronous operation... execution time: 00:03:07 and 2.61% complete'
2023-09-27T19:00:39.0072241Z ]
2023-09-27T19:00:43.1017661Z [ '' ]
2023-09-27T19:00:43.1018257Z [
2023-09-27T19:00:43.1019217Z   'Processing asynchronous operation... execution time: 00:03:11 and 2.66% complete'
2023-09-27T19:00:43.1019496Z ]
2023-09-27T19:00:48.1483707Z [ '' ]
2023-09-27T19:00:48.1484080Z [
2023-09-27T19:00:48.1489978Z   'Processing asynchronous operation... execution time: 00:03:15 and 2.72% complete'
2023-09-27T19:00:48.1490390Z ]
2023-09-27T19:00:51.3695468Z [ '' ]
2023-09-27T19:00:51.3696002Z [
2023-09-27T19:00:51.3696675Z   'Processing asynchronous operation... execution time: 00:03:20 and 2.78% complete'
2023-09-27T19:00:51.3697048Z ]
2023-09-27T19:00:55.4465415Z [ '' ]
2023-09-27T19:00:55.4465986Z [
2023-09-27T19:00:55.4466720Z   'Processing asynchronous operation... execution time: 00:03:24 and 2.83% complete'
2023-09-27T19:00:55.4467097Z ]
2023-09-27T19:00:59.5211073Z [ '' ]
2023-09-27T19:00:59.5211604Z [
2023-09-27T19:00:59.5212756Z   'Processing asynchronous operation... execution time: 00:03:28 and 2.89% complete'
2023-09-27T19:00:59.5213078Z ]
2023-09-27T19:01:03.5980272Z [ '' ]
2023-09-27T19:01:03.5980807Z [
2023-09-27T19:01:03.5981617Z   'Processing asynchronous operation... execution time: 00:03:32 and 2.95% complete'
2023-09-27T19:01:03.5981872Z ]
2023-09-27T19:01:07.6747030Z [ '' ]
2023-09-27T19:01:07.6747696Z [
2023-09-27T19:01:07.6748413Z   'Processing asynchronous operation... execution time: 00:03:36 and 3.00% complete'
2023-09-27T19:01:07.6748675Z ]
2023-09-27T19:01:11.7536187Z [ '' ]
2023-09-27T19:01:11.7536780Z [
2023-09-27T19:01:11.7537521Z   'Processing asynchronous operation... execution time: 00:03:40 and 3.06% complete'
2023-09-27T19:01:11.7537758Z ]
2023-09-27T19:01:15.8403586Z [ '' ]
2023-09-27T19:01:15.8404150Z [
2023-09-27T19:01:15.8404883Z   'Processing asynchronous operation... execution time: 00:03:44 and 3.12% complete'
2023-09-27T19:01:15.8405133Z ]
2023-09-27T19:01:19.9308395Z [ '' ]
2023-09-27T19:01:19.9308913Z [
2023-09-27T19:01:19.9309589Z   'Processing asynchronous operation... execution time: 00:03:48 and 3.17% complete'
2023-09-27T19:01:19.9309864Z ]
2023-09-27T19:01:24.0125310Z [ '' ]
2023-09-27T19:01:24.0128569Z [
2023-09-27T19:01:24.0129454Z   'Asynchronous operation 72654ab4-675d-ee11-be6f-0022482809bb failed within 00:03:52.6670890.'
2023-09-27T19:01:24.0129799Z ]
2023-09-27T19:01:24.0130015Z [ '' ]
2023-09-27T19:01:24.0130228Z [
2023-09-27T19:01:24.0131220Z   'The reason given was: Data Source import: FAILURE: Error calling /modifyPermissionsForServicePrincipal, StatusCode: Forbidden, please verify that user a1b7ceaa-fbb8-ed11-83fe-0022482809bb has at least Can use + share Permission on connection e66cab61334940aeb5765e948a1100ff'
2023-09-27T19:01:24.0131722Z ]
2023-09-27T19:01:24.2004059Z [ 'Microsoft PowerPlatform CLI' ]
2023-09-27T19:01:24.2004851Z [ 'Version: 1.27.6+g9f62afb' ]
2023-09-27T19:01:24.2059015Z [ 'Online documentation: https://aka.ms/PowerPlatformCLI' ]
2023-09-27T19:01:24.2061042Z [
2023-09-27T19:01:24.2061802Z   'Feedback, Suggestions, Issues: https://github.com/microsoft/powerplatform-build-tools/discussions'
2023-09-27T19:01:24.2062225Z ]
2023-09-27T19:01:24.2062780Z [ '' ]
2023-09-27T19:01:24.2063269Z [ 'Error: The async operation completed with a statuscode of Failed.' ]
2023-09-27T19:01:24.2063673Z [ '' ]
2023-09-27T19:01:24.2064009Z [ '' ]
2023-09-27T19:01:24.2064339Z [
2023-09-27T19:01:24.2065079Z   'Usage: pac solution import [--path] [--activate-plugins] [--force-overwrite] [--skip-dependency-check] [--import-as-holding] [--publish-changes] [--convert-to-managed] [--async] [--max-async-wait-time] [--settings-file] [--skip-lower-version]'
2023-09-27T19:01:24.2065641Z ]
2023-09-27T19:01:24.2065950Z [ '' ]
2023-09-27T19:01:24.2066283Z [
2023-09-27T19:01:24.2066862Z   '  --path                      Path to solution zip file. If not specified, assumes the current folder is a cdsproj project. (alias: -p)'
2023-09-27T19:01:24.2067290Z ]
2023-09-27T19:01:24.2067614Z [
2023-09-27T19:01:24.2068124Z   '  --activate-plugins          Activate plug-ins and workflows on the solution. (alias: -ap)'
2023-09-27T19:01:24.2068530Z ]
2023-09-27T19:01:24.2068858Z [
2023-09-27T19:01:24.2069420Z   '  --force-overwrite           Force an overwrite of unmanaged customizations (alias: -f)'
2023-09-27T19:01:24.2069827Z ]
2023-09-27T19:01:24.2070131Z [
2023-09-27T19:01:24.2070682Z   '  --skip-dependency-check     Skip dependency check against dependencies flagged as product update (alias: -s)'
2023-09-27T19:01:24.2071112Z ]
2023-09-27T19:01:24.2071439Z [
2023-09-27T19:01:24.2071944Z   '  --import-as-holding         Import the solution as a holding solution. (alias: -h)'
2023-09-27T19:01:24.2072320Z ]
2023-09-27T19:01:24.2072647Z [
2023-09-27T19:01:24.2073157Z   '  --publish-changes           Publish your changes upon a successful import. (alias: -pc)'
2023-09-27T19:01:24.2073556Z ]
2023-09-27T19:01:24.2073906Z [
2023-09-27T19:01:24.2074400Z   '  --convert-to-managed        Convert to a managed solution. (alias: -cm)'
2023-09-27T19:01:24.2074809Z ]
2023-09-27T19:01:24.2075104Z [
2023-09-27T19:01:24.2075593Z   '  --async                     Imports the solution asynchronously. (alias: -a)'
2023-09-27T19:01:24.2075970Z ]
2023-09-27T19:01:24.2076285Z [
2023-09-27T19:01:24.2076835Z   '  --max-async-wait-time       Max asynchronous wait time in minutes. The default value is 60 minutes. (alias: -wt)'
2023-09-27T19:01:24.2077228Z ]
2023-09-27T19:01:24.2077546Z [
2023-09-27T19:01:24.2078126Z   '  --settings-file             The .json file with the deployment settings for connection references and environment variables.'
2023-09-27T19:01:24.2078548Z ]
2023-09-27T19:01:24.2078863Z [
2023-09-27T19:01:24.2079396Z   '  --skip-lower-version        Skip solution import if same or higher version is present in current environment. (alias: -slv)'
2023-09-27T19:01:24.2079814Z ]
2023-09-27T19:01:24.2080132Z [ '' ]
2023-09-27T19:01:24.4040916Z ##[error]error: 1
2023-09-27T19:01:24.4065820Z ##[error]failed: Connected to... SEFA Validation
Connected as ***

Solution Importing...

Waiting for asynchronous operation 72654ab4-675d-ee11-be6f-0022482809bb to complete with timeout of 02:00:00

Processing asynchronous operation... execution time: 00:00:00 and 0.00% complete

Processing asynchronous operation... execution time: 00:00:04 and 0.06% complete

Processing asynchronous operation... execution time: 00:00:08 and 0.12% complete

Processing asynchronous operation... execution time: 00:00:12 and 0.17% complete

Processing asynchronous operation... execution time: 00:00:16 and 0.23% complete

Processing asynchronous operation... execution time: 00:00:20 and 0.29% complete

Processing asynchronous operation... execution time: 00:00:24 and 0.34% complete

Processing asynchronous operation... execution time: 00:00:28 and 0.40% complete

Processing asynchronous operation... execution time: 00:00:32 and 0.45% complete

Processing asynchronous operation... execution time: 00:00:36 and 0.51% complete

Processing asynchronous operation... execution time: 00:00:40 and 0.57% complete

Processing asynchronous operation... execution time: 00:00:44 and 0.62% complete

Processing asynchronous operation... execution time: 00:00:49 and 0.68% complete

Processing asynchronous operation... execution time: 00:00:53 and 0.74% complete

Processing asynchronous operation... execution time: 00:00:57 and 0.79% complete

Processing asynchronous operation... execution time: 00:01:01 and 0.85% complete

Processing asynchronous operation... execution time: 00:01:05 and 0.91% complete

Processing asynchronous operation... execution time: 00:01:09 and 0.96% complete

Processing asynchronous operation... execution time: 00:01:13 and 1.02% complete

Processing asynchronous operation... execution time: 00:01:17 and 1.08% complete

Processing asynchronous operation... execution time: 00:01:21 and 1.13% complete

Processing asynchronous operation... execution time: 00:01:25 and 1.19% complete

Processing asynchronous operation... execution time: 00:01:29 and 1.25% complete

Processing asynchronous operation... execution time: 00:01:33 and 1.30% complete

Processing asynchronous operation... execution time: 00:01:37 and 1.36% complete

Processing asynchronous operation... execution time: 00:01:41 and 1.42% complete

Processing asynchronous operation... execution time: 00:01:45 and 1.47% complete

Processing asynchronous operation... execution time: 00:01:50 and 1.53% complete

Processing asynchronous operation... execution time: 00:01:54 and 1.59% complete

Processing asynchronous operation... execution time: 00:01:58 and 1.64% complete

Processing asynchronous operation... execution time: 00:02:02 and 1.70% complete

Processing asynchronous operation... execution time: 00:02:06 and 1.76% complete

Processing asynchronous operation... execution time: 00:02:10 and 1.81% complete

Processing asynchronous operation... execution time: 00:02:14 and 1.87% complete

Processing asynchronous operation... execution time: 00:02:18 and 1.93% complete

Processing asynchronous operation... execution time: 00:02:22 and 1.98% complete

Processing asynchronous operation... execution time: 00:02:26 and 2.04% complete

Processing asynchronous operation... execution time: 00:02:30 and 2.10% complete

Processing asynchronous operation... execution time: 00:02:34 and 2.15% complete

Processing asynchronous operation... execution time: 00:02:39 and 2.21% complete

Processing asynchronous operation... execution time: 00:02:43 and 2.27% complete

Processing asynchronous operation... execution time: 00:02:47 and 2.32% complete

Processing asynchronous operation... execution time: 00:02:51 and 2.38% complete

Processing asynchronous operation... execution time: 00:02:55 and 2.44% complete

Processing asynchronous operation... execution time: 00:02:59 and 2.49% complete

Processing asynchronous operation... execution time: 00:03:03 and 2.55% complete

Processing asynchronous operation... execution time: 00:03:07 and 2.61% complete

Processing asynchronous operation... execution time: 00:03:11 and 2.66% complete

Processing asynchronous operation... execution time: 00:03:15 and 2.72% complete

Processing asynchronous operation... execution time: 00:03:20 and 2.78% complete

Processing asynchronous operation... execution time: 00:03:24 and 2.83% complete

Processing asynchronous operation... execution time: 00:03:28 and 2.89% complete

Processing asynchronous operation... execution time: 00:03:32 and 2.95% complete

Processing asynchronous operation... execution time: 00:03:36 and 3.00% complete

Processing asynchronous operation... execution time: 00:03:40 and 3.06% complete

Processing asynchronous operation... execution time: 00:03:44 and 3.12% complete

Processing asynchronous operation... execution time: 00:03:48 and 3.17% complete

Asynchronous operation 72654ab4-675d-ee11-be6f-0022482809bb failed within 00:03:52.6670890.

The reason given was: Data Source import: FAILURE: Error calling /modifyPermissionsForServicePrincipal, StatusCode: Forbidden, please verify that user a1b7ceaa-fbb8-ed11-83fe-0022482809bb has at least Can use + share Permission on connection e66cab61334940aeb5765e948a1100ff
Microsoft PowerPlatform CLI
Version: 1.27.6+g9f62afb
Online documentation: https://aka.ms/PowerPlatformCLI
Feedback, Suggestions, Issues: https://github.com/microsoft/powerplatform-build-tools/discussions

Error: The async operation completed with a statuscode of Failed.


Usage: pac solution import [--path] [--activate-plugins] [--force-overwrite] [--skip-dependency-check] [--import-as-holding] [--publish-changes] [--convert-to-managed] [--async] [--max-async-wait-time] [--settings-file] [--skip-lower-version]

  --path                      Path to solution zip file. If not specified, assumes the current folder is a cdsproj project. (alias: -p)
  --activate-plugins          Activate plug-ins and workflows on the solution. (alias: -ap)
  --force-overwrite           Force an overwrite of unmanaged customizations (alias: -f)
  --skip-dependency-check     Skip dependency check against dependencies flagged as product update (alias: -s)
  --import-as-holding         Import the solution as a holding solution. (alias: -h)
  --publish-changes           Publish your changes upon a successful import. (alias: -pc)
  --convert-to-managed        Convert to a managed solution. (alias: -cm)
  --async                     Imports the solution asynchronously. (alias: -a)
  --max-async-wait-time       Max asynchronous wait time in minutes. The default value is 60 minutes. (alias: -wt)
  --settings-file             The .json file with the deployment settings for connection references and environment variables.
  --skip-lower-version        Skip solution import if same or higher version is present in current environment. (alias: -slv)

2023-09-27T19:01:25.5229843Z [ 'Authentication profiles and token cache removed' ]
2023-09-27T19:01:25.7284090Z [
2023-09-27T19:01:25.7284990Z   'The Clear Authentication Result: Authentication profiles and token cache removed'
2023-09-27T19:01:25.7285347Z ]
2023-09-27T19:01:25.7300666Z ##[error]Error: Connected to... SEFA Validation
Connected as ***

Solution Importing...

Waiting for asynchronous operation 72654ab4-675d-ee11-be6f-0022482809bb to complete with timeout of 02:00:00

Processing asynchronous operation... execution time: 00:00:00 and 0.00% complete

Processing asynchronous operation... execution time: 00:00:04 and 0.06% complete

Processing asynchronous operation... execution time: 00:00:08 and 0.12% complete

Processing asynchronous operation... execution time: 00:00:12 and 0.17% complete

Processing asynchronous operation... execution time: 00:00:16 and 0.23% complete

Processing asynchronous operation... execution time: 00:00:20 and 0.29% complete

Processing asynchronous operation... execution time: 00:00:24 and 0.34% complete

Processing asynchronous operation... execution time: 00:00:28 and 0.40% complete

Processing asynchronous operation... execution time: 00:00:32 and 0.45% complete

Processing asynchronous operation... execution time: 00:00:36 and 0.51% complete

Processing asynchronous operation... execution time: 00:00:40 and 0.57% complete

Processing asynchronous operation... execution time: 00:00:44 and 0.62% complete

Processing asynchronous operation... execution time: 00:00:49 and 0.68% complete

Processing asynchronous operation... execution time: 00:00:53 and 0.74% complete

Processing asynchronous operation... execution time: 00:00:57 and 0.79% complete

Processing asynchronous operation... execution time: 00:01:01 and 0.85% complete

Processing asynchronous operation... execution time: 00:01:05 and 0.91% complete

Processing asynchronous operation... execution time: 00:01:09 and 0.96% complete

Processing asynchronous operation... execution time: 00:01:13 and 1.02% complete

Processing asynchronous operation... execution time: 00:01:17 and 1.08% complete

Processing asynchronous operation... execution time: 00:01:21 and 1.13% complete

Processing asynchronous operation... execution time: 00:01:25 and 1.19% complete

Processing asynchronous operation... execution time: 00:01:29 and 1.25% complete

Processing asynchronous operation... execution time: 00:01:33 and 1.30% complete

Processing asynchronous operation... execution time: 00:01:37 and 1.36% complete

Processing asynchronous operation... execution time: 00:01:41 and 1.42% complete

Processing asynchronous operation... execution time: 00:01:45 and 1.47% complete

Processing asynchronous operation... execution time: 00:01:50 and 1.53% complete

Processing asynchronous operation... execution time: 00:01:54 and 1.59% complete

Processing asynchronous operation... execution time: 00:01:58 and 1.64% complete

Processing asynchronous operation... execution time: 00:02:02 and 1.70% complete

Processing asynchronous operation... execution time: 00:02:06 and 1.76% complete

Processing asynchronous operation... execution time: 00:02:10 and 1.81% complete

Processing asynchronous operation... execution time: 00:02:14 and 1.87% complete

Processing asynchronous operation... execution time: 00:02:18 and 1.93% complete

Processing asynchronous operation... execution time: 00:02:22 and 1.98% complete

Processing asynchronous operation... execution time: 00:02:26 and 2.04% complete

Processing asynchronous operation... execution time: 00:02:30 and 2.10% complete

Processing asynchronous operation... execution time: 00:02:34 and 2.15% complete

Processing asynchronous operation... execution time: 00:02:39 and 2.21% complete

Processing asynchronous operation... execution time: 00:02:43 and 2.27% complete

Processing asynchronous operation... execution time: 00:02:47 and 2.32% complete

Processing asynchronous operation... execution time: 00:02:51 and 2.38% complete

Processing asynchronous operation... execution time: 00:02:55 and 2.44% complete

Processing asynchronous operation... execution time: 00:02:59 and 2.49% complete

Processing asynchronous operation... execution time: 00:03:03 and 2.55% complete

Processing asynchronous operation... execution time: 00:03:07 and 2.61% complete

Processing asynchronous operation... execution time: 00:03:11 and 2.66% complete

Processing asynchronous operation... execution time: 00:03:15 and 2.72% complete

Processing asynchronous operation... execution time: 00:03:20 and 2.78% complete

Processing asynchronous operation... execution time: 00:03:24 and 2.83% complete

Processing asynchronous operation... execution time: 00:03:28 and 2.89% complete

Processing asynchronous operation... execution time: 00:03:32 and 2.95% complete

Processing asynchronous operation... execution time: 00:03:36 and 3.00% complete

Processing asynchronous operation... execution time: 00:03:40 and 3.06% complete

Processing asynchronous operation... execution time: 00:03:44 and 3.12% complete

Processing asynchronous operation... execution time: 00:03:48 and 3.17% complete

Asynchronous operation 72654ab4-675d-ee11-be6f-0022482809bb failed within 00:03:52.6670890.

The reason given was: Data Source import: FAILURE: Error calling /modifyPermissionsForServicePrincipal, StatusCode: Forbidden, please verify that user a1b7ceaa-fbb8-ed11-83fe-0022482809bb has at least Can use + share Permission on connection e66cab61334940aeb5765e948a1100ff
Microsoft PowerPlatform CLI
Version: 1.27.6+g9f62afb
Online documentation: https://aka.ms/PowerPlatformCLI
Feedback, Suggestions, Issues: https://github.com/microsoft/powerplatform-build-tools/discussions

Error: The async operation completed with a statuscode of Failed.


Usage: pac solution import [--path] [--activate-plugins] [--force-overwrite] [--skip-dependency-check] [--import-as-holding] [--publish-changes] [--convert-to-managed] [--async] [--max-async-wait-time] [--settings-file] [--skip-lower-version]

  --path                      Path to solution zip file. If not specified, assumes the current folder is a cdsproj project. (alias: -p)
  --activate-plugins          Activate plug-ins and workflows on the solution. (alias: -ap)
  --force-overwrite           Force an overwrite of unmanaged customizations (alias: -f)
  --skip-dependency-check     Skip dependency check against dependencies flagged as product update (alias: -s)
  --import-as-holding         Import the solution as a holding solution. (alias: -h)
  --publish-changes           Publish your changes upon a successful import. (alias: -pc)
  --convert-to-managed        Convert to a managed solution. (alias: -cm)
  --async                     Imports the solution asynchronously. (alias: -a)
  --max-async-wait-time       Max asynchronous wait time in minutes. The default value is 60 minutes. (alias: -wt)
  --settings-file             The .json file with the deployment settings for connection references and environment variables.
  --skip-lower-version        Skip solution import if same or higher version is present in current environment. (alias: -slv)

2023-09-27T19:01:25.7400937Z ##[section]Finishing: Import Managed Solution as Update

Expected Behavior

Sharing the connection should assign the appropriate level of permission.

What component are you experiencing the issue with?

ALM Accelerator Canvas App

What solution version are you using?

September 2023

Steps To Reproduce

I'm not 100% sure on this.

Anything else?

I did verify that manually changing the permission in the target environment on the SQL connection only (there are 3 total in the app) to, "Can use + share," fixed the import problem.

AB#1397
@sefa-phaag sefa-phaag added alm-accelerator ALM Accelerator Components and Apps bug Something isn't working labels Sep 27, 2023
@mikefactorial mikefactorial changed the title [ALM Accelerator - BUG]: ISSUE TITLE [ALM Accelerator - BUG]: Connection Sharing Permissions Sep 27, 2023
@mikefactorial
Copy link
Collaborator

mikefactorial commented Sep 27, 2023 •
edited

@sefa-phaag thanks for reporting this and for the detail! Hadn't seen this issue previously, but will make the update to use CanViewWithShare permission in the next release.

@mikefactorial mikefactorial self-assigned this Sep 27, 2023
@sefa-phaag
Copy link
Author

@mikefactorial Thanks. I'm also just now realizing that if you open the configuration deployment settings again, it reverts the manual permission on the connection, so it breaks again.

@mikefactorial mikefactorial mentioned this issue Oct 3, 2023
Merged
@CoEStarterKitBot
Copy link
Collaborator

@sefa-phaag This has been fixed in the latest release. Please install the latest version of the toolkit following the instructions for installing updates. Note that if you do not remove the unmanaged layers as described there you will not receive updates from us.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@mikefactorial mikefactorial

Labels
alm-accelerator ALM Accelerator Components and Apps bug Something isn't working
Projects
CoE ALM Accelerator
Status: Done ✅
Milestone
CoE Starter Kit - October 2023
Development

Successfully merging a pull request may close this issue.

October AA4PP Release microsoft/coe-starter-kit
4 participants
@mikefactorial @sefa-phaag @CoEStarterKitBot @RajeevPentyala