Hello, I have setup web sync from wm 5.0 and it seems to crash when applying the snapshot. Looking at the column definitions it seems fine. Am I missing something? Thanks in advance.
John
The identity column must be either an integer or big integer data type and cannot be NULL.
HRESULT 0x80004005 (25551)
The SQL statement failed to execute. [ SQL statement = CREATE TABLE "macros" ( "peopleid" numeric ( 18 , 0 ) NOT NULL , "macroid" numeric ( 18 , 0 ) IDENTITY ( 1 , 1 ) NOT NULL , "description" nvarchar ( 255 ) NULL , "rowguid" uniqueidentifier ROWGUIDCOL NOT NULL CONSTRAINT "MSmerge_df_rowguid_8E4B26C6706844BC984B039BA07845B5" DEFAULT ( NEWID ( ) ) ) ]
HRESULT 0x80004005 (28560)
The operation could not be completed.
The error message has everything! Please read it again. It says that your identity column (macroid) is not of type bigint or int. SQL Server Mobile/Everywhere support IDENTITY only on int and bigint.
Thanks,
Laxmi Narsimha Rao ORUGANTI, SQL Server Everywhere, Microsoft Corporation
|||I'm getting the same error when trying to set up a subscription to merge replication with wm 5.0. Here is the error:
The identity column must be either an integer or big integer data type and cannot be NULL.
HRESULT 0x80004005 (25551)
The SQL statement failed to execute. If this occurred while using merge replication, this is an internal error. If this occurred while using RDA, then the SQL statement is invalid either on the PULL statement or on the SubmitSQL statement. [ SQL statement = CREATE TABLE "INV_MfrProduct" ( "MfrProductId" numeric ( 18 , 0 ) IDENTITY ( 1 , 1 ) NOT NULL , "MfrProductDesc" nvarchar ( 100 ) NOT NULL , "isActive" bit NOT NULL , "ClassId" numeric ( 18 , 0 ) NULL , "rowguid" uniqueidentifier ROWGUIDCOL NOT NULL CONSTRAINT "MSmerge_df_rowguid_CA8620C3C47D4A388517DDA409E1C2AB" DEFAULT ( NEWID ( ) ) ) ]
HRESULT
The table in question though is only one (last one) out of several that have identity as numeric field. The identity range is safely within the limits of bigint though. So, what would be the solution to this? Not use merge replication?
Please, advise.
No comments:
Post a Comment