Error when applying snapshot

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.

Error when applying snapshot

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.

Error when applying a filter to a table

Table Properties, Filter Tab.
Added a filter.
Expression: =Fields!LastActionDate.Value
Operator: = Value: "7/1/2004"
Receive following when previewing report:
"An error has occured during report processing. The processing of
filter expression for the table 'table1' cannot be performed. The
comparision failed. Please check the data type returned by the data
expression."
I tried Expression: =CDate(Fields!LastActionDate.Value)
I tried removing quotes from Date value.
No Luck.
Can someone help?
Thank you!You'll also need to cast the filter Value: =CDate("7/1/2004")
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"The Whistler" <sharris@.SLeasynews.com> wrote in message
news:s6puh0pvgceg530k3sfagtefa3qogid418@.4ax.com...
> Table Properties, Filter Tab.
> Added a filter.
> Expression: =Fields!LastActionDate.Value
> Operator: => Value: "7/1/2004"
> Receive following when previewing report:
> "An error has occured during report processing. The processing of
> filter expression for the table 'table1' cannot be performed. The
> comparision failed. Please check the data type returned by the data
> expression."
> I tried Expression: =CDate(Fields!LastActionDate.Value)
> I tried removing quotes from Date value.
> No Luck.
> Can someone help?
> Thank you!
>
>