error: identifier stored proc name is out of scope

Does anyone know what this error message is telling me.

Thanks in advance everyone.

RBCan you show us the code that is generating this error?

Terri|||Terri,

 Public Shared Function GetSelectedFunds() As DataTable
 'Dim GlobalConnString As String = System.Configuration.ConfigurationSettings.AppSettings("ConnectionString")
 'Dim SelectedCenter As Integer = ddlCenters.SelectedItem.Value
 Try
 Return ExecuteDataset(SqlHelper.GlobalConnString, CommandType.StoredProcedure, "GetSelectedFOIFunds", New SqlParameter("@.ParentFund", Test.SelectedCenter)).Tables(0)
 Catch Ex As Exception
 Throw New ApplicationException("An error occurred while executing GetSelectedFunds", Ex)
 End Try
 End Function
 Sub subCenterListChange(ByVal S As Object, ByVal E As EventArgs)
 SelectedCenter = ddlCenters.SelectedItem.Value
 ddlFOI.DataSource = GetSelectedFunds()
 ddlFOI.DataBind()
 End Sub

What i'm trying to do is once a user makes a selection on the first dropdown list then I want to fire off the second drop down list and fill it with a result set that is based on the first selection.

For some reason it is not firing off and it is saying the following:

''error: identifier 'stored procedure name' is out of scope'

Any help is appricated:

Thanks again

RB

Error: Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options

Hi,
SQLServer 2000, using an OPENDATASOURCE command within a stored procedure to
access data on another Server running 2000. I get the following error, whe
n I exececute the Stored Procedure in Query Analyzer:
Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be
set for the connection. This ensures consistent query semantics. Enable the
se options and then reissue your query.
Interestingly, when I issue the identicl select statement within Query Analy
zer, it works fine.
I tried issuing a "Set ANSI_NULLS OFF" etc commands prior, to no avail.
THanks for any help.
JimReview the information in BOL regarding "set ansi_nulls" - pay special
attention to the information about stored procedures. Then review the notes
for "create procedure" - it reiterates the previous point and adds some
additional information. Then - go fix your procedure. Note that using EM
to do this makes the process that much more difficult, since it tends to
hide important details (like this). Instead, use QA and a script to create
the procedure. Of course, you should be using scripts of some sort since
all code for the database (schema, stored procedures, UDFs, triggers, etc)
are as important to the entire system as your application code.
BTW - you want to set ansi_nulls ON, not OFF. Generally, something that is
"set" means it is set "on".|||Generally the error is due to needing to set the properties
when you create the stored procedure. Try recreating your
stored procedure using:
SET ANSI_NULLS ON
GO
SET ANSI_WARNINGS ON
GO
CREATE PROCEDURE YourStoredProc...etc.
-Sue
On Thu, 21 Sep 2006 14:58:30 -0700, "Jim Fox"
<jim.fox@.emailhdi.com> wrote:

>Hi,
>SQLServer 2000, using an OPENDATASOURCE command within a stored procedure t
o access data on another Server running 2000. I get the following error, wh
en I exececute the Stored Procedure in Query Analyzer:
>Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to b
e set for the connection. This ensures consistent query semantics. Enable th
ese options and then reissue your query.
>Interestingly, when I issue the identicl select statement within Query Anal
yzer, it works fine.
>I tried issuing a "Set ANSI_NULLS OFF" etc commands prior, to no avail.
>THanks for any help.
>Jim|||Thanks - Much appreciated!
"Scott Morris" <bogus@.bogus.com> wrote in message
news:%23VbpjNk3GHA.5092@.TK2MSFTNGP04.phx.gbl...
> Review the information in BOL regarding "set ansi_nulls" - pay special
> attention to the information about stored procedures. Then review the
> notes for "create procedure" - it reiterates the previous point and adds
> some additional information. Then - go fix your procedure. Note that
> using EM to do this makes the process that much more difficult, since it
> tends to hide important details (like this). Instead, use QA and a script
> to create the procedure. Of course, you should be using scripts of some
> sort since all code for the database (schema, stored procedures, UDFs,
> triggers, etc) are as important to the entire system as your application
> code.
> BTW - you want to set ansi_nulls ON, not OFF. Generally, something that
> is "set" means it is set "on".
>|||Along these lines, I am calling a trigger that runs an
insert/update/delete on a linked server table, and am running into the
same issues. However, setting ANSI_NULLS or ANSI_WARNINGS in the
trigger itself does not help out at all...
I've been on the phone with MS all day, and am looking for a fresh
perspective...
My trigger is this:
CREATE TRIGGER opsCompany_Insert ON [dbo].[RM00101]
FOR INSERT
AS
SET ANSI_DEFAULTS ON
-- SET THE DB NAME / DO THIS FOR EACH COMPANY DB --
DECLARE @.CompanyDB CHAR(5)
SELECT @.CompanyDB = (SELECT 'TWO')
-- Set Company Number
DECLARE @.CompanyNumber CHAR(15)
SELECT @.CompanyNumber = (SELECT CUSTNMBR FROM INSERTED)
-- Set Company Name
DECLARE @.CompanyName CHAR(65)
SELECT @.CompanyName = (SELECT CUSTNAME FROM INSERTED)
-- Set Currency ID
DECLARE @.CurrencyID CHAR(15)
SELECT @.CurrencyID = (SELECT CURNCYID FROM INSERTED)
-- Set GovernmentID
DECLARE @.GovernmentID CHAR(25)
SELECT @.GovernmentID = (SELECT TXRGNNUM FROM INSERTED)
-- DEX_ROW_ID
DECLARE @.MstrID INT
SELECT @.MstrID = (SELECT DEX_ROW_ID FROM INSERTED)
-- Push to Cranberry
INSERT INTO SQLSVR.TESTDATA.dbo.Company (GPCompanyID, CompanyNumber,
CompanyName, CurrencyID, GovernmentID, CompanyDB, AddedBy, AddedOn)
VALUES (@.MstrID, @.CompanyNumber, @.CompanyName, @.CurrencyID,
@.GovernmentID, @.CompanyDB, user, getdate())
I can run the trigger fine to a local database, but to the linked
server, I get the same 'Heterogeneous' error... I ahve set it up from
QA with
SET ANSI_NULLS, ANSI_WARNINGS ON
GO
Create Trigger ...
And also setting it within the trigger right after 'AS'
However still no luck...
Any thoughts?
Thanks!
Jim Fox wrote:[vbcol=seagreen]
> Thanks - Much appreciated!
> "Scott Morris" <bogus@.bogus.com> wrote in message
> news:%23VbpjNk3GHA.5092@.TK2MSFTNGP04.phx.gbl...|||> Along these lines, I am calling a trigger that runs an
> insert/update/delete on a linked server table, and am running into the
> same issues. However, setting ANSI_NULLS or ANSI_WARNINGS in the
> trigger itself does not help out at all...
These are connection level settings - for the most part. Stored procedures
have their own wrinkle to this. Ultimately, the issue is the same. You
must use the appropriate connection-level settings for this architecture to
work. Ideally, your client application should be designed to enforce the
appropriate settings. If you can't do that, then the only other option
that I can see is to put your logic for accessing the remote DB into a
procedure. Your procedure must be created with the "sticky" settings that
are needed and can set the others that are needed within the body of the
procedure. I think that approach will work, but I've not investigated all
of the issues to know for certain. Note - your trigger code does not
support mult-row inserts, making the use of a stored procedure much easier
(and as technically flawed the trigger).
Some other alternatives you might want to consider.
* Some form of replication.
* Some form of asynchronous queueing of updates.sql

Error: Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options

Hi,
SQLServer 2000, using an OPENDATASOURCE command within a stored procedure to access data on another Server running 2000. I get the following error, when I exececute the Stored Procedure in Query Analyzer:
Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query.
Interestingly, when I issue the identicl select statement within Query Analyzer, it works fine.
I tried issuing a "Set ANSI_NULLS OFF" etc commands prior, to no avail.
THanks for any help.
Jim
Review the information in BOL regarding "set ansi_nulls" - pay special
attention to the information about stored procedures. Then review the notes
for "create procedure" - it reiterates the previous point and adds some
additional information. Then - go fix your procedure. Note that using EM
to do this makes the process that much more difficult, since it tends to
hide important details (like this). Instead, use QA and a script to create
the procedure. Of course, you should be using scripts of some sort since
all code for the database (schema, stored procedures, UDFs, triggers, etc)
are as important to the entire system as your application code.
BTW - you want to set ansi_nulls ON, not OFF. Generally, something that is
"set" means it is set "on".
|||Generally the error is due to needing to set the properties
when you create the stored procedure. Try recreating your
stored procedure using:
SET ANSI_NULLS ON
GO
SET ANSI_WARNINGS ON
GO
CREATE PROCEDURE YourStoredProc...etc.
-Sue
On Thu, 21 Sep 2006 14:58:30 -0700, "Jim Fox"
<jim.fox@.emailhdi.com> wrote:

>Hi,
>SQLServer 2000, using an OPENDATASOURCE command within a stored procedure to access data on another Server running 2000. I get the following error, when I exececute the Stored Procedure in Query Analyzer:
>Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query.
>Interestingly, when I issue the identicl select statement within Query Analyzer, it works fine.
>I tried issuing a "Set ANSI_NULLS OFF" etc commands prior, to no avail.
>THanks for any help.
>Jim
|||Thanks - Much appreciated!
"Scott Morris" <bogus@.bogus.com> wrote in message
news:%23VbpjNk3GHA.5092@.TK2MSFTNGP04.phx.gbl...
> Review the information in BOL regarding "set ansi_nulls" - pay special
> attention to the information about stored procedures. Then review the
> notes for "create procedure" - it reiterates the previous point and adds
> some additional information. Then - go fix your procedure. Note that
> using EM to do this makes the process that much more difficult, since it
> tends to hide important details (like this). Instead, use QA and a script
> to create the procedure. Of course, you should be using scripts of some
> sort since all code for the database (schema, stored procedures, UDFs,
> triggers, etc) are as important to the entire system as your application
> code.
> BTW - you want to set ansi_nulls ON, not OFF. Generally, something that
> is "set" means it is set "on".
>
|||Along these lines, I am calling a trigger that runs an
insert/update/delete on a linked server table, and am running into the
same issues. However, setting ANSI_NULLS or ANSI_WARNINGS in the
trigger itself does not help out at all...
I've been on the phone with MS all day, and am looking for a fresh
perspective...
My trigger is this:
CREATE TRIGGER opsCompany_Insert ON [dbo].[RM00101]
FOR INSERT
AS
SET ANSI_DEFAULTS ON
-- SET THE DB NAME / DO THIS FOR EACH COMPANY DB --
DECLARE @.CompanyDB CHAR(5)
SELECT @.CompanyDB = (SELECT 'TWO')
-- Set Company Number
DECLARE @.CompanyNumber CHAR(15)
SELECT @.CompanyNumber = (SELECT CUSTNMBR FROM INSERTED)
-- Set Company Name
DECLARE @.CompanyName CHAR(65)
SELECT @.CompanyName = (SELECT CUSTNAME FROM INSERTED)
-- Set Currency ID
DECLARE @.CurrencyID CHAR(15)
SELECT @.CurrencyID = (SELECT CURNCYID FROM INSERTED)
-- Set GovernmentID
DECLARE @.GovernmentID CHAR(25)
SELECT @.GovernmentID = (SELECT TXRGNNUM FROM INSERTED)
-- DEX_ROW_ID
DECLARE @.MstrID INT
SELECT @.MstrID = (SELECT DEX_ROW_ID FROM INSERTED)
-- Push to Cranberry
INSERT INTO SQLSVR.TESTDATA.dbo.Company (GPCompanyID, CompanyNumber,
CompanyName, CurrencyID, GovernmentID, CompanyDB, AddedBy, AddedOn)
VALUES (@.MstrID, @.CompanyNumber, @.CompanyName, @.CurrencyID,
@.GovernmentID, @.CompanyDB, user, getdate())
I can run the trigger fine to a local database, but to the linked
server, I get the same 'Heterogeneous' error... I ahve set it up from
QA with
SET ANSI_NULLS, ANSI_WARNINGS ON
GO
Create Trigger ...
And also setting it within the trigger right after 'AS'
However still no luck...
Any thoughts?
Thanks!
Jim Fox wrote:[vbcol=seagreen]
> Thanks - Much appreciated!
> "Scott Morris" <bogus@.bogus.com> wrote in message
> news:%23VbpjNk3GHA.5092@.TK2MSFTNGP04.phx.gbl...
|||> Along these lines, I am calling a trigger that runs an
> insert/update/delete on a linked server table, and am running into the
> same issues. However, setting ANSI_NULLS or ANSI_WARNINGS in the
> trigger itself does not help out at all...
These are connection level settings - for the most part. Stored procedures
have their own wrinkle to this. Ultimately, the issue is the same. You
must use the appropriate connection-level settings for this architecture to
work. Ideally, your client application should be designed to enforce the
appropriate settings. If you can't do that, then the only other option
that I can see is to put your logic for accessing the remote DB into a
procedure. Your procedure must be created with the "sticky" settings that
are needed and can set the others that are needed within the body of the
procedure. I think that approach will work, but I've not investigated all
of the issues to know for certain. Note - your trigger code does not
support mult-row inserts, making the use of a stored procedure much easier
(and as technically flawed the trigger).
Some other alternatives you might want to consider.
* Some form of replication.
* Some form of asynchronous queueing of updates.

Error: Generating Instances in SQL Server is disabled...

Use sp_configure 'user instances enabled' to generate user instances.

I get the above error when I attempt to add an SQL Database item into my VS (C#) project. I do not understand what needs to be done to correct the problem.

Any help is appreciated.

Thank You,

Klaus

From SQL Server 2005 Books Onlinetopic:

user instances enabled Option

http://msdn2.microsoft.com/en-us/library/ms187513.aspx

The user instance enabled option that you can access through sp_configure is not supported in Microsoft SQL Server 2005. This option works only with SQL Server 2005 Express Edition (SQL Server Express).

For more information about how user instances work, see User Instances for Non-Administrators.

User Instances for Non-Administrators

http://msdn2.microsoft.com/en-us/library/ms143684.aspx

Error: Forward dependencies are not valid

I want to set a Report Parameter on a field. The Report Parameter is called 'filter'. In the statement I put the Report Parameter in the WHERE-part:
WHERE ([DatabaseName$TableName].[FieldName] = @.filter). After this I set the 'Available values' on the Report Parameter in the lay-out to Non-queried.
When the report is running, no problems.

But.....

Now I want to set 'Available values' on 'From Query' and refer to the data set, so the user can choose on which value he want to filter. But now, after running the preview the following error displays:
Error1[rsInvalidReportParameterDependency]The report parameter ‘filter’ has a DefaultValue or a ValidValue that depends on the report parameter “filter”. Forward dependencies are not valid.

Why can't I set the Report Parameter to 'From Query'? Anyone any suggestions?

(you can see the rest of my statement here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1098540&SiteID=1)

Thx a lot of helping me out with this topic.....

Hi,

If I get it right, you have a dataset that you want to filter by a parameter 'FILTER' and the possible values for the filter also from the same dataset?

This is not possible since if you are requesting the possible values for the filter he will execute the query in the dataset. Since this dataset requires a parameter filter to be able to execute, you are having a loop.

What you should do is to make the 'From Query' property refer to a different dataset.

NOTE: Reporting Services first performs the queries in the same order as the Parameters have been set. Therefor, if the dataset of a given parameter needs the value of a second parameter, you need to make sure that this second parameter is standing above the first parameter in the parameter list.

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

Geert,

thx for your support. I've found a solution for my specific situation. I will drop it here for others with the same problem:

1. Report Parameter, Available non-queried.
- At Label I've filled in the options that I want to see in the pulldown menu.
- At Value I've filled in the values form my table (in this case only 4 or 5)
2. At the table properties, tab filtering I've made a filterlist called
- expression: =Fields!FieldName.Value
- operator: '='
- value : =Parameters!ParameterName.Value

This solution is only usefull if you don't have too much options to choose (because you have to fill in all the options manually..... )

Error: File /iisHelp/common/500-100.asp Line 0 Out of memory.

Hi
i am getting the this error now a days. can help me out
because my IIS server geting very slow & also i have to
restart the IIS Server every time also when this DLHOST
coming that time My IIS server get Problem.
can help me out & give us what could be the problem it is
very urg for us i am facing very Big problem
here i am sending the error Log from eventViewr
Error: File /iisHelp/common/500-100.asp Line 0 Out of
memory. Unable to allocate required memory..
For additional information specific to this message please
visit the Microsoft Online Support site located at:
http://www.microsoft.com/contentredirect.asp.What does this have to do with SQL Server?
--
http://www.aspfaq.com/
(Reverse address to reply.)
"sanjaypawar@.hotmail.com" <anonymous@.discussions.microsoft.com> wrote in
message news:731e01c47641$2a233a00$a401280a@.phx.gbl...
> Hi
> i am getting the this error now a days. can help me out
> because my IIS server geting very slow & also i have to
> restart the IIS Server every time also when this DLHOST
> coming that time My IIS server get Problem.
> can help me out & give us what could be the problem it is
> very urg for us i am facing very Big problem
> here i am sending the error Log from eventViewr
>
> Error: File /iisHelp/common/500-100.asp Line 0 Out of
> memory. Unable to allocate required memory..
> For additional information specific to this message please
> visit the Microsoft Online Support site located at:
> http://www.microsoft.com/contentredirect.asp.sql

Error: File /iisHelp/common/500-100.asp Line 0 Out of memory.

Hi
i am getting the this error now a days. can help me out
because my IIS server geting very slow & also i have to
restart the IIS Server every time also when this DLHOST
coming that time My IIS server get Problem.
can help me out & give us what could be the problem it is
very urg for us i am facing very Big problem
here i am sending the error Log from eventViewr
Error: File /iisHelp/common/500-100.asp Line 0 Out of
memory. Unable to allocate required memory..
For additional information specific to this message please
visit the Microsoft Online Support site located at:
http://www.microsoft.com/contentredirect.asp.What does this have to do with SQL Server?
http://www.aspfaq.com/
(Reverse address to reply.)
"sanjaypawar@.hotmail.com" <anonymous@.discussions.microsoft.com> wrote in
message news:731e01c47641$2a233a00$a401280a@.phx.gbl...
> Hi
> i am getting the this error now a days. can help me out
> because my IIS server geting very slow & also i have to
> restart the IIS Server every time also when this DLHOST
> coming that time My IIS server get Problem.
> can help me out & give us what could be the problem it is
> very urg for us i am facing very Big problem
> here i am sending the error Log from eventViewr
>
> Error: File /iisHelp/common/500-100.asp Line 0 Out of
> memory. Unable to allocate required memory..
> For additional information specific to this message please
> visit the Microsoft Online Support site located at:
> http://www.microsoft.com/contentredirect.asp.

Error: File /iisHelp/common/500-100.asp Line 0 Out of memory.

Hi
i am getting the this error now a days. can help me out
because my IIS server geting very slow & also i have to
restart the IIS Server every time also when this DLHOST
coming that time My IIS server get Problem.
can help me out & give us what could be the problem it is
very urg for us i am facing very Big problem
here i am sending the error Log from eventViewr
Error: File /iisHelp/common/500-100.asp Line 0 Out of
memory. Unable to allocate required memory..
For additional information specific to this message please
visit the Microsoft Online Support site located at:
http://www.microsoft.com/contentredirect.asp.
What does this have to do with SQL Server?
http://www.aspfaq.com/
(Reverse address to reply.)
"sanjaypawar@.hotmail.com" <anonymous@.discussions.microsoft.com> wrote in
message news:731e01c47641$2a233a00$a401280a@.phx.gbl...
> Hi
> i am getting the this error now a days. can help me out
> because my IIS server geting very slow & also i have to
> restart the IIS Server every time also when this DLHOST
> coming that time My IIS server get Problem.
> can help me out & give us what could be the problem it is
> very urg for us i am facing very Big problem
> here i am sending the error Log from eventViewr
>
> Error: File /iisHelp/common/500-100.asp Line 0 Out of
> memory. Unable to allocate required memory..
> For additional information specific to this message please
> visit the Microsoft Online Support site located at:
> http://www.microsoft.com/contentredirect.asp.

Error: fcb::close-flush: Operating system error 21(The device is not ready.) encountered

We are using sql server 2005 Enterprise Edition with service pack1

I got the following error messages in the SQL log

The operating system returned error 21(The device is not ready.) to SQL Server during a read at offset 0x00000000090000 in file '....mdf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online. fcb::close-flush: Operating system error 21(The device is not ready.) encountered.

I got these errors for about 2 hrs and after that I see these messages in the sql log

Starting up database ' ' 1 transactions rolled forward in database '' (). This is an informational message only. No user action is required. 0 transactions rolled back in database ' ' (). This is an informational message only. No user action is required. Recovery is writing a checkpoint in database ' ' ( ). This is an informational message only. No user action is required. CHECKDB for database '' finished without errors on (local time). This is an informational message only; no user action is required.

Can anyone please help me in troubleshooting this issue. Why this migh have happened.

any help would be appreciated.

Thanks

This sounds like an IO subsystem issue, i.e. SQL Server is having difficulty talking to one of your drives. Are you using direct attached storage or a SAN?|||

Thanks for the reply. We have Netapp SCSI disk storage. Could you please tell me how do I troubleshoot this so that I wont get such errors in future.

Thanks

|||Based on this and what you describe in your other post, you really ought to give Microsoft PSS a call.|||

Do read this kb before contacting PSS. You might be running on an unsupported device.

http://support.microsoft.com/kb/304261

ERROR: Failure to compile WMI file

I received this error at the end of the "Reporting Services" setup.

I checked WMI process in Services and everything is OK, it's running.

So far I was able to install Designer Tools only (unchecking Report Manager and Report server).

All system components are up to date and SQL Server SP3 is installed.

I would highly appreciate it if somebody could help me out. It's now matter of survival to me.

Thanks in advance,

Confused Virginian

You also need SP3a to install Reporting Services. Hope this helps.|||

Caddre,

Thank you for your help. I already have SP3 installed.

Eventually I found the fix, right there:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/reinstalling_wmi.asp

This article explains how to recreate corrupted WMI repository.

Virginian

Error: Failed to load script task

I have an email script that keeps failing to load when I execute my script task. I have the precompileintobinarycode set to true. Anyone know why it won't load the script? I would use the Send Mail task but it can't find my smtp connection or something.

Thanks,

Mike

This error can spontaneously appear for no apparent reason. It seems that if you have the PreCompile property set to True, but you have precompiled script in the package, which is what spontaneously disappears, this error will be raised. To resolve this issue:

a. Open the package

b. Open the Script Task editor

c. Click Design Script

d. Close the VSA Editor

e. Close the Script Task Editor

f. Save and close the package.

|||

didn't work I still get the same error.

sql

Error: Failed to load script task

I have an email script that keeps failing to load when I execute my script task. I have the precompileintobinarycode set to true. Anyone know why it won't load the script? I would use the Send Mail task but it can't find my smtp connection or something.

Thanks,

Mike

This error can spontaneously appear for no apparent reason. It seems that if you have the PreCompile property set to True, but you have precompiled script in the package, which is what spontaneously disappears, this error will be raised. To resolve this issue:

a. Open the package

b. Open the Script Task editor

c. Click Design Script

d. Close the VSA Editor

e. Close the Script Task Editor

f. Save and close the package.

|||

didn't work I still get the same error.

Error: Failed to generate a user instance...

Hello,

When trying to add a new SQL database to a VS 2005 project I get this error:

Failed to generate a user instance of SQL server due to a failure in starting the process for the user instance. The connection will be closed. [CLIENT: <local machine>]

Any ideas what is causing this error and how to fix it?

Thanks

Tom

Hi Tom,

This question has been discussed several times in this forum, you should do a search and read other discussions to see if they address your issue.

The first step in troubleshooting this is to look at the User Instance error log located at C:\Documents and Settings\<user>\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\<main instance name> (The default instance name is SQLEXPRESS) and see if it give any clues to the cause of the error.

Regards,

Mike Wachal
SQL Express team

-
Please mark your thread as Answered when you get your solution.

Error: Expected End of Statement

I just don't see it (SSRS 2005 Expression Syntax Error):

=((Fields!PostedAmount_InHouse.Value + Fields!NewPDs_Check.Value + Fields!NewCCs_Check.Value) / Fields!CurrentPostingDay.Value) * (Fields!TotalPostingDays.Value - Fields!CurrentPostingDay.Value) + (Fields!PostedAmount_InHouse.Value + Fields!OldPDs_Check.Value + Fields!NewPDs_Check.Value + Fields!OldCCs_Check.Value + Fields!NewCCs_Check.Value) * Fields!FeeSchedule.Value)) / 100

Error: Expected End of Statement

4( + 6) = Error: Expected Endof Statement

Error: Event id: 208 @ Copy Database Wizard

Can anyone help me?

When i Use the copy database wizard @.sql 2005 at the last step

i get these 2 Error's in the log's

Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 208
Date: 14-8-2006
Time: 13:28:40
User: N/A
Computer: SERVER01

Description:
SQL Server Scheduled Job 'CDW_NAME_0' (0x883C948F64FCAA49BEA22068F4C7E15A) - Status: Failed - Invoked on: 2006-08-14 13:28:19 - Message: The job failed. The Job was invoked by User Domain\Administrator. The last step to run was step 1 (CDW_NAME_0_Step).

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Event Type: Error
Event Source: SQLISPackage
Event Category: None
Event ID: 12291
Date: 14-8-2006
Time: 13:28:40
User: Domain\Administrator
Computer: SERVER01
Description:
Package "CDW_NAME_0" failed.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

I have the same error on SQL 2005 enterprise, am trying to copy a 2000 database into 2005. Should work but fails on copy.|||

I'm moving this over to the tools forum since they have more experience with CDW.

Thanks,
Sam

|||DID YOU FIND ANYTHING ON THIS PROBLEM|||

what is the service pack on this box. You should apply SP2 and also check whether SSIS (Integration Service) is installed or not

Madhu

|||THERE IS SP2 AND THE INTEGRATION SERVICE IS STARTED AS ADMNISTRATOR

Error: Event id: 208 @ Copy Database Wizard

Can anyone help me?

When i Use the copy database wizard @.sql 2005 at the last step

i get these 2 Error's in the log's

Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 208
Date: 14-8-2006
Time: 13:28:40
User: N/A
Computer: SERVER01

Description:
SQL Server Scheduled Job 'CDW_NAME_0' (0x883C948F64FCAA49BEA22068F4C7E15A) - Status: Failed - Invoked on: 2006-08-14 13:28:19 - Message: The job failed. The Job was invoked by User Domain\Administrator. The last step to run was step 1 (CDW_NAME_0_Step).

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Event Type: Error
Event Source: SQLISPackage
Event Category: None
Event ID: 12291
Date: 14-8-2006
Time: 13:28:40
User: Domain\Administrator
Computer: SERVER01
Description:
Package "CDW_NAME_0" failed.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

I have the same error on SQL 2005 enterprise, am trying to copy a 2000 database into 2005. Should work but fails on copy.|||

I'm moving this over to the tools forum since they have more experience with CDW.

Thanks,
Sam

|||DID YOU FIND ANYTHING ON THIS PROBLEM|||

what is the service pack on this box. You should apply SP2 and also check whether SSIS (Integration Service) is installed or not

Madhu

|||THERE IS SP2 AND THE INTEGRATION SERVICE IS STARTED AS ADMNISTRATORsql

Error: Email Subscription to Report (Sharepoint Integrated Mode) Options

I encounter this error when user try to subscribe using email delivery
to one of the report. I have configured the Reporting Services to use
Sharepoint integrated mode. This user is a regular user that has read
access to the report item.

Below is the message detail:

A subscription delivery error has occurred. (rsDeliveryError)
A subscription delivery error has occurred. (rsDeliveryError)
One of the extension parameters is not valid for the following reason:
The account you are using does not have administrator privileges. A
subscription cannot be created for [emailaddress].
(rsInvalidExtensionParameter)

Is it true that user needs to have administrator privilege in order to
subscribe for report? I don't think so, right?

Regards,
Gunady Ng

Hi Gunady,

Non-admin users can only send a report to an email address that is specified in the SharePoint user profile for that user. Can you check the "TO" field and ensure that the email address is that of the user as seen in the SharePoint user profile?

Thanks,

Sharmila

|||

Thank you for the answer. Is this restriction apply to cc or bcc as well?

Regards,

Gunady Ng

|||

Yes, it applies to all.

Thanks,
Sharmila

|||

is there a way around this?

Is there a way to setup on per-report basis?

I'm using reporting services within sharepoint as a content delivery solution, I need teh users to be able ost chedule reports and have them delivered by email to thair sharpoint drop box and/or to their customers staright from teh subscripton interface

I'm able to do this as admin but I need teh users to be able to do the same

I tried looking in the rsreportsever.config but can not figure out how to do this, I set <sendemailtouseralias>False but still nothing,

I also dont have the otion for CC: or BCC: when I'm loged in with nonadministrative account.

There must be an option for this but I'm not finding it in any documentation

I'm running Reporting Services SP2 in WSS3 integrated mode

Please advice and help...

Thanks

Nik

Error: Email Subscription to Report (Sharepoint Integrated Mode) Options

I encounter this error when user try to subscribe using email delivery
to one of the report. I have configured the Reporting Services to use
Sharepoint integrated mode. This user is a regular user that has read
access to the report item.

Below is the message detail:

A subscription delivery error has occurred. (rsDeliveryError)
A subscription delivery error has occurred. (rsDeliveryError)
One of the extension parameters is not valid for the following reason:
The account you are using does not have administrator privileges. A
subscription cannot be created for [emailaddress].
(rsInvalidExtensionParameter)

Is it true that user needs to have administrator privilege in order to
subscribe for report? I don't think so, right?

Regards,
Gunady Ng

Hi Gunady,

Non-admin users can only send a report to an email address that is specified in the SharePoint user profile for that user. Can you check the "TO" field and ensure that the email address is that of the user as seen in the SharePoint user profile?

Thanks,

Sharmila

|||

Thank you for the answer. Is this restriction apply to cc or bcc as well?

Regards,

Gunady Ng

|||

Yes, it applies to all.

Thanks,
Sharmila

|||

is there a way around this?

Is there a way to setup on per-report basis?

I'm using reporting services within sharepoint as a content delivery solution, I need teh users to be able ost chedule reports and have them delivered by email to thair sharpoint drop box and/or to their customers staright from teh subscripton interface

I'm able to do this as admin but I need teh users to be able to do the same

I tried looking in the rsreportsever.config but can not figure out how to do this, I set <sendemailtouseralias>False but still nothing,

I also dont have the otion for CC: or BCC: when I'm loged in with nonadministrative account.

There must be an option for this but I'm not finding it in any documentation

I'm running Reporting Services SP2 in WSS3 integrated mode

Please advice and help...

Thanks

Nik

Error: Email Subscription to Report (Sharepoint Integrated Mode) Options

I encounter this error when user try to subscribe using email delivery
to one of the report. I have configured the Reporting Services to use
Sharepoint integrated mode. This user is a regular user that has read
access to the report item.

Below is the message detail:

A subscription delivery error has occurred. (rsDeliveryError)
A subscription delivery error has occurred. (rsDeliveryError)
One of the extension parameters is not valid for the following reason:
The account you are using does not have administrator privileges. A
subscription cannot be created for [emailaddress].
(rsInvalidExtensionParameter)

Is it true that user needs to have administrator privilege in order to
subscribe for report? I don't think so, right?

Regards,
Gunady Ng

Hi Gunady,

Non-admin users can only send a report to an email address that is specified in the SharePoint user profile for that user. Can you check the "TO" field and ensure that the email address is that of the user as seen in the SharePoint user profile?

Thanks,

Sharmila

|||

Thank you for the answer. Is this restriction apply to cc or bcc as well?

Regards,

Gunady Ng

|||

Yes, it applies to all.

Thanks,
Sharmila

|||

is there a way around this?

Is there a way to setup on per-report basis?

I'm using reporting services within sharepoint as a content delivery solution, I need teh users to be able ost chedule reports and have them delivered by email to thair sharpoint drop box and/or to their customers staright from teh subscripton interface

I'm able to do this as admin but I need teh users to be able to do the same

I tried looking in the rsreportsever.config but can not figure out how to do this, I set <sendemailtouseralias>False but still nothing,

I also dont have the otion for CC: or BCC: when I'm loged in with nonadministrative account.

There must be an option for this but I'm not finding it in any documentation

I'm running Reporting Services SP2 in WSS3 integrated mode

Please advice and help...

Thanks

Nik

Error: duplicate key row

What might cause the following error when inserting rows in tables that have primary keys defined as IDENTITY (1,1)?

duplicate key row in object 'aa' with unique index 'aa'

I have seen this happen frequently when data has been bulk loaded sometime in the past into a table that has an IDENTITY key. This is especially common when you have a test environment in which some production data was bulk loaded to give some "good test data." To me it means that an identity number has "already been used" as a record key.

Dave

|||The rows are inserted one at a time using the parent IDENTITY key as a FK constraint in the child table which also has an IDENTITY KEY. However, this scenario does not sound like it would cause an error.|||

Can you post the table structures? That would help us to see what your problem might be.

If you can post a few statements that cause the duplicates, that would even be better.

|||

If you have the property NOT FOR REPLICATION enabled for the identity column.

Merging changes would allow the exact id values to be inserted rather than a new value that would give the error if same id value exists in the participating server.

similarly, if you are trying to insert manually using SET IDENTITY_INSERT table ON...