Reseeding Identity column on subscriber

Hi,
Is it possiible to re-seed the identity column on a subscriber which is
using merge replication.
I am getting PK constraints when inserting a row.
Thanks
have a look at
sp_MSadjustmergeidentity
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"mm" <postto@.news.com> wrote in message
news:uy7V4AFwEHA.3620@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Is it possiible to re-seed the identity column on a subscriber which is
> using merge replication.
> I am getting PK constraints when inserting a row.
> Thanks
>

Request Length Exceeded

I'm re-posting under an updated subscriber ID so Microsoft techs will answer...
I am working in Visual Studio 2005. I have a Report Model project with a
data source, a data source view which contains all of the tables in my
database (SQL Server 2005), and a Report Model that contains the items that I
want the users to be able to work with.
When I deploy the project, I get the following error:
Error 2 System.Web.Services.Protocols.SoapException: There was an exception
running the extensions specified in the config file. -->
System.Web.HttpException: Maximum request length exceeded. at
System.Web.HttpRequest.GetEntireRawContent() at
System.Web.HttpRequest.get_InputStream() at
System.Web.Services.Protocols.SoapServerProtocol.Initialize() -- End of
inner exception stack trace -- at
System.Web.Services.Protocols.SoapServerProtocol.Initialize() at
System.Web.Services.Protocols.ServerProtocolFactory.Create(Type type,
HttpContext context, HttpRequest request, HttpResponse response, Boolean&
abortProcessing) c:\crimson\wmsdev\vbapps2005\desktopweb\wmsreportmodels\CrimsonWMS.smdl 0 0
How do I fix it?
Thank you,
Mark LauserI second that. Ran into the same problem today.
Don Olsen
"Mark Lauser" wrote:
> I'm re-posting under an updated subscriber ID so Microsoft techs will answer...
>
> I am working in Visual Studio 2005. I have a Report Model project with a
> data source, a data source view which contains all of the tables in my
> database (SQL Server 2005), and a Report Model that contains the items that I
> want the users to be able to work with.
> When I deploy the project, I get the following error:
> Error 2 System.Web.Services.Protocols.SoapException: There was an exception
> running the extensions specified in the config file. -->
> System.Web.HttpException: Maximum request length exceeded. at
> System.Web.HttpRequest.GetEntireRawContent() at
> System.Web.HttpRequest.get_InputStream() at
> System.Web.Services.Protocols.SoapServerProtocol.Initialize() -- End of
> inner exception stack trace -- at
> System.Web.Services.Protocols.SoapServerProtocol.Initialize() at
> System.Web.Services.Protocols.ServerProtocolFactory.Create(Type type,
> HttpContext context, HttpRequest request, HttpResponse response, Boolean&
> abortProcessing) c:\crimson\wmsdev\vbapps2005\desktopweb\wmsreportmodels\CrimsonWMS.smdl 0 0
> How do I fix it?
> Thank you,
> Mark Lauser
>|||After re-reading this error and looking at the smdl file I suspected that the
problem was the XML being sent to the SOAP service was too long. Started
deleting some unused tables and viola it worked after deleting about 6
tables. Your milage may vary.
Hope that helps.
-Don
"Mark Lauser" wrote:
> I'm re-posting under an updated subscriber ID so Microsoft techs will answer...
>
> I am working in Visual Studio 2005. I have a Report Model project with a
> data source, a data source view which contains all of the tables in my
> database (SQL Server 2005), and a Report Model that contains the items that I
> want the users to be able to work with.
> When I deploy the project, I get the following error:
> Error 2 System.Web.Services.Protocols.SoapException: There was an exception
> running the extensions specified in the config file. -->
> System.Web.HttpException: Maximum request length exceeded. at
> System.Web.HttpRequest.GetEntireRawContent() at
> System.Web.HttpRequest.get_InputStream() at
> System.Web.Services.Protocols.SoapServerProtocol.Initialize() -- End of
> inner exception stack trace -- at
> System.Web.Services.Protocols.SoapServerProtocol.Initialize() at
> System.Web.Services.Protocols.ServerProtocolFactory.Create(Type type,
> HttpContext context, HttpRequest request, HttpResponse response, Boolean&
> abortProcessing) c:\crimson\wmsdev\vbapps2005\desktopweb\wmsreportmodels\CrimsonWMS.smdl 0 0
> How do I fix it?
> Thank you,
> Mark Lauser
>|||Thanks for your input Don. I tried deleting all I could stand to, but the
problem persisted. I'm hoping for a different solution that will allow a
larger request length.
Best Regards,
Mark Lauser
"Don Olsen" wrote:
> After re-reading this error and looking at the smdl file I suspected that the
> problem was the XML being sent to the SOAP service was too long. Started
> deleting some unused tables and viola it worked after deleting about 6
> tables. Your milage may vary.
> Hope that helps.
> -Don
> "Mark Lauser" wrote:
> > I'm re-posting under an updated subscriber ID so Microsoft techs will answer...
> >
> >
> > I am working in Visual Studio 2005. I have a Report Model project with a
> > data source, a data source view which contains all of the tables in my
> > database (SQL Server 2005), and a Report Model that contains the items that I
> > want the users to be able to work with.
> >
> > When I deploy the project, I get the following error:
> >
> > Error 2 System.Web.Services.Protocols.SoapException: There was an exception
> > running the extensions specified in the config file. -->
> > System.Web.HttpException: Maximum request length exceeded. at
> > System.Web.HttpRequest.GetEntireRawContent() at
> > System.Web.HttpRequest.get_InputStream() at
> > System.Web.Services.Protocols.SoapServerProtocol.Initialize() -- End of
> > inner exception stack trace -- at
> > System.Web.Services.Protocols.SoapServerProtocol.Initialize() at
> > System.Web.Services.Protocols.ServerProtocolFactory.Create(Type type,
> > HttpContext context, HttpRequest request, HttpResponse response, Boolean&
> > abortProcessing) c:\crimson\wmsdev\vbapps2005\desktopweb\wmsreportmodels\CrimsonWMS.smdl 0 0
> >
> > How do I fix it?
> >
> > Thank you,
> > Mark Lauser
> >|||Hey, Mark
I think I just replied to your original post, so see if you can dig back a
couple of posts and read the answer...but it has to do with the <httpRuntime
maxRequestLength="" /> element in the web.config file of the ReportServer and
Report Manager apps.
--
Regards,
Thiago Silva
"Mark Lauser" wrote:
> Thanks for your input Don. I tried deleting all I could stand to, but the
> problem persisted. I'm hoping for a different solution that will allow a
> larger request length.
> Best Regards,
> Mark Lauser
>
> "Don Olsen" wrote:
> > After re-reading this error and looking at the smdl file I suspected that the
> > problem was the XML being sent to the SOAP service was too long. Started
> > deleting some unused tables and viola it worked after deleting about 6
> > tables. Your milage may vary.
> >
> > Hope that helps.
> >
> > -Don
> >
> > "Mark Lauser" wrote:
> >
> > > I'm re-posting under an updated subscriber ID so Microsoft techs will answer...
> > >
> > >
> > > I am working in Visual Studio 2005. I have a Report Model project with a
> > > data source, a data source view which contains all of the tables in my
> > > database (SQL Server 2005), and a Report Model that contains the items that I
> > > want the users to be able to work with.
> > >
> > > When I deploy the project, I get the following error:
> > >
> > > Error 2 System.Web.Services.Protocols.SoapException: There was an exception
> > > running the extensions specified in the config file. -->
> > > System.Web.HttpException: Maximum request length exceeded. at
> > > System.Web.HttpRequest.GetEntireRawContent() at
> > > System.Web.HttpRequest.get_InputStream() at
> > > System.Web.Services.Protocols.SoapServerProtocol.Initialize() -- End of
> > > inner exception stack trace -- at
> > > System.Web.Services.Protocols.SoapServerProtocol.Initialize() at
> > > System.Web.Services.Protocols.ServerProtocolFactory.Create(Type type,
> > > HttpContext context, HttpRequest request, HttpResponse response, Boolean&
> > > abortProcessing) c:\crimson\wmsdev\vbapps2005\desktopweb\wmsreportmodels\CrimsonWMS.smdl 0 0
> > >
> > > How do I fix it?
> > >
> > > Thank you,
> > > Mark Lauser
> > >

Republishing

Hi
I want to republish data in sql server. Scenario is like
this.
SERVER A SERVER B SERVER C
Publisher --> Subscriber/Publisher --> Subscriber
Server A publish data (Merge/push to SERVER B)
Server B publish data (Merge/push to SERVER C)
Can be done this type of publishing.?
Is there any way to doing this type of publishing.
Thanks
Dishan
Yes this can be done.
Books On Line should have more information on it.
If you have trouble setting up, please respond to this thread with the
problems.
I will try to help.
Hope that helps
--Mahesh
[ This posting is provided "as is" with no warranties and confers no
rights. ]
"DishanF" <d700693@.hotmail.com> wrote in message
news:550901c480e9$7fac2560$a501280a@.phx.gbl...
> Hi
> I want to republish data in sql server. Scenario is like
> this.
> SERVER A SERVER B SERVER C
> Publisher --> Subscriber/Publisher --> Subscriber
> Server A publish data (Merge/push to SERVER B)
> Server B publish data (Merge/push to SERVER C)
> Can be done this type of publishing.?
> Is there any way to doing this type of publishing.
> Thanks
> Dishan
|||Can you send me any web urls ?

Republisher (publishing subscriber) merge replication

Hi,
I am trying to have a republisher run with Merge replication, but am getting error messages anytime I try to publish to the third tier.
Any suggestions on where I can find more info?
Thanks
Wil
I ran into touble once trying that until I set the subscriber type
(sp_AddMergeSubscription) to Global. You might want to check your setting.
Paul
"Wil" <wil@.canoemail.com> wrote in message
news:258CA56C-2CE7-4531-8998-704C698E6DA3@.microsoft.com...
> Hi,
> I am trying to have a republisher run with Merge replication, but am
getting error messages anytime I try to publish to the third tier.
> Any suggestions on where I can find more info?
> Thanks
> Wil
|||what is your error message?
"Wil" <wil@.canoemail.com> wrote in message
news:258CA56C-2CE7-4531-8998-704C698E6DA3@.microsoft.com...
> Hi,
> I am trying to have a republisher run with Merge replication, but am
getting error messages anytime I try to publish to the third tier.
> Any suggestions on where I can find more info?
> Thanks
> Wil

Repost: Security level already for "RosettaMgr"

As an MSDN subscriber, I though I was supposed to get a guaranteed response
here. I am reposting this since no one responded to my 1st inquiry.
Out of the blue this morning our Report Server stopped working with the
following error:
Configuration Error
...
Parser Error Message: Security Level already defined for RosettaMgr
Source Error:
Line 22: <securityPolicy>
Line 23: <trustlevel name="RosettaMgr"
policyFile="rsmgrpolicy.config" />
Line 24: </securityPolicy>
line 24: <trust level="RosettaMgr" originUrl="" />
Removing the offending lines from web.config resolved the problem but I'm
unclear why this happened suddenly. I'm also leery of removing these
settings without fully understanding the implications. If anyone has any
insight as to the cause of this error or can intelligently explain the
<securityPolicy> and <trust level> settings I sure would appreciate a little
feedback.
Thanks,
Rich BakosHi Rich,
Sorry that you're encountering trouble. Not sure where your expectation was
set regarding guaranteed response If you could let me know that would be
very helpful. AFAIK, MS doesn't guarantee responses on this newsgroup -
you're actually talking with many folks on the product team directly. Though
we'd love to answer all questions, we're also trying to ship an awesome
product as part of SQL Server 2005. I'm sure you understand our quandry
:-).
Now your question:
Report Manager ships with a default security group called RosettaMgr.
Removing this line is not desired. The relevant section of the file reads:
<securityPolicy>
<trustLevel name="RosettaMgr" policyFile="rsmgrpolicy.config"/>
</securityPolicy>
<trust level="RosettaMgr" originUrl=""/>
What this line does is it ensure that the report manager loads code, that it
assigns the code the correct permission defined in the rsmgrpolicy.config
file.
This is a shot in the dark but the web.config file included with an
application follows a hierarchy based on other web.config files that come
before it. You can read up on this here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/secmod/html/secmod92.asp
Are you running another application that also uses ASP.Net on the same
server? Has any web.config changed on your server shortly before your
application started to fail?
One other questions - did you move/copy the report manager virtual
directory?
-Lukasz
"Richard Bakos" <bakos@.nospam.nospam> wrote in message
news:%23PAol8DGFHA.444@.TK2MSFTNGP15.phx.gbl...
> As an MSDN subscriber, I though I was supposed to get a guaranteed
> response
> here. I am reposting this since no one responded to my 1st inquiry.
> Out of the blue this morning our Report Server stopped working with the
> following error:
> Configuration Error
> ...
> Parser Error Message: Security Level already defined for RosettaMgr
>
> Source Error:
> Line 22: <securityPolicy>
> Line 23: <trustlevel name="RosettaMgr"
> policyFile="rsmgrpolicy.config" />
> Line 24: </securityPolicy>
> line 24: <trust level="RosettaMgr" originUrl="" />
> Removing the offending lines from web.config resolved the problem but I'm
> unclear why this happened suddenly. I'm also leery of removing these
> settings without fully understanding the implications. If anyone has any
> insight as to the cause of this error or can intelligently explain the
> <securityPolicy> and <trust level> settings I sure would appreciate a
> little
> feedback.
> Thanks,
> Rich Bakos
>
>|||Lukasz Pawlowski [MSFT] wrote:
Hi Lukasz.
Thanks for you response.
> Sorry that you're encountering trouble. Not sure where your
> expectation was set regarding guaranteed response If you could let
> me know that would be very helpful.
My mistake, the page says a "commitment" to respond rather than a guarantee.
http://msdn.microsoft.com/newsgroups/managed/
> <securityPolicy>
> <trustLevel name="RosettaMgr" policyFile="rsmgrpolicy.config"/>
> </securityPolicy>
> <trust level="RosettaMgr" originUrl=""/>
Yes. Those are the offending lines and the server will not run with those
elements defined. To add to the problem, we can not move reports to
different folders or update definitions since removing the offending
elements. Everything else appears to work correctly.
Here is the exact text of the error:
Description: An error occurred during the processing of a configuration file
required to service this request. Please review the specific error details
below and modify your configuration file appropriately.
Parser Error Message: Security level already defined for 'RosettaMgr'.
Source Error:
Line 21: <httpRuntime executionTimeout="9000"/>
Line 22: <securityPolicy>
Line 23: <trustLevel name="RosettaMgr" policyFile="rsmgrpolicy.config"/>
Line 24: </securityPolicy>
Line 25: <trust level="RosettaMgr" originUrl=""/>
Source File: C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\web.config Line: 23
----
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET
Version:1.1.4322.573
> What this line does is it ensure that the report manager loads code,
> that it assigns the code the correct permission defined in the
> rsmgrpolicy.config file.
Thanks for the explaination but this doesn't explain why I'm getting a parse
error complaining that a Security level is already defined. My web.config
files had not been changed until the day I removed the offending elements.
> Are you running another application that also uses ASP.Net on the same
> server?
No. However, the web.config for the report server also contains the elements
sin question.
>Has any web.config changed on your server shortly before
> your application started to fail?
No.
> One other questions - did you move/copy the report manager virtual
> directory?
No.
Any other insight you might have certainly would be helpful.
Thanks,
Rich Bakos|||Richard Bakos wrote:
> No. However, the web.config for the report server also contains the
> elements sin question.
My mistake. The element definitions are not identical. Once defines
RosettaMgr while the other defines RosettaSrv.
Rich|||The solution to your problem is to install the ASP.Net hotfix for a
canonicalization issue. You can do this from the following KB article:
http://support.microsoft.com/kb/887787
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"Richard Bakos" <bakos@.nospam.nospam> wrote in message
news:uYe6DZKGFHA.560@.TK2MSFTNGP15.phx.gbl...
> Richard Bakos wrote:
>> No. However, the web.config for the report server also contains the
>> elements sin question.
> My mistake. The element definitions are not identical. Once defines
> RosettaMgr while the other defines RosettaSrv.
> Rich
>|||Lukasz Pawlowski [MSFT] wrote:
Hi Lukasz,
> The solution to your problem is to install the ASP.Net hotfix for a
> canonicalization issue. You can do this from the following KB
> article:
That made no difference. The problem still exists.
Rich Bakos

Repost: Merge Replication Error - Failed to enumerate changes in the filtered article

Hi,
I am using Merge Replication and the subscriber is a pull subscriber.
Some tables are filtered, in the publication properties, if I go to FILTER
ROWS, then FILTER CLAUSE column, some tables are filtered like so
depot_system_id = 'xxxxx-xxxxx-xxxxx-xxxxxx' where x makes up the guid.
The replication objects are owned by DBO.
Versions of SQL:
Publisher:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: )
Subscriber:
MSDE
Everything was working fine, then all of a sudden, I get this error. (See
below)
Does anyone know what would cause this and how I can overcome it?
Thanks in Advance
Warren
************************************************** *
******************ERROR DETAILS******************
************************************************** *
Last command: {call sp_MSsetupbelongs(?,?,?,?,?,1,?,?,1,?,?,?,?,?,?)}
Error Message: Failed to enumerate changes in the filtered articles.
Error Details:
Failed to enumerate changes in the filtered articles.
(Source: Merge Replication Provider (Agent); Error number: -2147200925)
Incorrect syntax near the keyword 'where'.
(Source: GENCENTRIC_SVR1 (Data source); Error number: 156)
Incorrect syntax near the keyword 'and'.
(Source: GENCENTRIC_SVR1 (Data source); Error number: 156)
************************************************** *
*******************END OF ERROR******************
************************************************** *
Someone reported a similar problem and solved it by reapplying sp3a.
http://groups-beta.google.com/group/... e3a5eb8c1ea7a
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Warren Patterson" <des@.newsgroups.nospam> wrote in message
news:eYSANebNFHA.2468@.tk2msftngp13.phx.gbl...
> Hi,
> I am using Merge Replication and the subscriber is a pull subscriber.
> Some tables are filtered, in the publication properties, if I go to FILTER
> ROWS, then FILTER CLAUSE column, some tables are filtered like so
> depot_system_id = 'xxxxx-xxxxx-xxxxx-xxxxxx' where x makes up the guid.
> The replication objects are owned by DBO.
> Versions of SQL:
> Publisher:
> --
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation
> Standard Edition on Windows NT 5.2 (Build 3790: )
> Subscriber:
> --
> MSDE
>
> Everything was working fine, then all of a sudden, I get this error. (See
> below)
> Does anyone know what would cause this and how I can overcome it?
> Thanks in Advance
> Warren
> ************************************************** *
> ******************ERROR DETAILS******************
> ************************************************** *
> Last command: {call sp_MSsetupbelongs(?,?,?,?,?,1,?,?,1,?,?,?,?,?,?)}
> Error Message: Failed to enumerate changes in the filtered articles.
> Error Details:
> Failed to enumerate changes in the filtered articles.
> (Source: Merge Replication Provider (Agent); Error number: -2147200925)
> ----
--
> --
> Incorrect syntax near the keyword 'where'.
> (Source: GENCENTRIC_SVR1 (Data source); Error number: 156)
> ----
--
> --
> Incorrect syntax near the keyword 'and'.
> (Source: GENCENTRIC_SVR1 (Data source); Error number: 156)
> ----
--
> --
> ************************************************** *
> *******************END OF ERROR******************
> ************************************************** *
>
>
|||Hi Hilary,
Installing SP3a doesnt make sense to me. I have 4 other publications on
that same machine, setup the exact same way, except the filters are on other
ID {"depot_system_id = 'xxxxx-xxxxx-xxxxx-xxxxxx' where x makes up the
guid."} and they are working perfectly.
I am running service pack 3 only. I cant remember, but something in the
deep recesses of my mind is telling me that there was a reason I didnt
install SP3a onto the publisher, but I cant remember why.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:eYPCVpeNFHA.508@.TK2MSFTNGP12.phx.gbl...
> Someone reported a similar problem and solved it by reapplying sp3a.
>
http://groups-beta.google.com/group/... e3a5eb8c1ea7a[vbcol=seagreen]
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Warren Patterson" <des@.newsgroups.nospam> wrote in message
> news:eYSANebNFHA.2468@.tk2msftngp13.phx.gbl...
FILTER[vbcol=seagreen]
(See
> ----
> --
> ----
> --
> ----
> --
>