Hi all,
I have a problem with replication. I did a search for error number 28549 in
this group and find no answer that matched my case. :-(
I have used replication for download data from sqlserver to pda. All the
tables a independent with each other. No link between them.
I have set the -ExchangeType 2 so that the synchronization is just one
direction from sql server to pda.
There aren't null data.
I have 50 users synchronize data. Some of users succeeded but most of them
failed.
The error is 28549-Integrity Violation...
I tried to copy the data file (.sdf) from pda of user succeeded in
synchronization. And then paste it to a new pda, synchronize again, and
that's so odd!!!! I met the same error!!!
I was confused, Can anyone help me out...
So appreciated
I have found that server have insert some rows that existing in
subscriptions. How can I find which row is conflict with db at subscriptions
at merge-agents. or at db server.
I have tried to delete merge_contents table, and it seems after that, all
subscriptions can not be regconized. All subscriptions are anonymous
subscriptions
"Mai Thoa" wrote:
> Hi all,
> I have a problem with replication. I did a search for error number 28549 in
> this group and find no answer that matched my case. :-(
> I have used replication for download data from sqlserver to pda. All the
> tables a independent with each other. No link between them.
> I have set the -ExchangeType 2 so that the synchronization is just one
> direction from sql server to pda.
> There aren't null data.
> I have 50 users synchronize data. Some of users succeeded but most of them
> failed.
> The error is 28549-Integrity Violation...
> I tried to copy the data file (.sdf) from pda of user succeeded in
> synchronization. And then paste it to a new pda, synchronize again, and
> that's so odd!!!! I met the same error!!!
> I was confused, Can anyone help me out...
> So appreciated
|||Please provide more detail about your setup, like, version of sql server,
kind of replication (replication over VPN or web sync using https), and in
which replication process are you getting this error?
thansk - Deepak
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Mai Thoa" <MaiThoa@.discussions.microsoft.com> wrote in message
news:09DF1BD7-55D6-473A-9FA0-BEA8B021603F@.microsoft.com...
> I have found that server have insert some rows that existing in
> subscriptions. How can I find which row is conflict with db at
subscriptions[vbcol=seagreen]
> at merge-agents. or at db server.
> I have tried to delete merge_contents table, and it seems after that, all
> subscriptions can not be regconized. All subscriptions are anonymous
> subscriptions
> "Mai Thoa" wrote:
in[vbcol=seagreen]
them[vbcol=seagreen]
Showing posts with label case. Show all posts
Showing posts with label case. Show all posts
Sunday, March 11, 2012
Friday, February 24, 2012
2005 SP 1 Install Failure Solution - Unable to install Windows Installer MSP file
This is posted for others who have
If this error occurs here is what worked for me. I hope it may work for you
but am not sure.
In my case I had SQL Express 2005 Installer on my system as well as I run
both (one for development, one for production).
Shut down all SQL related services manually.
I set registry permissions on Software\Policies\Microsoft\Windows\Installer
to include the account that is doing the install with Full Control. Click
Advanced and make sure everything is selected.
I downloaded and ran the SQL Install Cleanup and removed the SQL 2005 Setup
Files Installer and the SQL Express Installer. I then reinstalled the SQL
Setup Files (ONLY!!!!!) from my SQL Server 2005 CD. If you don't don't do
this you won't be able to use the SP.
Q290301 OFFXP: Windows Installer CleanUp Utility
http://support.microsoft.com/support/kb/articles/q290/3/01.asp
I then reinstalled the SP and it worked.
Hope this helps somebody.
Special thanks to Peter Yang of Microsoft for his invaluable assistance on
this issue.
--
Get a powerful web, database, application, and email hosting with KJM
Solutions
http://www.kjmsolutions.comForgot to mention this is on a Windows Server 2003 SP1 platform.
--
Get a powerful web, database, application, and email hosting with KJM
Solutions
http://www.kjmsolutions.com
"vbnetdev" <vbnetdev@.community.nospam> wrote in message
news:OdGUsVgaGHA.3304@.TK2MSFTNGP04.phx.gbl...
> This is posted for others who have
> If this error occurs here is what worked for me. I hope it may work for
> you but am not sure.
> In my case I had SQL Express 2005 Installer on my system as well as I run
> both (one for development, one for production).
> Shut down all SQL related services manually.
> I set registry permissions on
> Software\Policies\Microsoft\Windows\Installer to include the account that
> is doing the install with Full Control. Click Advanced and make sure
> everything is selected.
> I downloaded and ran the SQL Install Cleanup and removed the SQL 2005
> Setup Files Installer and the SQL Express Installer. I then reinstalled
> the SQL Setup Files (ONLY!!!!!) from my SQL Server 2005 CD. If you don't
> don't do this you won't be able to use the SP.
> Q290301 OFFXP: Windows Installer CleanUp Utility
> http://support.microsoft.com/support/kb/articles/q290/3/01.asp
> I then reinstalled the SP and it worked.
> Hope this helps somebody.
> Special thanks to Peter Yang of Microsoft for his invaluable assistance on
> this issue.
> --
> Get a powerful web, database, application, and email hosting with KJM
> Solutions
> http://www.kjmsolutions.com
>
>|||Hi,
Thanks for your feedback. This information has been added to Microsoft's
database. Your solution will benefit many other users, and we really value
having you as a Microsoft customer.
If you have any other questions or concerns, please do not hesitate to
contact us. It is always our pleasure to be of assistance.
Have a nice day!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "vbnetdev" <vbnetdev@.community.nospam>
>References: <OdGUsVgaGHA.3304@.TK2MSFTNGP04.phx.gbl>
>Subject: Re: 2005 SP 1 Install Failure Solution - Unable to install
Windows Installer MSP file
>Date: Thu, 27 Apr 2006 10:15:48 -0500
>Lines: 50
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
>X-RFC2646: Format=Flowed; Response
>Message-ID: <uQdG71gaGHA.3740@.TK2MSFTNGP03.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 63-252-11-73.ip.mcleodusa.net 63.252.11.73
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:429460
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Forgot to mention this is on a Windows Server 2003 SP1 platform.
>--
>Get a powerful web, database, application, and email hosting with KJM
>Solutions
>http://www.kjmsolutions.com
>
>"vbnetdev" <vbnetdev@.community.nospam> wrote in message
>news:OdGUsVgaGHA.3304@.TK2MSFTNGP04.phx.gbl...
>> This is posted for others who have
>> If this error occurs here is what worked for me. I hope it may work for
>> you but am not sure.
>> In my case I had SQL Express 2005 Installer on my system as well as I
run
>> both (one for development, one for production).
>> Shut down all SQL related services manually.
>> I set registry permissions on
>> Software\Policies\Microsoft\Windows\Installer to include the account
that
>> is doing the install with Full Control. Click Advanced and make sure
>> everything is selected.
>> I downloaded and ran the SQL Install Cleanup and removed the SQL 2005
>> Setup Files Installer and the SQL Express Installer. I then reinstalled
>> the SQL Setup Files (ONLY!!!!!) from my SQL Server 2005 CD. If you don't
>> don't do this you won't be able to use the SP.
>> Q290301 OFFXP: Windows Installer CleanUp Utility
>> http://support.microsoft.com/support/kb/articles/q290/3/01.asp
>> I then reinstalled the SP and it worked.
>> Hope this helps somebody.
>> Special thanks to Peter Yang of Microsoft for his invaluable assistance
on
>> this issue.
>> --
>> Get a powerful web, database, application, and email hosting with KJM
>> Solutions
>> http://www.kjmsolutions.com
>>
>>
>
>
If this error occurs here is what worked for me. I hope it may work for you
but am not sure.
In my case I had SQL Express 2005 Installer on my system as well as I run
both (one for development, one for production).
Shut down all SQL related services manually.
I set registry permissions on Software\Policies\Microsoft\Windows\Installer
to include the account that is doing the install with Full Control. Click
Advanced and make sure everything is selected.
I downloaded and ran the SQL Install Cleanup and removed the SQL 2005 Setup
Files Installer and the SQL Express Installer. I then reinstalled the SQL
Setup Files (ONLY!!!!!) from my SQL Server 2005 CD. If you don't don't do
this you won't be able to use the SP.
Q290301 OFFXP: Windows Installer CleanUp Utility
http://support.microsoft.com/support/kb/articles/q290/3/01.asp
I then reinstalled the SP and it worked.
Hope this helps somebody.
Special thanks to Peter Yang of Microsoft for his invaluable assistance on
this issue.
--
Get a powerful web, database, application, and email hosting with KJM
Solutions
http://www.kjmsolutions.comForgot to mention this is on a Windows Server 2003 SP1 platform.
--
Get a powerful web, database, application, and email hosting with KJM
Solutions
http://www.kjmsolutions.com
"vbnetdev" <vbnetdev@.community.nospam> wrote in message
news:OdGUsVgaGHA.3304@.TK2MSFTNGP04.phx.gbl...
> This is posted for others who have
> If this error occurs here is what worked for me. I hope it may work for
> you but am not sure.
> In my case I had SQL Express 2005 Installer on my system as well as I run
> both (one for development, one for production).
> Shut down all SQL related services manually.
> I set registry permissions on
> Software\Policies\Microsoft\Windows\Installer to include the account that
> is doing the install with Full Control. Click Advanced and make sure
> everything is selected.
> I downloaded and ran the SQL Install Cleanup and removed the SQL 2005
> Setup Files Installer and the SQL Express Installer. I then reinstalled
> the SQL Setup Files (ONLY!!!!!) from my SQL Server 2005 CD. If you don't
> don't do this you won't be able to use the SP.
> Q290301 OFFXP: Windows Installer CleanUp Utility
> http://support.microsoft.com/support/kb/articles/q290/3/01.asp
> I then reinstalled the SP and it worked.
> Hope this helps somebody.
> Special thanks to Peter Yang of Microsoft for his invaluable assistance on
> this issue.
> --
> Get a powerful web, database, application, and email hosting with KJM
> Solutions
> http://www.kjmsolutions.com
>
>|||Hi,
Thanks for your feedback. This information has been added to Microsoft's
database. Your solution will benefit many other users, and we really value
having you as a Microsoft customer.
If you have any other questions or concerns, please do not hesitate to
contact us. It is always our pleasure to be of assistance.
Have a nice day!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "vbnetdev" <vbnetdev@.community.nospam>
>References: <OdGUsVgaGHA.3304@.TK2MSFTNGP04.phx.gbl>
>Subject: Re: 2005 SP 1 Install Failure Solution - Unable to install
Windows Installer MSP file
>Date: Thu, 27 Apr 2006 10:15:48 -0500
>Lines: 50
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
>X-RFC2646: Format=Flowed; Response
>Message-ID: <uQdG71gaGHA.3740@.TK2MSFTNGP03.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 63-252-11-73.ip.mcleodusa.net 63.252.11.73
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:429460
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Forgot to mention this is on a Windows Server 2003 SP1 platform.
>--
>Get a powerful web, database, application, and email hosting with KJM
>Solutions
>http://www.kjmsolutions.com
>
>"vbnetdev" <vbnetdev@.community.nospam> wrote in message
>news:OdGUsVgaGHA.3304@.TK2MSFTNGP04.phx.gbl...
>> This is posted for others who have
>> If this error occurs here is what worked for me. I hope it may work for
>> you but am not sure.
>> In my case I had SQL Express 2005 Installer on my system as well as I
run
>> both (one for development, one for production).
>> Shut down all SQL related services manually.
>> I set registry permissions on
>> Software\Policies\Microsoft\Windows\Installer to include the account
that
>> is doing the install with Full Control. Click Advanced and make sure
>> everything is selected.
>> I downloaded and ran the SQL Install Cleanup and removed the SQL 2005
>> Setup Files Installer and the SQL Express Installer. I then reinstalled
>> the SQL Setup Files (ONLY!!!!!) from my SQL Server 2005 CD. If you don't
>> don't do this you won't be able to use the SP.
>> Q290301 OFFXP: Windows Installer CleanUp Utility
>> http://support.microsoft.com/support/kb/articles/q290/3/01.asp
>> I then reinstalled the SP and it worked.
>> Hope this helps somebody.
>> Special thanks to Peter Yang of Microsoft for his invaluable assistance
on
>> this issue.
>> --
>> Get a powerful web, database, application, and email hosting with KJM
>> Solutions
>> http://www.kjmsolutions.com
>>
>>
>
>
2005 SP 1 Install Failure Solution - Unable to install Windows Installer MSP file
This is posted for others who have
If this error occurs here is what worked for me. I hope it may work for you
but am not sure.
In my case I had SQL Express 2005 Installer on my system as well as I run
both (one for development, one for production).
Shut down all SQL related services manually.
I set registry permissions on Software\Policies\Microsoft\Windows\Inst
aller
to include the account that is doing the install with Full Control. Click
Advanced and make sure everything is selected.
I downloaded and ran the SQL Install Cleanup and removed the SQL 2005 Setup
Files Installer and the SQL Express Installer. I then reinstalled the SQL
Setup Files (ONLY!!!!!) from my SQL Server 2005 CD. If you don't don't do
this you won't be able to use the SP.
Q290301 OFFXP: Windows Installer CleanUp Utility
http://support.microsoft.com/suppor...s/q290/3/01.asp
I then reinstalled the SP and it worked.
Hope this helps somebody.
Special thanks to Peter Yang of Microsoft for his invaluable assistance on
this issue.
--
Get a powerful web, database, application, and email hosting with KJM
Solutions
http://www.kjmsolutions.comForgot to mention this is on a Windows Server 2003 SP1 platform.
Get a powerful web, database, application, and email hosting with KJM
Solutions
http://www.kjmsolutions.com
"vbnetdev" <vbnetdev@.community.nospam> wrote in message
news:OdGUsVgaGHA.3304@.TK2MSFTNGP04.phx.gbl...
> This is posted for others who have
> If this error occurs here is what worked for me. I hope it may work for
> you but am not sure.
> In my case I had SQL Express 2005 Installer on my system as well as I run
> both (one for development, one for production).
> Shut down all SQL related services manually.
> I set registry permissions on
> Software\Policies\Microsoft\Windows\Inst
aller to include the account that
> is doing the install with Full Control. Click Advanced and make sure
> everything is selected.
> I downloaded and ran the SQL Install Cleanup and removed the SQL 2005
> Setup Files Installer and the SQL Express Installer. I then reinstalled
> the SQL Setup Files (ONLY!!!!!) from my SQL Server 2005 CD. If you don't
> don't do this you won't be able to use the SP.
> Q290301 OFFXP: Windows Installer CleanUp Utility
> http://support.microsoft.com/suppor...s/q290/3/01.asp
> I then reinstalled the SP and it worked.
> Hope this helps somebody.
> Special thanks to Peter Yang of Microsoft for his invaluable assistance on
> this issue.
> --
> Get a powerful web, database, application, and email hosting with KJM
> Solutions
> http://www.kjmsolutions.com
>
>|||Hi,
Thanks for your feedback. This information has been added to Microsoft's
database. Your solution will benefit many other users, and we really value
having you as a Microsoft customer.
If you have any other questions or concerns, please do not hesitate to
contact us. It is always our pleasure to be of assistance.
Have a nice day!
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "vbnetdev" <vbnetdev@.community.nospam>
>References: <OdGUsVgaGHA.3304@.TK2MSFTNGP04.phx.gbl>
>Subject: Re: 2005 SP 1 Install Failure Solution - Unable to install
Windows Installer MSP file
>Date: Thu, 27 Apr 2006 10:15:48 -0500
>Lines: 50
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
>X-RFC2646: Format=Flowed; Response
>Message-ID: <uQdG71gaGHA.3740@.TK2MSFTNGP03.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 63-252-11-73.ip.mcleodusa.net 63.252.11.73
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:429460
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Forgot to mention this is on a Windows Server 2003 SP1 platform.
>--
>Get a powerful web, database, application, and email hosting with KJM
>Solutions
>http://www.kjmsolutions.com
>
>"vbnetdev" <vbnetdev@.community.nospam> wrote in message
>news:OdGUsVgaGHA.3304@.TK2MSFTNGP04.phx.gbl...
run[vbcol=seagreen]
that[vbcol=seagreen]
on[vbcol=seagreen]
>
>
If this error occurs here is what worked for me. I hope it may work for you
but am not sure.
In my case I had SQL Express 2005 Installer on my system as well as I run
both (one for development, one for production).
Shut down all SQL related services manually.
I set registry permissions on Software\Policies\Microsoft\Windows\Inst
aller
to include the account that is doing the install with Full Control. Click
Advanced and make sure everything is selected.
I downloaded and ran the SQL Install Cleanup and removed the SQL 2005 Setup
Files Installer and the SQL Express Installer. I then reinstalled the SQL
Setup Files (ONLY!!!!!) from my SQL Server 2005 CD. If you don't don't do
this you won't be able to use the SP.
Q290301 OFFXP: Windows Installer CleanUp Utility
http://support.microsoft.com/suppor...s/q290/3/01.asp
I then reinstalled the SP and it worked.
Hope this helps somebody.
Special thanks to Peter Yang of Microsoft for his invaluable assistance on
this issue.
--
Get a powerful web, database, application, and email hosting with KJM
Solutions
http://www.kjmsolutions.comForgot to mention this is on a Windows Server 2003 SP1 platform.
Get a powerful web, database, application, and email hosting with KJM
Solutions
http://www.kjmsolutions.com
"vbnetdev" <vbnetdev@.community.nospam> wrote in message
news:OdGUsVgaGHA.3304@.TK2MSFTNGP04.phx.gbl...
> This is posted for others who have
> If this error occurs here is what worked for me. I hope it may work for
> you but am not sure.
> In my case I had SQL Express 2005 Installer on my system as well as I run
> both (one for development, one for production).
> Shut down all SQL related services manually.
> I set registry permissions on
> Software\Policies\Microsoft\Windows\Inst
aller to include the account that
> is doing the install with Full Control. Click Advanced and make sure
> everything is selected.
> I downloaded and ran the SQL Install Cleanup and removed the SQL 2005
> Setup Files Installer and the SQL Express Installer. I then reinstalled
> the SQL Setup Files (ONLY!!!!!) from my SQL Server 2005 CD. If you don't
> don't do this you won't be able to use the SP.
> Q290301 OFFXP: Windows Installer CleanUp Utility
> http://support.microsoft.com/suppor...s/q290/3/01.asp
> I then reinstalled the SP and it worked.
> Hope this helps somebody.
> Special thanks to Peter Yang of Microsoft for his invaluable assistance on
> this issue.
> --
> Get a powerful web, database, application, and email hosting with KJM
> Solutions
> http://www.kjmsolutions.com
>
>|||Hi,
Thanks for your feedback. This information has been added to Microsoft's
database. Your solution will benefit many other users, and we really value
having you as a Microsoft customer.
If you have any other questions or concerns, please do not hesitate to
contact us. It is always our pleasure to be of assistance.
Have a nice day!
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "vbnetdev" <vbnetdev@.community.nospam>
>References: <OdGUsVgaGHA.3304@.TK2MSFTNGP04.phx.gbl>
>Subject: Re: 2005 SP 1 Install Failure Solution - Unable to install
Windows Installer MSP file
>Date: Thu, 27 Apr 2006 10:15:48 -0500
>Lines: 50
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
>X-RFC2646: Format=Flowed; Response
>Message-ID: <uQdG71gaGHA.3740@.TK2MSFTNGP03.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 63-252-11-73.ip.mcleodusa.net 63.252.11.73
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:429460
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Forgot to mention this is on a Windows Server 2003 SP1 platform.
>--
>Get a powerful web, database, application, and email hosting with KJM
>Solutions
>http://www.kjmsolutions.com
>
>"vbnetdev" <vbnetdev@.community.nospam> wrote in message
>news:OdGUsVgaGHA.3304@.TK2MSFTNGP04.phx.gbl...
run[vbcol=seagreen]
that[vbcol=seagreen]
on[vbcol=seagreen]
>
>
Subscribe to:
Posts (Atom)