Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Evaluate OPR4ONWY:OI2DL65P error
Hello,
I'm trying execute a sql server function from obiee 12c, and i get this error.
Does some one knows why?
Error Codes: OPR4ONWY:OI2DL65P
SQL Issued: EVALUATE('dbo.fnc_prueba_evaluate(%1,%2)' AS int, 'A' , 'B')
Thanks a lot!!!
Answers
-
That error code isn't the real error. Check the logs and post the real error
0 -
Christian thanks for your answer.
I saw the obis1-query.log and appears this:
b37bbde5
EVALUATE('dbo.fnc_prueba_evaluate(%1,%2)' AS int, 'A' , 'X')
/* QUERY_SRC_CD='rawSQL' */
In obis1-diagnostics.log no shows anything, what it means there is no a sintax error.
Does exist another log where i can see?
Tnaks for your help.
0 -
1037520 wrote:Hello,I'm trying execute a sql server function from obiee 12c, and i get this error.
How does your "try" looks like?
How does the analysis looks like? What's the formula you used?
More details you provide, more chances to get a proper answer focusing on that exact case...
0 -
Ok Gianni.... inicially i'm testing from Administration-> Issue SQL.
If it works what i need doing is execute a procedure or function database (sql server) from a dashboard and send it some user parameters, the procedure must making a process according that parameters and insert data to a table , then i must show the result (table) in my dashboard.
I'm testing first if the call evaluate works with sql server database, with oracle had worked.
Thank you.
0 -
1037520 wrote:I'm testing first if the call evaluate works with sql server database, with oracle had worked.
You can't just take code from one technology and paste it to a different technology. that's not how IT works.
And if your log doesn't contain much then your log level may be too low. Push it to 5.
0 -
Christian, the function database is correct over sql server, it doesn't have errors.
What you want to say is I can´t call with "Evaluate" a microsoft sql server function database?? Evaluate Just works whit oracle databases??
I have the RPD connect to sql server database and all my analysis and dashboards works ok.
The log level was equal to 5 when i tested.
Tnks.
0 -
No it works for all since what it does is pass the call uninterpreted to the underlying data source.
0 -
ok thanks, but then why it shows that error??
I chage to 7 the log level and the logs show the same, no detail about the error.
0 -
It's weird that you don't get "Unable to evaluate text 1.0 as either true or false" as an error. It's the most common 12c evaluate issue referenced by bug 25469348
0 -
Christian,
Where did you find the text error?? It has sense. My function returns an integer as 1 or 0.
Does 'evaluate' need that i return a boolean??
0
