BI Publisher couldn`t load the sample data
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
-
Hello,
Have you tried to run the query(s) in the sql developer/plus?
Regards,
Carlos
0 -
but i am how can we set it in bi publisher
0 -
allow the particular person to view the data
0 -
what is the session identifier for?
Tim
0 -
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
0 -
has run in toad generates data through session identifier
0 -
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
0 -
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
0 -
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
0 -
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
0