cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

logical index creation error

Former Member

on ‎02-19-2014 11:20 AM

0 Kudos

Hello!

I get this error during activation the Analytic view. Analytic View contain two tables. Join condition of this table contain to fields. If I remove one of this field activation finish successfull. Description of this Analytic View you can see in attached screens.

HANA and Studion version is 71.

What is the couse of this error?

P.S. Error text I put in attached txt file (please change extension of this file to xhtml)






Job Details. 



Job ID :  
HBD_Activation__1392804357182




Job Type :  
Activation




System :  
HBD:192.168.61.10:10:




Start Time :  
Wed Feb 19 14:05:57 GST 2014




End Time :  
Wed Feb 19 14:26:54 GST 2014




Elapsed Time :  
1257.062 Seconds









Summary Report. 








NameTypePackageStatusDescription



AN_TEST.analyticview
Analytic View
OK_OLAP
Error
.















Detailed Report. 






    

  • Activating objects...
    • 

  • Summary of activation status
    • 

      

    • Activation of AN_TEST
      • 

    

  • Detail activation status
    • 

      

    • Execute validation rules
      • 

        

      • Object AN_TEST
        • 

          

        • Validation of OK_OLAP.AN_TEST 
          • 

            

          • Client-side validation
            • 

              

            • No rule selected
              • 

            

          

        

      

    • Activation ID: 1529 (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.
        • 

      • OK_OLAP.AN_TEST
        • 

          

        • Internal deployment of object failed;Repository :   Encountered an error in repository runtime extension;Internal Error:Deploy Analytic View: nntransaction rolled back by an internal error: column store error: logical index creation error: [2999] general error (no further information available);object=_SYS_BIC:OK_OLAP/AN_TESTen(46)nnSQL: transaction rolled back by an internal error: column store error: <?xml version="1.0" encoding="utf-8"?> 
          <createCubeResult version="1.0"> 
          <status> 
          <message> 
          Error during executing SQL statement</message> 
          <errorCode> 
          2116</errorCode> 
          </status> 
          <details> 
          <errors> 
          <detail> 
          <element> 
          CREATE COLUMN VIEW "_SYS_BIC"."OK_OLAP/AN_TEST" WITH PARAMETERS (DESCRIPTION='', INDEXTYPE=5, JOININDEX = "MAHMETZYANOV"."OLAPCASHES", JOININDEXTYPE = 2, JOININDEX = "MAHMETZYANOV"."OLAPFACTS", JOININDEXTYPE = 1, JOINCONDITION = ('JOIN_OLAPFACTS_OLAPCASHES_1', "MAHMETZYANOV"."OLAPFACTS", "SHOPNAME", "MAHMETZYANOV"."OLAPCASHES", "SHOPINDEX", '', 49, 2), JOINCONDITION = ('JOIN_OLAPFACTS_OLAPCASHES_2', "MAHMETZYANOV"."OLAPFACTS", "CASHNUMBER", "MAHMETZYANOV"."OLAPCASHES", "ID", '', 49, 1), JOINPATH = ('PATH_OLAPCASHES_1', 'JOIN_OLAPFACTS_OLAPCASHES_1, JOIN_OLAPFACTS_OLAPCASHES_2'), VIEWATTRIBUTE = ('REGION', "MAHMETZYANOV"."OLAPCASHES", "REGION", 'PATH_OLAPCASHES_1', '', '', '', 'REGION'), VIEWATTRIBUTE = ('CASHNAME', "MAHMETZYANOV"."OLAPCASHES", "CASHNAME", 'PATH_OLAPCASHES_1', '', '', '', 'CASHNAME'), KEYFIGURE = ("PAYMENT", 1, FORMULA='', DESCRIPTION='', UNITCONVERSIONNAME='', EXPRESSION='', EXPRESSIONFLAGS=0, INDEXID="MAHMETZYANOV"."OLAPFACTS", ATTRIBUTE="PAYMENT"), CHARACTERISTIC=('REGION', KEYATTRIBUTE="REGION"), CHARACTERISTIC=('CASHNAME', KEYATTRIBUTE="CASHNAME"), 'REGISTERVIEWFORAPCHECK'='1', OPTIMIZEMETAMODEL=1)</element> 
          <code> 
          46</code> 
          <message> 
          transaction rolled back by an internal error: column store error: logical index creation error: [2999] general error (no further information available);object=_SYS_BIC:OK_OLAP/AN_TESTen</message> 
          </detail> 
          </errors> 
          </details> 
          </createCubeResult> 
          nnCreate OLAP Scenario statement: CREATE OLAP SCENARIO '<?xml version="1.0" encoding="utf-8"?> 
          <cubeSchema version="3" operation="createHanaCube"> 
          <cube name="_SYS_BIC:OK_OLAP/AN_TEST" registerCubeForApsFlag="true" registerCubeForSqlApsFlag="false"> 
          <cubeTables> 
          <cubeTable name="MAHMETZYANOV:OLAPCASHES" type="d-table"/> 
          <cubeTable name="MAHMETZYANOV:OLAPFACTS" type="f-table"/> 
          </cubeTables> 
          <joinConditions> 
          <joinCondition name="JOIN_OLAPFACTS_OLAPCASHES_1" cardinality="1:1" joinType="leftOuter"> 
          <partner1 table="MAHMETZYANOV:OLAPFACTS" column="SHOPNAME"/> 
          <partner2 table="MAHMETZYANOV:OLAPCASHES" column="SHOPINDEX"/> 
          </joinCondition> 
          <joinCondition name="JOIN_OLAPFACTS_OLAPCASHES_2" cardinality="1:1" joinType="leftOuter"> 
          <partner1 table="MAHMETZYANOV:OLAPFACTS" column="CASHNUMBER"/> 
          <partner2 table="MAHMETZYANOV:OLAPCASHES" column="ID"/> 
          </joinCondition> 
          </joinConditions> 
          <joinPaths> 
          <joinPath name="PATH_OLAPCASHES_1"> 
          <joins> 
          <join name="JOIN_OLAPFACTS_OLAPCASHES_1"/> 
          <join name="JOIN_OLAPFACTS_OLAPCASHES_2"/> 
          </joins> 
          </joinPath> 
          </joinPaths> 
          <dimensionAttributes> 
          <dimensionAttribute name="REGION"> 
          <columnMappings> 
          <columnMapping name="REGION" technicalName="REGION" type="key" table="MAHMETZYANOV:OLAPCASHES" column="REGION" joinPath="PATH_OLAPCASHES_1" isVisible="true"/> 
          </columnMappings> 
          </dimensionAttribute> 
          <dimensionAttribute name="CASHNAME"> 
          <columnMappings> 
          <columnMapping name="CASHNAME" technicalName="CASHNAME" type="key" table="MAHMETZYANOV:OLAPCASHES" column="CASHNAME" joinPath="PATH_OLAPCASHES_1" isVisible="true"/> 
          </columnMappings> 
          </dimensionAttribute> 
          </dimensionAttributes> 
          <measures> 
          <measure name="PAYMENT" table="MAHMETZYANOV:OLAPFACTS" column="PAYMENT" aggregationType="sum" isVisible="true"/> 
          </measures> 
          <constraints/> 
          </cube> 
          </cubeSchema> 
          'n           
          • 

        • Model deployment started: OK_OLAP/AN_TEST timestamp: 2014-02-19,14:05:54.171
          • 

        • Removing BIMC records for OK_OLAP/AN_TEST timestamp: 2014-02-19,14:05:54.172
          • 

        • Removing hierarchy views for OK_OLAP/AN_TEST timestamp: 2014-02-19,14:05:54.176
          • 

        • Start deployment of analytic view, timestamp: 2014-02-19,14:05:54.180
          • 

        • CREATE OLAP SCENARIO statement :   CREATE OLAP SCENARIO '<?xml version="1.0" encoding="utf-8"?> 
          <cubeSchema version="3" operation="createHanaCube"> 
          <cube name="_SYS_BIC:OK_OLAP/AN_TEST" registerCubeForApsFlag="true" registerCubeForSqlApsFlag="false"> 
          <cubeTables> 
          <cubeTable name="MAHMETZYANOV:OLAPCASHES" type="d-table"/> 
          <cubeTable name="MAHMETZYANOV:OLAPFACTS" type="f-table"/> 
          </cubeTables> 
          <joinConditions> 
          <joinCondition name="JOIN_OLAPFACTS_OLAPCASHES_1" cardinality="1:1" joinType="leftOuter"> 
          <partner1 table="MAHMETZYANOV:OLAPFACTS" column="SHOPNAME"/> 
          <partner2 table="MAHMETZYANOV:OLAPCASHES" column="SHOPINDEX"/> 
          </joinCondition> 
          <joinCondition name="JOIN_OLAPFACTS_OLAPCASHES_2" cardinality="1:1" joinType="leftOuter"> 
          <partner1 table="MAHMETZYANOV:OLAPFACTS" column="CASHNUMBER"/> 
          <partner2 table="MAHMETZYANOV:OLAPCASHES" column="ID"/> 
          </joinCondition> 
          </joinConditions> 
          <joinPaths> 
          <joinPath name="PATH_OLAPCASHES_1"> 
          <joins> 
          <join name="JOIN_OLAPFACTS_OLAPCASHES_1"/> 
          <join name="JOIN_OLAPFACTS_OLAPCASHES_2"/> 
          </joins> 
          </joinPath> 
          </joinPaths> 
          <dimensionAttributes> 
          <dimensionAttribute name="REGION"> 
          <columnMappings> 
          <columnMapping name="REGION" technicalName="REGION" type="key" table="MAHMETZYANOV:OLAPCASHES" column="REGION" joinPath="PATH_OLAPCASHES_1" isVisible="true"/> 
          </columnMappings> 
          </dimensionAttribute> 
          <dimensionAttribute name="CASHNAME"> 
          <columnMappings> 
          <columnMapping name="CASHNAME" technicalName="CASHNAME" type="key" table="MAHMETZYANOV:OLAPCASHES" column="CASHNAME" joinPath="PATH_OLAPCASHES_1" isVisible="true"/> 
          </columnMappings> 
          </dimensionAttribute> 
          </dimensionAttributes> 
          <measures> 
          <measure name="PAYMENT" table="MAHMETZYANOV:OLAPFACTS" column="PAYMENT" aggregationType="sum" isVisible="true"/> 
          </measures> 
          <constraints/> 
          </cube> 
          </cubeSchema> 
          '           
          • 

        • timestamp: 2014-02-19,14:05:54.182
          • 

        • CREATE OLAP SCENARIO statement executed, timestamp: 2014-02-19,14:26:12.897
          • 

        • Create Analytic View failed :   SQL: transaction rolled back by an internal error: column store error: <?xml version="1.0" encoding="utf-8"?> 
          <createCubeResult version="1.0"> 
          <status> 
          <message> 
          Error during executing SQL statement</message> 
          <errorCode> 
          2116</errorCode> 
          </status> 
          <details> 
          <errors> 
          <detail> 
          <element> 
          CREATE COLUMN VIEW "_SYS_BIC"."OK_OLAP/AN_TEST" WITH PARAMETERS (DESCRIPTION='', INDEXTYPE=5, JOININDEX = "MAHMETZYANOV"."OLAPCASHES", JOININDEXTYPE = 2, JOININDEX = "MAHMETZYANOV"."OLAPFACTS", JOININDEXTYPE = 1, JOINCONDITION = ('JOIN_OLAPFACTS_OLAPCASHES_1', "MAHMETZYANOV"."OLAPFACTS", "SHOPNAME", "MAHMETZYANOV"."OLAPCASHES", "SHOPINDEX", '', 49, 2), JOINCONDITION = ('JOIN_OLAPFACTS_OLAPCASHES_2', "MAHMETZYANOV"."OLAPFACTS", "CASHNUMBER", "MAHMETZYANOV"."OLAPCASHES", "ID", '', 49, 1), JOINPATH = ('PATH_OLAPCASHES_1', 'JOIN_OLAPFACTS_OLAPCASHES_1, JOIN_OLAPFACTS_OLAPCASHES_2'), VIEWATTRIBUTE = ('REGION', "MAHMETZYANOV"."OLAPCASHES", "REGION", 'PATH_OLAPCASHES_1', '', '', '', 'REGION'), VIEWATTRIBUTE = ('CASHNAME', "MAHMETZYANOV"."OLAPCASHES", "CASHNAME", 'PATH_OLAPCASHES_1', '', '', '', 'CASHNAME'), KEYFIGURE = ("PAYMENT", 1, FORMULA='', DESCRIPTION='', UNITCONVERSIONNAME='', EXPRESSION='', EXPRESSIONFLAGS=0, INDEXID="MAHMETZYANOV"."OLAPFACTS", ATTRIBUTE="PAYMENT"), CHARACTERISTIC=('REGION', KEYATTRIBUTE="REGION"), CHARACTERISTIC=('CASHNAME', KEYATTRIBUTE="CASHNAME"), 'REGISTERVIEWFORAPCHECK'='1', OPTIMIZEMETAMODEL=1)</element> 
          <code> 
          46</code> 
          <message> 
          transaction rolled back by an internal error: column store error: logical index creation error: [2999] general error (no further information available);object=_SYS_BIC:OK_OLAP/AN_TESTen</message> 
          </detail> 
          </errors> 
          </details> 
          </createCubeResult> 
          2014-02-19,14:26:12.898           
          • 

        • End deployment of analytic view, timestamp: 2014-02-19,14:26:12.898
          • 

        • Model deployment ended: OK_OLAP/AN_TEST timestamp: 2014-02-19,14:26:12.898
          •
HBD_Activation_MAHMETZYANOV_1392804357182.txt.zip
Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member185165
Active Participant
‎02-20-2014 2:21 PM
0 Kudos

Hi Marat,

Its not possible to have measure/key-figures from more than one fact table in analytical view. In such cases one need to go for calculation view. I presume that's the reason you are facing this issue.

Whatever you are trying should work in cal. view.

Regards,

Vijay


Show replies
Show replies
Former Member
‎02-20-2014 2:30 PM
0 Kudos

In join conditions of my Analytic view I have two fields. If I remove one them activation finished without errors and doesn't matter one or two tables measure/key-figures I use in my Analytic View.

former_member185165
Active Participant
‎02-20-2014 2:37 PM
0 Kudos

Former Member

former_member184768
Active Contributor
‎02-19-2014 12:38 PM
0 Kudos

Hi Marat,

Couple of points:

1) Can you please confirm that the SHOPINDEX in OLAPCASHES is same as SHOPNAME in the other table.

2) Can you please validate the view once and check what error message do you get.

I have the doubt on the relationship of the columns used in the join condition.

Regards

Ravi

Show replies
Show replies
Former Member
‎02-19-2014 2:11 PM
0 Kudos

1) This fields has absolutly same types.

2) I don't understand what you meen. If I press button "Save and Validate" I get error from my first post. If I press "Validate" from context menu of AV when I again get this error.

former_member184768
Active Contributor
‎02-19-2014 3:08 PM
0 Kudos

I was hoping for the error details something like this. You can get this from the Job log after you try to activate the object.

Regards,

Ravi

Former Member
‎02-20-2014 6:25 AM
0 Kudos

Hi, Ravi.

I have another error after activation attempt. I put error text in my first post. Also you can download attachment "HBD_Activation_MAHMETZYANOV_1392804357182.txt.zip" in first post. Just change extension txt with xhtml and open this file with your browser.

former_member184768
Active Contributor
‎02-20-2014 6:50 AM
0 Kudos

Hi Marat,

Can you please check and confirm if you have set the join cardinality as 1:1. Can you please try changing it 1:n and try activating the view.

Regards,

Ravi

Former Member
‎02-20-2014 7:21 AM
0 Kudos

I have yet try change cardinality and join types (left,right,inner,referential) and it doesn't help

former_member184768
Active Contributor
‎02-20-2014 8:44 AM
0 Kudos

Unfortunately the error specified in the job log doesn't provide any more information.

Ravi

Ask a Question