When using the deploy script found at single_tech_samples/synapseanalytics/sample1_loading_dynamic_modules/setup I am sometimes getting the following error:
(ValidationFailed) Workspace request validation failed, check error details for more information
Code: ValidationFailed
Message: Workspace request validation failed, check error details for more information
Exception Details: (InvalidSqlServerPassword) Sql Server password not complex. The password must be atleast 8 characters long and contain characters from three of the following four categories: (uppercase letters, lowercase letters, digits (0-9), Non-alphanumeric characters such as: !, $, #, or %).
Code: InvalidSqlServerPassword
Message: Sql Server password not complex. The password must be atleast 8 characters long and contain characters from three of the following four categories: (uppercase letters, lowercase letters, digits (0-9), Non-alphanumeric characters such as: !, $, #, or %).
This is caused by the command generating the password: SQL_ADMIN_PASSWORD=$(cat /dev/urandom | tr -dc 'a-zA-Z0-9' | fold -w 15 | head -n 1 | tr '[:upper:]' '[:lower:]' )!
Since the input is completely random there is a non-zero chance that the password will not contain a number. Since we are converting all upper case to lower case then it leads to sometimes the password only having lowercase letters and an ! which means it fails the complexity check.
Expected Behavior
Consistent creation of a synapse workspace and internal SQL table
Reproduce
Go to 'single_tech_samples/synapseanalytics/sample1_loading_dynamic_modules/setup'
Provide variables for the following
DEPLOYMENT_PREFIX
AZURE_SUBSCRIPTION_ID
AZURE_RESOURCE_GROUP_LOCATION
Perform an az login
Run ./deploy.sh
See error
Additional Context
Can be fixed by removing tr '[:upper:]' '[:lower:]' from the command
Description
When using the deploy script found at single_tech_samples/synapseanalytics/sample1_loading_dynamic_modules/setup I am sometimes getting the following error:
This is caused by the command generating the password:
SQL_ADMIN_PASSWORD=$(cat /dev/urandom | tr -dc 'a-zA-Z0-9' | fold -w 15 | head -n 1 | tr '[:upper:]' '[:lower:]' )!
Since the input is completely random there is a non-zero chance that the password will not contain a number. Since we are converting all upper case to lower case then it leads to sometimes the password only having lowercase letters and an ! which means it fails the complexity check.
Expected Behavior
Reproduce
./deploy.sh
Additional Context
tr '[:upper:]' '[:lower:]'
from the command