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

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Report Performance poor_Error in validation

Started by chr.93, 03 Mar 2020 09:15:06 AM

Previous topic - Next topic

chr.93

Hello everyone ;D

I have a report that runs, but has very poor performance. When I validate the report i get the following error:

RSV-VAL-0010 Failed to load the report specification. XQE-GEN-0018 Query Service internal error has occurred, please see the log for details.


Do you have any idea how can i resolve this and improve the performance?




chr.93

Quote from: BigChris on 03 Mar 2020 09:49:56 AM
Does this give you anything useful:
http://www-01.ibm.com/support/docview.wss?uid=swg1PM90632

or this:
https://www.ibm.com/support/pages/xqe-gen-0018-when-user-creates-datasource-query-subjects-framework-manager

I saw in the logs that it has something to do with the master link relationships. I changed i little the format of the report and improved a little the performance. I don't get that error anymore, however in some cases it is still slow  :-\
However thank you for the suggestions!

Andrei I

Quote from: chr.93 on 04 Mar 2020 05:19:42 AM
I saw in the logs that it has something to do with the master link relationships. I changed i little the format of the report and improved a little the performance. I don't get that error anymore, however in some cases it is still slow  :-\
However thank you for the suggestions!
Did you check using a DB client that SQL queries generated by Cognos are actually slow?