Solved

TSQL Timeout Expired

Posted on 2013-01-22
7
939 Views
Last Modified: 2013-02-22
Windows 2008 R2 Standard 64bit
SQL Server 2008 64 bit
WSUS 3.1 Sp3

WSUS Database is on the SQL Server

Monthly I run this

c:\util\wsus_cleanup_cl server010 f 80 all

I get this report

1/15/2013 2:00:00 PM
=======================================

Running server cleanup now.  A cleanup report will be added once cleanup is done.

Cleanup Results:

5101361126byte(s) removed from the WSUS Content directory.
0 expired update(s) were declined in WSUS.
0 computer(s) were removed from WSUS.
587 obsolete update(s) were removed from WSUS.
0 superseded update(s) were declined in WSUS.
10741 Unneeded revision(s) were removed from WSUS.

Running the SQL maintenance script now...

Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

The job runs ok but the SQL part fails

The "ALL" option will run all of the cleanup job parameters which includes the SQL database maint routine

I attached the SQL TSQL code that comes with WSUS server.

I do not see anywhere how this points to the correct server .

Can someone help me out here?
DB-maint.sql
0
Comment
Question by:Thomas Grassi
[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
  • 4
  • 3
7 Comments
 
LVL 23

Expert Comment

by:Ayman Bakr
ID: 38808419
0
 
LVL 23

Author Comment

by:Thomas Grassi
ID: 38810590
Just reviewed the article

My question is where is this timeout value kept?

How can I view it and the change it?
0
 
LVL 23

Expert Comment

by:Ayman Bakr
ID: 38811172
I assume you have .Net framework installed and according to the thread you should search for the file XYZModel.Designer.vb, where XYZ should stand for your entity. Well, I am not sure whether the existence of this file depends on having EF or not.

Can you search for that file?
0
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 
LVL 23

Accepted Solution

by:
Ayman Bakr earned 500 total points
ID: 38811207
I have found another solution in a thread which more resembles your design, SQL with WSUS - check it out:

http://www.mombu.com/microsoft/windows-server-update-services/t-replica-servers-stopped-synchronizing-560790.html

Hope this helps!
0
 
LVL 23

Author Comment

by:Thomas Grassi
ID: 38811234
Ok will check this out later tonight
0
 
LVL 23

Author Comment

by:Thomas Grassi
ID: 38814256
I searched for XYZModel.Designer.vb, not found.

The www.mombu.com article is talking about replica servers not my case here.

My sql WSUS database is working ok

Just this maint script I have is not connecting to SQL

SQL and WSUS are on the same Windows 2008 server.
The registry entries for WSUS are pointing to the SQL server correctly.

this command c:\util\wsus_cleanup_cl server010 f 80 all

When you select all at the end it does all WSUS maintenance includig accessing the sql database.
0
 
LVL 23

Author Closing Comment

by:Thomas Grassi
ID: 38920252
I figured this out myself

I just changed c:\util\wsus_cleanup_cl server010 f 80 all

to c:\util\wsus_cleanup_cl server010 f 80 superseded expired obsolete compress computers files

This way it will not do the SQL process.

I use SQL maint plans to clean up the sql wsus database which works fine.

Thanks for helping
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

733 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