13 Replies Latest reply: Nov 16, 2013 9:35 PM by Anees Ahmad RSS

Problem activating HANA SP5 Decision Table

Shashi Sharma
Currently Being Moderated

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/query_check.cc:1966

Actions