Getting error "Failed to load(Odbc driver returned an error (SQLExecDirectW).)" when Limit By has "

Summary

Getting error "Failed to load(Odbc driver returned an error (SQLExecDirectW).)" when Limit By has "All Prompts" selected

Content

Hi ,

I am facing a issue. I have 3 prompts on my report:

1)Business Type -- column prompt

2)Hire Date -- variable prompt

3)Colleague Number -- column prompt

 'Colleague Number' prompt's  'Limit By' has "All Prompts" selected .

When we are running the OTBI analyses, it throws error.

"Failed to load(Odbc driver returned an error (SQLExecDirectW).)"  

I noticed that the 2nd parameter 'Hire Date' is variable prompt which is causing issue.

Instead of selecting 'All Prompts' for Colleague Number, if I select only 1st prompt (Business Type) from LOV and then run the analysis , the Colleague Number LOV gives proper results in runtime.