Error in Activating Calculation View

Former Member — Fri, 03 May 2013 12:50:43 GMT

Hi HANAer,

I am facing an error during activating calculation view in HANA SPS5 Trail environment.

This is a SQL script based calculation view, where the SQL was written like:

/********* Begin Procedure Script ************/

BEGIN

var_out =

SELECT

SUM(T2.AMOUNT-T1.AMOUNT) AS AMOUNT,

T1.MONTH_INT AS MONTH_INT

FROM

(SELECT AVG(AMOUNT) AS AMOUNT, MONTH_INT

FROM

“_SYS_BIC”.”psa/ANA_TRANSACTION”

GROUP BY MONTH_INT) AS T1,

(SELECT AVG(AMOUNT) AS AMOUNT, MONTH_INT

FROM

“_SYS_BIC”.”psa/ANA_TRANSACTION”

GROUP BY MONTH_INT) AS T2

WHERE T1.MONTH_INT = T2.MONTH_INT - 1

GROUP BY T1.MONTH_INT;

END /********* End Procedure Script ************/

The error log is as below:

---------------------

Detail Report:

Activation of objects
Summary of activation status
- Activation of CAL_AVG_DIFF_TREND
Detail activation status
- Execute validation rules
  - Object CAL_AVG_DIFF_TREND
    - Validation of psa.CAL_AVG_DIFF_TREND
      - Client side validation
        Table Validity Rule
        psa.CAL_AVG_DIFF_TREND: SQL Table Validity Successful
        Floating Element Rule
        psa.CAL_AVG_DIFF_TREND: Floating Element Check Rule Successful!
        No source element found in mapping.
        psa.CAL_AVG_DIFF_TREND:Source Mapping Check Rule Successful!
        Participant Element check
        psa.CAL_AVG_DIFF_TREND:Participant Element check Successful
        Output Object Type Rule
        psa.CAL_AVG_DIFF_TREND: Output Object Type Rule Successful!
        Data Type Check Rule
        psa.CAL_AVG_DIFF_TREND:Data Type Check Rule:Skipped
        Output Object Attribute Rule
        psa.CAL_AVG_DIFF_TREND: Output Object Attribute Rule Successful!
        Duplicate Output Attribute Rule
        psa.CAL_AVG_DIFF_TREND: Duplicate Output Attribute Rule Successful!
        Output Object Attribute/Measure Existence Rule
        psa.CAL_AVG_DIFF_TREND: Output Object Attribute/Measure Existence Rule Successful!
        Constant Mapping Check Rule
        psa.CAL_AVG_DIFF_TREND:Constant Mapping Check Rule Successful!
        Filter Validate Rule
        psa.CAL_AVG_DIFF_TREND:Filter Validate Rule:Skipped
        Counter Attribute Reference Check Rule
        psa.CAL_AVG_DIFF_TREND: Counter Attribute Reference Check Rule Successful!
        Input Parameter Check Rule
        psa.CAL_AVG_DIFF_TREND: Input Parameter Check Rule Successful!
        Calculation View Type Check Rule
        Calculation View Type Check Rule: Skipped
        Calculation View Type Check Rule Successful
        BI Virtual InfoProvider Rule
        psa.CAL_AVG_DIFF_TREND:Name Validate Rule successful
        Hierarchy Level Validate Rule
        psa.CAL_AVG_DIFF_TREND:Hierarchy Level Validate Rule:Skipped
        Large object data type check rule
        psa.CAL_AVG_DIFF_TREND: Large object data Type Check Rule:Skipped
        ABAP Name Check
        psa.CAL_AVG_DIFF_TREND: ABAP name validity successful
- Activation Id:155
  - Repository: Activation failed for at least one object;At least one runtime reported an error during activation. Please see CheckResults for details
    - Activation is performed with activation mode cascade two-phases.
    - Internal deployment of object failed;Repository: Encountered an error in repository runtime extension;Internal Error:Deploy Calculation View: SQL: sql syntax error: incorrect syntax near "�": line 11 col 1 (at pos 396)nSet Schema DDL statement: set schema "SYSTEM"nType DDL: create type "_SYS_BIC"."psa/CAL_AVG_DIFF_TREND/proc/tabletype/VAR_OUT" as table ("AMOUNT" DOUBLE, "MONTH_INT" TINYINT)nProcedure DDL: create procedure "_SYS_BIC"."psa/CAL_AVG_DIFF_TREND/proc" ( OUT var_out "_SYS_BIC"."psa/CAL_AVG_DIFF_TREND/proc/tabletype/VAR_OUT" ) language sqlscript sql security definer reads sql data as n /********* Begin Procedure Script ************/ n BEGIN n t var_out =n t SELECTnSUM(T2.AMOUNT-T1.AMOUNT) AS AMOUNT,nT1.MONTH_INT AS MONTH_INTnFROMn(SELECT AVG(AMOUNT) AS AMOUNT, MONTH_INTnFROMn“_SYS_BIC”.”psa/ANA_TRANSACTION”nGROUP BY MONTH_INT) AS T1,n(SELECT AVG(AMOUNT) AS AMOUNT, MONTH_INTnFROMn“_SYS_BIC”.”psa/ANA_TRANSACTION”nGROUP BY MONTH_INT) AS T2nWHERE T1.MONTH_INT = T2.MONTH_INT - 1nGROUP BY T1.MONTH_INT; nnEND /********* End Procedure Script ************/nVersion: 77n
    - Model deployment started: psa/CAL_AVG_DIFF_TREND timestamp: 2013-05-03,05:38:48.926
    - Start deployCalcView::startDocument, timestamp: 2013-05-03,05:38:48.938
    - Version: 77
    - End deployCalcView::startDocument, timestamp: 2013-05-03,05:38:48.938
    - Start deployCalcView::endDocument, timestamp: 2013-05-03,05:38:48.939
    - Start deployCalcView::deploy, timestamp: 2013-05-03,05:38:48.939
    - Start deployCalcView::createConsumptionXML, timestamp: 2013-05-03,05:38:48.940
    - End deployCalcView::createConsumptionXML, timestamp: 2013-05-03,05:38:48.940
    - Calculation View: _SYS_BIC/psa/CAL_AVG_DIFF_TREND
    - Consumption XML : <?xml version="1.0" encoding="UTF-8" standalone="no"?>
      <cubeSchema defaultLanguage="EN" defaultSchema="_SYS_BIC" operation="createHanaCube" version="3">
      <sqlScriptView name="psa/CAL_AVG_DIFF_TREND" schema="_SYS_BIC" sqlScriptFunctionSchema="_SYS_BIC" sqlScriptFunctionName="psa/CAL_AVG_DIFF_TREND/proc" registerViewForApsFlag="true">
      <dimensionAttributes>
      <dimensionAttribute name="MONTH_INT$attr">
      <columnMappings>
      <columnMapping column="MONTH_INT" name="MONTH_INT" type="key"/>
      </columnMappings>
      </dimensionAttribute>
      </dimensionAttributes>
      <measures>
      <measure column="AMOUNT" name="AMOUNT" aggregationType="sum"/>
      </measures>
      </sqlScriptView>
      </cubeSchema>
    - Start deployCalcView::deployScriptCV, timestamp: 2013-05-03,05:38:48.950
    - set Schema DDL: set schema "SYSTEM"
    - Validate Procedure failed: SQL: sql syntax error: incorrect syntax near "�": line 11 col 1 (at pos 396)2013-05-03,05:38:48.952
    - End deployCalcView::deploy, timestamp: 2013-05-03,05:38:48.952
    - End deployCalcView::endDocument(), timestamp: 2013-05-03,05:38:48.952
    - Post deploy processing started: psa/CAL_AVG_DIFF_TREND timestamp: 2013-05-03,05:38:48.952
    - Model deployment ended: psa/CAL_AVG_DIFF_TREND timestamp: 2013-05-03,05:38:48.952

------------------------

Is there anybody could help to find the root cause and shot this trouble? Thanks in advance!

Re: Error in Activating Calculation View

Former Member — Fri, 03 May 2013 17:02:53 GMT

Hi Jasper,

Same quote problem here. (http://scn.sap.com/message/14023352#14023352

BTW: Did you already granted rights to user system to access _SYS_REPO? If not execute this:

GRANT SELECT ON SCHEMA SYSTEM TO _SYS_REPO WITH GRANT OPTION;

Regards, Fernando Da Rós

Question Re: Error in Activating Calculation View in Technology Q&A

Error in Activating Calculation View

Re: Error in Activating Calculation View