Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #650 > unrolled thread

Thousands of Files in "c:\Documents and Settings\LocalService\Application Data\Microsoft\Protect\S-1-5-19"

Back to article view | Back to comp.databases.ms-sqlserver

Contents

  Thousands of Files in "c:\Documents and Settings\LocalService\Application Data\Microsoft\Protect\S-1-5-19" Gene Wirchenko <genew@ocis.net> - 2011-09-07 18:18 -0700
    Re: Thousands of Files in "c:\Documents and Settings\LocalService\Application Data\Microsoft\Protect\S-1-5-19" Erland Sommarskog <esquel@sommarskog.se> - 2011-09-08 15:38 +0200
      Re: Thousands of Files in "c:\Documents and Settings\LocalService\Application Data\Microsoft\Protect\S-1-5-19" Gene Wirchenko <genew@ocis.net> - 2011-09-08 15:22 -0700
    Re: Thousands of Files in "c:\Documents and Settings\LocalService\Application Data\Microsoft\Protect\S-1-5-19" "Andrew Morton" <akm@in-press.co.uk.invalid> - 2011-09-09 09:47 +0100
      Re: Thousands of Files in "c:\Documents and Settings\LocalService\Application Data\Microsoft\Protect\S-1-5-19" Gene Wirchenko <genew@ocis.net> - 2011-09-09 11:45 -0700
        Re: Thousands of Files in "c:\Documents and Settings\LocalService\Application Data\Microsoft\Protect\S-1-5-19" "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2011-09-09 15:33 -0400
          Re: Thousands of Files in "c:\Documents and Settings\LocalService\Application Data\Microsoft\Protect\S-1-5-19" Gene Wirchenko <genew@ocis.net> - 2011-09-12 11:07 -0700
            Re: Thousands of Files in "c:\Documents and Settings\LocalService\Application Data\Microsoft\Protect\S-1-5-19" "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2011-09-12 14:19 -0400
              Re: Thousands of Files in "c:\Documents and Settings\LocalService\Application Data\Microsoft\Protect\S-1-5-19" Gene Wirchenko <genew@ocis.net> - 2011-09-12 12:02 -0700
                Re: Thousands of Files in "c:\Documents and Settings\LocalService\Application Data\Microsoft\Protect\S-1-5-19" "Andrew Morton" <akm@in-press.co.uk.invalid> - 2011-09-13 09:11 +0100
                  Re: Thousands of Files in "c:\Documents and Settings\LocalService\Application Data\Microsoft\Protect\S-1-5-19" Gene Wirchenko <genew@ocis.net> - 2011-09-13 09:40 -0700

#650 — Thousands of Files in "c:\Documents and Settings\LocalService\Application Data\Microsoft\Protect\S-1-5-19"

Dear SQLers:

     I have written about this before, have searched for answers
before, and I still do not have a solution.

     Thousands of 368-byte files are being created in "c:\Documents
and Settings\LocalService\Application
Data\Microsoft\Protect\S-1-5-19".  How do I get this to stop?

     Even deleting these files can take hours.  There are that many.
Running a chkdsk can take a lot longer than usual when there are a lot
of these files on my system.

     From my searching, I understand that it may be due to Reporting
Services and a cryptokey problem, but I know of no way to stop it.

     HELP!

Sincerely,

Gene Wirchenko

[toc] | [next] | [standalone]

#652

Gene Wirchenko (genew@ocis.net) writes:
>      I have written about this before, have searched for answers
> before, and I still do not have a solution.
> 
>      Thousands of 368-byte files are being created in "c:\Documents
> and Settings\LocalService\Application
> Data\Microsoft\Protect\S-1-5-19".  How do I get this to stop?
> 
>      Even deleting these files can take hours.  There are that many.
> Running a chkdsk can take a lot longer than usual when there are a lot
> of these files on my system.
> 
>      From my searching, I understand that it may be due to Reporting
> Services and a cryptokey problem, but I know of no way to stop it.

I have no ideas what that may be. On this computer I have to directories
under Protect with a SID in the directory name. One directory has a single
file with a GUID name and a file Preferred. The other directory has five
such files + "Preferred". But this is a netbook which I rarely use when
I'm at home, but right now I am travelling. There is no Reporting Services
on this machine.

I can see that the latest such file is from Aug 22nd, which is about the
day I took out the netbook to prepare it for the trip.

One idea would be to write a program in the language of your choice which
deletes all files but the latest, and run it from Task Manager or SQL 
Server Agent regularly.


-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

[toc] | [prev] | [next] | [standalone]

#655

On Thu, 08 Sep 2011 15:38:44 +0200, Erland Sommarskog
<esquel@sommarskog.se> wrote:

>Gene Wirchenko (genew@ocis.net) writes:
>>      I have written about this before, have searched for answers
>> before, and I still do not have a solution.
>> 
>>      Thousands of 368-byte files are being created in "c:\Documents
>> and Settings\LocalService\Application
>> Data\Microsoft\Protect\S-1-5-19".  How do I get this to stop?
>> 
>>      Even deleting these files can take hours.  There are that many.
>> Running a chkdsk can take a lot longer than usual when there are a lot
>> of these files on my system.
>> 
>>      From my searching, I understand that it may be due to Reporting
>> Services and a cryptokey problem, but I know of no way to stop it.
>
>I have no ideas what that may be. On this computer I have to directories
>under Protect with a SID in the directory name. One directory has a single
>file with a GUID name and a file Preferred. The other directory has five
>such files + "Preferred". But this is a netbook which I rarely use when
>I'm at home, but right now I am travelling. There is no Reporting Services
>on this machine.
>
>I can see that the latest such file is from Aug 22nd, which is about the
>day I took out the netbook to prepare it for the trip.
>
>One idea would be to write a program in the language of your choice which
>deletes all files but the latest, and run it from Task Manager or SQL 
>Server Agent regularly.

     I do, but with files being created at about one every three
seconds the last time I checked, that is 25 to 30 thousand files per
day.

Sincerely,

Gene Wirchenko

[toc] | [prev] | [next] | [standalone]

#656

Changing the account used for the ReportServer service might help:
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/c6e240d9-4ec3-408e-beff-ac8fa0f43c94/

-- 
Andrew 

[toc] | [prev] | [next] | [standalone]

#658

On Fri, 9 Sep 2011 09:47:22 +0100, "Andrew Morton"
<akm@in-press.co.uk.invalid> wrote:

>Changing the account used for the ReportServer service might help:
>http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/c6e240d9-4ec3-408e-beff-ac8fa0f43c94/

     I have a basic installation.  I am not even using the reporting.

     And what account do I change it to?

     Oddly, the Reporting Services Configuration Manager will not let
me into the panel for Service Account.  I get:

     There was an error while switching panels.  The most likely cause
is an error in retrieving WMI properties.  The exception details are:

     InvalidArgument=Value of '2' is not valid for 'SelectedIndex'.
     Parameter name: SelectedIndex

I can get into all of the other panels.

Sincerely,

Gene Wirchenko
 

[toc] | [prev] | [next] | [standalone]

#659

Gene Wirchenko wrote:
> On Fri, 9 Sep 2011 09:47:22 +0100, "Andrew Morton"
> <akm@in-press.co.uk.invalid> wrote:
>
>> Changing the account used for the ReportServer service might help:
>>
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/c6e240d9-4ec3-408e-beff-ac8fa0f43c94/
>
>      I have a basic installation.  I am not even using the reporting.
>
Why not stop the RS service then?

[toc] | [prev] | [next] | [standalone]

#663

On Fri, 9 Sep 2011 15:33:27 -0400, "Bob Barrows"
<reb01501@NOyahooSPAM.com> wrote:

>Gene Wirchenko wrote:
>> On Fri, 9 Sep 2011 09:47:22 +0100, "Andrew Morton"
>> <akm@in-press.co.uk.invalid> wrote:
>>
>>> Changing the account used for the ReportServer service might help:
>>>
>http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/c6e240d9-4ec3-408e-beff-ac8fa0f43c94/
>>
>>      I have a basic installation.  I am not even using the reporting.
>>
>Why not stop the RS service then?

     Well, I do not know that that actually is the problem.  It was
only something I read.  I did solve the problem though:

     I started Windows in Safe Mode.  I set the files in the directory
to R/W and deleted them and the directory.  I then created a text file
with the same name as the directory.  So far, it seems to be working.
The commit charge on my system is lower, too, but I do not know if
this is connected.

Sincerely,

Gene Wirchenko

[toc] | [prev] | [next] | [standalone]

#664

Gene Wirchenko wrote:
> On Fri, 9 Sep 2011 15:33:27 -0400, "Bob Barrows"
> <reb01501@NOyahooSPAM.com> wrote:
>
>> Gene Wirchenko wrote:
>>> On Fri, 9 Sep 2011 09:47:22 +0100, "Andrew Morton"
>>> <akm@in-press.co.uk.invalid> wrote:
>>>
>>>> Changing the account used for the ReportServer service might help:
>>>>
>>
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/c6e240d9-4ec3-408e-beff-ac8fa0f43c94/
>>>
>>>      I have a basic installation.  I am not even using the
>>> reporting.
>>>
>> Why not stop the RS service then?
>
>      Well, I do not know that that actually is the problem.  It was
> only something I read.  I did solve the problem though:
>
>      I started Windows in Safe Mode.  I set the files in the directory
> to R/W and deleted them and the directory.  I then created a text file
> with the same name as the directory.  So far, it seems to be working.
> The commit charge on my system is lower, too, but I do not know if
> this is connected.
>
What gave you the idea to try that?

[toc] | [prev] | [next] | [standalone]

#665

On Mon, 12 Sep 2011 14:19:04 -0400, "Bob Barrows"
<reb01501@NOyahooSPAM.com> wrote:

>Gene Wirchenko wrote:
>> On Fri, 9 Sep 2011 15:33:27 -0400, "Bob Barrows"
>> <reb01501@NOyahooSPAM.com> wrote:
>>
>>> Gene Wirchenko wrote:
>>>> On Fri, 9 Sep 2011 09:47:22 +0100, "Andrew Morton"
>>>> <akm@in-press.co.uk.invalid> wrote:
>>>>
>>>>> Changing the account used for the ReportServer service might help:
>>>>>
>>>
>http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/c6e240d9-4ec3-408e-beff-ac8fa0f43c94/
>>>>
>>>>      I have a basic installation.  I am not even using the
>>>> reporting.
>>>>
>>> Why not stop the RS service then?
>>
>>      Well, I do not know that that actually is the problem.  It was
>> only something I read.  I did solve the problem though:
>>
>>      I started Windows in Safe Mode.  I set the files in the directory
>> to R/W and deleted them and the directory.  I then created a text file
>> with the same name as the directory.  So far, it seems to be working.
>> The commit charge on my system is lower, too, but I do not know if
>> this is connected.
>>
>What gave you the idea to try that?

     I may have seen a case of it in the past.  That a directory entry
exists does not mean it is the type that you want.  I figured that the
file creation would fail on a path error. It was possible that the
file would be deleted and the directory recreated, but I doubted that
would be done.

Sincerely,

Gene Wirchenko

[toc] | [prev] | [next] | [standalone]

#666

Do you now have thousands of entries per day in the event logs instead?

-- 
Andrew 

[toc] | [prev] | [next] | [standalone]

#668

On Tue, 13 Sep 2011 09:11:37 +0100, "Andrew Morton"
<akm@in-press.co.uk.invalid> wrote:

>Do you now have thousands of entries per day in the event logs instead?

     No.  There are several entries apparently connected with what my
problem was, but no, not thousands.  Thanks for pointing out that
possibility; I had not thought of it.

Sincerely,

Gene Wirchenko

[toc] | [prev] | [standalone]

Back to top | Article view | comp.databases.ms-sqlserver

csiph-web