Solved

Sharepoint Workflow Status Page

Posted on 2010-11-29
12
1,843 Views
Last Modified: 2012-08-14
Hi,
I have an Infopath Form Library hosted on Sharepoint. This library has a workflow attached. It had been working fine up until a few days ago. Now when I click on the workflow status link under the Workflow column, the page hangs for 5-10 minutes and then times out. It then throws an 'Unknown Error'.

I have other form librarys on the Sharepoint site collection and I can access their workflow status page without a problem. So this problem is local to 1 site.

It is the same for ALL workflows within the problem site, irrelevant of what status they are at (In Progress, Completed, Cancelled etc.)

Any ideas? This is a work related issue and I need to sort it out asap so any advice would be greatly appreciated

Ben
0
Comment
Question by:Beircheart
  • 6
  • 6
12 Comments
 
LVL 7

Expert Comment

by:tstritof
ID: 34229127
Hi,

could you please post the error that is logged in your log files? Try looking for the file with your server name and today's date/time in C:\Program Files\ Common Files\Microsoft Shared\web server extensions\12\LOGS.

Also, is the workflow activated at site level or site collection level?

Regards,
Tomislav
0
 

Author Comment

by:Beircheart
ID: 34229372
Hi Tomislav,

Thank you for your reply.

I clicked the link at 11:32 and it eventually failed at 11:42

I've attached the log file

I think the webparts error is particularly relevant. Other pages in other sites within the same site collection were failing to load also. Removing certain web parts and adding them in again fixed those sites. Unfortuantely, I couldn't access the WrkStat.aspx page to try the same on the problem site...

Thanks again Tomislav
Log-File.txt
0
 
LVL 7

Expert Comment

by:tstritof
ID: 34229446
Hi,

you are having serious issues with your SQL transaction log.

Check if the solution described here can be applied in your situation - however be careful since your content database is about everything your MOSS is about (at least when users whose data is stored there are concerned).

Regards,
Tomislav
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 7

Expert Comment

by:tstritof
ID: 34229454
Also, the problem with transaction log might have been caused by some WP gone wild so monitor the sites and WP in question to see if this reoccurs at some point.

Regards,
Tomislav
0
 

Author Comment

by:Beircheart
ID: 34229467
I think you're on to something...
It's starting to make sense. I'll look in to it and get back to you later today

Good man Tomislav
0
 

Author Comment

by:Beircheart
ID: 34231180
Hi Tomislav,

RE: Transaction Log
I spoke to the Sharepoint admin and he fixed that particular problem. As you probably know, this was causing problems throughout Sharepoint.

However, my problem with the workflow status page remains. Can you tell me anything about the WebParts errors in the previously attached Log-File.txt?

Ben
0
 
LVL 7

Expert Comment

by:tstritof
ID: 34239408
Hi,

could you please retry the "error generation" and repost the log? Just to get a fresh picture.

Regards,
Tomislav
0
 

Author Comment

by:Beircheart
ID: 34240182
0
 
LVL 7

Expert Comment

by:tstritof
ID: 34240444
The only error logged here relates to the search web part (SearcBoxEx).

Do you have a search web part added to your site master (default.master)? Or application master directly (application.master)?

I've seen folks report problems with it (check this article) but not related to workflow.

Have you tried restarting the application pool for this site in IIS? Maybe it's down to some config change that hasn't propagated properly.
0
 

Accepted Solution

by:
Beircheart earned 0 total points
ID: 34393667
Hi,
My apologies for leaving this question for so long but in the meantime we have found the problem:

The Workflow History list was logging at an enormous rate (~40 entries per second). This equated to over 10 million entries over a weekend!! This list then affected the WrkStat.aspx page. As a temporary workaround, I went to the workflow settings and pointed the workflow to a new workflow history list. I say this is temporary because this list would then 'overflow' and the same problem would occur. The external contractor that developed the workflow simply forgot to turn this excessive logging off but they have now been contacted and have disabled the workflow.

Now though, we have another problem of trying to clear these lists (The largest is over 26 million). Anytime we tackle them the server crashes. Anyway, that's another issue

I consider this closed.

Tomislav, I appreciate your time and effort on this and even though I'd like to award points for effort, I'll have to mark this post as the solution for the sake of accuracy

All the best,
Ben
0
 
LVL 7

Expert Comment

by:tstritof
ID: 34394616
No problem. I hate looking up an answer on EE just to find out there was no actual answer :) So I agree this is the way to go. Glad you resolved the issue.

Regarding the logging, I've seen the "log flood" happen on SharePoint but not in a list though.

How are you performing the delete that crashes the server?

Regards,
Tomislav
0
 

Author Closing Comment

by:Beircheart
ID: 34424446
Reason in previous post
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question