Send As SMS

Tuesday, November 16, 2004

IIS Logfile issue with small SPS2003 Server Farm

I have installed the following configuration for a customer of ours.

Server-name: XXX1
Operating System: Windows 2003 Server (including relevant updates)
Server applications: Microsoft Office SharePoint Portal Server 2003
Network: Attached to Windows 2000 Active Directory

Server-name: XXX2
Operating System: Windows 2003 Server (including relevant updates)
Server applications: Microsoft SQL Server 2000 with SP3a
Network: Attached to Windows 2000 Active Directory

SharePoint 2003 was installed in a small server farm environment, with XXX1 hosting SharePoint and using XXX2 as its SQL repository.
I migrated 130,000 documents from a SharePoint Portal Server 2001 based workspace to the new SharePoint 2003 implementation (on servers above) using the Microsoft migration tools called SPIN and SPOUT.


Now on to the Technical Issue itself.

Initially the customer reported an issue with the Management of Audiences. They tried to create an audience of specific NT users (the SharePoint 2003 installation was already connected to AD and have relevant profiles and users imported) and then tried to compile those audiences. Then the “Manage Audiences” page displayed a message saying:
“An error has occurred while accessing SQL database or system resources. If this is the first time you have seen this message, please try again later. If this problem persists, please contact your administrator.”
We then analysed the Diagnostic Logfiles within the SharePoint Central Administration, and found the following 2 error messages:
“Error retrieving audience schedule!
InnerException Message: Logon Failure: the user has not been granted the requested logon type at this computer”
And
“Could not find stored procedure: dbo.Orgle_job_UpdateLastTouch”

Then our customer reported that their system partition had been max’d out due to the IIS logfiles for the W3SVC1 (i.e. Default WebSite – where SPS is installed) growing to nearly 22GB’s.
This file was obviously too big to open, and so we moved it and let IIS create a new one. We let IIS run for a few minutes, and then stopped IIS and opened the logfile. It had already reached 1MB in size and there was a reoccurrence of the following POST’s and GET’s about 20 times a second.
Here is 4 seconds of IIS logfile entries (please find the complete logfile attached, along with the Application, System and Security event logs):

2004-11-16 13:03:57 POST /_vti_bin/sitedata.asmx - 80 200 0 0
2004-11-16 13:03:57 GET /_vti_bin/owssvr.dll - 80 - 401 2 2148074254
2004-11-16 13:03:57 GET /_vti_bin/owssvr.dll - 80 - 401 2 2148074254
2004-11-16 13:03:57 GET /_vti_bin/owssvr.dll - 80 - 401 2 2148074254
2004-11-16 13:03:57 GET /_vti_bin/owssvr.dll - 80 - 401 2 2148074254
2004-11-16 13:03:57 GET /_vti_bin/owssvr.dll - 80 - 401 1 0
2004-11-16 13:03:57 GET /_vti_bin/owssvr.dll - 80 - 401 1 0
2004-11-16 13:03:57 GET /_vti_bin/owssvr.dll - 80 - 401 1 0
2004-11-16 13:03:57 GET /_vti_bin/owssvr.dll - 80 - 401 1 0
2004-11-16 13:03:57 GET /_vti_bin/owssvr.dll - 80 - 401 2 2148074254
2004-11-16 13:03:57 GET /_vti_bin/owssvr.dll - 80 - 401 2 2148074254
2004-11-16 13:03:57 GET /_vti_bin/owssvr.dll - 80 - 401 1 0
2004-11-16 13:03:57 GET /_vti_bin/owssvr.dll - 80 - 401 2 2148074254
2004-11-16 13:03:57 GET /_vti_bin/owssvr.dll - 80 - 401 1 0
2004-11-16 13:03:57 GET /_vti_bin/owssvr.dll - 80 - 401 1 0
2004-11-16 13:03:57 GET /_vti_bin/owssvr.dll - 80 - 401 2 2148074254
2004-11-16 13:03:57 GET /_vti_bin/owssvr.dll - 80 - 401 1 0
2004-11-16 13:03:58 GET /_vti_bin/owssvr.dll - 80 200 0 0
2004-11-16 13:03:58 GET /_vti_bin/owssvr.dll - 80 200 0 0
2004-11-16 13:03:58 GET /_vti_bin/owssvr.dll - 80 200 0 0
2004-11-16 13:03:58 GET /_vti_bin/owssvr.dll - 80 200 0 0
2004-11-16 13:03:58 GET /_vti_bin/owssvr.dll - 80 200 0 0
2004-11-16 13:03:58 GET /_vti_bin/owssvr.dll - 80 200 0 0
2004-11-16 13:03:58 GET /_vti_bin/owssvr.dll - 80 200 0 0
2004-11-16 13:03:58 GET /_vti_bin/owssvr.dll - 80 200 0 0

(I have removed any references to ip and NT info in the above logfiles)

A hotfix (http://support.microsoft.com/default.aspx?scid=kb;en-us;837249) for the Audiences that I received off Microsoft seem to fix the Audiences issues we were experiencing before.
Although the SharePoint installation seems to be functioning fine now, the IIS logfiles are still filling with these entries.

We have disabled logging on the Default Website, just so the SharePoint server will stop falling over every time the IIS logfile fills the system partition.

We have also logged a call with Microsoft, to see if we can fix it, I'll add a comment as soon as we have fixed it.

20 Comments:

At 12:39 PM, Graham Quinn said...

Turns out that this is "Standard" SharePoint behavior. Every document in your SharePoint Portal will be constantly polled and crawled and will create 2 entries each time in your IIS logfiles. One of the entries will be an anonymous attempt with a 401 and the other will be an authenticated attempt using the Content Access Account with a 200. Trying to see if these settings can be turned off...

 
At 5:11 PM, Furiant said...

Did you ever get this issue figured out? It sounds very similar to one we're having, where we cannot create an audience in SP. (Specifically, we cannot create rules for an audience.)

We get the following error message.


"Add Audience Rule: Rule Name

An error has occurred while accessing SQL database or system resources. If this is the first time you have seen this message, please try again later. If this problem persists, please contact your administrator. "


Any answers you might have come up with would be greatly appeciated, as we are at our wits' end with SharePoint, and this is rapidly becoming the last straw.

 
At 7:24 PM, Anonymous said...

Hello!

Nice site, keep up the good work .

http://buy-phentermine.hem.nu BUY PHENTERMINE
BUY PHENTERMINE
http://blog.sol.no/buy-phentermine
BUY PHENTERMINE
http://buy-phentermine.hem.nu buy phentermine
http://buy-phentermine.hem.nu phentermine online
http://buy-phentermine.hem.nu order phentermine
http://buy-phentermine.hem.nu cheap phentermine
http://buy-phentermine.hem.nu buy phentermine online
http://buy-phentermine.hem.nu phentermine diet pill
http://buy-phentermine.hem.nu phentermine online pharmacy
http://buy-phentermine.hem.nu phentermine prescription
http://buy-phentermine.hem.nu what is phentermine
http://buy-phentermine.hem.nu free phentermine

 
At 9:33 PM, Anonymous said...

Good day to everyone
Aciphex
Aciphex
http://www.yeshuanet.com/docs/images/Aciphex/index.html
`````````````````````````````````````````````
Tramadol
http://www.yeshuanet.com/docs/images/Tramadol/index.html
Tramadol
`````````````````````````````````````````````
Bentyl
http://www.yeshuanet.com/docs/images/Bentyl/index.html
Bentyl
thx for u

 
At 5:37 AM, Anonymous said...

hello all
Aciphex
Aciphex
http://www.yeshuanet.com/docs/images/Aciphex/index.html
============================================
Tramadol
http://www.yeshuanet.com/docs/images/Tramadol/index.html
Tramadol
`````````````````````````````````````````````
Bentyl
http://www.yeshuanet.com/docs/images/Bentyl/index.html
Bentyl
thx to u

 
At 1:27 AM, Anonymous said...

Here is some pills-info links

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
naprosyn
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
naproxen
nasacort
/////////////////////////////
nexium

\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\
N

nizoral
==================================
ortho
paroxetine
--------------------------------------------------
P

\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\
penlac
percocet
\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\
phendimetrazine
phentermine
prevacid
/////////////////////////////
prilosec
propecia
protopic
---------------------------------------------
prozac
pyrethrin
ranitidine
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
remeron
retin
rozerem
seasonale
--------------------------------------------------
O
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

sibutramine
singulair
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
skelaxin
soma
/////////////////////////////
synalar
tamiflu
tetracycline
T

--------------------------------------------------
tramadol
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
cymbalta
--------------------------------------------------

PPS
If I'll find something else, I'll post it here ))

your can mail me karlonushik@cashette.com

 
At 9:10 PM, Anonymous said...

Hello
Here is some pills-info links

tretinoin
triphasil
==================================
ultracet
ultram
valium
::::::::::::::::::::::::::::::::::::::::::::::


V
\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\
valtrex
vaniqa
vermox
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
viagra
vicodin
--------------------------------------------------
watson
---------------------------------------------
wellbutrin
xanax
yasmin
::::::::::::::::::::::::::::::::::::::::::::::
zanaflex
zelnorm
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
zithromax
zocor
zoloft
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
zovirax
zyban

Z
---------------------------------------------

zyloprim
zyrtec

---------------------------------------------
/////////////////////////////

PS
It would be interesting, if you'll post some more info about that pills.. thx
This is my university project )) Thank you for your post;)

Please post your comments

 
At 10:53 AM, Anonymous said...

Hello, people

So this one your can test :
sitemap
http://info-graf.fr/mas/images/smilies/sitemap.html
sitemap
Here is some of them :
map
map of the site
http://eagleinsurance.com.au/images/smilies/sitemap.html
So this one your can test :
sites map
map sites
http://buff.com.au/images/smilies/sitemap.html
The system should find the most relevant web-sites
Do you think it's helpful?

 
At 2:22 AM, Anonymous said...

Do you care about you helth??!! )
But we don't think about this?

Hi


fluoxetine
--------------------------------------------------
fosamax
gris
_______________
hoodia
************************************************
imitrex
_______________
ionamin
:::::;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
kenalog
lamisil
!-!-!-!!-!-!-!!-!-!-!!-!-!-!!-!-!-!!-!-!-!
levbid
levitra
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
lexapro
lipitor
--------------------------------------------------
lortab
meclizine
`````````````````````````````
meridia
/////////////////////////////
mircette
naprosyn
:::::;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
naproxen
nasacort
/////////////////////////////
nexium
_______________
nizoral
************************************************
ortho
\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\
paroxetine
:::::;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
penlac
percocet
!-!-!-!!-!-!-!!-!-!-!!-!-!-!!-!-!-!!-!-!-!
phendimetrazine
phentermine
:::::::::::::::::::::::::::::::::::::::::::::::::
prevacid
prilosec
!-!-!-!!-!-!-!!-!-!-!!-!-!-!!-!-!-!!-!-!-!
propecia
protopic
:::::::::::::::::::::::::::::::::::::::::::::::::
prozac
pyrethrin
---------------------------------------------------------
ranitidine
remeron
_______________
retin
:::::::::::::::::::::::::::::::::::::::::::::::::


PS
It would be great, if you'll post your thoughts about that pills.. thx
This is my university project )) Thank you for your post;)

 
At 1:35 PM, Anonymous said...

Hi all!
free hard core teen sex statistics on teen sex
free teen sex move http://byronss.com.au/photos/images/smiles/temp/index.html --> teen sex and drug
hot young teen sex gay teen sex pic l

 
At 9:52 PM, Anonymous said...

Hi
1. direct phentermine
Best video generic tramadol
200
6 cialis open western

2 diet phentermine pill prescription--> http://culturitalia.uibk.ac.at/forumSLI/_forumSLI/000002cf.htm
More info order tramadol--> http://culturitalia.uibk.ac.at/forumSLI/_forumSLI/000002d0.htm
cialis dosage--
> http://culturitalia.uibk.ac.at/forumSLI/_forumSLI/000002d1.htm
3. 90 00 phentermine
purchase tramadol
cialis price

 
At 4:38 AM, Anonymous said...

Hi all!
young teen sex video [url=http://byronss.com.au/photos/images/smiles/temp/index.html] free teen sex porn video [/url]
teen sex information http://byronss.com.au/photos/images/smiles/temp/index.html --> big cock teen sex
teen sex fuck video gay teen sex photo l

 
At 1:32 AM, Anonymous said...

salute!
Great site. Keep doing.
Now I understand, that for site creation it is necessary to be not webmaster, but the psychologist. Here a lot of helpful information.

Check this:

http://xenical.butkel1.org/ xenical
http://hydrocodone.butkel1.org/ hydrocodone
http://celexa.butkel1.org/ celexa
http://ephedra.butkel1.org/ ephedra
http://lorcet.butkel1.org/ lorcet
http://meridia.butkel1.org/ meridia
http://tramadol.butkel1.org/ tramadol
http://carisoprodol.butkel1.org/ carisoprodol
http://cialis.butkel1.org/ cialis
http://paxil.butkel1.org/ paxil
clonazepam http://clonazepam.butkel1.org clonazepam
lortab http://lortab.butkel1.org lortab
lexapro http://lexapro.butkel1.org lexapro
codeine http://codeine.butkel1.org codeine
viagra http://viagra.butkel1.org viagra
vicodin http://vicodin.butkel1.org vicodin
percocet http://percocet.butkel1.org percocet
ativan http://ativan.butkel1.org ativan
oxycontin http://oxycontin.butkel1.org oxycontin
rivotril http://rivotril.butkel1.org rivotril


Ciao!

 
At 12:35 PM, Anonymous said...

off


 
At 2:43 PM, Anonymous said...

Hi, I want little tell about innovation of medicine
Tramadol is used to relieve moderate to moderately severe pain
Tadalafil relaxes muscles within the penis

Zolpidem (ZOLE-pi-dem) belongs to the group of medicines called central nervous system depressants

Valium belongs to the group of medicines called central nervous system depressants

Xanax is used to treat anxiety disorders and panic attacks

GELONIDA is a narcotic analgesic used to treat or prevent moderate to severe pain

Sildenafil relaxes muscles within the penis

and other





 
At 3:24 PM, Anonymous said...

MESSAGE

 
At 3:24 PM, Anonymous said...

Hi, I want little tell about innovation of medicine
Tramadol is used to relieve moderate to moderately severe pain
Tadalafil relaxes muscles within the penis

Zolpidem (ZOLE-pi-dem) belongs to the group of medicines called central nervous system depressants

Valium belongs to the group of medicines called central nervous system depressants

Xanax is used to treat anxiety disorders and panic attacks

GELONIDA is a narcotic analgesic used to treat or prevent moderate to severe pain

Sildenafil relaxes muscles within the penis

and other





 
At 9:11 PM, Anonymous said...

MESSAGE

 
At 9:11 PM, Anonymous said...

Hi, I want little tell about innovation of medicine
Tramadol is used to relieve moderate to moderately severe pain
Tadalafil relaxes muscles within the penis

Zolpidem (ZOLE-pi-dem) belongs to the group of medicines called central nervous system depressants

Valium belongs to the group of medicines called central nervous system depressants

Xanax is used to treat anxiety disorders and panic attacks

GELONIDA is a narcotic analgesic used to treat or prevent moderate to severe pain

Sildenafil relaxes muscles within the penis

and other





 
At 12:46 PM, Anonymous said...

MESSAGE

 

Post a Comment

<< Home