Hi Experts, I'm getting JDBC error while data previewing Analytic view which is created from any catalog except (_SYS_BIC).

[Former Member]

Hi Experts,

           I'm getting JDBC error while data previewing Analytic view which is created from any schema except (_SYS_BIC schema). I'm getting error like

""  Please any one tell me the solution for this problem.

Tanks,

Vishali Raghava Raju.

[Former Member · Accepted solution]

Hello Vishali,

Did you validate your view which you have created ? If so what is the result? Can you share the "Validation" log? (If you face any errors)

Regards,

Krishna Tangudu

[rajarshi_muhuri · Accepted solution]

_SYS_BIC alreadyhas the rights given by the sql command

GRANT SELECT ON SCHEMA _SYS_BIC TO _SYS_REPO WITH GRANT OPTION;

thus run the below statement in the sql editor

GRANT SELECT ON SCHEMA <your schema> TO _SYS_REPO WITH GRANT OPTION;

you wont get the preview error in the analytical view

[Former Member · Accepted solution]

Hi,

  Thank you very much.

Thanks,

Vishali raghava Raju

[former_member182277]

Hello Vishali,

Please add your schema in the _SYS_REPO and select the execute and select as yes option and save it.

Then activate the view again and preview the data. you will able to see the same.

Regards,

Neha

[Former Member]

Hi Neha,

         What i am asking is I'm getting JDBC ERROR like. while previewing View's which are created from any schema except "_SYS_REPO" schema. I don't have problem with "_SYS_REPO".

Thanks,

Vishali Raghava Raju

[former_member182277]

Thats what i am saying vishali, when you are creating schema and table under the particular schema and want to use the table of the same schema in the modelling you need to add the schema in the _SYS_REPO.

Once add and then reactivate your model and go for data preview.

Regards,

Neha