We have a simple table with no relationships that is not deploying data due to an XML Field. The DDT error is shown in the attached file "DDT_Data_Deploy_Error.png" and the actual table properties are in the file "Settings_Table_XML.png." Here's a snippet from the text log file:
2/10/2009 8:57:49 AM-> Deploying data from OHRSettings...
2/10/2009 8:57:49 AM-> An error occurred while deploying the data to the server.
2/10/2009 8:57:49 AM-> SqlException
2/10/2009 8:57:49 AM-> Procedure or function 'OHRSettingsInsertOverwrite' expects parameter '@SettingsXML', which was not supplied.
We have a Data Deployment package that will copy data if the User_fk = -1. If there's any data that matches this, the deploy fails with the above message. I checked that the OHRSettingsInsertOverwrite SP is on the db and it is:
USE [SYSTOC800]
GO
/****** Object: StoredProcedure [dbo].[OHRSettingsInsertOverwrite] Script Date: 02/10/2009 10:26:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[OHRSettingsInsertOverwrite] @OHRSettings_pk as Int, @User_fk as Int, @RetrievalKey as VarChar(255), @GroupKey as VarChar(255), @SettingsXML as Xml, @RowVersion as Int, @RowState as TinyInt AS BEGIN DELETE FROM OHRSettings WHERE OHRSettings_pk = @OHRSettings_pk SET IDENTITY_INSERT OHRSettings ON INSERT INTO OHRSettings (OHRSettings_pk, User_fk, RetrievalKey, GroupKey, SettingsXML, RowVersion, RowState) VALUES (@OHRSettings_pk, @User_fk, @RetrievalKey, @GroupKey, @SettingsXML, @RowVersion, @RowState) SET IDENTITY_INSERT OHRSettings OFF END
Have you run into any issues with XML fields? If so, do you have a workaround for this situation? I can provide more info if you need it.
Thanks,
Derek