Symptom
- 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
Read more...
Environment
- SAP Data Intelligence 3.x - On Premise Edition
- SAP Data Intelligence 2113.15.41 - Cloud Edition
Product
Keywords
KBA , CA-DI-MM , Metadata Management , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.