error handling flow: following

Showing posts with label following. Show all posts

Thursday, March 29, 2012

error loading the report in the designer

Hi all,
I'm working on rs2005, and i cannot load any server report in the
designer.
i get the following error:
"One or more errors encountered while loading the designer. The errors
are listed below.
Exception has been thrown by the target of an invocation "
I can load local reports, and i can load the server reports on other
computers.
It just suddenly stopped working in my laptop, and no reinstallation
helps (at least not the visual studio, framework, or the report server)
Does anyone hav an idea?
Thanks,
EyalWell, i found the solution eventually,
After getting a message "font verdana does not support style regular"
while trying to load a winforms into the designer, i deleted all my
fonts from my computer, and copied them from another computer.
both the winform problem and the reporting services problem has gone
forever.
it seems that a corrupted font has crashed the visual studio designer.
Eyal
Eyal =EB=FA=E1:
> Hi all,
> I'm working on rs2005, and i cannot load any server report in the
> designer.
> i get the following error:
> "One or more errors encountered while loading the designer. The errors
> are listed below.
> Exception has been thrown by the target of an invocation "
> I can load local reports, and i can load the server reports on other
> computers.
> It just suddenly stopped working in my laptop, and no reinstallation
> helps (at least not the visual studio, framework, or the report server)
> > Does anyone hav an idea?
> Thanks,
> Eyal

Error loading 'IntegrationServicesRules' assembly in Best Practice Analyzer 2005 CTP

Hi,

I get the following error when trying to scan *.dtsx files in Best Practice Analyzer 2005 CTP:

15:47:02.609: Could not load file or assembly 'IntegrationServicesRules, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

Does a fix/workaround for this error exist?

Also, the BPA 2005 CTP seems to have problems with internet updating.

Thanks in advance,

Niels

What version of SQL Server are you running?
What version of Windows are you running?
Do you have the client tools installed on the same machine as SQL Server 2005 BPA?

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

|||

SQL Server 2005 on XP SP2 - more version details below:

Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

The client tools are installed on the same machine as BPA 2005 CTP.

|||

We have confirmed this to be a bug in the CTP release. Thanks for reporting this. It has been fixed in the next release. We will be shipping the next version within the next 6 weeks.

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

Error loading http://localhost/ReportServer

Hi!

I've installed the Report Server but when I try to go to http://localhost/ReportServer I get the following error:

Reporting Services Error

An internal error occurred on the report server. See the error log for more details. (rsInternalError)

And the log in the c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\SQLDUMPER_ERRORLOG.log file is this:

12/01/06 12:51:40, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 5344
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x0A0F2A04
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
12/01/06 12:51:42, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
12/01/06 12:51:42, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\Archivos de programa\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\SQLDmpr0058.mdmp
12/01/06 12:51:42, ACTION, aspnet_wp.exe, Watson Invoke: No

Does anybody have which could be the problem?

Thanks in advance! :)

Tomas,

I have the exact same problem. Did you ever solve your problem?

|||

Hi Chuck,

Yes, I solved this problem deleting from the web.config (folders ReportServer and/or ReportManaget) this:

xmlns=http://schemas.microsoft.com/.NetConfiguration/v2.0

If you have more problems (I had :) ) tell me and I'll try to help you: eltommy@.gmail.com

Good luck!!!

|||

Hi Tomás

I′m having the same problem

When I go to Initialization in Configure Reporting Server the error is :

There was an error while switching panels. The most likely cause is an error retrieving VMI properties. The exceptions details are:

An internal error occurred on the report server. See the error log for more details. (rsInternalError)

I didn′t found the line that you mentioned

Bellow is my web.config. I tried to erase :xmlns="urn:schemas-microsoft-com:asm.v1, but I haven′t success.

Thanks in advance

Consuelo

<?xml version="1.0" encoding="utf-8"?>
<configuration>
<configSections>
<section name="MicrosoftWebControls" type="System.Configuration.NameValueSectionHandler, System, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089, processorArchitecture=MSIL"/>
<section name="RStrace" type="Microsoft.ReportingServices.Diagnostics.RSTraceSectionHandler,Microsoft.ReportingServices.Diagnostics"/>
<section name="UIConfig" type="Microsoft.ReportingServices.UI.UIConfigSectionHandler,ReportingServicesWebUserInterface"/>
</configSections>
<system.net>
<defaultProxy enabled="false"/>
</system.net>
<system.web>
<pages validateRequest="false"/>
<compilation defaultLanguage="c#" debug="false"/>
<customErrors mode="Off"/>
<authentication mode="Windows"/>
<identity impersonate="true"/>
<trace enabled="false" requestLimit="10" pageOutput="false" traceMode="SortByTime" localOnly="true"/>
<sessionState mode="InProc" cookieless="false" timeout="20"/>
<globalization requestEncoding="utf-8" responseEncoding="utf-8"/>
<httpRuntime executionTimeout="9000"/>
<securityPolicy>
<trustLevel name="RosettaMgr" policyFile="rsmgrpolicy.config"/>
</securityPolicy>
<trust level="RosettaMgr" originUrl=""/>
<httpHandlers>
<add verb="*" path="Reserved.ReportViewerWebControl.axd" type="Microsoft.Reporting.WebForms.HttpHandler, ReportingServicesWebUserInterface, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/>
</httpHandlers>
</system.web>
<appSettings>
<add key="ReportViewerServerConnection" value="Microsoft.ReportingServices.UI.WebControlConnection, ReportingServicesWebUserInterface, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/>
<add key="ReportViewerTemporaryStorage" value="Microsoft.ReportingServices.UI.ReportViewerTemporaryStorage, ReportingServicesWebUserInterface, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/>
</appSettings>
<RStrace>
<add name="FileName" value="ReportServerWebApp_"/>
<add name="Prefix" value="tid, time"/>
<add name="TraceListeners" value="debugwindow, file"/>
<add name="TraceFileMode" value="unique"/>
<add name="Components" value="all"/>
</RStrace>
<system.diagnostics>
<switches>

<add name="DefaultTraceSwitch" value="3"/>
</switches>
</system.diagnostics>
<runtime>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
<assemblyIdentity name="Microsoft.ReportingServices.Interfaces" publicKeyToken="89845dcd8080cc91" culture="neutral"/>
<bindingRedirect oldVersion="8.0.242.0" newVersion="9.0.242.0"/>
</dependentAssembly>
</assemblyBinding>
</runtime>
</configuration>

|||

I found a solution

I was with SQL SERVER 2000 and 2005 installed. I desinstalled both and erased ReportServer and Reports folders in IIS, after that installed just SQL SERVER 2005. Now it′s ok.

|||I'm very happy about you Consuelo, this kind of issues are very stressing and in your case it was difficult to find the solution. Congratulations!!! :)sql

Error loading http://localhost/ReportServer

Hi!

I've installed the Report Server but when I try to go to http://localhost/ReportServer I get the following error:

Reporting Services Error

An internal error occurred on the report server. See the error log for more details. (rsInternalError)

And the log in the c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\SQLDUMPER_ERRORLOG.log file is this:

Does anybody have which could be the problem?

Thanks in advance! :)

Tomas,

I have the exact same problem. Did you ever solve your problem?

|||

Hi Chuck,

Yes, I solved this problem deleting from the web.config (folders ReportServer and/or ReportManaget) this:

xmlns=http://schemas.microsoft.com/.NetConfiguration/v2.0

If you have more problems (I had :) ) tell me and I'll try to help you: eltommy@.gmail.com

Good luck!!!

|||

Hi Tomás

I′m having the same problem

When I go to Initialization in Configure Reporting Server the error is :

There was an error while switching panels. The most likely cause is an error retrieving VMI properties. The exceptions details are:

An internal error occurred on the report server. See the error log for more details. (rsInternalError)

I didn′t found the line that you mentioned

Bellow is my web.config. I tried to erase :xmlns="urn:schemas-microsoft-com:asm.v1, but I haven′t success.

Thanks in advance

Consuelo

|||

I found a solution

I was with SQL SERVER 2000 and 2005 installed. I desinstalled both and erased ReportServer and Reports folders in IIS, after that installed just SQL SERVER 2005. Now it′s ok.

|||I'm very happy about you Consuelo, this kind of issues are very stressing and in your case it was difficult to find the solution. Congratulations!!! :)

Error Loading : sqlceme30.dll

Dear All,

Please let me know how I can overcome the following Error.

System.InvalidOperationException was unhandled
Message="An error occurred creating the form. See Exception.InnerException for details. The error is: Unable to load DLL 'sqlceme30.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)"
Source="RDA_Dummy"
StackTrace:
at RDA_Dummy.My.MyProject.MyForms.Create__Instance__[T](T Instance) in 17d14f5c-a337-4978-8281-53493378c1071.vb:line 190
at RDA_Dummy.My.MyProject.MyForms.get_frmMain()
at RDA_Dummy.My.MyApplication.OnCreateMainForm() in C:\Test\My Project\Application.Designer.vb:line 35
at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.OnRun()
at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.DoApplicationModel()
at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.Run(String[] commandLine)
at RDA_Dummy.My.MyApplication.Main(String[] Args) in 17d14f5c-a337-4978-8281-53493378c1071.vb:line 81
at System.AppDomain.nExecuteAssembly(Assembly assembly, String[] args)
at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()

Regards,

SEe this http://blogs.msdn.com/smartclientdata/archive/2005/07/15/439008.aspx blog is any help.|||

Hi,

Thank you for your respond... It was detailed enough.

However I am facing an issue on Deployment, so I submited this to Smart Device Forum. "Pls Refer below Link"

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

This gives me another answer, please assist me in this case.

THnakx

Error loading 'IntegrationServicesRules' assembly in Best Practice Analyzer 2005 CTP

Hi,

I get the following error when trying to scan *.dtsx files in Best Practice Analyzer 2005 CTP:

Does a fix/workaround for this error exist?

Also, the BPA 2005 CTP seems to have problems with internet updating.

Thanks in advance,

Niels

What version of SQL Server are you running?
What version of Windows are you running?
Do you have the client tools installed on the same machine as SQL Server 2005 BPA?

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

|||

SQL Server 2005 on XP SP2 - more version details below:

The client tools are installed on the same machine as BPA 2005 CTP.

|||

We have confirmed this to be a bug in the CTP release. Thanks for reporting this. It has been fixed in the next release. We will be shipping the next version within the next 6 weeks.

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

Error is SQL block

I want to know the error in the following SQL block,

I want to know, what is the error in the below block,

BEGIN

Declare @.StoreIdasvarchar(20)

Declare @.DepartmentIdasvarchar(20)

Declare @.VendorNumberasvarchar(20)

Declare @.SortByasint

Declare @.AllVendorSelectedasint

Declare @.SQLasnvarchar(500)

Set @.StoreId='1'

Set @.DepartmentId='NONE'

Set @.VendorNumber='NONE'

Set @.SortBy= 0

Set @.AllVendorSelected= 0

SET @.SQL='SELECT

Inventory.ItemNum

,Inventory.ItemName

,Inventory.ItemName_Extra

,Inventory.Dept_ID

,Inventory.In_Stock

,Inventory.Cost

,Inventory.Price

,Inventory.NumBoxes

,Inventory.NumPerCase

,Inventory.Store_ID

,Departments.Description

FROM

Inventory

INNER JOIN Departments ON Inventory.Store_ID = Departments.Store_ID AND Inventory.Dept_ID = Departments.Dept_ID

LEFT OUTER JOIN Inventory_Vendors ON Inventory.ItemNum = Inventory_Vendors.ItemNum AND Inventory.Store_ID = Inventory_Vendors.Store_ID

WHERE

Inventory.Store_Id in (@.StoreId)

AND Inventory.Dept_ID in (@.DepartmentId)

AND (@.AllVendorSelected = 1 OR Inventory_Vendors.Vendor_Number in (@.VendorNumber))'

IF(@.SortBy= 0)

SET @.SQL= @.SQL+'ORDER BY Inventory.ItemNum'

ELSE

SET @.SQL= @.SQL+'ORDER BY Inventory.ItemName'

EXEC @.SQL

END

I see several errors, mostly to do with this.

WHERE

Inventory.Store_Id in (@.StoreId)

AND Inventory.Dept_ID in (@.DepartmentId)

AND (@.AllVendorSelected = 1 OR Inventory_Vendors.Vendor_Number in (@.VendorNumber))'

|||

I hate this editor.

Anyway, you can't stick @.StoreId in there like that if it may ever have multiples (I see a single here, but assume it's a test or you would not use IN). You need to use '+@.StoreId+' instead. Same goes for the other fields like that.

sql

Tuesday, March 27, 2012

Error installing SQL server 2005 SP2 - "Machine does not have a product that matches the in

Hi,

While I am trying to install SQL server 2005 I get the following message - "Machine does not have a product that matches the installation package". The installation does not occur.

I am using Windows 2000 Professional SP4 and using 32 bit installer - SQLServer2005SP2-KB921896-x86-ENU.exe

Help would be appreciated... thanks.

Regards,

Ravindranath Kini

Other than Sql server 2005 enterprise edition you can install everything with Windows 2000 SP..........can you provide the details available in Summary.txt file available in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG.

Refer the system requirements http://technet.microsoft.com/en-us/library/ms143506.aspx

|||

SQLServer2005SP2-KB921896-x86-ENU.exe is service pack only. Did you installed SQL Server 2005 on your computer? Moreover, this service pack doesn't support SQL Server 2005 Express Edition (Microsoft SQL Server 2005 Service Pack 2 http://www.microsoft.com/downloads/details.aspx?FamilyID=d07219b2-1e23-49c8-8f0c-63fa18f26d3a&DisplayLang=en). For SQL Server 2005 Express Edition SP2, please download from http://msdn2.microsoft.com/en-us/express/bb410792.aspx.

|||

Deepak,

The details of Summary.txt are available here.

Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Uninstall : Successful , Reboot required
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0004_BNGWIP-D-99927_SQLSupport_1.log
--
Product : MSXML 6.0 Parser (KB933579)
Product Version : 6.10.1200.0
Uninstall : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0004_BNGWIP-D-99927_MSXML6_1.log
--
Setup succeeded with the installation, inspect the log file completely for status on all the components.

Time : Tue Aug 21 12:08:04 2007

The setup is installing only MSXML6. It is not installing the SQL Server 2005.

Warren,

I am trying to install SP2 directly witout installing the SQL server 2005 base version. Will it not work?

Thanks for the replies,

Error installing SQL server 2005 SP2 - "Machine does not have a product that matches the in

Hi,

While I am trying to install SQL server 2005 I get the following message - "Machine does not have a product that matches the installation package". The installation does not occur.

I am using Windows 2000 Professional SP4 and using 32 bit installer - SQLServer2005SP2-KB921896-x86-ENU.exe

Help would be appreciated... thanks.

Regards,

Ravindranath Kini

Refer the system requirements http://technet.microsoft.com/en-us/library/ms143506.aspx

|||

Deepak,

The details of Summary.txt are available here.

Time : Tue Aug 21 12:08:04 2007

The setup is installing only MSXML6. It is not installing the SQL Server 2005.

Warren,

I am trying to install SP2 directly witout installing the SQL server 2005 base version. Will it not work?

Thanks for the replies,

Error installing SQL server 2005 SP2 - "Machine does not have a product that matches the in

Hi,

While I am trying to install SQL server 2005 I get the following message - "Machine does not have a product that matches the installation package". The installation does not occur.

I am using Windows 2000 Professional SP4 and using 32 bit installer - SQLServer2005SP2-KB921896-x86-ENU.exe

Help would be appreciated... thanks.

Regards,

Ravindranath Kini

Refer the system requirements http://technet.microsoft.com/en-us/library/ms143506.aspx

|||

Deepak,

The details of Summary.txt are available here.

Time : Tue Aug 21 12:08:04 2007

The setup is installing only MSXML6. It is not installing the SQL Server 2005.

Warren,

I am trying to install SP2 directly witout installing the SQL server 2005 base version. Will it not work?

Thanks for the replies,

Error installing SQL Server 2005 Developer Edition

I get the following error installing SQL Server 2005 Developer Edition

Failed to install and configure assemblies C:\Program Files\Microsoft SQL Server\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.dll in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501
Error description: You must have administrative credentials to perform this task. Contact your system administrator for assistance.

I am installing on Windows XP with Admin privs.

There is nothing listed in COM+ Services for SQL.

The Distributed Transaction Coordinator service is running.

There is a previous installation of SQL 2000 Developer Edition installed.

I have seen some pretty old posts with the same error.

I was wondering if there was a final resolution, service pack, etc. that solves this problem?

I think your best bet is to follow Milos' suggestion in this thread:

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

Thanks,
Sam Lester (MSFT)

|||

As I mentioned, there is nothing in COM+ services for SQL.

I just clicked ignore to let the installation continue.

I have not tried to use integration services yet.

Error installing SQL 2000 on W2k3 cluster

When installing SQL 2000 on a W2K3 cluster, I get the following error: An
error occurred while creating virtual server resources for clustering.
Cluster specific registry entries couldn't be written. I followed the
instructions in KB872931 and I get the same results. Can anyone assist?
Kevin
All,
Never mind. starting the remote registry service on all nodes fixed the
problem.
Kevin
"Kevin Wheeler" <kevin.l.wheeler@.lmco.com> wrote in message
news:OMeIGELyEHA.2192@.TK2MSFTNGP14.phx.gbl...
> When installing SQL 2000 on a W2K3 cluster, I get the following error: An
> error occurred while creating virtual server resources for clustering.
> Cluster specific registry entries couldn't be written. I followed the
> instructions in KB872931 and I get the same results. Can anyone assist?
>
> Kevin
>
|||Kevin,
The error message "An error occurred while creating virtual server resources for clustering. Cluster specific registry entries couldn't be written" occurs when the SQL Server 2000 virtual server Setup program tries to
create the virtual server resources on the remote nodes in the failover cluster.
The KB872931 will be helpful only if your sqlstp.log had the errors as written in the MORE INFORMATION section of the KB.
Give us more information to be able to help you out.
Few qs that comes to mind :
1) Do you have Teminal Services installed on Win2K3 nodes? If yes, the you need to remove it. See KB 301520
2) Are you installing a named instance or a default instance of SQL2K virtual instance? If named instance, have created a named pipe alias for the server name as per KB 815431
3) Do you have mount volumes in the cluster? They are not supported for SQL 2K virtual instance. See KB 819546
4) Paste the sqlstp.log for us to look at
Interested in troubleshooting it yourself
Troubleshooting SQL 2000 Virtual Server and Service Pack Setups for Failover Clustering
http://support.microsoft.com/default...lurb020703.asp
Upcoming Webcast
TechNet Support WebCast: How to install a Microsoft SQL Server 2000 virtual server on a Microsoft Windows Server 2003 cluster
Discusses how to install Microsoft SQL Server 2000 clustering on Microsoft Windows Server 2003 and differences between Microsoft Windows 2000 Server and Windows Server 2003.
http://support.microsoft.com/default...b;en-us;888121
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||I understand that. I guess it need access to the remote nodes registry.
When the remote registry service was disabled, the install failed. When I
enabled it, the install completed with no errors.
Kevin
"Uttam Parui[MS]" <uttamkp@.online.microsoft.com> wrote in message
news:tPwDvzMyEHA.3436@.cpmsftngxa10.phx.gbl...
> Kevin,
> The error message "An error occurred while creating virtual server
resources for clustering. Cluster specific registry entries couldn't be
written" occurs when the SQL Server 2000 virtual server Setup program tries
to
> create the virtual server resources on the remote nodes in the failover
cluster.
> The KB872931 will be helpful only if your sqlstp.log had the errors as
written in the MORE INFORMATION section of the KB.
> Give us more information to be able to help you out.
> Few qs that comes to mind :
> 1) Do you have Teminal Services installed on Win2K3 nodes? If yes, the you
need to remove it. See KB 301520
> 2) Are you installing a named instance or a default instance of SQL2K
virtual instance? If named instance, have created a named pipe alias for the
server name as per KB 815431
> 3) Do you have mount volumes in the cluster? They are not supported for
SQL 2K virtual instance. See KB 819546
> 4) Paste the sqlstp.log for us to look at
> Interested in troubleshooting it yourself
> Troubleshooting SQL 2000 Virtual Server and Service Pack Setups for
Failover Clustering
>
http://support.microsoft.com/default...ebcasts/wcd020
703/wcdblurb020703.asp
> Upcoming Webcast
> TechNet Support WebCast: How to install a Microsoft SQL Server 2000
virtual server on a Microsoft Windows Server 2003 cluster
> Discusses how to install Microsoft SQL Server 2000 clustering on
Microsoft Windows Server 2003 and differences between Microsoft Windows 2000
Server and Windows Server 2003.
> http://support.microsoft.com/default...b;en-us;888121
> Best Regards,
> Uttam Parui
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>
|||Glad to hear that you resolved the issue. You are correct. The "Remote Registry" service needs to be running on all cluster nodes during the installation.
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

Monday, March 26, 2012

Error Installing Service Pack 1

Hi all,
I tried to upgrade a clients site to Sp1 and got the following error:
"SQL Setup failed to connect to the database service for server
configuration. Refer to the Server error logs and setup logs for more
detailed error information."
I was just wondering if anyone else has come across this error and know any
ways to fix it?
Also does the account I am logged onto (or Term Served into) the box with
require access to the Configuration Database or the Database Server?
And I can't find any documentation on what security level is required for
applying the Service Pack ie. SQL System Administrator or just DBO of the
config database?
Thanks in advance.
Angus LoganJust like the original setup, the service pack uses integrated security to
update the ReportServer database. You need to have dbo privileges to the
database on the machine where setup is being run.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Angus Logan" <angus_logan@.data3.com.au> wrote in message
news:ebzCsMeWEHA.384@.TK2MSFTNGP10.phx.gbl...
> Hi all,
> I tried to upgrade a clients site to Sp1 and got the following error:
> "SQL Setup failed to connect to the database service for server
> configuration. Refer to the Server error logs and setup logs for more
> detailed error information."
> I was just wondering if anyone else has come across this error and know
> any
> ways to fix it?
> Also does the account I am logged onto (or Term Served into) the box with
> require access to the Configuration Database or the Database Server?
> And I can't find any documentation on what security level is required for
> applying the Service Pack ie. SQL System Administrator or just DBO of the
> config database?
> Thanks in advance.
> Angus Logan
>

Error Installing RS with exising DB

I am getting the following error while attempting to install RS on a Small
Business Server 2000 box that already contains the ReportServer DB from a
previous setup where the Web portion of RS resided on another box.
The error is:
"A database with the specified name (ReportServer) already exists and is not
a valid report server database. You must either remote the existing database
or select a new database name."
What may be wrong?
Tx
AndyRS won't allow you to install onto a DB that already exists locally. If the
RS that used this database is not needed anymore, then just delete it (and
the temp database associated with it), then you can install. Or you can just
select a new name for the database when running setup.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andy Schmidt" <andys@.minunteclinic.com> wrote in message
news:ub2%23zNz$EHA.1296@.TK2MSFTNGP10.phx.gbl...
>I am getting the following error while attempting to install RS on a Small
> Business Server 2000 box that already contains the ReportServer DB from a
> previous setup where the Web portion of RS resided on another box.
> The error is:
> "A database with the specified name (ReportServer) already exists and is
> not
> a valid report server database. You must either remote the existing
> database
> or select a new database name."
> What may be wrong?
> Tx
> Andy
>|||Daniel,
I don't want to re-create all of the folder structure, permissions, etc. If
I create a new db is there a way to import from the old db's tables?
Tx
Andy
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:#6$JXoAAFHA.204@.TK2MSFTNGP10.phx.gbl...
> RS won't allow you to install onto a DB that already exists locally. If
the
> RS that used this database is not needed anymore, then just delete it (and
> the temp database associated with it), then you can install. Or you can
just
> select a new name for the database when running setup.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Andy Schmidt" <andys@.minunteclinic.com> wrote in message
> news:ub2%23zNz$EHA.1296@.TK2MSFTNGP10.phx.gbl...
> >I am getting the following error while attempting to install RS on a
Small
> > Business Server 2000 box that already contains the ReportServer DB from
a
> > previous setup where the Web portion of RS resided on another box.
> >
> > The error is:
> >
> > "A database with the specified name (ReportServer) already exists and is
> > not
> > a valid report server database. You must either remote the existing
> > database
> > or select a new database name."
> >
> > What may be wrong?
> >
> > Tx
> > Andy
> >
> >
>|||You can use rsconfig to point to the old database after you install to a new
database. Just make sure that both db schemas are the same. That is if the
original DB is SP1 make sure to upgrade the new one to SP1 before using
rsconfig. You will most likely then have issues with reading encrypted
data. If you saved off your symmetric key from the old installation, after
using rsconfig you can import the key using rskeymgmt. If you did not save
the old symmetric key, after running rsconfig, run rskeymgmt -d. This will
delete all encrypted data from RS. That means you will need to enter all
your report/data source credential again.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andy Schmidt" <andys@.minunteclinic.com> wrote in message
news:Ohy1KViAFHA.2316@.TK2MSFTNGP15.phx.gbl...
> Daniel,
> I don't want to re-create all of the folder structure, permissions, etc.
> If
> I create a new db is there a way to import from the old db's tables?
> Tx
> Andy
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> news:#6$JXoAAFHA.204@.TK2MSFTNGP10.phx.gbl...
>> RS won't allow you to install onto a DB that already exists locally. If
> the
>> RS that used this database is not needed anymore, then just delete it
>> (and
>> the temp database associated with it), then you can install. Or you can
> just
>> select a new name for the database when running setup.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>>
>> "Andy Schmidt" <andys@.minunteclinic.com> wrote in message
>> news:ub2%23zNz$EHA.1296@.TK2MSFTNGP10.phx.gbl...
>> >I am getting the following error while attempting to install RS on a
> Small
>> > Business Server 2000 box that already contains the ReportServer DB from
> a
>> > previous setup where the Web portion of RS resided on another box.
>> >
>> > The error is:
>> >
>> > "A database with the specified name (ReportServer) already exists and
>> > is
>> > not
>> > a valid report server database. You must either remote the existing
>> > database
>> > or select a new database name."
>> >
>> > What may be wrong?
>> >
>> > Tx
>> > Andy
>> >
>> >
>>
>sql

Thursday, March 22, 2012

Error in X-Path Query

I am new to XML in SQL Server and X-Path Query

Recently I have done the following virtual lab in techNet site

SQL Server 2005 XML Capabilities

The following query is worked fine in the lab

SELECTTOP 10 Demographics.query('declare default element namespace=

"http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/IndividualSurvey"

/IndividualSurvey/YearlyIncome')

FROM Sales.Individual

But later I installed SQL Server Express in my system and also the Express Manager CTP

but i am getting the following error if I execute the above query in my system

Msg 9317, Level 16, State 1, Line 1

XQuery [Sales.Individual.Demographics.query()]: Syntax error near '=', expected string literal.

Check ou this link: http://tinyurl.com/avqxx

Check out this syntax. I think your syntax is wrong and are missing a ref to the namespace and a ' ; '.

I.e

SELECT MyXml.query('

declare namespace s="http://myns/mydemoschema";

/s:root/s:product[@.s:id="304"]/s:name')FROM MyTable

notice the ; indeclare namespace s="http://myns/mydemoschema";

|||i think the name space is required when we are assigning the declared name space to a reference such as "s=" in the above example|||take default element out too.|||

Finally It is solved

I found the problem from another forum athttp://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=145&messageid=248323

Here is the answer given by Veteran

To declare default namespace, there is no "=" after namespace keyword. And there is a ";" after the namespace string. The following query works:

SELECTTOP 10 Demographics.query('declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/IndividualSurvey";

/IndividualSurvey/YearlyIncome')

FROM Sales.Individual

Error in X-Path Query

I am new to XML in SQL Server and X-Path Query

Recently I have done the following virtual lab in techNet site

SQL Server 2005 XML Capabilities

The following query is worked fine in the lab

SELECT TOP 10 Demographics.query('declare default element namespace=

"http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/IndividualSurvey"

/IndividualSurvey/YearlyIncome')

FROM Sales.Individual

But later I installed SQL Server Express in my system and also the Express Manager CTP

but i am getting the following error if I execute the above query in my system

Msg 9317, Level 16, State 1, Line 1

XQuery [Sales.Individual.Demographics.query()]: Syntax error near '=', expected string literal.

The correct syntax for the XQuery expression is below:

SELECT TOP 10 Demographics.query('declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/IndividualSurvey";
/IndividualSurvey/YearlyIncome')
FROM Sales.Individual

sql

Error in using xp_cmdshell and osql

Hi, can anyone help me with the following xp_cmdshell/osql problem?
To solve a problem with osql I use the two sql test-scripts. Script1 is
loaded in Sql Query Analyzer. Executing scripts 1: this calls en execute
script2, which prints a message to the output window. Quite simple.
My problem: this is functioning well on a my develop pc (Windows XP-Pro),
but is not functioning on a production server with Windows 2000 Server (SP4)
.
On this production machine, recently sql server 2000 SP3 has been installed,
and everything of sqlserver 2000 looks the same as on my develop pc under
XP-pro. The error reported is about the syntax usage of osql: "usage: osql
[-U login id] [-P password] [-S server]" and the all the rest of the option
s
..... So I should think it has something to do with the used syntax, but i
t
IS functioning on my develop pc!
I don't understand why these testscripts do work on my develop pc, and don't
on the production server. I guess it has something to do with either the
difference in OS, or a setting in the new sql installation on the production
server, but I can't find out the cause.
****************************************
**
Script1.sql:
DECLARE @.SqlPath sysname, @.SqlScript as sysname, @.Cmd sysname, @.CmdCpl
nvarchar(400), @.CmdAndPath sysname
SET @.Cmd = 'osql -S MyServer -d MyDb -Usa -PPwd -i'
SET @.SqlPath = 'C:\MyPathToScript2'
SET @.CmdAndPath = @.Cmd + @.SqlPath
SET @.SqlScript = 'Script2.sql'
SET @.CmdCpl = @.CmdAndPath + @.SqlScript
EXEC master..xp_cmdshell @.CmdCpl
****************************************
**
Script2.sql:
DECLARE @.Test varchar(255)
SET @.Test = 'Hello world'
PRINT @.Test
****************************************
**
Any suggestions are welcome,
Regards Coen.One possible cause is that @.CmdCpl contains whitespace in the prod
environment so the command line parameters are not parsed as expected. In
that case, you can enclose the path in double-quotes:
SET @.CmdCpl = '"' + @.CmdAndPath + @.SqlScript + '"'
If that isn't the problem, try printing the actual @.CmdCpl value and running
from the command line.
Hope this helps.
Dan Guzman
SQL Server MVP
"Coen" <cbusker@.newsgroups.microsoft.com> wrote in message
news:D4DCA3BF-E67B-437C-ADE1-9071EA673BCE@.microsoft.com...
> Hi, can anyone help me with the following xp_cmdshell/osql problem?
> To solve a problem with osql I use the two sql test-scripts. Script1 is
> loaded in Sql Query Analyzer. Executing scripts 1: this calls en execute
> script2, which prints a message to the output window. Quite simple.
> My problem: this is functioning well on a my develop pc (Windows XP-Pro),
> but is not functioning on a production server with Windows 2000 Server
> (SP4).
> On this production machine, recently sql server 2000 SP3 has been
> installed,
> and everything of sqlserver 2000 looks the same as on my develop pc under
> XP-pro. The error reported is about the syntax usage of osql: "usage: osql
> [-U login id] [-P password] [-S server]" and the all the rest of the
> options
> ..... So I should think it has something to do with the used syntax, but
> it
> IS functioning on my develop pc!
> I don't understand why these testscripts do work on my develop pc, and
> don't
> on the production server. I guess it has something to do with either the
> difference in OS, or a setting in the new sql installation on the
> production
> server, but I can't find out the cause.
> ****************************************
**
> Script1.sql:
> DECLARE @.SqlPath sysname, @.SqlScript as sysname, @.Cmd sysname, @.CmdCpl
> nvarchar(400), @.CmdAndPath sysname
> SET @.Cmd = 'osql -S MyServer -d MyDb -Usa -PPwd -i'
> SET @.SqlPath = 'C:\MyPathToScript2'
> SET @.CmdAndPath = @.Cmd + @.SqlPath
> SET @.SqlScript = 'Script2.sql'
> SET @.CmdCpl = @.CmdAndPath + @.SqlScript
> EXEC master..xp_cmdshell @.CmdCpl
> ****************************************
**
> Script2.sql:
> DECLARE @.Test varchar(255)
> SET @.Test = 'Hello world'
> PRINT @.Test
> ****************************************
**
> Any suggestions are welcome,
> Regards Coen.
>|||Dan, thank you for your help. Indeed the problem was caused by whitespaces,
so simple. The double quotes resolved the problem. Thank you for your
assistance.
Regards, Coen
"Dan Guzman" wrote:

> One possible cause is that @.CmdCpl contains whitespace in the prod
> environment so the command line parameters are not parsed as expected. In
> that case, you can enclose the path in double-quotes:
> SET @.CmdCpl = '"' + @.CmdAndPath + @.SqlScript + '"'
> If that isn't the problem, try printing the actual @.CmdCpl value and runni
ng
> from the command line.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Coen" <cbusker@.newsgroups.microsoft.com> wrote in message
> news:D4DCA3BF-E67B-437C-ADE1-9071EA673BCE@.microsoft.com...
>
>sql

Error in use of order by in over clause

Hi,

I am getting a wierd error while using order by in the over clause. Consider the following query:

select count (*) over (order by STD_CLL_CNTR_KEY) as cnt

from FCT_CLL_CS_DTLS

The error reported is :

Msg 156, Level 15, State 1, Line 2

Incorrect syntax near the keyword 'order'.

But at the same time this particular query seems to be working fine:

select rank () over (order by STD_CLL_CNTR_KEY) as cnt

from FCT_CLL_CS_DTLS

Am I missing something fundamental or is there a bigger issue.

Thanks in advance,

Regards,

Emil

I quote from Books Online the complete sytax related to the 3 key words :RANK, OVER and COUNT :

RANK ( ) OVER ( [ < partition_by_clause > ] < order_by_clause > )

COUNT ( { [ [ ALL | DISTINCT ] expression ] | * } )

OVER Clause (Transact-SQL)

Determines the partitioning and ordering of the rowset before the associated window function is applied.

so, the second is the correct SELECT

and

RANK

Returns the rank of each row within the partition of a result set. The rank of a row is one plus the number of ranks that come before the row in question.

so using RANK is the right decision because you count STD_CLL_CNTR_KEYSTD_CLL_CNTR_KEY that i guess is a primary key

|||Thanks Gigi

Error in use of order by in over clause

Hi,

I am getting a wierd error while using order by in the over clause. Consider the following query:

select count (*) over (order by STD_CLL_CNTR_KEY) as cnt

from FCT_CLL_CS_DTLS

The error reported is :

Msg 156, Level 15, State 1, Line 2

Incorrect syntax near the keyword 'order'.

But at the same time this particular query seems to be working fine:

select rank () over (order by STD_CLL_CNTR_KEY) as cnt

from FCT_CLL_CS_DTLS

Am I missing something fundamental or is there a bigger issue.

Thanks in advance,

Regards,

Emil

I quote from Books Online the complete sytax related to the 3 key words :RANK, OVER and COUNT :

RANK ( ) OVER ( [ < partition_by_clause > ] < order_by_clause > )

COUNT ( { [ [ ALL | DISTINCT ] expression ] | * } )

OVER Clause (Transact-SQL)

Determines the partitioning and ordering of the rowset before the associated window function is applied.

so, the second is the correct SELECT

and

RANK

Returns the rank of each row within the partition of a result set. The rank of a row is one plus the number of ranks that come before the row in question.

so using RANK is the right decision because you count STD_CLL_CNTR_KEYSTD_CLL_CNTR_KEY that i guess is a primary key

|||Thanks Gigi

Error in stored procedure that updates a row

I have the following stored procedure:

CREATE PROCEDURE user1122500.sp_modifyOrganization
(
@.Name nvarchar(100)
,@.Location nvarchar(50)
,@.Url nvarchar (250)
,@.Org_Type nvarchar (50)
,@.Par_Org_Id uniqueidentifier
,@.Row_Id uniqueidentifier
,@.Error_Code int OUTPUT
,@.Error_Text nvarchar(768) OUTPUT
)
AS
DECLARE @.errorMsg nvarchar(512)
DECLARE @.spName sysname

SELECT @.spName = Object_Name(@.@.ProcID)
SET @.Error_Code = 0

IF @.Url > ' '
BEGIN
UPDATE USER1122500.ORGANIZATION
SET URL = @.Url
,UPDATED = GETDATE()
WHERE ROW_ID = @.Row_Id

IF @.@.error <> 0
BEGIN
EXEC user1122500.sp_tagValueList @.errorMsg OUTPUT, N'ROW_ID', @.Row_Id,
N'URL', @.Url
SET @.Error_Code = 51002 -- Error Message as created in the ERROR_LIST table
SELECT @.Error_Text = (SELECT DESC_TEXT FROM USER1122500.ERROR_LIST WHERE ERROR_CODE = @.Error_Code)
RAISERROR(@.Error_Text, 11, 1, @.spName, @.@.error, 'ORGANIZATION', @.errorMsg)
RETURN(@.@.error)
END
END

IF @.Org_Type > ' '
BEGIN
UPDATE USER1122500.ORGANIZATION
SET ORG_TYPE = @.Org_Type
,UPDATED = GETDATE()
WHERE ROW_ID = @.Row_Id

IF @.@.error <> 0
BEGIN
EXEC user1122500.sp_tagValueList @.errorMsg OUTPUT, N'ROW_ID', @.Row_Id,
N'ORG_TYPE', @.Org_Type
SET @.Error_Code = 51002 -- Error Message as created in the ERROR_LIST table
SELECT @.Error_Text = (SELECT DESC_TEXT FROM USER1122500.ERROR_LIST WHERE ERROR_CODE = @.Error_Code)
RAISERROR(@.Error_Text, 11, 1, @.spName, @.@.error, 'ORGANIZATION', @.errorMsg)
RETURN(@.@.error)
END
END

IF @.Par_Org_Id IS NOT NULL
BEGIN
UPDATE USER1122500.ORGANIZATION
SET PAR_ORG_ID = @.Par_Org_Id
,UPDATED = GETDATE()
WHERE ROW_ID = @.Row_Id

IF @.@.error <> 0
BEGIN
EXEC user1122500.sp_tagValueList @.errorMsg OUTPUT, N'ROW_ID', @.Row_Id,
N'PAR_ORG_ID', @.Par_Org_Id
SET @.Error_Code = 51002 -- Error Message as created in the ERROR_LIST table
SELECT @.Error_Text = (SELECT DESC_TEXT FROM USER1122500.ERROR_LIST WHERE ERROR_CODE = @.Error_Code)
RAISERROR(@.Error_Text, 11, 1, @.spName, @.@.error, 'ORGANIZATION', @.errorMsg)
RETURN(@.@.error)
END
END

IF @.Name > ' ' OR @.Location > ' '
BEGIN

IF EXISTS (SELECT ROW_ID FROM USER1122500.ORGANIZATION WHERE NAME = @.Name AND LOCATION = @.Location)
BEGIN
EXEC user1122500.sp_tagValueList @.errorMsg OUTPUT, N'NAME', @.Name,
N'LOCATION', @.Location
SET @.Error_Code = 55004 -- Error Message as created in the ERROR_LIST table
SELECT @.Error_Text = (SELECT DESC_TEXT FROM USER1122500.ERROR_LIST WHERE ERROR_CODE = @.Error_Code)
-- RAISERROR(@.Error_Text, 10, 1, @.spName, @.Error_Code, 'ORGANIZATION', @.errorMsg)
SELECT @.Error_Text = (SELECT REPLACE(@.Error_Text,'sp_name',@.spName))
SELECT @.Error_Text = (SELECT REPLACE(@.Error_Text,'err_cd',@.Error_Code))
SELECT @.Error_Text = (SELECT REPLACE(@.Error_Text,'tbl_name','ORGANIZATION'))
SELECT @.Error_Text = (SELECT REPLACE(@.Error_Text,'err_msg',@.errorMsg))
RETURN(@.Error_Code)
END

IF @.Name > ' '
BEGIN
UPDATE USER1122500.ORGANIZATION
SET NAME = @.Name
,UPDATED = GETDATE()
WHERE ROW_ID = @.Row_Id

IF @.@.error <> 0
BEGIN
EXEC user1122500.sp_tagValueList @.errorMsg OUTPUT, N'ROW_ID', @.Row_Id,
N'PAR_ORG_ID', @.Name
SET @.Error_Code = 51002 -- Error Message as created in the ERROR_LIST table
SELECT @.Error_Text = (SELECT DESC_TEXT FROM USER1122500.ERROR_LIST WHERE ERROR_CODE = @.Error_Code)
RAISERROR(@.Error_Text, 11, 1, @.spName, @.@.error, 'ORGANIZATION', @.errorMsg)
RETURN(@.@.error)
END
END

IF @.Location > ' '
BEGIN
UPDATE USER1122500.ORGANIZATION
SET LOCATION = @.Location
,UPDATED = GETDATE()
WHERE ROW_ID = @.Row_Id

IF @.@.error <> 0
BEGIN
EXEC user1122500.sp_tagValueList @.errorMsg OUTPUT, N'ROW_ID', @.Row_Id,
N'LOCATION', @.Location
SET @.Error_Code = 51002 -- Error Message as created in the ERROR_LIST table
SELECT @.Error_Text = (SELECT DESC_TEXT FROM USER1122500.ERROR_LIST WHERE ERROR_CODE = @.Error_Code)
RAISERROR(@.Error_Text, 11, 1, @.spName, @.@.error, 'ORGANIZATION', @.errorMsg)
RETURN(@.@.error)
END
END

END
GO

This is the code that runs it:

string strSP = "sp_modifyOrganization";

SqlParameter[] Params =new SqlParameter Music [8] ;

string strParOrgID =null;

if (this.ddlParentOrg.SelectedItem.Value != "")

{

strParOrgID =this.ddlParentOrg.SelectedItem.Value;

}

Params[0] =new SqlParameter("@.Name", txtName.Text);

Params[1] =new SqlParameter("@.Location",this.txtLocation.Text);

Params[2] =new SqlParameter("@.Url",this.txtURL.Text);

Params[3] =new SqlParameter("@.Org_Type",this.txtOrgType.Text);

//Params[4] = new SqlParameter("@.Par_Org_Id", strParOrgID);

Params[4] =new SqlParameter("@.Par_Org_Id", "CA1FBC83-D978-48F1-BCBC-E53AD5E8A321".ToUpper());

Params[5] =new SqlParameter("@.Row_Id", "688f2d10-1550-44f8-a62c-17610d1e979a".ToUpper());

// Params[5] = new SqlParameter("@.Row_Id", lblOrg_ID.Text);

Params Devil [6] =new SqlParameter("@.Error_Code", -1);

Params[7] =new SqlParameter("@.Error_Text", "");

Params[4].SqlDbType = SqlDbType.UniqueIdentifier;

Params[5].SqlDbType = SqlDbType.UniqueIdentifier;

Params Devil [6] .Direction = ParameterDirection.Output;

Params[7].Direction = ParameterDirection.Output;

try

{

this.dtsData = SqlHelper.ExecuteDataset(ConfigurationSettings.AppSettings["SIM_DSN"], CommandType.StoredProcedure, strSP, Params);

if (Params Devil [6] .Value.ToString() != "0")

{

lblError.Text = "There was an error: " + Params Devil [6] .Value.ToString()+ "###" + Params[7].Value.ToString();

lblError.Visible =true;

}

//catch (System.Data.SqlClient.SqlException ex)

catch (System.InvalidCastException inv)

{

lblError.Text = lblOrg_ID.Text + "<br><br>" + inv.ToString() + inv.Message + inv.StackTrace + inv.HelpLink;

lblError.Visible =true;

}

catch (Exception ex)

{

lblError.Text = lblOrg_ID.Text + "<br><br>" + ex.ToString();

lblError.Visible =true;

// return false;

}

This is the exception being generated:

System.InvalidCastException: Invalid cast from System.String to System.Guid.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) in C:\Program Files\_vsNETAddOns\Microsoft Application Blocks for .NET\Data Access v2\Code\VB\Microsoft.ApplicationBlocks.Data\SQLHelper.vb:line 542
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) in C:\Program Files\_vsNETAddOns\Microsoft Application Blocks for .NET\Data Access v2\Code\VB\Microsoft.ApplicationBlocks.Data\SQLHelper.vb:line 458
at development.youthleadercert.com.share.ascx.organizationForm.btnAdd_Click(Object sender, EventArgs e) in c:\documents and settings\mark rubin\vswebcache\development.youthleadercert.com\share\ascx\organizationform.ascx.cs:line 352

I have no idea what field is even causing the error, nor do I see that I'm even using a GUID field. I've been stuck on this for 2 days. Any help?

I would guess it's here. You're passing them as strings. You may want to explicitly type them as UniqueIdentifiers. Or, change your proc temporarily and define your parameters as varchars and see what happens. I bet that even though they may look like GUIDs, SQL doesn't see them that way when they're passed in. Just a guess, but that would be where I would start.

Params[4] =new SqlParameter("@.Par_Org_Id", "CA1FBC83-D978-48F1-BCBC-E53AD5E8A321".ToUpper());

Params[5] =new SqlParameter("@.Row_Id", "688f2d10-1550-44f8-a62c-17610d1e979a".ToUpper());

|||

In my code, I already am setting the db type a few rows down...

Params[4].SqlDbType = SqlDbType.UniqueIdentifier;

Params[5].SqlDbType = SqlDbType.UniqueIdentifier;

Thursday, March 29, 2012

error loading the report in the designer

Error loading 'IntegrationServicesRules' assembly in Best Practice Analyzer 2005 CTP

Error loading http://localhost/ReportServer

Reporting Services Error

An internal error occurred on the report server. See the error log for more details. (rsInternalError)

Error loading http://localhost/ReportServer

Reporting Services Error

An internal error occurred on the report server. See the error log for more details. (rsInternalError)

Error Loading : sqlceme30.dll

Error loading 'IntegrationServicesRules' assembly in Best Practice Analyzer 2005 CTP

Error is SQL block

Tuesday, March 27, 2012

Error installing SQL server 2005 SP2 - "Machine does not have a product that matches the in

Error installing SQL server 2005 SP2 - "Machine does not have a product that matches the in

Error installing SQL server 2005 SP2 - "Machine does not have a product that matches the in

Error installing SQL Server 2005 Developer Edition

Error installing SQL 2000 on W2k3 cluster

Monday, March 26, 2012

Error Installing Service Pack 1

Error Installing RS with exising DB

Thursday, March 22, 2012

Error in X-Path Query

Error in X-Path Query

Error in using xp_cmdshell and osql

Error in use of order by in over clause

Error in use of order by in over clause

Error in stored procedure that updates a row

error handling flow

Blog Archive

About Me