If you are unable to create a new account, please email support@bspsoftware.com

 

can't use generated SQL/MDX tool owning to 'prompt page' doesn't response

Started by Chopin, 13 Aug 2015 06:13:37 AM

Previous topic - Next topic

Chopin

Hi Cognos experts,

I met an issue. Please kindly share your expertise.
I can't use generated SQL/MDX tool owning to 'prompt page' doesn't response .
After I input the prompt value in the prompt page, then I click 'OK', but the page doesn't return to report studio, and I failed to get its SQL.
[/s]

----Modified Aug-14th----
As we know, there are 3 three steps to generate SQL:
(1)click tool -->'show generated SQL/MDX'
(2)if prompts needed, in the prompt page input prompt values.
(3)click 'OK' in the prompt page.  Then return to report studio page, we we see SQL for the report.

The problem is when there is no prompt needed to input, then "Show generated SQL/MDX" tool is workable.
But when there are prompts needed, in the 3rd step, after I click 'OK', the page doesn't return to report studio . I have to close the page, then it throws an error :
the server returned an unrecognizable validation response


I wonder if there are some configuration related to it that are not correct.


For details please find it from below :
step1:

step2:
But in this step, it won't response after click "OK". And have to close the window by click up-right 'close'  button


step3:



Many thanks!
Chopin   

bvk.cognoise

Hi Chopin,

Before generating your SQL or MDX have you tried to run the report? if yes are you getting report output with out any errors.

Because it looks like there could be some issue in report definition itself.


Regards
Bvk

Regards
BVK

Chopin

Hi Bvk,

These reports have normal outcome.
As we know, there are 3 three steps to generate SQL:
(1)click tool -->'show generated SQL/MDX'
(2)if prompts needed, in the prompt page input prompt values.
(3)click 'OK' in the prompt page.  Then return to report studio page, we we see SQL for the report.

The problem is when there is no prompt needed to input, then "Show generated SQL/MDX" tool is workable.
But when there are prompts needed, this tool become unworkable . In the "prompt page", after input prompt value, in the 3rd step, after I click 'OK', the page doesn't return to report studio . I have to close the page, then it throws an error :
the server returned an unrecognizable validation response

the details also seen from EverNote :
http://www.evernote.com/l/AhumUXSmDMdLxob422joHYi56Lpqp7nr0Mc/


I wonder if there are some configuration related to it that are not correct.

Thanks,
Chopin