Who can tell me what does error message mean?

  • Thread starter Thread starter Colin Chen
  • Start date Start date
C

Colin Chen

What may cause this problem?
error message:

¡°An unhandled exception of type
'System.Web.Services.Protocols.SoapException' occurred in
system.web.services.dll



Additional information: System.Web.Services.Protocols.SoapException: Server
was unable to process request. ---> System.Data.SqlClient.SqlException:
Updating columns with the rowguidcol property is not allowed.

at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows,
DataTableMapping tableMapping)

at System.Data.Common.DbDataAdapter.Update(DataTable dataTable)

at ProductsService.ProductsServiceClass.UpdateProductsData(String Diff)
in d:\donnet_service\productsservice\productsserviceclass.h:line 228

--- End of inner exception stack trace ---¡±
 
Hi Colin,

It seems to me that this is a server side error while updating database.
It also seems that you are trying to update ROWGUIDCOL in the sql server
which is not allowed.
Can you show us the commandtext belonging to dataadapter you use to invoke
Update?
 
Of course.
Thanks for you help.
It's my first time to post mail here.

====================================
The code following is for a Web Service Application
=====================================
// Write the DataSet data as an XML DiffGram string.
System.IO.StringWriter sw = new System.IO.StringWriter();
dataSet1.WriteXml(sw, XmlWriteMode.DiffGram);

// Display the XML DiffGram in the text box to show what it looks like.
richTextBox1.Text = sw.ToString();

// Create a proxy object that is ready to invoke the XML Web service method.
localhost.Service1 svc = new localhost.Service1();

// Invoke the XML Web service method to save Products data.
svc.UpdateProductsData(sw.ToString());
==============================================
The code following is for a Web Service
==============================================
[WebMethod]
public void UpdateProductsData(string Diff)
{
//Read the XML DiffGram into the DataSet object in the XML Web service.
System.IO.StringReader sr = new System.IO.StringReader(Diff);
productsDataSet1.ReadXml(sr, XmlReadMode.DiffGram);

// Use the SqlDataAdapter object to update the database accordingly.
sqlDataAdapter1.Update(productsDataSet1.Products);
}
==============================================================

Miha Markic said:
Hi Colin,

It seems to me that this is a server side error while updating database.
It also seems that you are trying to update ROWGUIDCOL in the sql server
which is not allowed.
Can you show us the commandtext belonging to dataadapter you use to invoke
Update?

--
Miha Markic [MVP C#] - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

Colin Chen said:
What may cause this problem?
error message:

¡°An unhandled exception of type
'System.Web.Services.Protocols.SoapException' occurred in
system.web.services.dll



Additional information: System.Web.Services.Protocols.SoapException: Server
was unable to process request. ---> System.Data.SqlClient.SqlException:
Updating columns with the rowguidcol property is not allowed.

at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows,
DataTableMapping tableMapping)

at System.Data.Common.DbDataAdapter.Update(DataTable dataTable)

at ProductsService.ProductsServiceClass.UpdateProductsData(String Diff)
in d:\donnet_service\productsservice\productsserviceclass.h:line 228

--- End of inner exception stack trace ---¡±
Click to expand...
Click to expand...
 
Thank you Miha Markic.
I have solved the problem, it's about a SQL SERVER issue.
Thank you for your help indeed.

Miha Markic said:
Hi Colin,

It seems to me that this is a server side error while updating database.
It also seems that you are trying to update ROWGUIDCOL in the sql server
which is not allowed.
Can you show us the commandtext belonging to dataadapter you use to invoke
Update?

--
Miha Markic [MVP C#] - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

Colin Chen said:
What may cause this problem?
error message:

¡°An unhandled exception of type
'System.Web.Services.Protocols.SoapException' occurred in
system.web.services.dll



Additional information: System.Web.Services.Protocols.SoapException: Server
was unable to process request. ---> System.Data.SqlClient.SqlException:
Updating columns with the rowguidcol property is not allowed.

at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows,
DataTableMapping tableMapping)

at System.Data.Common.DbDataAdapter.Update(DataTable dataTable)

at ProductsService.ProductsServiceClass.UpdateProductsData(String Diff)
in d:\donnet_service\productsservice\productsserviceclass.h:line 228

--- End of inner exception stack trace ---¡±
Click to expand...
Click to expand...
 
Back
Top