Missing Data

[Peter W]

Hi

 

I have a sharepoint list with 211 items in it.

 

This data covers a single entry per day for the last 211 days, i want to connect up a single series bar chart and group the data by month and have a drill down to day.

 

Except it will do the grouping to month, but when I drill down to the day I get missing days, it renders find and I look in the debug information and it says an error but this error seems to be old and related to the preview.

 

Can you tell me how much is too much data, and what can I do to get this data added to the chart.

 

Thanks

 

Peter

 

Debug information

 

Debug Information:

Renderer: Flash

Flash Player installed: true

Browser Information:

App code name: Mozilla

App name: Microsoft Internet Explorer

Version: 4.0 (compatible; MSIE 8.0; Windows NT 6.1; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; CMNTDF; .NET4.0C; .NET4.0E; InfoPath.3)

Platform: Win32

User agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; CMNTDF; .NET4.0C; .NET4.0E; InfoPath.3)

Invoker: WebPart Menu

 

SharePoint Version: 14.0.4762.1000

 

ErrorLog entries:

Date: 03/07/2012 16:57:55

Title: too much data

Exception: too much data

Type: Error

Stack Trace: at Collabion.Charts.Business.ChartBuilder.GetData(IDataProvider provider, ChartConfiguration configuration, Boolean preview)

at Collabion.Charts.Business.ChartBuilder.GetXml(ChartConfiguration configuration, IDataProvider provider, Boolean preview)

at Collabion.Charts.Business.WebService.GetChartXmlPreview(String chartConfiguration)

at Collabion.Charts.WebServicePage.OnInit(EventArgs e)

Inner Stack Trace:

Inner Exception:

Additional Information:

Request: https://sharepoint.anonanonuk.com/_layouts/CollabionCharts/WebService.aspx

----------------------------------------------------------------------------------

Date: 03/07/2012 16:57:30

Title: too much data

Exception: too much data

Type: Error

Stack Trace: at Collabion.Charts.Business.ChartBuilder.GetData(IDataProvider provider, ChartConfiguration configuration, Boolean preview)

at Collabion.Charts.Business.ChartBuilder.GetXml(ChartConfiguration configuration, IDataProvider provider, Boolean preview)

at Collabion.Charts.Business.WebService.GetChartXmlPreview(String chartConfiguration)

at Collabion.Charts.WebServicePage.OnInit(EventArgs e)

Inner Stack Trace:

Inner Exception:

Additional Information:

Request: https://sharepoint.anonanonuk.com/_layouts/CollabionCharts/WebService.aspx

----------------------------------------------------------------------------------

Date: 03/07/2012 16:53:42

Title: too much data

Exception: too much data

Type: Error

Stack Trace: at Collabion.Charts.Business.ChartBuilder.GetData(IDataProvider provider, ChartConfiguration configuration, Boolean preview)

at Collabion.Charts.Business.ChartBuilder.GetXml(ChartConfiguration configuration, IDataProvider provider, Boolean preview)

at Collabion.Charts.Business.WebService.GetChartXmlPreview(String chartConfiguration)

at Collabion.Charts.WebServicePage.OnInit(EventArgs e)

Inner Stack Trace:

Inner Exception:

Additional Information:

Request: https://sharepoint.anonanonuk.com/_layouts/CollabionCharts/WebService.aspx

----------------------------------------------------------------------------------

Date: 03/07/2012 16:52:46

Title: Chart settings could not be retrieved. Please check your connection settings and try again.

Exception: The data provider could not be found. Please select another data provider or contact your administrator.

Type: Error

Stack Trace: at Collabion.Charts.Business.ProviderManager.GetProvider(String webPartId, String name)

at Collabion.Charts.Business.WebService.GetProviderConfiguration(String webPartId, String name)

at Collabion.Charts.WebServicePage.OnInit(EventArgs e)

Inner Stack Trace:

Inner Exception:

Additional Information:

Request: https://sharepoint.anonanonuk.com/_layouts/CollabionCharts/WebService.aspx

----------------------------------------------------------------------------------

Date: 03/07/2012 16:44:41

Title: Chart preview could not be generated. Please check your chart settings and try again.

Exception: Chart preview could not be generated. Please check your chart settings and try again.

Type: Error

Stack Trace: at Collabion.Charts.Business.Helpers.DataTableHelper.ApplyGroupBy(DataTable sourceTable, GroupByOperation groupBy)

at Collabion.Charts.Business.Providers.ListDataProvider.<>c__DisplayClassc.<GetDataFromStorage>b__9()

at Microsoft.SharePoint.SPSecurity.<>c__DisplayClass4.<RunWithElevatedPrivileges>b__2()

at Microsoft.SharePoint.Utilities.SecurityContext.RunAsProcess(CodeToRunElevated secureCode)

at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(WaitCallback secureCode, Object param)

at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(CodeToRunElevated secureCode)

at Collabion.Charts.Business.Providers.ListDataProvider.GetDataFromStorage()

at Collabion.Charts.Business.Providers.Base.DataProviderBase.GetData()

at Collabion.Charts.Business.ChartBuilder.GetData(IDataProvider provider, ChartConfiguration configuration, Boolean preview)

at Collabion.Charts.Business.ChartBuilder.GetXml(ChartConfiguration configuration, IDataProvider provider, Boolean preview)

at Collabion.Charts.Business.WebService.GetChartXmlPreview(String chartConfiguration)

at Collabion.Charts.WebServicePage.OnInit(EventArgs e)

Inner Stack Trace:

Inner Exception:

Additional Information:

Request: https://sharepoint.anonanonuk.com/_layouts/CollabionCharts/WebService.aspx

----------------------------------------------------------------------------------

 

Chart XML:<chart previewanimation="1" exportenabled="1" exportatclient="0" exportshowmenuitem="1" exporthandler="/_layouts/CollabionCharts/FCExporter.aspx" exportcallback="CC_onAfterExportObjectSaving" exportaction="download" showsecondarylimits="1" showdivlinesecondaryvalue="1" animation="1" caption="Test" yaxisname="Items" pyaxisname="Items"><set label='Jan'12' value="130670" link='newchart-xmlurl-https%3a%2f%2fsharepoint.anonanonuk.com%2fservices%2fdpcs%2f_layouts%2fCollabionCharts%2fWebService.aspx%3fmethod%3dGetDrillDownChartXml%26webPartId%3dg_4ee546dc_aa53_4096_b3aa_9c48e6ecc939%26label%3dDate%26value%3dJan%26apos%3b12%26series%3d0%26isGetDrillDownGrouping%3dFalse'/><set label='Feb'12' value="178021" link='newchart-xmlurl-https%3a%2f%2fsharepoint.anonanonuk.com%2fservices%2fdpcs%2f_layouts%2fCollabionCharts%2fWebService.aspx%3fmethod%3dGetDrillDownChartXml%26webPartId%3dg_4ee546dc_aa53_4096_b3aa_9c48e6ecc939%26label%3dDate%26value%3dFeb%26apos%3b12%26series%3d0%26isGetDrillDownGrouping%3dFalse'/><set label='Mar'12' value="180989" link='newchart-xmlurl-https%3a%2f%2fsharepoint.anonanonuk.com%2fservices%2fdpcs%2f_layouts%2fCollabionCharts%2fWebService.aspx%3fmethod%3dGetDrillDownChartXml%26webPartId%3dg_4ee546dc_aa53_4096_b3aa_9c48e6ecc939%26label%3dDate%26value%3dMar%26apos%3b12%26series%3d0%26isGetDrillDownGrouping%3dFalse'/><set label='Apr'12' value="219966" link='newchart-xmlurl-https%3a%2f%2fsharepoint.anonanonuk.com%2fservices%2fdpcs%2f_layouts%2fCollabionCharts%2fWebService.aspx%3fmethod%3dGetDrillDownChartXml%26webPartId%3dg_4ee546dc_aa53_4096_b3aa_9c48e6ecc939%26label%3dDate%26value%3dApr%26apos%3b12%26series%3d0%26isGetDrillDownGrouping%3dFalse'/><set label='May'12' value="213304" link='newchart-xmlurl-https%3a%2f%2fsharepoint.anonanonuk.com%2fservices%2fdpcs%2f_layouts%2fCollabionCharts%2fWebService.aspx%3fmethod%3dGetDrillDownChartXml%26webPartId%3dg_4ee546dc_aa53_4096_b3aa_9c48e6ecc939%26label%3dDate%26value%3dMay%26apos%3b12%26series%3d0%26isGetDrillDownGrouping%3dFalse'/><set label='Jun'12' value="200475" link='newchart-xmlurl-https%3a%2f%2fsharepoint.anonanonuk.com%2fservices%2fdpcs%2f_layouts%2fCollabionCharts%2fWebService.aspx%3fmethod%3dGetDrillDownChartXml%26webPartId%3dg_4ee546dc_aa53_4096_b3aa_9c48e6ecc939%26label%3dDate%26value%3dJun%26apos%3b12%26series%3d0%26isGetDrillDownGrouping%3dFalse'/><set label='Jul'12' value="6650" link='newchart-xmlurl-https%3a%2f%2fsharepoint.anonanonuk.com%2fservices%2fdpcs%2f_layouts%2fCollabionCharts%2fWebService.aspx%3fmethod%3dGetDrillDownChartXml%26webPartId%3dg_4ee546dc_aa53_4096_b3aa_9c48e6ecc939%26label%3dDate%26value%3dJul%26apos%3b12%26series%3d0%26isGetDrillDownGrouping%3dFalse'/></chart>

Operating System Details

OS Version: 6.1.7601.65536

OS Platform: Win32NT

OS ServicePack: Service Pack 1

OS Version String: Microsoft Windows NT 6.1.7601 Service Pack 1

 

 

 

 

[Swarnam]

Hey,

 

The chart preview mode will be able to display a maximum of 250 data points.

 

However, more number of data points chart preview mode will throw an exception whereas the chart will be rendered in the chart wizard.

 

Hope this helps.