Error at Creating Attribute View

[Former Member]

I got an error on HANA. When I create an Attribute View and try to activate it gives me this error:

MDXRuntime: Internal deployment of object failed: Internal Error:Deploy Attribute View: SQL: insufficient privilege: Not authorizednCreate view DDL statement: CREATE COLUMN VIEW "_SYS_BIC"."systempack/TEST1" TYPE JOIN WITH PARAMETERS ( joinIndex = "SYSTEM"."EPM_PRODUCTS", joinIndexType = 0, joinIndex = "SYSTEM"."EPM_EMPLOYEES", joinIndexType = 0, joinIndex = "SYSTEM"."EPM_AD", joinIndexType = 0, joinCondition = ('JOIN_EPM_PRODUCTS_EPM_EMPLOYEES_1', "SYSTEM"."EPM_PRODUCTS", "CREATED_BY", "SYSTEM"."EPM_EMPLOYEES", "NODE_KEY", '', 0, 0), joinCondition = ('JOIN_EPM_EMPLOYEES_EPM_AD_2', "SYSTEM"."EPM_EMPLOYEES", "PR_ADDRESS_GUID", "SYSTEM"."EPM_AD", "NODE_KEY", '', 0, 0), joinPath = ('PATH', 'JOIN_EPM_PRODUCTS_EPM_EMPLOYEES_1, JOIN_EPM_EMPLOYEES_EPM_AD_2'), viewAttribute = ('PRODUCT_ID', "SYSTEM"."EPM_PRODUCTS", "PRODUCT_ID", 'PATH', 'default', 'attribute', '', 'systempack/TEST1$PRODUCT_ID'), viewAttribute = ('CATEGORY', "SYSTEM"."EPM_PRODUCTS", "CATEGORY", 'PATH', 'default', 'attribute', '', 'systempack/TEST1$CATEGORY'), viewAttribute = ('FIRST_NAME', "SYSTEM"."EPM_EMPLOYEES", "FIRST_NAME", 'PATH', 'default', 'attribute', '', 'systempack/TEST1$FIRST_NAME'), viewAttribute = ('LAST_NAME', "SYSTEM"."EPM_EMPLOYEES", "LAST_NAME", 'PATH', 'default', 'attribute', '', 'systempack/TEST1$LAST_NAME'), viewAttribute = ('CITY', "SYSTEM"."EPM_AD", "CITY", 'PATH', 'default', 'attribute', '', 'systempack/TEST1$CITY'), viewAttribute = ('WIDTH', "SYSTEM"."EPM_PRODUCTS", "WIDTH", 'PATH', 'default', 'attribute', '', 'systempack/TEST1$WIDTH'), viewAttribute = ('HEIGHT', "SYSTEM"."EPM_PRODUCTS", "HEIGHT", 'PATH', 'default', 'attribute', '', 'systempack/TEST1$HEIGHT'), viewAttribute = ('DEPTH', "SYSTEM"."EPM_PRODUCTS", "DEPTH", 'PATH', 'default', 'attribute', '', 'systempack/TEST1$DEPTH'), viewAttribute = ('product_volume',,, '', '', '', 'fixed("WIDTH" *"HEIGHT" *"DEPTH", 5, 0)'), view = ('V_EPM_PRODUCTS', "SYSTEM"."EPM_PRODUCTS", 'PATH'), defaultView = 'V_EPM_PRODUCTS', 'REGISTERVIEWFORAPCHECK' = '1' )nVersion: 45n

But I take sql from error and execute it, I dont get error.

CREATE COLUMN VIEW "_SYS_BIC"."systempack/TEST1" TYPE JOIN WITH PARAMETERS ( joinIndex = "SYSTEM"."EPM_PRODUCTS", joinIndexType = 0, joinIndex = "SYSTEM"."EPM_EMPLOYEES", joinIndexType = 0, joinIndex = "SYSTEM"."EPM_AD", joinIndexType = 0, joinCondition = ('JOIN_EPM_PRODUCTS_EPM_EMPLOYEES_1', "SYSTEM"."EPM_PRODUCTS", "CREATED_BY", "SYSTEM"."EPM_EMPLOYEES", "NODE_KEY", '', 0, 0), joinCondition = ('JOIN_EPM_EMPLOYEES_EPM_AD_2', "SYSTEM"."EPM_EMPLOYEES", "PR_ADDRESS_GUID", "SYSTEM"."EPM_AD", "NODE_KEY", '', 0, 0), joinPath = ('PATH', 'JOIN_EPM_PRODUCTS_EPM_EMPLOYEES_1, JOIN_EPM_EMPLOYEES_EPM_AD_2'), viewAttribute = ('PRODUCT_ID', "SYSTEM"."EPM_PRODUCTS", "PRODUCT_ID", 'PATH', 'default', 'attribute', '', 'systempack/TEST1$PRODUCT_ID'), viewAttribute = ('CATEGORY', "SYSTEM"."EPM_PRODUCTS", "CATEGORY", 'PATH', 'default', 'attribute', '', 'systempack/TEST1$CATEGORY'), viewAttribute = ('FIRST_NAME', "SYSTEM"."EPM_EMPLOYEES", "FIRST_NAME", 'PATH', 'default', 'attribute', '', 'systempack/TEST1$FIRST_NAME'), viewAttribute = ('LAST_NAME', "SYSTEM"."EPM_EMPLOYEES", "LAST_NAME", 'PATH', 'default', 'attribute', '', 'systempack/TEST1$LAST_NAME'), viewAttribute = ('CITY', "SYSTEM"."EPM_AD", "CITY", 'PATH', 'default', 'attribute', '', 'systempack/TEST1$CITY'), viewAttribute = ('WIDTH', "SYSTEM"."EPM_PRODUCTS", "WIDTH", 'PATH', 'default', 'attribute', '', 'systempack/TEST1$WIDTH'), viewAttribute = ('HEIGHT', "SYSTEM"."EPM_PRODUCTS", "HEIGHT", 'PATH', 'default', 'attribute', '', 'systempack/TEST1$HEIGHT'), viewAttribute = ('DEPTH', "SYSTEM"."EPM_PRODUCTS", "DEPTH", 'PATH', 'default', 'attribute', '', 'systempack/TEST1$DEPTH'), viewAttribute = ('product_volume',,, '', '', '', 'fixed("WIDTH" *"HEIGHT" *"DEPTH", 5, 0)'), view = ('V_EPM_PRODUCTS', "SYSTEM"."EPM_PRODUCTS", 'PATH'), defaultView = 'V_EPM_PRODUCTS', 'REGISTERVIEWFORAPCHECK' = '1' )

Statement 'CREATE COLUMN VIEW "_SYS_BIC"."systempack/TEST1" TYPE JOIN WITH PARAMETERS ( joinIndex = ...' successfully executed in 269 ms 76 µs  - Rows Affected: 0

I dont understand why this happens. I can execute select queries but I cannot preview data after this. I am logging on HANA with "SYSTEM" user.

[Former Member · Accepted solution]

Hi Erhan,

Yeah the error is slightly misleading and there a few threads in this forum already discussing this issue.

Execute this:

grant select on schema <SCHEMA> to _SYS_REPO with grant option;

Thanks,

Anooj

[Former Member]

Hi,

I am trying to work on efashion tutorial on Hana. I have managed to import tables and create 3 Attribute view. Now all of a sudden I am getting an error while activating the attribute view as Activated with errors and it has a grey mark at the top of the view. When I check the error log I only get the below info which doesnt state anything about privilege issues. I have already granted grant access to _sys_repo as I have already created 3 attribute views successfully activated.

Please advise.

<?xml version="1.0" encoding="UTF-8" ?>

- <modelerjob id="DCJ_Activation_s0009721548_1355293281761">

- <jobinfo>

<Jobtype>Activation</Jobtype>

<startdate>Wed Dec 12 11:51:21 IST 2012</startdate>

<enddate>Wed Dec 12 11:51:22 IST 2012</enddate>

<elapsedtime>0.562 Seconds</elapsedtime>

<systemuri>newdb://DCJ:HANASRV-03:00:s0009721548</systemuri>

<result>ERROR</result>

</jobinfo>

- <executioninfo>

- <message>

<status>ERROR</status>

<info>Activation of objects</info>

- <message>

<status>ERROR</status>

<info>Summary of activation status</info>

- <message>

<status>ERROR</status>

<info>Activation of AT_CALENDAR_LOOKUP</info>

</message>

</message>

- <message>

<status>NONE</status>

<info>Detail activation status</info>

- <message>

<status>NONE</status>

<info>Activating all Attribute Views</info>

</message>

</message>

</message>

</executioninfo>

- <objectresults>

<object result="Completed" type="Activation" uri="newdb://DCJ:HANASRV-03:00:s0009721548/efashion/attributeviews/AT_CALENDAR_LOOKUP.attributeview" />

</objectresults>

</modelerjob>

[former_member182277]

Hello,

What version you are using for HANA Studio and HANA DB.

Sometime error encountered when both are not diffeent version.

Make them on the same level.

If above condition is fulfil, then please add the schema name under _sys_repo wit select and execute option and save it.

Now you can activate the view again and do the data preview.

Hope it helps.

Regards,neha

[Former Member]

Hello,

Update the version to 31.

Regards,

Nagaraj