Showing posts with label subscriber. Show all posts
Showing posts with label subscriber. Show all posts

Thursday, March 29, 2012

cannot remove subscription from subscriber!

after deleting a publication from the publisher (which gave a message that
it would also delete all subscriptions to it) the subscription remains on
the subscriber. There is no reference to it on the publisher anymore. It
also looks strange on the subscriber, for example the name format listed in
the subscriptions container on the subscriber was something like
serverName:DatabaseName:PublicationName, and is now only
ServerName:DatabaseName, no publication name. I should also note the name of
the sql server alias used to register it with enterprise manager was change
from that of what it was during the original setup of this replication (was
snapshot, by the way). This was a fix I found for an earlier problem when
trying to setup a new merge replication topology... the alias had to be
changed to match the actual server netbios name. I believe I deleted the
publication from the publisher AFTER I edited the subscriber server's alias
name. Could this have something to do with it?
other info: I cannot delete the tables (articles) from the subscriber
because it thinks its still part of the replication (that was deleted). I
also cannot create the new merge replication, or at least I can create it
but it fails since I need to use the same tables which it thinks are
unavailable due to the previously deleted replication scheme.
any guidance is greatly appreciated. I'm in quite the bind here.
thanks.
answered in the post marked urgent problem
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"djc" <dcopenhaver@.megapathdsl.net> wrote in message
news:%23GZNEuaUEHA.1012@.TK2MSFTNGP09.phx.gbl...
> after deleting a publication from the publisher (which gave a message that
> it would also delete all subscriptions to it) the subscription remains on
> the subscriber. There is no reference to it on the publisher anymore. It
> also looks strange on the subscriber, for example the name format listed
in
> the subscriptions container on the subscriber was something like
> serverName:DatabaseName:PublicationName, and is now only
> ServerName:DatabaseName, no publication name. I should also note the name
of
> the sql server alias used to register it with enterprise manager was
change
> from that of what it was during the original setup of this replication
(was
> snapshot, by the way). This was a fix I found for an earlier problem when
> trying to setup a new merge replication topology... the alias had to be
> changed to match the actual server netbios name. I believe I deleted the
> publication from the publisher AFTER I edited the subscriber server's
alias
> name. Could this have something to do with it?
> other info: I cannot delete the tables (articles) from the subscriber
> because it thinks its still part of the replication (that was deleted). I
> also cannot create the new merge replication, or at least I can create it
> but it fails since I need to use the same tables which it thinks are
> unavailable due to the previously deleted replication scheme.
> any guidance is greatly appreciated. I'm in quite the bind here.
> thanks.
>
|||Running sp_removedbreplication can be used to remove all(ish) traces of
replication in the subscriber database, but obviously must only be done if
this database is not also configured as a publisher. There is also a stored
procedure to tell SQL Server a table is no longer involved in replication
that might be useful: sp_MSunmarkreplinfo which takes the tablename as a
parameter.
Regards,
Paul Ibison
|||thank you! i'll check it out.
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:uNDdsubUEHA.1764@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> answered in the post marked urgent problem
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "djc" <dcopenhaver@.megapathdsl.net> wrote in message
> news:%23GZNEuaUEHA.1012@.TK2MSFTNGP09.phx.gbl...
that[vbcol=seagreen]
on[vbcol=seagreen]
> in
name[vbcol=seagreen]
> of
> change
> (was
when[vbcol=seagreen]
> alias
I[vbcol=seagreen]
it
>
|||great. thank you.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:%23TQbhNeUEHA.1012@.TK2MSFTNGP09.phx.gbl...
> Running sp_removedbreplication can be used to remove all(ish) traces of
> replication in the subscriber database, but obviously must only be done if
> this database is not also configured as a publisher. There is also a
stored
> procedure to tell SQL Server a table is no longer involved in replication
> that might be useful: sp_MSunmarkreplinfo which takes the tablename as a
> parameter.
> Regards,
> Paul Ibison
>
sql

Tuesday, March 27, 2012

Cannot register subscriber

We are setting up a test laptop to use with Merge replication to a SQL 2K
server that serves as both Publisher and Distributor. I was hoping to
create a push subscription but that needs a register server setup that does
not work. When I go to register the server (MSDE on laptop) from the
Publisher, it shows the laptop computer name in the "Select a SQL Server"
dialog box. But when I select it and choose to connect using either windows
authentication OR SQL server login I get the message "SQL Server does not
exist or access denied". When I setup the laptop with MSDE, I set the
authentication to be "Mixed" and entered a strong sa password. Can someone
tell me why this is happening?
p.s. I can setup the laptop as a subscriber using anonymous settings using
Windows Synchronization Manager from the laptop just fine.
David
Unregister this SQL Server in Enterprise Manager and then add it back again.
I think you are having name resolution problems.
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
"David Chase" <dlchase@.lifetimeinc.com> wrote in message
news:eRe$lX0BGHA.3584@.TK2MSFTNGP11.phx.gbl...
> We are setting up a test laptop to use with Merge replication to a SQL 2K
> server that serves as both Publisher and Distributor. I was hoping to
> create a push subscription but that needs a register server setup that
> does not work. When I go to register the server (MSDE on laptop) from the
> Publisher, it shows the laptop computer name in the "Select a SQL Server"
> dialog box. But when I select it and choose to connect using either
> windows authentication OR SQL server login I get the message "SQL Server
> does not exist or access denied". When I setup the laptop with MSDE, I
> set the authentication to be "Mixed" and entered a strong sa password.
> Can someone tell me why this is happening?
> p.s. I can setup the laptop as a subscriber using anonymous settings using
> Windows Synchronization Manager from the laptop just fine.
> David
>
|||That did not work.
David
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OxlsptDCGHA.1288@.TK2MSFTNGP09.phx.gbl...
> Unregister this SQL Server in Enterprise Manager and then add it back
> again. I think you are having name resolution problems.
> --
> 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
> "David Chase" <dlchase@.lifetimeinc.com> wrote in message
> news:eRe$lX0BGHA.3584@.TK2MSFTNGP11.phx.gbl...
>
|||What is the sa account you are using? It should be the sa account of the
publisher - not the subscriber.
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
"David Chase" <dlchase@.lifetimeinc.com> wrote in message
news:ORhLPe$CGHA.4080@.TK2MSFTNGP09.phx.gbl...
> That did not work.
> David
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:OxlsptDCGHA.1288@.TK2MSFTNGP09.phx.gbl...
>
sql

Sunday, March 25, 2012

Cannot propogate to subscriber

I'm getting this error when I try to replicate
The schema script
'\\CVTDEESQL005\ETMSData\unc\CVTDEESQL005_ZenithSQ L_L_060104_ZenithSQL_L_060104\20070120231902\tblCa ll_1.sch'
could not be propagated to the subscriber. The step failed.
I can find this row in sysMergeSchemaChange but I'm not sure why it's
causing a problem. Can someone give me some guidance?
kr
Spike
I'd do some logging and see if this records more info
(http://support.microsoft.com/?id=312292).
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||"Paul Ibison" wrote:

> I'd do some logging and see if this records more info
> (http://support.microsoft.com/?id=312292).
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
> Message: The process could not read file '\\CVTDEESQL005\ETMSData\unc\CVTDEESQL005_ZenithSQ L_L_060104_ZenithSQL_L_060104\20070120231902\tblCa ll_1.sch' due to OS error 53.
53 is a network error, so I quess either the file is not there or I've lost
access to the directory. If I were to remove this line from
sysMergeSchemeChange would that sort it? Or be a very bad idea?
The row in question is the second one after exec.sp_MsChange_Retention etc.
|||I'd run the snapshot once again. Perhaps there are also other files that
went missing, and if there's an underlying problem it'd be best to sort it
out systematically.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||"Paul Ibison" wrote:

> I'd run the snapshot once again. Perhaps there are also other files that
> went missing, and if there's an underlying problem it'd be best to sort it
> out systematically.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
> Okay I'll try that but one thing I don't understand is why I'm the only person affected. All my other users can replicate ok but even if I create a new database and set up a new pull subscription I still get that error.
|||OK - if it is reproducible, then let's look a little deeper. After the
snapshot agent runs, does the file exist? Does the account that sql server
agent runs under (are you using push or pull?) have access to the repldata
share? Is there enough space on the subscriber?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||"Paul Ibison" wrote:

> OK - if it is reproducible, then let's look a little deeper. After the
> snapshot agent runs, does the file exist? Does the account that sql server
> agent runs under (are you using push or pull?) have access to the repldata
> share? Is there enough space on the subscriber?
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
> Hi Paul
I've tried to run the snapshot agent but it fails with "The Agent is
suspect. No response after 30 minutes. I'm using pull subscription. I need
to get access to the server via PCAnywhere to verify that the file/path is
acessible by the SQLAgent account but that may take some time. So I'll get
back to you.
all the best
spike
|||Hi,
Have you downloaded the SP4 hotfix (if your on SP4 that is!)
I downloaded and installed this;
http://support.microsoft.com/kb/916287
TIM
"Spike" wrote:

>
> "Paul Ibison" wrote:
> I've tried to run the snapshot agent but it fails with "The Agent is
> suspect. No response after 30 minutes. I'm using pull subscription. I need
> to get access to the server via PCAnywhere to verify that the file/path is
> acessible by the SQLAgent account but that may take some time. So I'll get
> back to you.
> all the best
> spike
|||"Paul Ibison" wrote:

> OK - if it is reproducible, then let's look a little deeper. After the
> snapshot agent runs, does the file exist? Does the account that sql server
> agent runs under (are you using push or pull?) have access to the repldata
> share? Is there enough space on the subscriber?
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
> We've rebooted the server and that seems to have cleared everything up!
Thanks for your help, cheers spike

Cannot preview or print: Invalid Page Number error

(This is a repost, under my correct subscriber ID.)
I have a report that I think is not too complex (a matrix inside a list).
With small datasets, all is well. But with large datasets (the threshold
seems to be around 5500 rows, which should turn out to be about 25 printed
pages), the report displays to the browser just fine, but if I attempt to
print it or preview it:
(1) I get just the 1st page, then a dialog box:
(Caption:) Invalid Page Number
(Text) The requested page does not exist.
(2) In addition, in the RS LogFiles folder, the corresponding log file has
this line in it:
aspnet_wp!chunks!72c!07/20/2006-22:22:04:: i INFO: ###
GetReportChunk('RenderingInfo_IMAGE', 2), chunk was not found!
this=93db4874-b6d5-4cf2-b885-affcf17ced96
I am guessing that the "2" here refers to page 2 of the report, which it is
bombing on.
(3) In addition, the aspnet_wp.exe process goes wild, consuming 80-95% of
the processor speed, and keeps churning until I am forced to shut it down.
========== I am seeing the same behavior (a) on my development machine, (b) on a test
server in my office, (c) at a client site. So I don't think it's an anomoly
of my environment.
I am running with SQL Server 2000, Reporting Services 2000 SP2. I also
found a hotfix on the MSFT site, which I installed, to no effect.
Any ideas, anyone'
Thanks in advance,
C17Hello,
Thank you for your post in MSDN newsgroup!
I understand that you encountered issue when prview/print a specific report
on different machines. If I'm off-base, please let me know.
Based on my research, I was not able to find any known issue on this error.
To troubleshoot the issue we may need to analyze memory dumps or use live
debug, this work has to be done by contacting Microsoft Product Support
Services. Therefore, we probably will not be able to resolve the issue
through the newsgroups. If the issue is urgent, I recommend that you open a
Support incident with Microsoft Product Support Services so that a
dedicated Support Professional can assist with this case. If you need any
help in this regard, please let me know.
For a complete list of Microsoft Product Support Services phone numbers,
please go to the following address on the World Wide Web:
http://support.microsoft.com/directory/overview.asp
If you'd still like to continue working via the newsgroup, please
understand the issue might take a long time to narrow down. During the
course of troubleshooting, we may redirect you to PSS if required. For now,
please try the following and let me know how it goes:
1. Get the sample RS project, and backend database with necessary tables
behind, and send them to me at petery@.microsoft.com. Please also let's know
the detailed reproduce steps
2. Does the issue occurs in report designer? Does the issue occur if you
configure default printer to "Microsoft Office Document Image Writer"?
3. Does the issue only occur with report with large number rows? If you
limit the rows/pages, can you reproduce the issue?
If you have other related information, please also let's know.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||I think it might be a timeout issue. I get the "Invalid Page Number" from
Print Preview after EXACTLY 5 minutes.
The question is, WHAT is timing out? I have the following set:
1) Query timeout (set as property of the query on the report) = 1800 seconds
= 30 minutes. (In fact the underlying report query takes only about 20
seconds to run.)
2) Report execution timeout (set for report using Report Manager) = 1800
seconds
3) Site settings default (set for entire site using Report Manager) = 1800
seconds
4) IIS Web Site/Default Web Site properties: 900 seconds = 15 minutes
What else is there that could be causing a time out at exactly 5 minutes'
Thanks,
C17|||Hello,
Thank you for your reply. I think this may not be related to timeout but
rather than memory related issue.
Based on my further research, the GetReportChunk exception shall not be
generated by printer renderer. It might be generated by HTML renderer which
uses url?s for the chart. Printer renderer will create only one stream for
the entire report and this stream will be in memory since we need to seek
on it. If in your report, every page has a chart or graph, We need to
preprocess these graph/chart before we will embed them in the file. This
process is taking time/memory.
If this is the issue, the workaround is to use less pages/records in one
report or use smaller graph. Also, you may contact PSS to get the following
fix to see if it resolves the issue:
905121 FIX: An error message is logged when you try to export a large
report to PDF, and you cannot open a spreadsheet file in Office Excel that
was exported from SQL Server 2000 Reporting Services
http://support.microsoft.com/default.aspx?scid=kb;EN-US;905121
If you have any update, please feel free to let's know.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Peter,
Thank you for the information, but I do not think that HotFix will solve the
problem, because the HotFix addresses problems with charts and images in
export to PDF. However, in my case:
* The problematic report does not contain ANY charts or images
* Export to PDF, and Export to Excel, works just fine. It's just Printing
and Print Preview that fails.
I will try the HotFix if you still think I should, but let me give you some
more information based on my testing:
1) I get the "Invalid Page Number" message box after 5 minutes with: Print
or Print Preview to *any* printer (including "Microsoft Office Document
Image Writer")
2) The problem occurs when running the report under *any* environment: (a)
when running my application, (b) within the report designer, (c) when
running the report from Report Manager.
3) The problem occurs at a threshold of about 800 rows in the underlying
query. If I change the report parameters so the query returns fewer rows,
the report successfully prints/previews in about 45 seconds. Above that
threshold, the report gives the "Invalid Page Number" message box after
exactly 5 minutes.
4) The problem does NOT occur upon Export to Excel, or Export to PDF.
(Export to PDF takes a long time to run, but I understand from reading the
newgroup that this is normal.)
I will bundle up a sample database, and the report, and email them to you as
you suggested in an earlier post. I don't think you will need my
application, because the problem occurs even when you run the report from
Report Manager.
Thanks,
--C17|||Hello Charles,
Thank you for your patience. I tested on RS 2005 SP1 machine and the issue
does not occur. I think you may consider the possibility of upgrading to
SQL 2005 as a workaround. Also, I?d check if I could find other workaround
on RS 2000. Please rest assured I?v reported this issue to the proper
channel. Thanks.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================Hello Charles,
I was able to reproduce the issue on my side. I tried to upgrade to build
1049 (hotfix 912715) but the issue still persists. It seems to be a product
issue for RS 2000. I will perform some more research and test it on RS
2005. Thank you for your patience.
Best Regards,
Best Regards,

Friday, February 24, 2012

Cannot insert explicit value for identity column

SQL Server 2000 SP4 (Enterprise edition) both publisher and Subscriber.
I have setup Identity column 'Not for Replication' in subscriber.
My error is
Cannot insert explicit value for identity column in table 'tablename' when
IDENTITY_INSERT is set to OFF.
I ran
SET IDENTITY_INSERT 'tablename' ON
I am still getting same error. Pl help
TIA
Sandeep
I am running transactional replication.
Thanks,
Sandeep
"Sandeep Shankar" <sandeep@.discussions.microsoft.com> wrote in message
news:%23yzPifMKIHA.1208@.TK2MSFTNGP03.phx.gbl...
> SQL Server 2000 SP4 (Enterprise edition) both publisher and Subscriber.
> I have setup Identity column 'Not for Replication' in subscriber.
> My error is
>
> Cannot insert explicit value for identity column in table 'tablename' when
> IDENTITY_INSERT is set to OFF.
>
> I ran
> SET IDENTITY_INSERT 'tablename' ON
>
> I am still getting same error. Pl help
> TIA
> Sandeep
>

Friday, February 10, 2012

Cannot find the identity range allocation entry for the Subscriber

Dear All,
When I am synchronizing the merge push subscription, receiving following error
Cannot find the identity range allocation entry for the Subscriber in the
MSmerge_identity_range table. Reinitialize the subscription.
What could be the cause of message, and is there some way so I can avoid
re-initialization of susbscription
How did you deploy this subscriber? Did you do a no-sync?
"M. M. Ansari" <MMAnsari@.discussions.microsoft.com> wrote in message
news:15A3AA2B-9F5F-45BC-BBC7-4C48FEF239E7@.microsoft.com...
> Dear All,
> When I am synchronizing the merge push subscription, receiving following
> error
> Cannot find the identity range allocation entry for the Subscriber in the
> MSmerge_identity_range table. Reinitialize the subscription.
> What could be the cause of message, and is there some way so I can avoid
> re-initialization of susbscription
>