I keep recieved the following erro when trying to use date/time field from my SP2010 library. The fields are populated from an inforpath form into SP.
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; WOW64; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C; .NET4.0E; InfoPath.3) Platform: Win32 User agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C; .NET4.0E; InfoPath.3) Invoker: Error message
SharePoint Version: 14.0.6106.5002
ErrorLog entries: Date: 12/17/2013 3:36:24 PM Title: Chart settings could not be saved. Please check your connection settings and try again. Chart Version: 1.1.7.0 Exception Method: GetColumnsToView Exception: String was not recognized as a valid DateTime.Couldn't store <> in GSC_x0020_SENT_x0020_DATE Column. Expected type is DateTime. Type: Error Stack Trace: at System.Data.DataColumn.set_Item(Int32 record, Object value) at System.Data.DataRow.set_Item(DataColumn column, Object value) at Collabion.Charts.Business.Helpers.DataTableHelper.GroupRows(IEnumerable`1 dataRows, GroupByOperation groupBy, ChartConfiguration chartConfiguration) at Collabion.Charts.Business.Helpers.DataTableHelper.ApplySplitBy(DataTable sourceTable, GroupByOperation groupBy, ChartConfiguration chartConfiguration) at Collabion.Charts.Business.Providers.ListDataProvider.<>c__DisplayClass18.<GetDataFromStorage>b__f() 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(ChartConfiguration ChartConfiguration) at Collabion.Charts.Business.Providers.ListDataProvider.GetColumnsToView(ChartConfiguration ChartConfiguration) at Collabion.Charts.Business.WebService.GetColumnsToView(String webPartId, String name) at Collabion.Charts.WebServicePage.OnInit(EventArgs e) Inner Stack Trace: at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles) at System.String.System.IConvertible.ToDateTime(IFormatProvider provider) at System.Data.Common.DateTimeStorage.Set(Int32 record, Object value) at System.Data.DataColumn.set_Item(Int32 record, Object value) Inner Exception: String was not recognized as a valid DateTime. Additional Information: Request: http://share.easynet.com/_layouts/CollabionCharts/WebService.aspx
It appears the as per my screenshot that the form is being identified as a date / time field. The created date (standard librayr field works but infopath fields do not), please can you help???
Date/Time fields from Sharepoint Library
in Collabion Charts for SharePoint
Posted · Edited by pmc1982 · Report reply
I keep recieved the following erro when trying to use date/time field from my SP2010 library. The fields are populated from an inforpath form into SP.
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; WOW64; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C; .NET4.0E; InfoPath.3)
Platform: Win32
User agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C; .NET4.0E; InfoPath.3)
Invoker: Error message
SharePoint Version: 14.0.6106.5002
ErrorLog entries:
Date: 12/17/2013 3:36:24 PM
Title: Chart settings could not be saved. Please check your connection settings and try again.
Chart Version: 1.1.7.0
Exception Method: GetColumnsToView
Exception: String was not recognized as a valid DateTime.Couldn't store <> in GSC_x0020_SENT_x0020_DATE Column. Expected type is DateTime.
Type: Error
Stack Trace: at System.Data.DataColumn.set_Item(Int32 record, Object value)
at System.Data.DataRow.set_Item(DataColumn column, Object value)
at Collabion.Charts.Business.Helpers.DataTableHelper.GroupRows(IEnumerable`1 dataRows, GroupByOperation groupBy, ChartConfiguration chartConfiguration)
at Collabion.Charts.Business.Helpers.DataTableHelper.ApplySplitBy(DataTable sourceTable, GroupByOperation groupBy, ChartConfiguration chartConfiguration)
at Collabion.Charts.Business.Providers.ListDataProvider.<>c__DisplayClass18.<GetDataFromStorage>b__f()
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(ChartConfiguration ChartConfiguration)
at Collabion.Charts.Business.Providers.ListDataProvider.GetColumnsToView(ChartConfiguration ChartConfiguration)
at Collabion.Charts.Business.WebService.GetColumnsToView(String webPartId, String name)
at Collabion.Charts.WebServicePage.OnInit(EventArgs e)
Inner Stack Trace: at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
at System.String.System.IConvertible.ToDateTime(IFormatProvider provider)
at System.Data.Common.DateTimeStorage.Set(Int32 record, Object value)
at System.Data.DataColumn.set_Item(Int32 record, Object value)
Inner Exception: String was not recognized as a valid DateTime.
Additional Information:
Request: http://share.easynet.com/_layouts/CollabionCharts/WebService.aspx
It appears the as per my screenshot that the form is being identified as a date / time field. The created date (standard librayr field works but infopath fields do not), please can you help???
Thanks
Peter