Tags: devanshjainms/sap-automation
Tags
Final PR for release v3.9.3.0 (Azure#500) * Merge from main to experimental (Azure#490) * remove duplicate definitions * remove duplicate --------- Co-authored-by: Kimmo Forss <[email protected]> * Prepare for hotfix 3.9.2.0 * Add permissions for control plane SPN * Updated variable name * Change provider for network links * Undo * Change provider * Update the ref in the resources.yml (cherry picked from commit 2408620) * changes required for release 3.9.2.0 * skip resource provider * HotFix 3.9.3 * Preparation for hotfix release 3.9.3 * Add the missing exports * Update advanced state management * move second parameter * Add verbosity * Update pipeline * remove the vault * remove the quotes * add the getopt values * move the order * Don't create the configuration variables * Switch the if statement * Don't reset the step * Add the support for test only for workload zone as well * Name rationalization * Add support for multiple IP ranges * Using a list * adress space check * change the address space to list * use the correct output * Use the renamed output storageaccount_resourcegroup_name * Don't perform deployment if not logged on as SPN * format * simplify network logic * Fix the logic for deployer configuration * Fix deployer and flatten the list of vnets * Fix the list of vnets * remove the set statements * Version update and fault domain counter * Update the template * Web App updates * Variable renames * Update pipeline * Package updates * Add support for multiple address ranges * Change HTML IDs * deployment task * Update Azure Identity * More informative task names * Feng shui * change the dns creation logic * Fixes for IPs * Default upgrade packages to false * Switch to use instance metadata * Add support for extending packages, mounts etc * Rel 9.2 support * Add support for dynamically retrieval of SWPM10 * hdbuserstore updates * pacemaker updates * Load Balancer timeout updates * Format the Terraform files, add support for tags for all resources * Start documentation of variables * Add support for providing tags for all resources * Support deployerless deployments * Add missing tags * Web App updates (tag support) * Add a dependency on the private end point * Add dependency for container * Work on the dependency map * Add a dependency on the storage account network rules * Make the public access same for both storage accounts * change the dependency order * store the state file if failure when removing * Adding the missing parameters * Set permissions on variable groups * Fix the Invoke-Restmethod call * Allow resetting of PAT * Fix typo * Resetting of PAT * allow reusing of repo * Add permissions to pipelines * Simplify the query * Add a pause * Remove default access for all pipelines * Don't show Invoke-RestMethod response * Add pipelines permissions for pool * Don't set permissions on pools (yet) * Add permissions on agent pools * Use the queue id and not the pool ID * Add more info * Final version for next release * prepare for release 3.9.3.0 * install lint 6.20.3 for the workflow as we are not ready to 6.21 yet. * suppress tracing when checking variables * Lint fixes * Linting * remove extended character * Pull in main * Several improvements and additions for deploying DB2 (Azure#496) * Bugfix nproc unlimited for dbsidadm group, not db2sidadm group * Use virtual_host from hostvars (inventory) for DB2 installation * Fixed DB2 log_dir mountpoint DB2 log_dir was mounted on /log/SID/dir instead of /db2/SID/log_dir * Fix Agent_IP variable for sap_library * Remove become and orchestration user for delegated VmAgentActions tasks * Improve 2.10-sap-notes tasks * Optimize SAP OS USERS and Group Creation (user_nw) tasks * Remove unused input-api variables * Add custom virtual_hostname variabels for db, ers, scs and pas * Add vars for ASCS/ERS NFS filesystem devices when not using AFS or ANF * Bugfix data source azuread_service_principal Error: Unsupported argument on imports.tf line 49, in data "azuread_service_principal" "sp": client_id = local.spn.client_id An argument named "client_id" is not expected here. one of `application_id,display_name,object_id` must be specified * Contain setting of HANA schema name to only execute when deploying HANA * alingment on task and set execution bit for the acss-registration shell script. --------- Co-authored-by: Kimmo Forss <[email protected]> Co-authored-by: Harm Jan Stam <[email protected]>
Hotfix v 3.9.2.0 Azure#2 (Azure#493) * Merge from main to experimental (Azure#490) * remove duplicate definitions * remove duplicate --------- Co-authored-by: Kimmo Forss <[email protected]> * Prepare for hotfix 3.9.2.0 * Add permissions for control plane SPN * Updated variable name * Change provider for network links * Undo * Change provider * Update the ref in the resources.yml * changes required for release 3.9.2.0 --------- Co-authored-by: Kimmo Forss <[email protected]>
SDAF - Release 3.9.0 (Azure#486) * SDAF - Release 3.9.0 --------- Co-authored-by: Jennifer Hajduk <[email protected]> Co-authored-by: Kimmo Forss <[email protected]> Co-authored-by: Shayak Sarkar <[email protected]> Co-authored-by: Jaskirat Singh <[email protected]> Co-authored-by: Kimmo Forss <[email protected]> Co-authored-by: Troy Shane <[email protected]> Co-authored-by: Rickmarges <[email protected]> Co-authored-by: Marges, RSY (Rick) <[email protected]> Co-authored-by: Harm Jan Stam <[email protected]> Co-authored-by: Harm Jan Stam <[email protected]>
Merging changes from sdaf-acss main after creation of v3.8.3.4 (Azure… …#475) * Added README.md file * Added file CONTRIBUTING.md * Updated README.md * Updated CONTRIBUTING.md * Added .gitignore * Adding owners.txt containing ServiceTree admins * v3.6 release * Updated owners.txt * Current code for ansible 3.7 that is being tested by ACSS. * Added a delay before validating the SCS ERS cluster. * Removed the BOM-catalog folder. * Merged PR 8320960: Merging sap-automation main into this repo's main branch. This is done as part of the 3.8.3 parity task. This is an attempt to bring the Co-Dev model into effect so that all ansible development can now happen through the SDAF-ASCS repo. Related work items: #24291278 * Merged PR 8350970: Fix Logical Volume creation Fix Logical Volume creation: Description: In the volume group vg_sap, we need to create several logical volumes which include for lv_sapmnt, lv_usrsapinstall, lv_usrsap. The goal is to allocate a predetermined amount of space to lv_sapmnt, lv_usersap and then allocate the rest of the space to lv_usersapinstall. But the order in which this allocation was being done was in reverse which resulted in lv_usersapinstall consuming all the space in vg_sap therefore, blocking the creation of other logical volumes. The ordering has been fixed in this PR. This is the test proof for the same: Query to view the results for createinfra test: https://waasservices.eastus.kusto.windows.net/WaaSKustoDB?query=H4sIAAAAAAAEAG2RTUsDQQyG7%2fsrwpwqbGFZQUGpILXCHvzAFXoQD2kmtaO7M0sm21Lwxzur0A8qzCFD3id5k8wR6wdWcTRbs9fsGzYrFoZnYXKRX13LtWLbwQ1YVNb0H5VFeT4uLsblJRTF1e8724F1v4gkrlMXfGXBeRhVXlk8NoepuCdeOIZeiJOagld0PoJBuwpkdpq71NfHgXsz8yBfyyZsHrFl8w6TCZipcDJX%2baVgVOlJe%2bH%2f4aeOBQcDaSod8MGgqXsiZsvW5GDu0TUpGgx2Ej6Z9GQb%2bVHNmUiQabD85yiHmmXtiG9J3drptrL5wZBD%2fJHAHPb51CqIZYHF9kh5cgWMdJ1lP74BzVW1AQAA&web=0 WaaSMetricEvent | where PreciseTimeStamp > datetime(2023-06-27 00:00:00) | where SubscriptionId in (InternalSubscriptions) | where ResourceId contains "adhoc" | where Dimensions["WorkflowName"] == "CreateInfrastructure" | where Dimensions["OperationState"] in ("Succeeded", "Failed") | project PreciseTimeStamp, Dimensions["ErrorCodeName"], ServiceActivityId, ResourceId, Region, ActivityId | order by ResourceId, PreciseTimeStamp asc; Query to view the results for install test: https://waasservices.eastus.kusto.windows.net/WaaSKustoDB?query=H4sIAAAAAAAEAG2RTUsDMRCG7%2fsrhpwqbGFZQUGpIFphD37gCj2Ih2ky2mg2WSazWwr%2beBOFflAhhwnv%2b%2bSdmSwQ23sStno%2bkpfiG9YrYoInJm0jvdiOWsGuhyswKCTpPqmr%2bnRanU3rc6iqi99zsgXbYRk1215s8I0B62HSeCH26PaluCOeKYaBNSW3Dl7Q%2bggKzSpotfXcplwfM%2feqFoG%2f3l1YP2BH6g1mM1CNj4LOZcUFNP9zjz0x5uw0kGQy96baQWsiQ0aVoO7QulTl3noOn6TlaBHlwZtz5sA3wdBfMyW0xKPVdK3FjlY2jSn35sv1RwJL2OkpKrAhhuXmwHn0ARj1ZVH8AGqZJGKwAQAA&web=0 WaaSMetricEvent | where PreciseTimeStamp > datetime(2023-06-27 00:00:00) | where SubscriptionId in (InternalSubscriptions) | where ResourceId contains "adhoc" | where Dimensions["WorkflowName"] == "InstallWorkload" | where Dimensions["OperationState"] in ("Succeeded", "Failed") | project PreciseTimeStamp, Dimensions["ErrorCodeName"], ServiceActivityId, ResourceId, Region, ActivityId | order by ResourceId, PreciseTimeStamp asc; 1 SCS failure observed which was transient and succeeded on retry These are the other errors observed which are not related to ansible: InstallHostUnreachable InstallServiceError AzureVMIsNotInSupportedProvisioningState Related work items: #24199283 * Merged PR 8352697: fix logical volume order with vg_sap fix logical volume order with vg_sap * Update owners.txt * Remediating Azure Artifacts Configuration Issues in your Repository * Merged PR 8383025: Getting latest release code from github repo into main branch. Pulling in the changes made to the experimental branch so that the hotfix release (3.8.3.2) made in github public repo is present here as well * Merged PR 8497623: Syncing SDAF Public main branch to SDAF-ACSS main branch Syncing SDAF Public main branch to SDAF-ACSS main branch Related work items: #24650568 * Merged PR 8543963: Added checks to see if dynamic BOM download has succeeded. In /deploy/ansible/roles-sap/3.3-bom-processing/tasks/bom_processor.yaml, added checks to see if: For every media element defined in a BOM - Dynamic BOM download has succeeded. - Whether archive property is defined. * Resolved merge conflict. * Adding some files to gitignore. * Removed Webapp/.npmrc * Removed the Nuget.config file. --------- Co-authored-by: Rob Chappelle <[email protected]> Co-authored-by: PIE Easy Start <[email protected]> Co-authored-by: Kimmo Forss <[email protected]> Co-authored-by: sedusch <[email protected]> Co-authored-by: Shayak Sarkar <[email protected]> Co-authored-by: Jaskirat Singh <[email protected]> Co-authored-by: MerlinBot <> Co-authored-by: MerlinBot <MerlinBot>
3.8.2 release (Azure#452) * Add the database instance number * Added a failed when condition * Add pool & account IDs to outputs * countrol output of transport volume * add a try to the transport volume name to facilitate resource imports * uppercase ansible_os_family * Add OracleLinux * Start with AVG support * Add skip-broken * change the dir where we search for sapcontrol * restore AVG * Add the EPEL repo * Add the node_tier to dictionary * Corrected attribute name * removed the extra when statement * remove the epel repo * Use subscription-manager to enable repos * Use DNF to register repo * temporary disable subscription-manager repos * adding libknet1-compress-lz4-plugin manually * subscription-manager * disable_gpg_check * removed test package * Add AVG later * put cluster in maintenance mode after generic resource creation on RHEL * update repo state * add install azure-cli to configure_deployer.sh * put cluster in maintenance mode after generic resource creation on SUSE * update the code for managing Azure CLI installs * Don't ise subscription-manager * cluster maintenance mode changes for RHEL & SUSE * only upgrade the packages once * Add OL repo * removed root * Rationalize login code, provide ARM_SUBSCRIPTION_ID as output * change order of when condition * Add azapi * removed the failed_when * Don't install ERS if SCS fails * Remove the extra when statement * removed the when * add failed_when conditions * azapi * local not locals * removed extra variables * Logon using SPN comparison * Don't use the variable * use the pool as data source * Remove AVG for now * changes to cluster components * Only set root owner if SAP users have not been created * Look for sap sid * update ERS HA install rescue action * change inventory_hostname to ansible_hostname in 5.6.4.0-cluster-Suse.yaml * also check for installationSuccesfullyFinished file * Fix the search path * check if installation output folder exists before doing find * remove the state attribute from stat * verify output directory exists before searching * don't recurse * Bring in the Fixes to get Ha SCS installation working (Azure#448) * Control ini file cleanup * check the installation file * Add More debugging info * Testing the 3.7 codebase * Use code from 3.7 * Ensure primary node is online * don't put cluster in maintenance mode yet * run as root * feng Shui * Linting fixes * Indentation fixes --------- Co-authored-by: Kimmo Forss <[email protected]> * comment out the additional call to create SAP resources. * comment the maintenance mode code for RHEL as well. * Introduce AVG * Add AVG variable to dictionary * add additional data source * simplify the data sources * update the disctionary * Set defaults for ppg and avset * Use the correct dictionary variable * add log & shared * Remove the count for the data source * add the avg resources * Add the account ID * Make the rule naming more tolerant * simplify the data source * naming update * Use the account ID * Add a try statement for ANF account name * Add a try statement for ANF pool name * Fix for empty arm_id * create empty dictionary * change uuid * Change networkFeatures * provide empty dictionary * Fix HANA log * fix creationToken * set unixPermissions * unixPermissions * removed unix * add try for capacityPoolResourceId * serviceLevel = "Premium" * set kerberos5xReadOnly to false * service_level * Add Zonal support * xompact the volumes * improve readability * AVG updates * Use the second ppg * zonality fixes for avg * If AVGs are used don't create standalone volumes * correct spec * AVG ppg logic * Updated the creationToken * Create the volumes * Add dependencies * Check the output * Use output * Use the AVG name * Support updating the AVG * location is not needed * User standard azurerm * remove azapi * simplify enumerator * remove azapi * added resource_group_name = * enumerator * change provider * HANA data data source * HANA shared output * Add secondary sapmnt * Incorrect function * make sapmnt multi value * Don't have sap_mnt as list * Don't look for HANA shared if it is provided by ANF * Default to no shared disk * HANA shared disk logic * hana_shared_mountpoint logic * missing if * Debug adding shared disk * Removed the hana shared disk from main dictionary * Add zones to AVG volumes * No zonal support * Use Ansible's magic variables for mounts * Don't show unneeded files from hosts * Corrected the task names * Web App semicolon fix * Don't constrain NFS info * Don't call AFS tasks for ANF usage * Add a try statement to handle upgrades from older versions * add the missing variables * Don't use SCS cluster name * Don't use the HA template for non HA deployments * Add an if statement to control the jinja template name * Don't link the VNEts if no private endpoints * Create bom folders as orchestration user * Add quotes for the web dispatcher instance number * Don't fail for local DNS * 3.8.1 release * Add support for SPN login for control plane * Set pipefail * Update the linter and skip the octal value rule * Linting updates * Linting fixes * remove whitespace * update sshkey playbook * Fix the pipefails * password jinja updates * set -o pipefail && * Don't lint chrony * Fix lint for chrony * Add the filter folder * Use the correct instance numbers * rename web_instance_number variable in sap-parameters.yml.tmpl to wd_instance_number. * push changes * fix web dispatcher variables * Add Logon using SPN code * Add SPN logon to removal pipeline * set 20GB swap for web dispatcher * disable selinux for web tier * Add support for marketplace images with plan * remove the set pipefail * swap the attributes in plan * swap plan components * Add RHEL 9 support for packages, repositories and services * Make python3 the default and only set python2 for SLES12 * Use the internal DNS when using private endpoints * Upgrade az cli * sudo upgrade * Removed the connection_String setting * Change to use MSI * Don't assign specific permission for web app * Provide DB SKU override * Add the SKU override in the Web App * Add the ability to not deploy the Microsoft.AzureCAT.AzureEnhancedMonitoring extension * Correct the variable name * Add RHEL 90 * Add Kernel parameters for RHEL 9 * removed the package libssh2 * removed libpng12 * removed oddjobd service * Add RHEL9 distro * 3119751 only mentions RHEL8 * update packages * Set NIC name for private endpoint for control plane * Upgrade Azure CLI & Terraform when re-running * Bump terrafom version * removed compat-sap-c++-* * Dont register Microsoft keys * USe CLI version 2.47 * Lock 0n 2.47 on Ubuntu 20.04 * Add llogging for CLI * Show what version got installed * Use grep to get the cli version * Simplify re-install * Ad more debug info on which agent is in use * SELinux for RHEL 9 * Allow rerun for manual deployer * Fix virtualenv on RHEL * RHEL deployer updates * Save the random ID value * missing $ * Corrected the output variable * use $$ in template * show YAML version * debug HANA on RHEL 9 * testing HANA install * debugging HANA installation * Add package chkconfig * only install chkconfig on hana * move flush handler * Use azurerm backend if reinstall * remove extra password parameter * test password setting for HANA installation * add password for * use the correct password copy * Only delete ini file if installation is successful * moved chkconfig to 9.0 dictionary * Add debugging * Improve re-install experience * reset firewall * storage account fire wall * export deployer_kv_user_arm_id * update variable name * Don't rerun the secrets setting * Remove Oracle repos * Add more images for RHEL * update BoM Validator * Added installation of devops extension in the main pipelines * Provide the ability to control zonal ANF --------- Co-authored-by: Kimmo Forss <[email protected]> Co-authored-by: hdamecharla <[email protected]>
PreviousNext