Dashboard prompt - report not generating

3427784

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

Gianni Ceresa

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.

3427784

Thanks Gianni, so here is the full error I am getting

Thank you.

Gianni Ceresa

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?

3427784

I'll have to check those out. I'll update if I find anything useful there. Thanks Gianni