Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

SPPS 2003 Problem

  Asked By: Karissa    Date: Mar 27    Category: Sharepoint    Views: 738

We have a Work Order List that is based on an Issue List. It gets
populated by an Event Handler when an InfoPath form is posted to a
form library. Everything has been working fin except that now there
are 3700+ Work Orders i the list that consists of over 13000 items.

We have exported older items to quarterly spreadsheets and stored them
in a Arhchive library. Now the challenge is to delete the 'archived'
items. I followed the example from the SDK for deleting a list item. I
can get the appropriate items from the list but when I try
listitems.delete(k), I get a security error. I even use impersonation
with adminstator credentials but no luck. I found

http://support.microsoft.com/kb/828811 but the portal is an internal
one and the suggested causes don't apply:

This problem occurs if both of the following conditions are true:
•The Windows SharePoint Services Web site is configured to use
Anonymous Access in addition to another method of authentication, such
as Basic Authentication.
•You connect to the site and check out a document in a document
library before you authenticate to the site.




5 Answers Found

Answer #1    Answered By: Alexandra Lewis     Answered On: Mar 27

The export will write all list items in the current view to the
spreadsheet. Once exported, Excel 2003 can sync both ways. This ability
was lost in the RTM version of Excel 2007 but I understand that there is
some kind of update that will restore this functionality.

So, create a list view that has what you want to see in the spreadsheet
and then export it. From that point on, periodically synchronizing the
spreadsheet with the list should do the trick.

Answer #2    Answered By: Himanta Barthakur     Answered On: Mar 27

I did that initially to pair down the list. We have over 3000 Issues and I
manually created Excel spreadsheets for specific dates and then unlinked them.
Then I wrote an applcation to delete the list items. That took care of the
immediate problem  but the list will grow again and I am looking to automate the
whole process:

Conceptual flow:

1. create spreadsheet for selected items on the server hard drive temporarily.
2. upload upload spreadsheet to Document library on the site.
3. delete the selected items from the list.

Currently, I am reading the list items into a table based on date criteria and
then using the file system to write a .csv file. I was hoping there was
something in the SP Object Model that I could use to get a view of he llist and
then generate the spreadsheet.

Answer #3    Answered By: Mansi Revenkar     Answered On: Mar 27

All of a sudden our SPPS 2003 Portal stopped responding. first we saw
an error in the browser about cross domain problem  but could not find
anyting in the event logs. we reboot the server and the portal somes
back up but then after a few minutes it stops responding and there
are no error in the event log. The portal will show fine but after a
few minutes if we refresh the page we get prompted for credentials and
the portal stops responding.

We do see a lot of ESENT Event 101 svchost (960) The database engine
stopped. Information messages.

Answer #4    Answered By: Lizette Mcconnell     Answered On: Mar 27

Please try to reboot your index server. Are you using any third party tools
for indexing ??

Also check if there were any UMS errors in the database server.

Didn't find what you were looking for? Find more on SPPS 2003 Problem Or get search suggestion and latest updates.