locked
The "DataFormWebPart" Web Part appears to be causing a problem. Server Out Of Memory RRS feed

  • Question

  • I have a dataview webpart, it has 1275 items in it.  but I do have one column which is required by the client and that is a History (Versioning) column. 

    This column holds the changes that have been made by various people so that they can track who changed what in a status column.  this info is captured via a workflow. So this column could become heavy with data, but currently there isnt alot of data in that column at all. and client doesnt think the status column will change often.

    the REAL issue is this:
    I can only show 500 rows before I get this error message:
    The "DataFormWebPart" Web Part appears to be causing a problem. Server Out Of Memory
    The
    re is no memory on the server to run your program.

    Pageing the dataview isn't an option I tried to explain the why and how it could be a good thing etc, but client wants all data on one page for the export to excel , which I solved with custom code. but I can only export the current 500 at a time.( if someone knows how to capture the paged data and get it all into one excel data dump that would be helpful and I actually could ignore the curent error message)

    I do NOT have access to the backend, I can only see the error messages, but I can contact the helpdesk  and they will work with me to solve the issue if I have the answers, (funny isnt it...)

    Thank you for your time


    Steve Athey

    Monday, March 18, 2013 2:16 PM

Answers

  • Hi cowboy2066,

    it is really tough when your access is limited to only Sharepoint Designer. 

    the memory out it may because of the data that is populated goes to the memory, and the memory is exhausted.

    perhaps you can try to create like a group items in data view: 

    http://office.microsoft.com/en-001/sharepoint-designer-help/sort-and-group-data-in-a-data-view-HA010103042.aspx#BM2 


    Regards,
    Aries
    Microsoft Online Community Support


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

    • Marked as answer by Emir Liu Wednesday, April 17, 2013 1:28 AM
    Tuesday, March 26, 2013 1:06 PM

All replies

  • Hi Steve,

    Could you please create a custom web part and display the data in a GridView? Then we can refer to the code in the following blog to export whole data from GridView to Excel even sorting and paging are enabled.
    http://mattberseth.com/blog/2007/04/export_gridview_to_excel_1.html

    Thanks & Regards,
    Emir Liu
    TechNet Subscriber Support in forum
    If you have any feedback on our support, please click here.


    Emir Liu
    TechNet Community Support

    Tuesday, March 19, 2013 9:28 AM
  • Emir

    Gridviews, I believe require the use of SQL Connection and Visual Studio to create a webpart.
    In the current environment, I don't have access to the SQL database and using Visual Studio is not allowed.

    I can use SharePoint Designer 2007, as we have not migrated to SPS2010 yet.   My data source is a List.  So If there is a way to use SPD 2007 and the list as a datasource please let me know, as everything I have seen and heard about Gridviews is that I need to use SQL and Visual Studio.


    Steve Athey

    Tuesday, March 19, 2013 1:14 PM
  • Hi Steve,

    We can also use SharePoint list as the data source for gridview control. See the following blogs.
    http://www.etechplanet.com/codesnippets/read-sharepoint-list-data-and-display-in-a-gridview-control.aspx
    http://msdn.microsoft.com/en-us/library/ms457534(v=office.12).aspx

    Thanks & Regards,
    Emir


    Emir Liu
    TechNet Community Support

    Wednesday, March 20, 2013 10:03 AM
  • I don't have access to Visual Studio and or a way to  upload  custom web parts, client restricts this.  and I'm ONLY allowed to use  SharePoint Designer.

    Steve Athey

    Wednesday, March 20, 2013 2:15 PM
  • Hi cowboy2066,

    it is really tough when your access is limited to only Sharepoint Designer. 

    the memory out it may because of the data that is populated goes to the memory, and the memory is exhausted.

    perhaps you can try to create like a group items in data view: 

    http://office.microsoft.com/en-001/sharepoint-designer-help/sort-and-group-data-in-a-data-view-HA010103042.aspx#BM2 


    Regards,
    Aries
    Microsoft Online Community Support


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

    • Marked as answer by Emir Liu Wednesday, April 17, 2013 1:28 AM
    Tuesday, March 26, 2013 1:06 PM