An Exception Occured when refershing the query

[former_member208451]

Hello All,

Below exception occured for the following two scenarios.

• It occured when i tried to refresh the query.
• Other Case, exception occured when i enter the user prompts , it was about to refresh and got the same error messageNeed to know, when this type of error message occurs generally " An exception occured in one of the data source " and " Nested Exception".Need your inputs.

Thanks in advance.

John

.

[TammyPowlas]

Please provide more information

What version of Analysis Office are you using?

could you share screen shots of the query and the error message?

if you are using Analysis Office 1.4 SP5 did you apply hot patch?

not sure if we can help based on the limited information you have provided

[former_member208451]

We are using AO 1.4 SP5..

I have don't have the hotfix whether hotfix has been installed or not.

Regards,

John

[Former Member]

Hi John,

Could you post the inner exception. Could you also try turn on logging. Steps on how to do this can be found in the help "Support settings"

[former_member208451]

what is the log file extension would be ? Ex: .tmp, .cvr,.xls.

Please let me know.

[TammyPowlas]

Please check the steps in this thread and look for the files depending on the location stored: