Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Sharepoint Workflow Status Page

Posted on 2010-11-29
12
Medium Priority
?
1,889 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

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

We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
A while back, I ran into a situation where I was trying to use the calculated columns feature in SharePoint 2013 to do some simple math using values in two lists. Between certain data types not being accessible, and also with trying to make a one to…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…

719 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