Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Problem activating HANA SP5 Decision Table

I am getting following error while activating a decision table on HANA SP5. I am logged in as user SYSTEM to HANA, who has CREATE ANY on _SYS_BIC. Not sure what privilege is missing? Any help will be appreciated.

Repository: Encountered an error in repository runtime extension;error preparing statement CREATE PROCEDURE "_SYS_BIC"."pricing/PROMO_PRICING" LANGUAGE SQLSCRIPT ASnBEGINntemp = SELECT "GUEST_SEGMENT","OFFER_DISCOUNT","GUEST_ID", CASE WHEN "GUEST_SEGMENT" = 'G' THEN 1nWHEN "GUEST_SEGMENT" = 'S' THEN 2nWHEN "GUEST_SEGMENT" = 'B' THEN 3nnELSE "OFFER_ID"nENDn AS "calc_OFFER_ID" ,"OFFER_ID" FROM "_SYS_BIC"."pricing/PROMO_PRICING/CV";UPDATE "PRICING"."PROMOTIONAL_OFFER"  as t SET "OFFER_ID" = (SELECT DISTINCT "calc_OFFER_ID" FROM :temp WHERE ( :temp."OFFER_DISCOUNT" is NULL OR :temp."OFFER_DISCOUNT" = t."OFFER_DISCOUNT") and ( :temp."OFFER_ID" is NULL OR :temp."OFFER_ID" = t."OFFER_ID") ); nnnEND;n for oid {tenant: , package: pricing, name: PROMO_PRICING, suffix: hdbruldec}: insufficient privilege: Not authorized at ptime/query/checker/

Not what you were looking for? View more on this topic or Ask a question