Solved

Sharepoint Workflow Status Page

Posted on 2010-11-29
12
1,822 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
 
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
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: 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

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.

Question has a verified solution.

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

Work Over Net is a new and very powerful collaboration product. With its new easy interface it is becoming very competitive to other similar products like webex and office interactive. WON 2010 have the standard business tools needed for multi-offic…
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…
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

920 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now