Error when trying to process cube after SP2

Hi Guys

Seems a nasty error started to appear after I installed SP2 on the corporate server and my machine and then trying to process a cube. Process goes through fine, but when I try to browse it a following error pops up. If anyone can help me with this, that would be great.

Parser: The end of the input was reached. (Microsoft SQL Server 2005 Analysis Services)

Program Location:

at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.Discover(String requestType, String requestNamespace, IDictionary restrictions, InlineErrorHandlingType inlineErrorHandling)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.GetSchemaDataSet(String schemaName, String schemaNamespace, IDictionary adomdRestrictions, Boolean throwOnInlineErrors)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.GetSchemaDataSet(String schemaName, String schemaNamespace, AdomdRestrictionCollection restrictions, Boolean throwOnInlineErrors)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.GetSchemaDataSet(String schemaName, AdomdRestrictionCollection restrictions)
at Microsoft.AnalysisServices.Browse.CubeBrowser.BrowsableObjectsManager.Refresh()
at Microsoft.AnalysisServices.Browse.CubeBrowser.BrowsableObjectsManager.UpdateComboBox()
at Microsoft.AnalysisServices.Browse.CubeBrowser.UpdateAll(Boolean translate)
at Microsoft.AnalysisServices.Browse.CubeBrowser.ReconnectCanFail()
at Microsoft.AnalysisServices.Browse.CubeBrowser.SupportFunctionWhichCanFail(FunctionWhichCanFail function)

Thank you

Found a problem: the default measures were not set up in perspectives. Hmm... I thought the first one will be selected automatically.

Error when trying to change server settings

I am trying to connect to a SQL Server machine using SQL security instead of integrgated security. However, the server was setup initially to use only integrated security. When I right click on the server and select properties, I get this error:

Error 0: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 5(Access is denied.).

I googled this error but could not find a single solution. The dll will not register with regsvr32. Do I need to repair SQL Server and then re-run the latest service pack, or is there a simple solution?

Thanks,Books Online

How to set up Mixed Mode security (Enterprise Manager)
To set up Mixed Mode security

Expand a server group.

Right-click a server, and then click Properties.

Click the Security tab.

Under Authentication, click SQL Server and Windows.

Under Audit level, select the level at which user accesses to Microsoft® SQL Server? are recorded in the SQL Server error log:
None causes no auditing to be performed.

Success causes only successful login attempts to be audited.

Failure causes only failed login attempts to be audited.

All causes successful and failed login attempts to be audited.

See Also

Authentication Modes
------

Does that help?|||Thanks. I understand how to setup mixed mode security, but the problem appears to be a dll called xpstar.dll which throws an error when I right click on the server icon and select properties. I wanted to know if there was a fix for this short of reinstalling.

When I right click on the server icon in server explorer and select properties, I get this error:

Error 0: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 5(Access is denied.).

I googled this error but could not find a single solution. The dll will not register with regsvr32. Do I need to repair SQL Server and then re-run the latest service pack, or is there a simple solution?|||No answers, just questions.

What version & service pack of SQL Server are you running?

Have you checked the event log to see if you can find any further information?

Terri|||Hello Terri,

It is SQL Server 2000 and should have service pack 3 installed.

There are no errors in the event log related to SQL Server.|||Is there anything in the SQL Server Logs?

Terri|||Unfortunately not.

Also, I reapplied Service Pack 3 and it did not fix the problem.

I have SQL on a development machine. If I right click on the local server instance and then select properties, the Server properties dialog appears. If I select the server, I get an error. At first, I thought it was the development machine, but unfortunately the same thing happens when I try this directly on the server. I am at a loss of what to do short of backing up the databases, uninstalling SQL, reinstalling SQL, and then restoring the databases. The SQL installation does not have a repair option - do you know what would happen if I installed SQL over the existing SQL?

Thanks,

error when trying to browse SSRS on a remote machine

Hi,

I deployed SSRS reports to my local report server and set the connection string to access a server on the network with Analysis Server.

Result:
I can access and use the reports from my computer. But when I use any other computer on the network I can't use the reports. I can access them but they don't find the database ant therefor they don't present any data.

Error message as folows: "An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Cannot create a connection to data source 'dsAnalys'. (rsErrorOpeningConnection) Get Online Help
Database 'Analys' does not exist. "

This works fine on my local machine, the error comes only when i try to browse on a remote machine. I am using SQL Server 2005

Any help would be appriciated!!!

Thanks in advance,

Chanduu

Can you access the database from a different PC using SQL Server Management Studio?

Possibly the server is not accessible from those PCs? Is it on a different domain?

|||yes, i am able to access|||

Chandu I am just trying to see what is causing this error.

1.) Do you have Shared Datasource in SSRS.

2.) While deploying to the remote server, make sure to include the right TargetServerUrl.

3.) On the Remote Server, go the Home folder and check for the DataSources if it has

a.) Enable this Data Source CheckBox checked.

b.) Connection string

c.) In the Connect Using: Check if the Credentials stored securely in the report server is Checked and the UserName and Password is given.

4.) Check for the permissions.

Hope this helps...

|||

Thanks a lot !!! friends .. I got answer for this error

Steps i followed to reslove this error

1. Goto http://<report server>/reports

2. Select the datasource folder

3. Check "Credentials stored in that report" and give valid user id and password

4. Check the check box"Use as windows credentials when connecting to datasource"

error when trying to browse SSRS on a remote machine

Hi,

I deployed SSRS reports to my local report server and set the connection string to access a server on the network with Analysis Server.

Result:
I can access and use the reports from my computer. But when I use any other computer on the network I can't use the reports. I can access them but they don't find the database ant therefor they don't present any data.

Error message as folows: "An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Cannot create a connection to data source 'dsAnalys'. (rsErrorOpeningConnection) Get Online Help
Database 'Analys' does not exist. "

This works fine on my local machine, the error comes only when i try to browse on a remote machine. I am using SQL Server 2005

Any help would be appriciated!!!

Thanks in advance,

Chanduu

Can you access the database from a different PC using SQL Server Management Studio?

Possibly the server is not accessible from those PCs? Is it on a different domain?

|||yes, i am able to access|||

Chandu I am just trying to see what is causing this error.

1.) Do you have Shared Datasource in SSRS.

2.) While deploying to the remote server, make sure to include the right TargetServerUrl.

3.) On the Remote Server, go the Home folder and check for the DataSources if it has

a.) Enable this Data Source CheckBox checked.

b.) Connection string

c.) In the Connect Using: Check if the Credentials stored securely in the report server is Checked and the UserName and Password is given.

4.) Check for the permissions.

Hope this helps...

|||

Thanks a lot !!! friends .. I got answer for this error

Steps i followed to reslove this error

1. Goto http://<report server>/reports

2. Select the datasource folder

3. Check "Credentials stored in that report" and give valid user id and password

4. Check the check box"Use as windows credentials when connecting to datasource"

sql

error when trying to browse SSRS on a remote machine

Hi,

I deployed SSRS reports to my local report server and set the connection string to access a server on the network with Analysis Server.

Result:
I can access and use the reports from my computer. But when I use any other computer on the network I can't use the reports. I can access them but they don't find the database ant therefor they don't present any data.

Error message as folows: "An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Cannot create a connection to data source 'dsAnalys'. (rsErrorOpeningConnection) Get Online Help
Database 'Analys' does not exist. "

This works fine on my local machine, the error comes only when i try to browse on a remote machine. I am using SQL Server 2005

Any help would be appriciated!!!

Thanks in advance,

Chanduu

Can you access the database from a different PC using SQL Server Management Studio?

Possibly the server is not accessible from those PCs? Is it on a different domain?

|||yes, i am able to access|||

Chandu I am just trying to see what is causing this error.

1.) Do you have Shared Datasource in SSRS.

2.) While deploying to the remote server, make sure to include the right TargetServerUrl.

3.) On the Remote Server, go the Home folder and check for the DataSources if it has

a.) Enable this Data Source CheckBox checked.

b.) Connection string

c.) In the Connect Using: Check if the Credentials stored securely in the report server is Checked and the UserName and Password is given.

4.) Check for the permissions.

Hope this helps...

|||

Thanks a lot !!! friends .. I got answer for this error

Steps i followed to reslove this error

1. Goto http://<report server>/reports

2. Select the datasource folder

3. Check "Credentials stored in that report" and give valid user id and password

4. Check the check box"Use as windows credentials when connecting to datasource"

Error when connecting remote SQL SERVER

Hi..

I have been assigned to make a database in some remote machine.The machine has MSSQL 2005.I need to connect to that remote machine's sql server via my pc using my SQL Management express.I do have that computer's IP address(say,123.456.789.000),and the username and password.But when i try to connect to the server ,I get the following error:

Cannot connect to 123.456.789.000\sqlexpress

An error has occured while establishing a connection to the server.When connecting to SQL server 2005,this failure may be caused by the fact that unser the default settings SQL server does not allow remote connections,(provider: SQL Network Interfaces,error:26-Error Locating Server/Instance specified)(Microsoft SQL Server)

I am a new programmer and dont know much.But i guess the problem is not in my server but in that server to which i am trying to connect.I guess that server has some instance created or it does not allow remote connections.But i am not sure.Is it so?Or is anything wrong in my server.Any ideas?IF you put these errors into a search engine you should get a series of answers.
Anyhows...check this out.
I faced this issue , found out that I was under the Vista client category.

cheers

error when connect to sqlserver from another machine

hi ..

i install sqlserver and make app with vb6 using ADO to connect to the database and successfully

i put that application on another pc on the network
when i open it it says "can't login computername\guest" ?!!

any help

thanks in advance.any answers|||Are both of your pcs on a domain or a workgroup? If it's not domain, you need to create a same account/password pair on both machines and use that account to login.|||thanks

Xinwei Hong for reply

the two machines on a workgroup so .. could you explain pcs under domain in few lines ?
now i will create two users on the two machines and tell you later

thanks in advance.
|||By "pcs under domain", I mean whether your PC is under a domain which is usually used in median/large company. In this case, domain controller will help you do a lot of things.|||thanks for reply

you says i can do a lot of things if i'm under domain like what ?and what is the domain controler ? could you explain ?

and if you have short time i can talk to you in messanger it will be kind from you

thanks|||i make 2 users with same name but ..
the same problem occurs ?|||It's hard to describe "domain controller" and related stuff in short words. I recommend you find some documents related to Windows Networks to read.

Are you sure your client is running under the user account you created and you used that account to login to the server? It means you may need to login the client Windows system and run your client app under that account. If you user Administrator or even logon the computer without a user/password, it won't work.|||is this means that i need a password for administrator user to login to the database server ?|||Not necessary. SQL server runs as a service under various account(e.g. network service, local system, administrator account, etc.).

Error using Copy Database Wizard in SSMS - SQL 2000 to SQL 2005

I have successfully used the Copy Database wizard in the past to copy from
SQL 2000 to SQL 2005 - both on my machine.
But now I always get an error at the Finsih step saying: "No description
found"
This occurs on the 3rd step of the process - Create Package.
I have tried changing all the options but always get the same error.
Les
lmcphee (lmcphee@.discussions.microsoft.com) writes:
> I have successfully used the Copy Database wizard in the past to copy from
> SQL 2000 to SQL 2005 - both on my machine.
> But now I always get an error at the Finsih step saying: "No description
> found"
> This occurs on the 3rd step of the process - Create Package.
> I have tried changing all the options but always get the same error.
Have you looked in the event log, which is where CDW logs by default.
(And it logs on the receiving server, not necessarily the one you
initiated the process from.) You can also redirect logging to a text
file.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Error updating data in table that uses a trigger?

Hello. I am new to SQL Server Management Studio 2005 and am using it to connect to a database on another machine running SQL Server 2000. Everything seems to work well, except when I try to edit table data on a particular table that has an update trigger associated with it. I am receiving the error:

-

The data in row 1 was not committed.

Error Source: Microsoft.VisualStudio.DataTools.

Error Message: The row value(s) updated or deleted either do not make the row unique or they alter multiple rows(5 rows).

Correct the errors and retry or press ESC to chancel the changes.

--

I want it to update those the 5 rows in the other tables...that's the whole point of having the trigger!

This used to work fine from Enterprise Manager 2000 and If I issue the update query manually from the new integrated "Query Analyzer" it is also ok. Is there some way to deactivate this new feature from the table viewer?

Thanks very much!

That error message occurred once for because there was a constraint which the deletion violated. I believe I had a field set to "NOT NULL" and the deletion was attempting to delete just that field for some reason.|||Also make sure that there are not two rows where every column is exactly the same.|||

Thanks for responding. My modification is not causing duplicate records to be created, nor am I violating any of my table rules (such as not NULL).

What I have is a trigger associated with my table so that whenever a record is updated it runs a stored procedure which then updates related information in other tables. It is not an error, but a very essential function of my database.

If I issue a manual update query (with query analyzer) I receive no errors and my trigger runs perfectly. It's only when I try to update a record interactively with the "Open Table" viewer/interface that I receive the error.

This new feature is very disruptive to the way I work and I was hoping that there was an option somewhere to turn it off, or make it so that it only applies to real errors such as duplicate records being created.

Thanks....

|||Can you run Profiler and gather a trace to see what it's doing differently than QA?|||

It's not really doing anything different, it's just that the new interactive "table viewer" has some sort of error checking routine that prohibits the update from executing because it sees that the query will affect data in other tables... which is what it was designed to do and worked flawlessly with Enterprise Manager 2000.

Am I the only person here who uses triggers to update data in other tables?

Thanks...

|||

You're absolutely not... I have the same problem. Very frustrating having to run the old version of Enterprise Manager just to update a few values.

Did you manage to find a fix for this?

|||Nope. No fix yet (that I'm aware of). Maybe if we keep this thread visible someone higher up can recommend that it be addressed in the next service pack.|||

Please file a defect report with the MSDN Feedback Center (http://lab.msdn.microsoft.com/productfeedback/).

If you can include a minimal script to create sample tables and a stored procedure to set up the test, that will help quite a bit.

Thanks,
Steve

|||

This appears to be a bug in the how SMSS is interperting the ADO 'feedback' area.

I have a table (T1) with a trigger that updates another table (T2) on INSERT and UPDATE.

1. UPDATE T1 SET C1 = 'value' WHERE ID=2 works fines

2. Trapping the SSMS generated 'sp_executesql' statement using Profiler and then executing it works fine.

3. Using SSMS to update the same row results in the error above.

Note that both1 and 2 above result in messages as follows:

(1 row(s) affected)

(1 row(s) affected)

If memory serves me right these 'messages' are both passed back in the ADO 'feedback' area and can be processed by the code of SSMS. Seems the code wasn't tested with replications scenarios.

Im on W2K3 and SQL 2005 SP plus hot fixes.

|||

There is an open Microsoft Connect issue... you can track the progress here:
https://connect.microsoft.com:443/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=125566

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

|||I'm not sure if this will help any of you but I was able to get around this by putting a SET NOCOUNT ON at the beginning of my trigger.

Error updating data in table that uses a trigger?

Hello. I am new to SQL Server Management Studio 2005 and am using it to connect to a database on another machine running SQL Server 2000. Everything seems to work well, except when I try to edit table data on a particular table that has an update trigger associated with it. I am receiving the error:

-

The data in row 1 was not committed.

Error Source: Microsoft.VisualStudio.DataTools.

Error Message: The row value(s) updated or deleted either do not make the row unique or they alter multiple rows(5 rows).

Correct the errors and retry or press ESC to chancel the changes.

--

I want it to update those the 5 rows in the other tables...that's the whole point of having the trigger!

This used to work fine from Enterprise Manager 2000 and If I issue the update query manually from the new integrated "Query Analyzer" it is also ok. Is there some way to deactivate this new feature from the table viewer?

Thanks very much!

That error message occurred once for because there was a constraint which the deletion violated. I believe I had a field set to "NOT NULL" and the deletion was attempting to delete just that field for some reason.|||Also make sure that there are not two rows where every column is exactly the same.|||

Thanks for responding. My modification is not causing duplicate records to be created, nor am I violating any of my table rules (such as not NULL).

What I have is a trigger associated with my table so that whenever a record is updated it runs a stored procedure which then updates related information in other tables. It is not an error, but a very essential function of my database.

If I issue a manual update query (with query analyzer) I receive no errors and my trigger runs perfectly. It's only when I try to update a record interactively with the "Open Table" viewer/interface that I receive the error.

This new feature is very disruptive to the way I work and I was hoping that there was an option somewhere to turn it off, or make it so that it only applies to real errors such as duplicate records being created.

Thanks....

|||Can you run Profiler and gather a trace to see what it's doing differently than QA?|||

It's not really doing anything different, it's just that the new interactive "table viewer" has some sort of error checking routine that prohibits the update from executing because it sees that the query will affect data in other tables... which is what it was designed to do and worked flawlessly with Enterprise Manager 2000.

Am I the only person here who uses triggers to update data in other tables?

Thanks...

|||

You're absolutely not... I have the same problem. Very frustrating having to run the old version of Enterprise Manager just to update a few values.

Did you manage to find a fix for this?

|||Nope. No fix yet (that I'm aware of). Maybe if we keep this thread visible someone higher up can recommend that it be addressed in the next service pack.|||

Please file a defect report with the MSDN Feedback Center (http://lab.msdn.microsoft.com/productfeedback/).

If you can include a minimal script to create sample tables and a stored procedure to set up the test, that will help quite a bit.

Thanks,
Steve

|||

This appears to be a bug in the how SMSS is interperting the ADO 'feedback' area.

I have a table (T1) with a trigger that updates another table (T2) on INSERT and UPDATE.

1. UPDATE T1 SET C1 = 'value' WHERE ID=2 works fines

2. Trapping the SSMS generated 'sp_executesql' statement using Profiler and then executing it works fine.

3. Using SSMS to update the same row results in the error above.

Note that both1 and 2 above result in messages as follows:

(1 row(s) affected)

(1 row(s) affected)

If memory serves me right these 'messages' are both passed back in the ADO 'feedback' area and can be processed by the code of SSMS. Seems the code wasn't tested with replications scenarios.

Im on W2K3 and SQL 2005 SP plus hot fixes.

|||

There is an open Microsoft Connect issue... you can track the progress here:
https://connect.microsoft.com:443/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=125566

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

|||I'm not sure if this will help any of you but I was able to get around this by putting a SET NOCOUNT ON at the beginning of my trigger.

Error updating data in table that uses a trigger?

Hello. I am new to SQL Server Management Studio 2005 and am using it to connect to a database on another machine running SQL Server 2000. Everything seems to work well, except when I try to edit table data on a particular table that has an update trigger associated with it. I am receiving the error:

-

The data in row 1 was not committed.

Error Source: Microsoft.VisualStudio.DataTools.

Error Message: The row value(s) updated or deleted either do not make the row unique or they alter multiple rows(5 rows).

Correct the errors and retry or press ESC to chancel the changes.

--

I want it to update those the 5 rows in the other tables...that's the whole point of having the trigger!

This used to work fine from Enterprise Manager 2000 and If I issue the update query manually from the new integrated "Query Analyzer" it is also ok. Is there some way to deactivate this new feature from the table viewer?

Thanks very much!

That error message occurred once for because there was a constraint which the deletion violated. I believe I had a field set to "NOT NULL" and the deletion was attempting to delete just that field for some reason.|||Also make sure that there are not two rows where every column is exactly the same.|||

Thanks for responding. My modification is not causing duplicate records to be created, nor am I violating any of my table rules (such as not NULL).

What I have is a trigger associated with my table so that whenever a record is updated it runs a stored procedure which then updates related information in other tables. It is not an error, but a very essential function of my database.

If I issue a manual update query (with query analyzer) I receive no errors and my trigger runs perfectly. It's only when I try to update a record interactively with the "Open Table" viewer/interface that I receive the error.

This new feature is very disruptive to the way I work and I was hoping that there was an option somewhere to turn it off, or make it so that it only applies to real errors such as duplicate records being created.

Thanks....

|||Can you run Profiler and gather a trace to see what it's doing differently than QA?|||

It's not really doing anything different, it's just that the new interactive "table viewer" has some sort of error checking routine that prohibits the update from executing because it sees that the query will affect data in other tables... which is what it was designed to do and worked flawlessly with Enterprise Manager 2000.

Am I the only person here who uses triggers to update data in other tables?

Thanks...

|||

You're absolutely not... I have the same problem. Very frustrating having to run the old version of Enterprise Manager just to update a few values.

Did you manage to find a fix for this?

|||Nope. No fix yet (that I'm aware of). Maybe if we keep this thread visible someone higher up can recommend that it be addressed in the next service pack.|||

Please file a defect report with the MSDN Feedback Center (http://lab.msdn.microsoft.com/productfeedback/).

If you can include a minimal script to create sample tables and a stored procedure to set up the test, that will help quite a bit.

Thanks,
Steve

|||

This appears to be a bug in the how SMSS is interperting the ADO 'feedback' area.

I have a table (T1) with a trigger that updates another table (T2) on INSERT and UPDATE.

1. UPDATE T1 SET C1 = 'value' WHERE ID=2 works fines

2. Trapping the SSMS generated 'sp_executesql' statement using Profiler and then executing it works fine.

3. Using SSMS to update the same row results in the error above.

Note that both1 and 2 above result in messages as follows:

(1 row(s) affected)

(1 row(s) affected)

If memory serves me right these 'messages' are both passed back in the ADO 'feedback' area and can be processed by the code of SSMS. Seems the code wasn't tested with replications scenarios.

Im on W2K3 and SQL 2005 SP plus hot fixes.

|||

There is an open Microsoft Connect issue... you can track the progress here:
https://connect.microsoft.com:443/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=125566

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

|||I'm not sure if this will help any of you but I was able to get around this by putting a SET NOCOUNT ON at the beginning of my trigger.

Error updating data in table that uses a trigger?

Hello. I am new to SQL Server Management Studio 2005 and am using it to connect to a database on another machine running SQL Server 2000. Everything seems to work well, except when I try to edit table data on a particular table that has an update trigger associated with it. I am receiving the error:

-

The data in row 1 was not committed.

Error Source: Microsoft.VisualStudio.DataTools.

Error Message: The row value(s) updated or deleted either do not make the row unique or they alter multiple rows(5 rows).

Correct the errors and retry or press ESC to chancel the changes.

--

I want it to update those the 5 rows in the other tables...that's the whole point of having the trigger!

This used to work fine from Enterprise Manager 2000 and If I issue the update query manually from the new integrated "Query Analyzer" it is also ok. Is there some way to deactivate this new feature from the table viewer?

Thanks very much!

That error message occurred once for because there was a constraint which the deletion violated. I believe I had a field set to "NOT NULL" and the deletion was attempting to delete just that field for some reason.|||Also make sure that there are not two rows where every column is exactly the same.|||

Thanks for responding. My modification is not causing duplicate records to be created, nor am I violating any of my table rules (such as not NULL).

What I have is a trigger associated with my table so that whenever a record is updated it runs a stored procedure which then updates related information in other tables. It is not an error, but a very essential function of my database.

If I issue a manual update query (with query analyzer) I receive no errors and my trigger runs perfectly. It's only when I try to update a record interactively with the "Open Table" viewer/interface that I receive the error.

This new feature is very disruptive to the way I work and I was hoping that there was an option somewhere to turn it off, or make it so that it only applies to real errors such as duplicate records being created.

Thanks....

|||Can you run Profiler and gather a trace to see what it's doing differently than QA?|||

It's not really doing anything different, it's just that the new interactive "table viewer" has some sort of error checking routine that prohibits the update from executing because it sees that the query will affect data in other tables... which is what it was designed to do and worked flawlessly with Enterprise Manager 2000.

Am I the only person here who uses triggers to update data in other tables?

Thanks...

|||

You're absolutely not... I have the same problem. Very frustrating having to run the old version of Enterprise Manager just to update a few values.

Did you manage to find a fix for this?

|||Nope. No fix yet (that I'm aware of). Maybe if we keep this thread visible someone higher up can recommend that it be addressed in the next service pack.|||

Please file a defect report with the MSDN Feedback Center (http://lab.msdn.microsoft.com/productfeedback/).

If you can include a minimal script to create sample tables and a stored procedure to set up the test, that will help quite a bit.

Thanks,
Steve

|||

This appears to be a bug in the how SMSS is interperting the ADO 'feedback' area.

I have a table (T1) with a trigger that updates another table (T2) on INSERT and UPDATE.

1. UPDATE T1 SET C1 = 'value' WHERE ID=2 works fines

2. Trapping the SSMS generated 'sp_executesql' statement using Profiler and then executing it works fine.

3. Using SSMS to update the same row results in the error above.

Note that both1 and 2 above result in messages as follows:

(1 row(s) affected)

(1 row(s) affected)

If memory serves me right these 'messages' are both passed back in the ADO 'feedback' area and can be processed by the code of SSMS. Seems the code wasn't tested with replications scenarios.

Im on W2K3 and SQL 2005 SP plus hot fixes.

|||

There is an open Microsoft Connect issue... you can track the progress here:
https://connect.microsoft.com:443/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=125566

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

|||I'm not sure if this will help any of you but I was able to get around this by putting a SET NOCOUNT ON at the beginning of my trigger.

Error updating data in table that uses a trigger?

Hello. I am new to SQL Server Management Studio 2005 and am using it to connect to a database on another machine running SQL Server 2000. Everything seems to work well, except when I try to edit table data on a particular table that has an update trigger associated with it. I am receiving the error:

-

The data in row 1 was not committed.

Error Source: Microsoft.VisualStudio.DataTools.

Error Message: The row value(s) updated or deleted either do not make the row unique or they alter multiple rows(5 rows).

Correct the errors and retry or press ESC to chancel the changes.

--

I want it to update those the 5 rows in the other tables...that's the whole point of having the trigger!

This used to work fine from Enterprise Manager 2000 and If I issue the update query manually from the new integrated "Query Analyzer" it is also ok. Is there some way to deactivate this new feature from the table viewer?

Thanks very much!

That error message occurred once for because there was a constraint which the deletion violated. I believe I had a field set to "NOT NULL" and the deletion was attempting to delete just that field for some reason.|||Also make sure that there are not two rows where every column is exactly the same.|||

Thanks for responding. My modification is not causing duplicate records to be created, nor am I violating any of my table rules (such as not NULL).

What I have is a trigger associated with my table so that whenever a record is updated it runs a stored procedure which then updates related information in other tables. It is not an error, but a very essential function of my database.

If I issue a manual update query (with query analyzer) I receive no errors and my trigger runs perfectly. It's only when I try to update a record interactively with the "Open Table" viewer/interface that I receive the error.

This new feature is very disruptive to the way I work and I was hoping that there was an option somewhere to turn it off, or make it so that it only applies to real errors such as duplicate records being created.

Thanks....

|||Can you run Profiler and gather a trace to see what it's doing differently than QA?|||

It's not really doing anything different, it's just that the new interactive "table viewer" has some sort of error checking routine that prohibits the update from executing because it sees that the query will affect data in other tables... which is what it was designed to do and worked flawlessly with Enterprise Manager 2000.

Am I the only person here who uses triggers to update data in other tables?

Thanks...

|||

You're absolutely not... I have the same problem. Very frustrating having to run the old version of Enterprise Manager just to update a few values.

Did you manage to find a fix for this?

|||Nope. No fix yet (that I'm aware of). Maybe if we keep this thread visible someone higher up can recommend that it be addressed in the next service pack.|||

Please file a defect report with the MSDN Feedback Center (http://lab.msdn.microsoft.com/productfeedback/).

If you can include a minimal script to create sample tables and a stored procedure to set up the test, that will help quite a bit.

Thanks,
Steve

|||

This appears to be a bug in the how SMSS is interperting the ADO 'feedback' area.

I have a table (T1) with a trigger that updates another table (T2) on INSERT and UPDATE.

1. UPDATE T1 SET C1 = 'value' WHERE ID=2 works fines

2. Trapping the SSMS generated 'sp_executesql' statement using Profiler and then executing it works fine.

3. Using SSMS to update the same row results in the error above.

Note that both1 and 2 above result in messages as follows:

(1 row(s) affected)

(1 row(s) affected)

If memory serves me right these 'messages' are both passed back in the ADO 'feedback' area and can be processed by the code of SSMS. Seems the code wasn't tested with replications scenarios.

Im on W2K3 and SQL 2005 SP plus hot fixes.

|||

There is an open Microsoft Connect issue... you can track the progress here:
https://connect.microsoft.com:443/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=125566

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

|||I'm not sure if this will help any of you but I was able to get around this by putting a SET NOCOUNT ON at the beginning of my trigger.

ERROR TIMEOUT EXPIRED

HELLO ALL

IM AM DEVELOPING WINDOWS APPLICATION (VB.NET2005).

I HAVE BACK END SQL SERVER 2000.

MY OS IS WINDOWS XP.

NOW I HAVE A ANOTHER MACHINE , IN THAT I INSTALLED MY APPLICATION.

NOW WHEN I LOGIN INTO MY APPLPICATION, IT DISPLAYS AN ERROR

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

WHAT WILL BE PROBLEM IN THIS

PLEASE HELP ME.

ANOTHER THING IF I CHANGE DATA SOURCE NAME AS SERVERSYSTEM(IT IS THE NAME OF OUR SERVER 2003) IT WORKS FINE

THANKS IN ADVCANCE

This error is frequently caused by an incorrect server name or instance name in your connection string. Check that.

By the way, this forum is dedicated to SQL Server Notification Services. You'll find better / more answers in a forum that more appropriate for your issue.

HTH...

Joe

Error System.InvalidOperationException: Client found response cont

Hi, All.
I have a windows 2000 server machine with SQL Enterprise 2000 edition and
reporting service enterprise edition on it.
The Report Mangaer application and the Report Server Web service are both
working.
and i have a web application that makes calls against the reporting service
API.
and I get the following error regardless of any method I call.
System.InvalidOperationException: Client found response content type of
'text/html', but expected 'text/xml'. The request failed with the error
message: -- -2146893039 (0x80090311) --. at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
message, WebResponse response, Stream responseStream, Boolean asyncCall) at
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters) at
ADschedule.SQLreporting.ReportingService.ListChildren(String Item, Boolean
Recursive).
Can anyone help to explain what to do?
tksThe problem is you are getting back an html response rather then a SOAP
response (xml). Have you verified that the .Url property is correct set on
your proxy object?
The error you are seeing is:
No authority could be contacted for authentication.
Have you set the credentials property correctly?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hang" <Hang@.discussions.microsoft.com> wrote in message
news:DC04C055-5821-4DC5-8A78-0519F2FDAA4E@.microsoft.com...
> Hi, All.
> I have a windows 2000 server machine with SQL Enterprise 2000 edition and
> reporting service enterprise edition on it.
> The Report Mangaer application and the Report Server Web service are both
> working.
> and i have a web application that makes calls against the reporting
> service
> API.
> and I get the following error regardless of any method I call.
> System.InvalidOperationException: Client found response content type of
> 'text/html', but expected 'text/xml'. The request failed with the error
> message: -- -2146893039 (0x80090311) --. at
> System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> message, WebResponse response, Stream responseStream, Boolean asyncCall)
> at
> System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters) at
> ADschedule.SQLreporting.ReportingService.ListChildren(String Item, Boolean
> Recursive).
>
> Can anyone help to explain what to do?
> tks
>|||Thanks for replying, Daniel
Yes. the .Url property is correct. I explicitly set it once i create a proxy
object.
here is a sample code
Dim rs As sqlReport.ReportingService
rs = New ReportingService
rs.Url = "http://severName/ReportServer/ReportService.asmx"
rs.Credentials = New NetworkCredential
("userName", "password", "theDomainName")
Dim c As CatalogItem() = rs.ListChildren("/", True)
that is the code code that throws the exception
by the way, On the same server, I used to have reporting service evaluation
edition and my application worked fine.
Then I got that problem after installing the official version(I uninstalled
the evalutiaon edition and deleted all the database associated with it before
installing).
tks.
"Daniel Reib [MSFT]" wrote:
> The problem is you are getting back an html response rather then a SOAP
> response (xml). Have you verified that the .Url property is correct set on
> your proxy object?
> The error you are seeing is:
> No authority could be contacted for authentication.
> Have you set the credentials property correctly?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Hang" <Hang@.discussions.microsoft.com> wrote in message
> news:DC04C055-5821-4DC5-8A78-0519F2FDAA4E@.microsoft.com...
> > Hi, All.
> > I have a windows 2000 server machine with SQL Enterprise 2000 edition and
> > reporting service enterprise edition on it.
> >
> > The Report Mangaer application and the Report Server Web service are both
> > working.
> > and i have a web application that makes calls against the reporting
> > service
> > API.
> > and I get the following error regardless of any method I call.
> >
> > System.InvalidOperationException: Client found response content type of
> > 'text/html', but expected 'text/xml'. The request failed with the error
> > message: -- -2146893039 (0x80090311) --. at
> > System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> > message, WebResponse response, Stream responseStream, Boolean asyncCall)
> > at
> > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > methodName, Object[] parameters) at
> > ADschedule.SQLreporting.ReportingService.ListChildren(String Item, Boolean
> > Recursive).
> >
> >
> > Can anyone help to explain what to do?
> >
> > tks
> >
>
>|||Just to follow up on this. It turned out it was an credential problem in this
case.
The web server, which hosts the web application, needs to be in the same
domain as that of the web server hosting the reporting services web service.
And a proper domain account is needed for accessing the reporting services
web service in this case.
hope this helps others who have encountered similiar problems.
Tks
"Hang" wrote:
> Thanks for replying, Daniel
> Yes. the .Url property is correct. I explicitly set it once i create a proxy
> object.
> here is a sample code
> Dim rs As sqlReport.ReportingService
> rs = New ReportingService
> rs.Url = "http://severName/ReportServer/ReportService.asmx"
> rs.Credentials = New NetworkCredential
> ("userName", "password", "theDomainName")
> Dim c As CatalogItem() = rs.ListChildren("/", True)
> that is the code code that throws the exception
> by the way, On the same server, I used to have reporting service evaluation
> edition and my application worked fine.
> Then I got that problem after installing the official version(I uninstalled
> the evalutiaon edition and deleted all the database associated with it before
> installing).
>
> tks.
> "Daniel Reib [MSFT]" wrote:
> > The problem is you are getting back an html response rather then a SOAP
> > response (xml). Have you verified that the .Url property is correct set on
> > your proxy object?
> >
> > The error you are seeing is:
> >
> > No authority could be contacted for authentication.
> >
> > Have you set the credentials property correctly?
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > "Hang" <Hang@.discussions.microsoft.com> wrote in message
> > news:DC04C055-5821-4DC5-8A78-0519F2FDAA4E@.microsoft.com...
> > > Hi, All.
> > > I have a windows 2000 server machine with SQL Enterprise 2000 edition and
> > > reporting service enterprise edition on it.
> > >
> > > The Report Mangaer application and the Report Server Web service are both
> > > working.
> > > and i have a web application that makes calls against the reporting
> > > service
> > > API.
> > > and I get the following error regardless of any method I call.
> > >
> > > System.InvalidOperationException: Client found response content type of
> > > 'text/html', but expected 'text/xml'. The request failed with the error
> > > message: -- -2146893039 (0x80090311) --. at
> > > System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> > > message, WebResponse response, Stream responseStream, Boolean asyncCall)
> > > at
> > > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > > methodName, Object[] parameters) at
> > > ADschedule.SQLreporting.ReportingService.ListChildren(String Item, Boolean
> > > Recursive).
> > >
> > >
> > > Can anyone help to explain what to do?
> > >
> > > tks
> > >
> >
> >
> >