Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

The workflow history was >6m records, so I have redirected all workflows to rite to other custom history logs while running a job to purge 1k records every 15 minutes. When I attempt to check the history on new items, jam getting the same error for those workflows. These are SP Designer workflows that have worked for months. I attempted to validate views/delete a view against which I trigger alerts to myself for troubleshooting. But I cannot retrieve the list or views bc of these errors:

$mysiteurl= "//my-site.mydomain.com:port"
$spSite=get-spSite -identity $mysiteurl
$spWeb=$spSite.openweb()
$wflist=$spweb.getlist("/lists/workflow history")

Exception calling "GetList" with 1 Argument(s):"(nativehr)0x80070003(/nativehr)(native stack)(/native stack)"at line1char23 $wfList=$spWeb.GetLst(((( ("/Lists/workflow history") +category info:not specified(:)[],methodinvocationexception +FullyQualifiedErrorid:DotNetMethodException

Any assistance is greatly appreciated

share|improve this question
    
I have the feeling the deletion procedure actually deleted associated from workflows not completed yet, you should validate the procedure for deletion from history. –  C. Marius - MVP Apr 23 '13 at 20:08
    
I am using a 3rd party tool, Cleanup Workflow History. It is a command line tool that deletes the entries in the WF History that have not been modified for 120 days. I cannot navigate to the Workflow history list at all, as I get the error "Webpage cannot be found." The list is still there, as I can query the size of the list and the deletion job is running.I cannot view the workflow history from any of the custom workflow history lists. Is it better to leave the remaining 5.8M records in the Workflow history list and just utilize the new lists? –  Ryan OConnor Stewart Apr 24 '13 at 14:12
    
I'm not saying you should leave them, certainly has been over the limit long time now. What I'm saying is that still workflows not completed/stopped, had still association. –  C. Marius - MVP Apr 24 '13 at 14:51
    
I am completely open to any recommendation you may have, bu the cleanup job is specifically looking at Workflow History and I now am trying to view other workflow history items - that post to other workflow history lists and the result is the same. Do you know of a way I can validate/invalidate any association? –  Ryan OConnor Stewart Apr 24 '13 at 17:34
    
Examples of code enabling checking of association and status available here sharepointdevelopertopics.blogspot.ch/2011/07/… and sharepointdevelopertopics.blogspot.ch/2011/06/… –  C. Marius - MVP Apr 24 '13 at 20:52

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.