Calculated view execution error

[mario_galeano]

When running a calculated view in Hana that runs a query, it shows the following error:

I am using the SYSTEM user

[pfefferf]

Please can you show the complete log (meaning the whole sentences instead of just the beginning).

But I guess it is related to the missing projection list in the used CE_PROJECTION calc. engine plan operator (which are deprecated by the way for several years now).

[mario_galeano]

Hi florian.pfeffer

This would be the complete log of the error:

Regarding the projection, which should be correct?

This would be the code used for the calculated view:

 BEGIN 
 
 	 varSTK = SELECT * FROM PRUEBA_JYB.V_STOCK_ECM;
 	 
 	 var_out = CE_PROJECTION(:varSTK); 


END

[pfefferf · Accepted solution]

Ok, you have an authorization error, as it is clearly mentioned in the error log. There are already tons of posts here in the community dealing with that "issue" (for instance https://answers.sap.com/questions/12668164/insufficient-privileges---not-authorized-deploy-ca.html).

[mario_galeano · Accepted solution]

Hi florian.pfeffer

I already assigned the permissions to the user _SYS_REPO via query and visually, however the error still persists

[mario_galeano · Accepted solution]

Hi florian.pfeffer

I already solved it, I needed to assign permissions of the SYS_REPO user to the schema to which I was making the query