3200873 - Run rulebook fails with error "insufficient privilege" - SAP Data Intelligence

• Cannot create rulebooks due to insufficient privileges
• Rulebook run failed with error below:

Module: dh-app-metadata
Code: 71267
Message: Failed record task failed: check logs for details
GUID: xxxxxxxxxxxxxxxxxx

Causes

Module: vflow
Code: 99999
Message: Graph yyyyyyyyyyy failed: Group Messages: Group: default; Messages: Graph failure: internalfailedrulemetadataproducer2 failed with the following error: General error; 258 insufficient privilege: Not authorized Process(es) terminated with errors. restarsOnFailure==false, handle zzzzzzzzzzzzzzzzzzzzz

• datahub-app-daemon-xxxx pod log shows an SQL statement which should be executed but failed. In this case, this is a CREATE COLUMN TABLE statement:

ERROR|Task failed.
{
  "id": "32a801b05d6a8805180024c2eb09d2a8",
  "rulebookRunId": "2fa801b05d6a8805180024c2eb09d2a8",
  "graphHandle": "c90bcf13d57f4a12bf280f982e9d40c9",
  "graphMessage": "Group messages:\nGroup: default; Messages: Graph failure: internalvalidationrulev2 failed with the following error:\nDBS-070407: |Loader QueryTransform_ValidationTransform_05af36d7835449daa66b7f7d9c3c12ab_FailExport_All_37de10cced86d617dd66_FAIL_DATA SQL submitted to database <> resulted in error <General error;258 insufficient privilege: Not authorized>. The SQL submitted is <CREATE COLUMN TABLE \"SYSTEM\".\"37de10cced86d617dd66_FAIL_DATA\" ( \"E-Mail Address - SMTP_ADDR\" NVARCHAR (5000) ,  \"EXECUTION_ID\" NVARCHAR (32)  not null ,  \"GENERATED_ID\" DOUBLE  not null ,   primary key ( \"EXECUTION_ID\", \"GENERATED_ID\") ) >. \nProcess(es) terminated with error(s). restartOnFailure==false\n"
}|dh-app-metadata|dh-app-metadata|17|RulebookTaskChecker.checkTask|TaskCheckerBase.js:49:33

• SAP Data Intelligence 3.x - On Premise Edition
• SAP Data Intelligence 2113.15.41 - Cloud Edition

KBA , CA-DI-MM , Metadata Management , Problem