error rebuild index with dbcc

I have an error like this, every time I reindex this table
via db maintenance plan.
Rebuilding indexes for table 'tbJOTrStatusbyWC'
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934:
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed
because the following SET options have incorrect
settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
What does it means this error ?
How to setting 'QUOTED_IDENTIFIER, ARITHABORT'
thx.You most probably have an index on a computed columns or an indexed view. And unfortunately, the
maint plan doesn't execute the needed SET commands to be able to rebuild these indexes. You would
have to create your own (TSQL) job where you execute needed SET commands and then DBCC DBREINDEX (or
DBCC INDEXDEFRAG).
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"kresna rudy kurniawan" <kresnark@.yahoo.com> wrote in message
news:3c9401c37b42$a2255740$a601280a@.phx.gbl...
> I have an error like this, every time I reindex this table
> via db maintenance plan.
> Rebuilding indexes for table 'tbJOTrStatusbyWC'
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934:
> [Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed
> because the following SET options have incorrect
> settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
> What does it means this error ?
> How to setting 'QUOTED_IDENTIFIER, ARITHABORT'
> thx.|||Tibor is correct in that the maintenance wizard has issues with things such
as computed columns and indexed views. I suggest you create your own
scheduled job to do the DBREINDEX and not use the wizard and all should be
fine.
--
Andrew J. Kelly
SQL Server MVP
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
wrote in message news:u$PV9Y2eDHA.3788@.tk2msftngp13.phx.gbl...
> > You are wrong,
> I'm pretty certain that I'm not. But you are welcome to think so, if you
wish.
> I still recommend that you check very closely if you have either indexes
on computed columns or
> indexes on views.
> You do not need any special SET options if you have an PK over several
columns, so it has to be
> something else.
> --
> Tibor Karaszi, SQL Server MVP
> Archive at: http://groups.google.com/groups?oi=djq&as
ugroup=microsoft.public.sqlserver
>
> "kresna rudy kurniawan" <kresnark@.yahoo.com> wrote in message
> news:3d9d01c37b5e$e471ee80$a601280a@.phx.gbl...
> > You are wrong,
> >
> > I don't use a computed columns, I use multi colums(JONo,
> > OPID,seqNo) for my primay key, this is the structure.
> >
> > TrackMainID int 4 1
> > JONo int 4 0
> > OPID int 4 0
> > SeqNo int 4 0
> > QtyIN numeric 5 1
> > QtyOut numeric 5 1
> > QtyOpen numeric 5 1
> > WCID int 4 1
> > FirstInDate datetime 8 1
> > LastOutDate datetime 8 1
> >
> > I still don't understand the message : incorrect
> > settings: 'QUOTED_IDENTIFIER, ARITHABORT'
> >
> > I must setting where ?
> >
> >
> >
> > >--Original Message--
> > >You most probably have an index on a computed columns or
> > an indexed view. And unfortunately, the
> > >maint plan doesn't execute the needed SET commands to be
> > able to rebuild these indexes. You would
> > >have to create your own (TSQL) job where you execute
> > needed SET commands and then DBCC DBREINDEX (or
> > >DBCC INDEXDEFRAG).
> > >
> > >--
> > >Tibor Karaszi, SQL Server MVP
> > >Archive at: http://groups.google.com/groups?oi=djq&as
> > ugroup=microsoft.public.sqlserver
> > >
> > >
> > >"kresna rudy kurniawan" <kresnark@.yahoo.com> wrote in
> > message
> > >news:3c9401c37b42$a2255740$a601280a@.phx.gbl...
> > >> I have an error like this, every time I reindex this
> > table
> > >> via db maintenance plan.
> > >>
> > >> Rebuilding indexes for table 'tbJOTrStatusbyWC'
> > >> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934:
> > >> [Microsoft][ODBC SQL Server Driver][SQL Server]DBCC
> > failed
> > >> because the following SET options have incorrect
> > >> settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
> > >>
> > >> What does it means this error ?
> > >> How to setting 'QUOTED_IDENTIFIER, ARITHABORT'
> > >>
> > >> thx.
> > >
> > >
> > >.
> > >
>sql

Error Processingn Cube with time dimension

The strange thing is that- i create two cubes with same data source using the same fact table and the same dimension in both cases.

However with the first one i dont define the dimension as a time dimension and the cube processes fine.

With the second cube i do define the dimension as a time dimension and then the cube processing errors. The error say attribute key cannnot be found? But it was found in the first cube?

Anyone know what might be causing this?

Thanks,

Can you try and use copy/paste functionality in BI Dev studio to make a copy of your existing cube and try to process it then?

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Thanks for the reply unfortunatly i still get he same error when i try this.

Some more information-

The error i get is that attribute key with value 0 cannot be found. i get as many of these errors as there are nulls in the fact tables date dimension key column. There arent any 0 values.

So it might be that for some reaon the nulls are converted to zeros when a date dimension is added and this throws the referential integrity errors? Please help..

Thanks,

|||

I think you guessed it right.

You need to make sure your fact table doesnt have null's in the date dimension key column.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

But surely my date dimension field can contain nulls. It is a nullable field in the OLTP system.?

i noticed this http://mgarner.wordpress.com/tag/mdx/ see the 'null = 0' post at the bottom.

|||

This is not a good practice to have a nullable key.

Although Analysis Services allows you to map null keys to Unknown member in the dimension, it is not a good idea.

To solve this problem try define a named calculation in your DSV to map null keys to some pre-defined value on the fly.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Thanks for you reply Edward

But.

Analysis services is not converting nulls to unknown if the column is defined as a time dimension. It is converting them to zeros and raisng referential integrity errors.

Is it the case that Analysis services cubes cannot contain nullable time dimensions?

This doesnt sound right to me as date columns often signify an event and therefore a null indicates that the event hasnt occured.

Not being able to define nullable time dimensions if true is a serious flaw in analysis services 2005.

What value could i set the calculated field to in the case of nulls. Surely unknown is the right value for a null date? I certainly wouldnt want to put in someone arbitary date and presumaably it would have to be a vlaue of datetime data type?

[Edit]

Edward below is some test code which builds a test fact table and test time dim. If you define the dim as a time dim then the processing will error if you insert the null in the time dim. Note if you dont define it as a time dim it processess fine with or without the null.

Please have a look at this and let me know.

Thanks alot for all your help.

if object_id('DateDim') is not null

drop table DateDim

go

if object_id('datefact') is not null

drop table datefact

go

create table DateDim

(ID int identity, date smalldatetime)

go

insert DateDim

select getdate()

union all

select getdate()+1

union all

select getdate() +2

union all

select getdate() +3

union all

select getdate() +4

union all

select getdate() +5

create table datefact

(id int identity, datekey int , amount int)

go

insert datefact

select 1, 50

union all

select 1, 50

union all

select 3, 50

union all

select 4, 50

union all

select 5, 50

union all

select 5, 50

/*--Uncomment this so a null is insert into the time dimension reprocess the cube and it will error

union all

select null, 50

*/

sql

Error or Bug? Field in dataset won't display on report

I've got a report with 6 datasets. Each dataset has a field labeled LastUpdateDT which basically shows the last time data for that dataset was updated. All the datasets are called via the same stored procedure in the SQL database. I pass a value in to select the appropriate dataset to be returned. Each dataset returns the same fields, the only difference is the meaning of the data in each dataset, all field names and types are identical.

I'm having a problem with 2 of the datasets in the report. Each dataset is displayed in it's own table in the report. When I add the LastUpdateDt field for the 2 problem datasets to the tables, it ALWAYS comes back empty. If I run the stored proc, the LastUpdateDt field has data, if I query the dataset from within the RS designer, the field has data, but it will not display on the table. I've completely dropped and recreated both the table and dataset and get the same problem. I don't get any error or warnings, just no data for that field only. All the other fields for the dataset display fine. It is the last field in the dataset, but I've also tried moving it and got the same result.

Has anyone every encountered anything like this and if so, how did you fix it?

Here's the code used to display the value: (It's in the table header)

=" Last Updated Date: " & CStr(First(Fields!LastUpdateDt.Value))

I've also added the field (=Fields!LastUpdateDt.Value) to the detail row and get no data showing even though I can see it when running the query in the data tab.

Problem solved. PEBKAC error. (Problem Exists Between Keyboard and Chair)!

Error number: 2812 - Transaction Replication

Hi,
I am trying transactional replication between two servers with a remote
distributor. I am getting following error each time I run the distribution
agent
Last Command : {CALL sp_MSupd_Customers (NULL,N'Alfreds Futterkiste -
test',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL ,N'ALFKI',0x0200)}
Transaction sequence number and command ID of last execution batch are
0x0000001A00000082000900000000 and 1.
Error Message :Could not find stored procedure 'sp_MSupd_Customers'.
Error details : Could not find stored procedure 'sp_MSupd_Customers'.
(Source: L000646\AA03 (Data source); Error number: 2812)
Can some one help please
If you have used @.sync_type = None in sp_addsubscription or in the
subscription wizard, Initialize subscription page, you select 'no, the
subscriber already has the schema and data' you may get this error. The
system tables for replication will be created on the subscriber in either
case but you'll need to manually create the stored procedures on the
subscriber if you use this option otherwise you'll have the above error when
you change a row on the publisher. Use sp_scriptpublicationcustomprocs
(assuming you have >= sp1) to create a script which creates the procedures
and run this script on the subscriber.
HTH,
Paul Ibison
|||Thanks for that Paul. It is all working now.
regards
"Paul Ibison" wrote:

> If you have used @.sync_type = None in sp_addsubscription or in the
> subscription wizard, Initialize subscription page, you select 'no, the
> subscriber already has the schema and data' you may get this error. The
> system tables for replication will be created on the subscriber in either
> case but you'll need to manually create the stored procedures on the
> subscriber if you use this option otherwise you'll have the above error when
> you change a row on the publisher. Use sp_scriptpublicationcustomprocs
> (assuming you have >= sp1) to create a script which creates the procedures
> and run this script on the subscriber.
> HTH,
> Paul Ibison
>
>

Error Msg 8120

Hello all,

I am using SQL Server 2005 Express on my local machine and am having a hard time figuring out why this problem is occuring. I am creating a stored procedure just fyi. 8120 = Column 's.Spread' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. And also...Column 's.Pay End Dt' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

Both of these fields are being used in an expression not actually pulled into the query. I have bolded the line that the error refers to...Here is the sql:

USE ForecastSQLDBA
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE GetHistoricalData
@.AccountName varchar(50),
@.MaxDate smalldatetime
AS
BEGIN

SELECTDivision,
SUM(CASE WHEN [Pay End Dt] BETWEEN '2005-01-01' AND '2005-12-31' THEN Spread ELSE 0 END) AS [05Spread],
SUM(CASE WHEN [Pay End Dt] BETWEEN '2006-01-01' AND '2006-12-31' THEN Spread ELSE 0 END) AS [06Spread],
SUM(CASE WHEN [Pay End Dt] BETWEEN '2005-01-01' AND '2005-12-31' THEN [Bill] ELSE 0 END)/SUM(CASE WHEN [Pay End Dt] BETWEEN '2005-01-01' AND '2005-12-31' THEN [Cost] ELSE 0 END) AS [05MarkUp],
SUM(CASE WHEN [Pay End Dt] BETWEEN '2006-01-01' AND '2006-12-31' THEN [Bill] ELSE 0 END)/SUM(CASE WHEN [Pay End Dt] BETWEEN '2006-01-01' AND '2006-12-31' THEN [Cost] ELSE 0 END) AS [06MarkUp],
SUM(CASE WHEN [Pay End Dt] BETWEEN '2007-01-01' AND @.maxdate THEN [Bill] ELSE 0 END)/SUM(CASE WHEN [Pay End Dt] BETWEEN '2007-01-01' AND @.maxdate THEN [Cost] ELSE 0 END) AS [07MarkUp],
SUM(CASE WHEN [Pay End Dt] BETWEEN '2005-01-01' AND '2005-12-31' THEN Spread ELSE 0 END)/SUM(CASE WHEN [Pay End Dt] BETWEEN '2005-01-01' AND '2005-12-31' THEN [Emp] ELSE 0 END) AS [05SPC],
SUM(CASE WHEN [Pay End Dt] BETWEEN '2006-01-01' AND '2006-12-31' THEN Spread ELSE 0 END)/SUM(CASE WHEN [Pay End Dt] BETWEEN '2006-01-01' AND '2006-12-31' THEN [Emp] ELSE 0 END) AS [06SPC],
SUM(CASE WHEN [Pay End Dt] BETWEEN '2007-01-01' AND @.maxdate THEN Spread ELSE 0 END)/SUM(CASE WHEN [Pay End Dt] BETWEEN '2007-01-01' AND @.maxdate THEN [Emp] ELSE 0 END) AS [07SPC],
SUM(CASE WHEN [Pay End Dt] = @.maxdate THEN [Bill] ELSE 0 END)/SUM(CASE [Pay End Dt] WHEN @.maxdate THEN [Cost] ELSE 0 END) AS [07CurMarkUp],
AVG(CASE WHEN [Pay End Dt] BETWEEN '2005-01-01' AND '2005-12-31' THEN [Emp] ELSE 0 END) AS [05AvgEmp],
AVG(CASE WHEN [Pay End Dt] BETWEEN '2006-01-01' AND '2006-12-31' THEN [Emp] ELSE 0 END) AS [06AvgEmp],
AVG(CASE WHEN [Pay End Dt] BETWEEN '2007-01-01' AND @.maxdate THEN [Emp] ELSE 0 END) AS [07AvgEmp],
MAX(CASE WHEN [Pay End Dt] BETWEEN '2005-01-01' AND '2005-12-31' THEN [Spread] ELSE 0 END) AS [05High],
MAX(CASE WHEN [Pay End Dt] BETWEEN '2006-01-01' AND '2006-12-31' THEN Spread ELSE 0 END) AS [06High],
MAX(CASE WHEN [Pay End Dt] BETWEEN '2007-01-01' AND @.maxdate THEN Spread ELSE 0 END) AS [07High],
CASE Spread WHEN MAX(CASE WHEN [Pay End Dt] BETWEEN '2005-01-01' AND '2005-12-31' THEN Spread ELSE 0 END) THEN [Pay End Dt] ELSE '' END AS [05MaxWeek],
CASE Spread WHEN MAX(CASE WHEN [Pay End Dt] BETWEEN '2006-01-01' AND '2006-12-31' THEN Spread ELSE 0 END) THEN [Pay End Dt] ELSE '' END AS [06MaxWeek],
CASE Spread WHEN MAX(CASE WHEN [Pay End Dt] BETWEEN '2007-01-01' AND @.maxdate THEN Spread ELSE 0 END) THEN [Pay End Dt] ELSE '' END AS [05MaxWeek]

FROM (SELECT Division, [Pay End Dt], Sum(isnull([SumOfNum of Emp],0)) AS Emp, SUM(isnull([SumOfNet Spread],0)) AS Spread, SUM(isnull([SumOfTotal Bill],0)) AS Bill, SUM(isnull([SumOfCost],0)) AS Cost FROM dbo.tbl_NAHistory WHERE [Generic Customer] = @.AccountName GROUP BY Division, [Pay End Dt]) AS s

GROUP BY [Division];
END

Thanks in advance,
-BOK, I was wrong...the last three CASE expressions need to go in the GROUP BY but they can't because they have aggregates. Any ideas?

Error messages upsizing from MSAccess database to SQLServer

I am trying to use SQLServer for the first time and I am trying to use the upsizing wizard on Access to get moved over to SQLServer. I am getting the following error messages:

Connection failed:

SQLState: '01000'

SQL Server Error: 2

[Microsoft][ODBC SQL Server][Shared Memory]ConnectionOpen (Connect()).

Connection failed:

SQLState: '08001'

SQLServer Error: 17

[Microsoft][ODBC SQL Server][Shared Memory]SQL Server does not exist or access denied.

Does anyone know how I should proceed? Any help would be appreciated.

Thanks

Which version of SQL Server are you using?

Does the following help

http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx

|||I am using SQL Server 2005 Express|||Did you try the steps in the link I provided?|||

I did all the steps and I got the following error message:

ODBC - call failed.

I also tried this: I wrote a new database that had only one table in it (no forms or queries) and a few records in that table. That test database did get upsized just fine. But when trying to upsize the database I really need, I still got the "ODBC - call failed" error message.

Do you have any recommendations.

Thanks

Mark

|||

http://support.microsoft.com/?scid=kb;en-us;303257&spid=2509&sid=49

HTH

Error messages upsizing from MSAccess database to SQLServer

I am trying to use SQLServer for the first time and I am trying to use the upsizing wizard on Access to get moved over to SQLServer. I am getting the following error messages:

Connection failed:

SQLState: '01000'

SQL Server Error: 2

[Microsoft][ODBC SQL Server][Shared Memory]ConnectionOpen (Connect()).

Connection failed:

SQLState: '08001'

SQLServer Error: 17

[Microsoft][ODBC SQL Server][Shared Memory]SQL Server does not exist or access denied.

Does anyone know how I should proceed? Any help would be appreciated.

Thanks

Which version of SQL Server are you using?

Does the following help

http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx

|||I am using SQL Server 2005 Express|||Did you try the steps in the link I provided?|||

I did all the steps and I got the following error message:

ODBC - call failed.

I also tried this: I wrote a new database that had only one table in it (no forms or queries) and a few records in that table. That test database did get upsized just fine. But when trying to upsize the database I really need, I still got the "ODBC - call failed" error message.

Do you have any recommendations.

Thanks

Mark

|||

http://support.microsoft.com/?scid=kb;en-us;303257&spid=2509&sid=49

HTH

Error message using "Copy Database Wizard"

Any advice from the crowd? Every time I try to run "Copy Database
Wizard" I get an error message saying I must be a member of the
sysadmin group and have permission to copy files over the network. I'm
a local admin on both boxes and a member of the sysadmin group on both
SQL servers and an admin on the network. What am I missing here?

Thanks,

Ralph Noble
ralph_noble@.hotmail.comIs the target server running under a domain account? Check out:

http://support.microsoft.com/defaul...463&Product=sql

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Ralph Noble" <ralph_noble@.hotmail.com> wrote in message
news:ed6de1e7.0411110741.15429731@.posting.google.c om...
> Any advice from the crowd? Every time I try to run "Copy Database
> Wizard" I get an error message saying I must be a member of the
> sysadmin group and have permission to copy files over the network. I'm
> a local admin on both boxes and a member of the sysadmin group on both
> SQL servers and an admin on the network. What am I missing here?
> Thanks,
> Ralph Noble
> ralph_noble@.hotmail.com

Error Message trying to deploy report.

I saw this posted about 6 weeks ago, but have not had the time to look. Could use some help.

TITLE: Microsoft Report Designer

A connection could not be made to the report server http://localhost/ReportServer.

ADDITIONAL INFORMATION:

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>Configuration Error</title>
<style>
body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;}
p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px}
b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px}
H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red }
H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon }
pre {font-family:"Lucida Console";font-size: .9em}
.marker {font-weight: bold; color: black;text-decoration: none;}
.version {color: gray;}
.error {margin-bottom: 10px;}
.expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; }
</style>
</head>

<body bgcolor="white">

<span><H1>Server Error in '/ReportServer' Application.<hr width=100% size=1 color=silver></H1>

<h2> <i>Configuration Error</i> </h2></span>

<font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif ">

<b> Description: </b>An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
<br><br>

<b> Parser Error Message: </b>An error occurred loading a configuration file: Failed to start monitoring changes to 'c:\inetpub\wwwroot\web.config' because access is denied.<br><br>

<b>Source Error:</b> <br><br>

<table width=100% bgcolor="#ffffcc">
<tr>
<td>
<code><pre>

[No relevant source lines]</pre></code>

</td>
</tr>
</table>

<br>

<b> Source File: </b> c:\inetpub\wwwroot\web.config<b> Line: </b> 0
<br><br>

<hr width=100% size=1 color=silver>

<b>Version Information:</b> Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210

</font>

</body>
</html>
<!--
[HttpException]: Failed to start monitoring changes to 'c:\inetpub\wwwroot\web.config' because access is denied.
at System.Web.DirectoryMonitor.AddFileMonitor(String file)
at System.Web.DirectoryMonitor.StartMonitoringFile(String file, FileChangeEventHandler callback, String alias)
at System.Web.FileChangesMonitor.StartMonitoringFile(String alias, FileChangeEventHandler callback)
at System.Web.Configuration.WebConfigurationHost.StartMonitoringStreamForChanges(String streamName, StreamChangeCallback callback)
at System.Configuration.BaseConfigurationRecord.MonitorStream(String configKey, String configSource, String streamname)
at System.Configuration.BaseConfigurationRecord.InitConfigFromFile()
[ConfigurationErrorsException]: An error occurred loading a configuration file: Failed to start monitoring changes to 'c:\inetpub\wwwroot\web.config' because access is denied. (c:\inetpub\wwwroot\web.config)
at System.Configuration.ConfigurationSchemaErrors.ThrowIfErrors(Boolean ignoreLocal)
at System.Configuration.BaseConfigurationRecord.ThrowIfParseErrors(ConfigurationSchemaErrors schemaErrors)
at System.Configuration.BaseConfigurationRecord.GetSectionRecursive(String configKey, Boolean getLkg, Boolean checkPermission, Boolean getRuntimeObject, Boolean requestIsHere, Object& result, Object& resultRuntimeObject)
at System.Configuration.BaseConfigurationRecord.GetSection(String configKey, Boolean getLkg, Boolean checkPermission)
at System.Configuration.BaseConfigurationRecord.GetSection(String configKey)
at System.Web.Configuration.RuntimeConfig.GetSectionObject(String sectionName)
at System.Web.Configuration.RuntimeConfig.GetSection(String sectionName, Type type, ResultsIndex index)
at System.Web.Configuration.RuntimeConfig.get_HealthMonitoring()
at System.Web.Configuration.HealthMonitoringSectionHelper..ctor()
at System.Web.Management.HealthMonitoringManager..ctor()
at System.Web.Management.HealthMonitoringManager.Manager()
at System.Web.Management.WebBaseEvent.RaiseRuntimeError(Exception e, Object source)
at System.Web.HttpResponse.ReportRuntimeError(Exception e, Boolean canThrow, Boolean localExecute)
at System.Web.HttpRuntime.FinishRequest(HttpWorkerRequest wr, HttpContext context, Exception e)
-->
--. (Microsoft.ReportingServices.Designer)

BUTTONS:

OK

Thanks!

Terry

Hello Terry,

You might want to take a look at this post, this user had the same issue.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=745372&SiteID=1

Jarret

|||I had the same problem, but when I allowed the NETWORK SERVICE account full permission on inetpub/wwwroot the problem went away. Here is the real question, why the hell is is looking at inetpub/wwwroot when the reportserver files are not even in wwwroot?|||YOu will need to allow the Worker process the IIS is running with access to the path mentioned in the error message.

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

Yes, but why is it mentioning that path when there are no other references to it in the project? The path in the error is wwwroot\web.config. This is not where my project is and nothing in my project is looking there, so where is it getting this path from?

Error Message trying to deploy report.

I saw this posted about 6 weeks ago, but have not had the time to look. Could use some help.

TITLE: Microsoft Report Designer

A connection could not be made to the report server http://localhost/ReportServer.

ADDITIONAL INFORMATION:

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>Configuration Error</title>
<style>
body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;}
p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px}
b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px}
H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red }
H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon }
pre {font-family:"Lucida Console";font-size: .9em}
.marker {font-weight: bold; color: black;text-decoration: none;}
.version {color: gray;}
.error {margin-bottom: 10px;}
.expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; }
</style>
</head>

<body bgcolor="white">

<span><H1>Server Error in '/ReportServer' Application.<hr width=100% size=1 color=silver></H1>

<h2> <i>Configuration Error</i> </h2></span>

<font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif ">

<b> Description: </b>An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
<br><br>

<b> Parser Error Message: </b>An error occurred loading a configuration file: Failed to start monitoring changes to 'c:\inetpub\wwwroot\web.config' because access is denied.<br><br>

<b>Source Error:</b> <br><br>

<table width=100% bgcolor="#ffffcc">
<tr>
<td>
<code><pre>

[No relevant source lines]</pre></code>

</td>
</tr>
</table>

<br>

<b> Source File: </b> c:\inetpub\wwwroot\web.config<b> Line: </b> 0
<br><br>

<hr width=100% size=1 color=silver>

<b>Version Information:</b> Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210

</font>

</body>
</html>
<!--
[HttpException]: Failed to start monitoring changes to 'c:\inetpub\wwwroot\web.config' because access is denied.
at System.Web.DirectoryMonitor.AddFileMonitor(String file)
at System.Web.DirectoryMonitor.StartMonitoringFile(String file, FileChangeEventHandler callback, String alias)
at System.Web.FileChangesMonitor.StartMonitoringFile(String alias, FileChangeEventHandler callback)
at System.Web.Configuration.WebConfigurationHost.StartMonitoringStreamForChanges(String streamName, StreamChangeCallback callback)
at System.Configuration.BaseConfigurationRecord.MonitorStream(String configKey, String configSource, String streamname)
at System.Configuration.BaseConfigurationRecord.InitConfigFromFile()
[ConfigurationErrorsException]: An error occurred loading a configuration file: Failed to start monitoring changes to 'c:\inetpub\wwwroot\web.config' because access is denied. (c:\inetpub\wwwroot\web.config)
at System.Configuration.ConfigurationSchemaErrors.ThrowIfErrors(Boolean ignoreLocal)
at System.Configuration.BaseConfigurationRecord.ThrowIfParseErrors(ConfigurationSchemaErrors schemaErrors)
at System.Configuration.BaseConfigurationRecord.GetSectionRecursive(String configKey, Boolean getLkg, Boolean checkPermission, Boolean getRuntimeObject, Boolean requestIsHere, Object& result, Object& resultRuntimeObject)
at System.Configuration.BaseConfigurationRecord.GetSection(String configKey, Boolean getLkg, Boolean checkPermission)
at System.Configuration.BaseConfigurationRecord.GetSection(String configKey)
at System.Web.Configuration.RuntimeConfig.GetSectionObject(String sectionName)
at System.Web.Configuration.RuntimeConfig.GetSection(String sectionName, Type type, ResultsIndex index)
at System.Web.Configuration.RuntimeConfig.get_HealthMonitoring()
at System.Web.Configuration.HealthMonitoringSectionHelper..ctor()
at System.Web.Management.HealthMonitoringManager..ctor()
at System.Web.Management.HealthMonitoringManager.Manager()
at System.Web.Management.WebBaseEvent.RaiseRuntimeError(Exception e, Object source)
at System.Web.HttpResponse.ReportRuntimeError(Exception e, Boolean canThrow, Boolean localExecute)
at System.Web.HttpRuntime.FinishRequest(HttpWorkerRequest wr, HttpContext context, Exception e)
-->
--. (Microsoft.ReportingServices.Designer)

BUTTONS:

OK

Thanks!

Terry

Hello Terry,

You might want to take a look at this post, this user had the same issue.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=745372&SiteID=1

Jarret

|||I had the same problem, but when I allowed the NETWORK SERVICE account full permission on inetpub/wwwroot the problem went away. Here is the real question, why the hell is is looking at inetpub/wwwroot when the reportserver files are not even in wwwroot?|||YOu will need to allow the Worker process the IIS is running with access to the path mentioned in the error message.

Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Yes, but why is it mentioning that path when there are no other references to it in the project? The path in the error is wwwroot\web.config. This is not where my project is and nothing in my project is looking there, so where is it getting this path from?

Error message

I am getting this error message over night. The server is
not busy during this time but a job that runs at 1 AM
seems to generate this error only when it runs at 1 AM.
When I rerun it at 7 AM when I come in to work it runs
fine. The error is:
Error: 1204, Severity: 19, State: 1
The SQL Server cannot obtain a LOCK resource at this time.
Rerun your statement when there are fewer active users or
ask the system administrator to check the SQL Server lock
and memory configuration.
What configuration settings are availiable for this? I
allow SQL to dynamically set its memory between 0 and 6656
MB with 8 gig availiable.
Please advise.Lots of questions:
Are you running SQL Ent Edition? (if not can not use more
than 2gb of ram)
What kind of job is it? Are you running maintenance
routines at the same time? Do you ahve any errors in the
SQL log at the same time? Event viewer errors?
Ray Higdon MCSE, MCDBA, CCNA
>--Original Message--
>I am getting this error message over night. The server is
>not busy during this time but a job that runs at 1 AM
>seems to generate this error only when it runs at 1 AM.
>When I rerun it at 7 AM when I come in to work it runs
>fine. The error is:
>Error: 1204, Severity: 19, State: 1
>The SQL Server cannot obtain a LOCK resource at this
time.
>Rerun your statement when there are fewer active users or
>ask the system administrator to check the SQL Server lock
>and memory configuration.
>What configuration settings are availiable for this? I
>allow SQL to dynamically set its memory between 0 and
6656
>MB with 8 gig availiable.
>Please advise.
>
>.
>

error message

I get the following error message in the log every time I reboot sql
server. I also seem to be experiencing exessive memory usage problems
with sql server. Any ideas?
I am running sql server 2000 sp3a
SuperSocket info: (SpnRegister) : Error 1355.It's nothing to worry about. SQL has tried to speak to AD for some
registration info :-
http://support.microsoft.com/default.aspx?scid=kb;en-us;303411
--
HTH
Ryan Waight, MCDBA, MCSE
"Rob Baker" <rob_baker123@.yahoo.co.uk> wrote in message
news:d3c6c67d.0311270125.3be0f95f@.posting.google.com...
> I get the following error message in the log every time I reboot sql
> server. I also seem to be experiencing exessive memory usage problems
> with sql server. Any ideas?
> I am running sql server 2000 sp3a
> SuperSocket info: (SpnRegister) : Error 1355.