Access Violation Occurs with Persistent Filters Enabled (193606)


The information in this article applies to:

  • Microsoft Site Server 3.0
This article was previously published under Q193606

SYMPTOMS

The following error may occur in Site Server Analysis Report Writer if persistent filtering is enabled and the SQL Server option for Select into/Bulk Copy is disabled:
An application error has occurred and an application error log is being generated. Report.exe Exception: access violation (0xc0000005), Address 0x0f025008

CAUSE

The SQL Server option for Select into/Bulk Copy is disabled. Persistent filters are temporary filters that are created by selecting a subset of data from one table into another.

WORKAROUND

To enable the SQL Server option for Select into/Bulk Copy for the Analysis database, perform the following steps:
  1. Run SQL Server Enterprise Manager.
  2. Expand the databases tree.
  3. Right-click on the Analysis database.
  4. Choose Edit.
  5. Choose Options.
  6. Select the Select into/Bulk Copy option. Truncate log on checkpoint should also be enabled.
  7. Stop and restart SQL Server.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Site Server version 3.0.
Modification Type:MajorLast Reviewed:7/22/1999
Keywords:kbbug KB193606
©2002 Microsoft Corporation. All rights reserved.