We had a problem with this also but it was specific to universes with
aliases on measure objects. We found that the combined query/join time
needed by the SQL executed by BusinessObjects was exceeding the time limit
we had set in the universe properties. If you are using aliases, I would
suggest doing some experimentation with the row/time restrictions. We also
have found that some of our users can get very enthusiastic when creating
BusinessObjects reports and load the report up with many measures (which are
aliases in the universe). For universes with large volumes of data behind
them, these type of “overloaded” reports will ALWAYS return partial results.
Best regards,
Crystal Golding
Senior Systems Analyst
University of Queensland
Brisbane Australia 4072
E-mail: c.golding@mailbox.uq.edu.au
Web: www.mis.jdstory.uq.edu.au
I have a user who created a nested query with the exact objects and conditions being
used with the exception of a different ‘org’ being selected in each. 7 of the 8 queries run
fine with the eigth returning the “partial results message” although there are actually no
results. I researched this both on the BO Knowledge Base and in the Listserv archives
trying every possible recomendation. I have increased row limit to 2.5 million and execution
time to 4 hours. The query returns at a time far less than the max and with 0 rows.
Any Suggestions?
Thanks,
Jeff
***************************************************************************** CONFIDENTIALITY NOTICE: This e-mail transmission, and any attachments, is intended only for the use of the individual or entity named above and may contain information that is confidential, privileged and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of any of the information contained in this transmission is strictly PROHIBITED.
If you have received this transmission in error, please immediately notify us at postmaster@kci1.com
I researched this both on the BO Knowledge Base and in the Listserv archives trying every possible recomendation. I have increased row limit to 2.5 million and execution time to 4 hours. The query returns at a time far less than the max and with 0 rows.
Any Suggestions?
When we had this problem the only way I managed to get around it was to remove the row limit and execution time limitations altogether. Have you tried that? It’s not ideal but it worked for us.
I’m posting this online so perhaps others can benefit also. I removed both time and row limitations and the query ran successfully. It took 90’ and only returned 4500 row but I am well aware that it must go through a monster view to get there. It’s not an ideal solution but fortunately it’s a once a month issue for us. Thanks again.
Jeff
I researched this both on the BO Knowledge Base and in the Listserv archives trying every possible recomendation. I have increased row limit to 2.5 million and execution time to 4 hours. The query returns at a time far less than the max and with 0 rows.
Any Suggestions?
When we had this problem the only way I managed to get around it was to remove the row limit and execution time limitations altogether. Have you tried that? It’s not ideal but it worked for us.
***************************************************************************** CONFIDENTIALITY NOTICE: This e-mail transmission, and any attachments, is intended only for the use of the individual or entity named above and may contain information that is confidential, privileged and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of any of the information contained in this transmission is strictly PROHIBITED.
If you have received this transmission in error, please immediately notify us at postmaster@kci1.com
Why would I get the ‘Partial Results’ message for a query? I haven’t set anything special for this report. And it isn’t running longer than the max set in the universe. It seems like it’s some sort of error message. What does it mean?
Check your Maximum Rows Retrieved setting in the universe. If your query returns 10,000 rows and this setting is 5,000 rows, I believe you will get this error message.
Q: Why would I get the ‘Partial Results’ message for a query? I haven’t set anything special for this report.
A: There is not anything set for reports, but you should uncheck Query Limits under Universe Parameters/Controls, particularly the - Limit Execution time to - parameter which will cause confusion when running multi queries reports.
In addition to the universe limits mentioned in the other replies, you also get this message when somebody sets row limits in the options dialog box in the query panel for one of the report’s queries. (Sometimes people set this for testing queries and forget about it later.) Click the “Options…” button in the query panel of each query to check.
Why would I get the ‘Partial Results’ message for a query? I haven’t set anything special for this report.
And it isn’t running longer than the max set in the universe.
It seems like it’s some sort of error message. What does it mean?
__________________________________________________ Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/
In a message dated 01-08-23 11:44:14 EDT, you write:
this is configurable in both designer and supervisor in roughly the same
spot.
also i think that the supervisor setting takes precedence over the universe setting as defined in designer but i am not positive. (anyone else?)
Yes, the Supervisor setting overrides the base parameter set by the Designer.
The advantage is you can have the universe designer set a limit of say 10,000 rows, but have a special group of users called “Power Users” set up in the repository. The supervisor can change the row limit to 50,000 rows for these users.
In a message dated 01-08-23 12:35:38 EDT, you write:
Supervisor does override Designer and I believe that if there is a
Only if the default setting has been changed. Anything that is still the default is normal black font. The red is a signal to the person reviewing the screen that some change has been made; you just can’t tell whether the number is higher or lower.
I am getting ‘Partial Results’ when i try to create a doc in Webi.The report works fine in full client.
What do i need to check?
Thanks in advance
__________________________________________________ Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com
