Odata service with error:Service exception: column store error

[former_member189009]

Dear friends,

      I create odata service in my XS project, it used to expose the data of attribute view, but it can show the data, it have the error like this:

      One more thing, my data contain some chinese string, I don't know whether this is the cause.

This is my odata service code:

service namespace "ODD_MAIN"

{"_SYS_BIC"."p1680829412trial.kevin.ODD_BET365/ODD_MAIN" as "ODD_MAIN" key generate local "GenID";}

the metadata:

[former_member189009 · Accepted solution]

Dear friends,

      I had solve the problem, it need to change the client and analytic privileges.

[former_member189009]

Dose any can help me with this ?

[thomas_jung]

I think the error message you are receiving is pretty explicit: User is not authorized.  This would mean the user running the service doesn't have the necessary role to access this view.  Setup the proper authorizations for this user and then this error will go away.

[former_member189009]

Hi Thomas,

     Thanks for your answer. But I already create one role file just like this :

   Then I use this statement to grant the role to the user:

call "HCP"."HCP_GRANT_ROLE_TO_USER"('p1680829412trial.kevin.ODD_BET365.roles::model_access365','P1680829412');

   But it still get the same error.

[thomas_jung]

Can you preview the view from the Studio/SQL Console with the same user?

[former_member189009]

Hi Thomas,

     Yes, I can use select statement in SQL console to preview data from my attribute view.