Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Dashboard prompt - report not generating
Hello all, I have 3 analysis that I have set up so it goes against a dashboard prompt. A user is able to select one of the three reports on the dashboard prompt and then further filter by year and country. Problem - I have the other 2 reports set up so that it works properly but for some odd reason (not sure if it's a glitch) by third report is not generating properly (even though it was yesterday). Everything is set up correctly by setting up a presentation variable and mapping the dashboard prompt to the 3 analysis I'd like a user to filter. When I try to generate the report not working I get the error -> Odbc driver returned an error (SQLExecDirectW)
Just a bit confused because it was working perfectly fine and this report that is not working is set up exactly like the other 2 analysis which is working perfectly fine.
Any guidance is appreciated.
Thank you
Answers
-
Hi,
Start by opening the "Odbc driver returned and error" message and get the full message and post that one
Things working yesterday and not working today generally means something changed: you or somebody else maybe changed the analysis or something else in the system, yesterday you had a cache effect and didn't see if wasn't working at some point etc.
No need to lose time trying to figure out random reasons without the exact error message first.
0 -
Thanks Gianni, so here is the full error I am getting
Thank you.
0 -
Well ... that's no luck
"a general error" and nothing saying what kind of error it was !
Anything else useful if you look into the logs?
0 -
I'll have to check those out. I'll update if I find anything useful there. Thanks Gianni
0
