microsoft / microsoft/Dynamics-365-FastTrack-Implementation-Assets
Error while executing CMDUtil
Nobody has claimed this yet.
- Dominant language
- Jupyter Notebook
- Stars
- 494
- Forks
- 296
- Avg merge
- 1d 10h
- Merged PRs (30d)
- 5
Description
Hello, I'm having issue running the CMDUtil Console App. Here is the Step at which it is failing. Can anyone please help on this issue or if anyone has faced similar issue.
11:24:09 info: CDMUtil.ConsoleApp[0] Manifest:Group.manifest.cdm.json
11:24:09 info: CDMUtil.ConsoleApp[0] Table:CustGroup
11:24:09 info: CDMUtil.ConsoleApp[0] Metadata to DDL as SynapseView
11:24:09 info: CDMUtil.ConsoleApp[0] Table:CustGroup
11:24:09 info: CDMUtil.ConsoleApp[0] Tables:1
11:24:09 info: CDMUtil.ConsoleApp[0] Entities/Views:0
11:24:09 info: CDMUtil.ConsoleApp[0] Executing DDL:CreateDB
11:24:09 info: CDMUtil.ConsoleApp[0] Status:success
11:24:09 info: CDMUtil.ConsoleApp[0] Executing DDL:CreateMasterKey
11:24:09 info: CDMUtil.ConsoleApp[0] Status:success
11:24:09 info: CDMUtil.ConsoleApp[0] Executing DDL:Create_Cred_sources_formats
11:24:09 fail: CDMUtil.ConsoleApp[0] Statement: -- create credentials as managed identity
IF NOT EXISTS(select * from sys.database_credentials where name = 'dynamics365_financeandoperations_mcqad365_sandbox')
CREATE DATABASE SCOPED CREDENTIAL dynamics365_financeandoperations_mcqad365_sandbox WITH IDENTITY='Managed Identity'
IF NOT EXISTS(select * from sys.external_data_sources where name = 'dynamics365_financeandoperations_mcqad365_sandbox_EDS')
CREATE EXTERNAL DATA SOURCE dynamics365_financeandoperations_mcqad365_sandbox_EDS WITH (
LOCATION = 'https://corpqa008adlsst.dfs.core.windows.net/dynamics365-financeandoperations/mcqad365.sandbox.operations.dynamics.com/',
CREDENTIAL = dynamics365_financeandoperations_mcqad365_sandbox);
IF NOT EXISTS(select * from sys.external_file_formats where name = 'dynamics365_financeandoperations_mcqad365_sandbox_FF_CSV_P1')
CREATE EXTERNAL FILE FORMAT dynamics365_financeandoperations_mcqad365_sandbox_FF_CSV_P1
WITH (FORMAT_TYPE = DELIMITEDTEXT, FORMAT_OPTIONS ( FIELD_TERMINATOR = ',', STRING_DELIMITER = '"', FIRST_ROW =1, USE_TYPE_DEFAULT = true , PARSER_VERSION = '1.0') );
IF NOT EXISTS(select * from sys.external_file_formats where name = 'dynamics365_financeandoperations_mcqad365_sandbox_FF_CSV_P2') CREATE EXTERNAL
FILE FORMAT dynamics365_financeandoperations_mcqad365_sandbox_FF_CSV_P2
WITH ( FORMAT_TYPE = DELIMITEDTEXT, FORMAT
_OPTIONS ( FIELD_TERMINATOR = ',', STRING_DELIMITER = '"', FIRST_ROW = 1 , PARSE
R_VERSION = '2.0') ); IF NOT EXISTS ( SELECT * FROM sys
.schemas WHERE name = N'dbo' ) EXEC('CREATE SCHEMA [dbo]');
11:24:09 fail: CDMUtil.ConsoleApp[0] CREATE DATABASE SCOPED CREDENTIAL is not su
pported in master database.
11:24:09 fail: CDMUtil.ConsoleApp[0] Status:failed
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start with the CMDUtil Console App invocation using Group.manifest.cdm.json and inspect the generated Create_Cred_sources_formats DDL around the database context. No source file or test is named; done would require a confirmed reproduction and an identified repository-specific fix or documentation path.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- azure, sql
- Domain
- cloud, databases
- Issue type
- Bug
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 15/100