Resolution

MISSION CONTROL: Unable to create table in MySQL DB because of the sql_require_primary_key setting

AuthorFullName__c
Prakriti Vishwakarma
articleNumber
000006146
ft:sourceType
Salesforce
FirstPublishedDate
2024-07-11T09:37:52Z
lastModifiedDate
2024-07-11
VersionNumber
1
1. Disable the “sql_require_primary_key” variable
One of the options to remediate this error is to disable the “sql_require_primary_key” in the MySQL Daabase which would allow the Table to be created.

2. In case, it is mandatory to have “sql_require_primary_key” enabled in the Database, you would need to add the following properties in the system.yaml file -
mc:
    database:
        mysql:
            requirePrimaryKey:
                enabled: true
[or]

Add the following property in the artifactory.system.properties file -
JF_MC_DATABASE_MYSQL_REQUIREPRIMARYKEY_ENABLED=true