F
friskyweasel
hello all -
Any help at all would be greatly appreciated on this one. We have
an .aspx page which utilized office web component pivot tables. The
query is run/executed server side, and an XML data stream is then
(somehow) passed to the pivot table on the front end.
The problem is, when we run a query which returns up to 5,000 records
or so, everything behaves as expected. But, once you go up above that
amount (one of the problem queries returns about 12,000 records), the
following behavior occurs. The query completes, and the pivot table
component appears on the screen unpopulated. I click on the "field
list" icon in the pivot table web component. From the resulting field
list popup box, I drag a field over to the "Drop Totals or Detail
Fields Here" area - the result is the following error:
"The query could not be processed:
System error: MaxElementDepth"
If, instead, I drop the field from the field list onto the "Drop
Column Fields Here" area, I get the following error:
"The query could not be processed:
Error while processing a partition: 'RECORD=4981'"
I'm not sure at all how to go about troubleshooting this issue, and
it's becoming a problem for our user base. It certainly seems to be
linked to the # of records returned. When changing my query filter
criteria to return 1 to 5,000 records or so, the exact same actions
(see above) do not cause any errors whatsoever. It performs exactly as
desired.
Can anyone please point me in the right direction for resolving this
issue? We inherited support for this web site, and have no experience
whatsoever with Office Web Components.
Any help at all would be greatly appreciated on this one. We have
an .aspx page which utilized office web component pivot tables. The
query is run/executed server side, and an XML data stream is then
(somehow) passed to the pivot table on the front end.
The problem is, when we run a query which returns up to 5,000 records
or so, everything behaves as expected. But, once you go up above that
amount (one of the problem queries returns about 12,000 records), the
following behavior occurs. The query completes, and the pivot table
component appears on the screen unpopulated. I click on the "field
list" icon in the pivot table web component. From the resulting field
list popup box, I drag a field over to the "Drop Totals or Detail
Fields Here" area - the result is the following error:
"The query could not be processed:
System error: MaxElementDepth"
If, instead, I drop the field from the field list onto the "Drop
Column Fields Here" area, I get the following error:
"The query could not be processed:
Error while processing a partition: 'RECORD=4981'"
I'm not sure at all how to go about troubleshooting this issue, and
it's becoming a problem for our user base. It certainly seems to be
linked to the # of records returned. When changing my query filter
criteria to return 1 to 5,000 records or so, the exact same actions
(see above) do not cause any errors whatsoever. It performs exactly as
desired.
Can anyone please point me in the right direction for resolving this
issue? We inherited support for this web site, and have no experience
whatsoever with Office Web Components.