Showing posts with label sync. Show all posts
Showing posts with label sync. Show all posts

Friday, March 9, 2012

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.

Friday, February 24, 2012

Error trying to install reporting services

I have verified that iwam_computer is enabled and in sync.
error mesage -
Internet Information Services 5.0 (IIS) or later is either not installed, or
it is configured in a way that is incompatible with a Reporting Services
installation.
log -
Microsoft SQL Server 2000 Reporting Services Setup beginning at Mon Jan 24
09:22:42 2005
<Func Name='UpdateComponents'>
SCU_SetupMgr::InitComponents()
<Func Name='WindowsInstallerComp::Init'>
<Func Name='WindowsInstallerComp::IsRequired'>
<Func Name='DotNetFxComp::Init'>
<Func Name='DotNetFxComp::IsRequired'>
<EndFunc Name='DotNetFxComp::IsRequired' Return='F' GetLastError='0'>
SCU_SetupMgr::svc() state=SS_INIT_DONE, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:414}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
<Func Name='SqlSetupFilesComp::Install'>
<Func Name='BootstrapPackageLogic'>
<Func Name='InstallBootstrapPackage'>
/I "E:\SQLRSEVAL\Setup\bootmsi.dat" REBOOT="ReallySuppress"
ADDLOCAL="BootstrapFiles,WatsonFiles,ParsFiles1033,HelpFiles1028,HelpFiles1031,HelpFiles1033,HelpFiles1036,HelpFiles1040,HelpFiles1041,HelpFiles1042,HelpFiles2052,HelpFiles3082,WatsonFiles1033" /qn
<EndFunc Name='InstallBootstrapPackage' Return='0' GetLastError='183'>
<EndFunc Name='BootstrapPackageLogic' Return='0' GetLastError='183'>
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
ScuProgressDlg::SetupFinished()
ScuProgressDlg::DialogProc() installation done... waiting for setup mgr
SCU_SetupMgr::svc() finished. SetupMgr: state=FINISHED, cancel_state=0,
is_done=1, ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:420}
<EndFunc Name='UpdateComponents' Return='0' GetLastError='183'>
<Func Name='DwLaunchMsiExec'>
<Func Name='PerformDetections'>
0
<EndFunc Name='PerformDetections' Return='0' GetLastError='0'>
Machine = ISOVDEVWAC8, Article = IIS, Result = 0 (0x0)
<Prerequisite Name="IsVS71Installed" Checked="Registry"
Item="HKLM\SOFTWARE\Microsoft\VisualStudio\7.1" Found="Can not open key"
Expected="No error" Result="Fail" />
Machine = ISOVDEVWAC8, Article = VSNET, Result = 60351 (0xebbf)
Machine = ISOVDEVWAC8, Article = ASPNET, Result = 0 (0x0)
Machine = ISOVDEVWAC8, Article = MDAC, Result = 0 (0x0)
Machine = ISOVDEVWAC8, Article = DTC, Result = 0 (0x0)
Machine = ISOVDEVWAC8, Article = SERVEROS, Result = 0 (0x0)
Machine = ISOVDEVWAC8, Article = SHAREPOINT, Result = 0 (0x0)
Machine = ISOVDEVWAC8, Article = AUTHZ, Result = 0 (0x0)
<Prerequisite Name="AreRSAccountsValidInstalled" Checked="User accounts"
Item="IWAM_machineName" Found="Not exist or not enable" Expected="Exist and
enabled" Result="Fail" />
Machine = ISOVDEVWAC8, Article = RSACCOUNTS, Result = 60357 (0xebc5)
**************
ISOVDEVWAC8
**************
Report Designer component requirement
<B>Explanation:</B> Visual Studio .NET 2003 is not installed.
<B>Action:</B> Install Visual Studio .NET 2003, and then rerun Setup to
install Report Designer. Or, continue Setup to complete the installation
without Report Designer.
Report Server component requirement
<B>Explanation:</B> Internet Information Services 5.0 (IIS) or later is
either not installed, or it is configured in a way that is incompatible with
a Reporting Services installation.
<B>Action:</B> To install the Report Server and Report Manager components,
you must first install Internet Information Services 5.0 (IIS) or later, and
then verify that the Web server configuration requirements are compatible
with Setup. Check the Setup documentation for more information about Web
server configuration requirements.
Report size = 1050
<Func Name='FSetupLogging'>
<Func Name='CreateSetupLogCabs'>
Creating Setup Logs Cab "C:\Program Files\Microsoft SQL Server\80\RS Setup
Bootstrap\LOG\RSStp_.cab"seems error comes from these line
> <Func Name='InstallBootstrapPackage'
> /I "E:\SQLRSEVAL\Setup\bootmsi.dat" REBOOT="ReallySuppress"
ADDLOCAL="BootstrapFiles,WatsonFiles,ParsFiles1033,HelpFiles1028,HelpFiles1031,HelpFiles1033,HelpFiles1036,HelpFiles1040,HelpFiles1041,HelpFiles1042,HelpFiles2052,HelpFiles3082,WatsonFiles1033
/q
> <EndFunc Name='InstallBootstrapPackage' Return='0
GetLastError='183'
> <EndFunc Name='BootstrapPackageLogic' Return='0
GetLastError='183'
>
Did you find how to solve it ? i got the same problem..
Thank|||o
in my case i used to install it with the command line options wher
some errors are but if you used the response file it's the same
For example do not use REINSTALL=All; it just failed, us
REINSTALLMODE=omus or amus (omus works
Also RS_BooksOnline_EN is not a valid entry even you see it everywher
on Ms Docs (bull...
use RS_BooksOnline and not RS_BooksOnline_EN
Hope it will hav helped yo