Oracle Analytics Cloud and Server

BI Publisher couldn`t load the sample data

Received Response
81
Views
10
Comments

Summary

BI Publisher couldn`t load the sample data

Content

I was trying a simple query from a view table where only some admin get access to view data and in this case i can add the data model with selecting 2 columns from it but issue is it doesnt show me a empty data it gives me an error

Failed to load data but when i get into the engine log it shows me error as java.sql.SQLSyntaxErrorException: ORA-01722: invalid number. please do help thank you

Answers

  • Carlos Carvalho
    Carlos Carvalho ✭✭✭✭✭

    Hello,

    Have you tried to run the query(s) in the sql developer/plus?

    Regards,

    Carlos

  • Dir_Pal
    Dir_Pal ✭✭✭✭✭

    but i am how can we set it in bi publisher

  • Dir_Pal
    Dir_Pal ✭✭✭✭✭

    allow the particular person to view the data

  • timdexter
    timdexter ✭✭✭✭✭

    what is the session identifier for?

    Tim

  • Dir_Pal
    Dir_Pal ✭✭✭✭✭

    I am not sure which way i can access in BI publisher when view the data shows the error as ORA-01722: invalid number. please do help thank you

  • Dir_Pal
    Dir_Pal ✭✭✭✭✭

    has run in toad generates data through session identifier

  • Dir_Pal
    Dir_Pal ✭✭✭✭✭

    oracle 12.2.2 version of BIP i am using

    it has parameters and I am using a view table from one of schema

    well in Toad it shows data if i pass the session.identifier if not it doesnt shows any data

    each query and subquery has been processed step by step and no error and data shows in toad by setting an identifier

    I am not using any plsql trigger code in it.

    please do the needful

  • timdexter
    timdexter ✭✭✭✭✭

    Hi

    The error is coming from the DB not from BIP. Its tough to help without more information

    1. What version and flavor of BIP are you using?

    2. Whats the SQL you are using? Does it have parameters?

    3. Are you using any plsql trigger code?

    Tim

  • Dir_Pal
    Dir_Pal ✭✭✭✭✭

    had done the trigger and function couldnt make it through as it made me hard choice but this is also one of the way can make it but long process . in changing weblogic allowing the user ID made things easy.

    well fetch the data of the user and logged in the name of user who is having the access. so now the table works perfectly fine no issues with the output .

    Thank you tim ur so helpful

  • timdexter
    timdexter ✭✭✭✭✭

    So, we have been conversing on another thread. What is the command you are using in the

    1. Pre fetch data trigger - https://docs.oracle.com/middleware/12213/bip/BIPDM/GUID-757ABC83-8CBC-4660-84CE-B8C1D48F7498.htm#BIPDM-GUID-BBCC37B1-40C…

    2. Pre Process Function - https://docs.oracle.com/middleware/12213/bip/BIPAD/GUID-D10CB848-B225-48FE-9169-D47D6B28FF58.htm#BIPAD287

    You did not say which one you were using?

    Tim