BI Publisher couldn`t load the sample data

Dir_Pal

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

Carlos Carvalho

Hello,

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

Regards,

Carlos

Dir_Pal

but i am how can we set it in bi publisher

Dir_Pal

allow the particular person to view the data

timdexter

what is the session identifier for?

Tim

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

has run in toad generates data through session identifier

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

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

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

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