Thursday, March 29, 2012
cannot remove subscription from subscriber!
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 remove push subscription on SQL Server 2000
Hi,
We have created replication from one production server to another backup server by using SQL scripts. These scripts have been generated by SQL Server after manual initial setup. When I ran these scripts they did not add the subscription for the backup server because a stored procedure were missing named something like sp_addsubscription. Therefore I ran the script on the production server and created the subscription manually on the backup server. But I made an error, I created a push subscription first but I should have created a pull subscription. Now I can't delete the push subscription. I don't even get a error message. I can't press delete and when right clicking on it I can only choose Help. The subscription has the following properties:
Type: push
Status: retrying
Last action: The process could not connect to distributor 'PSERV'
Replication type: Snapshot
Anyone know how I can delete this push subscription on my backup server?
Best,
/M
When you right-click on the subscription, are you connected to the production/publisher or backup/subscriber.
Try to do this on the publisher and see if you can delete it.
You can also call sp_dropsubscription (with the appropriate parameters) on the production server to drop the subscription.
|||Nothing at all exist on the production server. The distribution and the publication has been removed. Only the push subscription exist at the backup server. And I can't delete that.
How can I use sp_dropsubscription. Can I use that from Query Analyzer. Does anyone have a SQL example for that?
Best
/M
If you just want to get rid of replication on the backup server use sp_removedbreplication.
Note that this will remove all types of replication: merge and Transactional.
Use this only if you wish to remove all of replication.
|||Additionally you can use the following:
sp_subscription_cleanup: for Transactional -- Removes metadata when a subscription is dropped at a Subscriber. For a synchronizing transaction subscription, it also includes immediate-updating triggers. This stored procedure is executed at the Subscriber on the subscription database.
sp_mergesubscription_cleanup: for Merge -- Removes metadata, such as triggers and entries, in sysmergesubscriptions and sysmergearticles after the specified merge push subscription is removed at the Publisher. This stored procedure is run at the Subscriber on the subscription database
|||I used sp_removedbreplication 'db_name' to remove everything at the backup server. It worked as I wanted...
Thanks very much!
Now, I am happy again... for a short time :)
Best
/M
Sunday, March 25, 2012
Cannot push subscription - See image attached
shown as "Never Started". How do I get this back in operation?
http://www.chuckchamblee.com/tcifiles/Image1.jpg
Can you check the owner of the job. If it is a domain user, please change to
sa and then see if you can manually start the job.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Sunday, March 11, 2012
Cannot make a report delivery
The estatus is this of the subscription: "The delivery extension associated with this subscription is not available on this report server. Verify that the delivery extension is installed".
How do I do? Because in the rsreportserver.config they appear as extensions (Report Server FileShare and Report Server Mail). Both arent working. Do I have to install something more or configure something to appear installed?
Thanks a lot
Hi,
compare your .config file with the entries here: Perhaps you screwed up the config file ?
<Extensions>
<Delivery>
<Extension Name="Report Server FileShare" Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<FileShareConfiguration>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
<RenderingExtension>RGDI</RenderingExtension>
</ExcludedRenderFormats>
</FileShareConfiguration>
</Configuration>
</Extension>
<Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<RSEmailDPConfiguration>
<SMTPServer></SMTPServer>
<SMTPServerPort></SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing></SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From></From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
<RenderingExtension>RGDI</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
<DefaultHostName></DefaultHostName>
<PermittedHosts></PermittedHosts>
</RSEmailDPConfiguration>
</Configuration>
</Extension>
<Extension Name="NULL" Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>
</Delivery>
(...)
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
-
I have the same problem with HTMLOWC rendering; other formats so far no problem. Installation is RS2005 on SQL2000 upgraded in place. File 'rsreportserver.config' looks fine and has the two HTMLOWC entries as above; it has not been manually edited.
Cannot make a report delivery
The estatus is this of the subscription: "The delivery extension associated with this subscription is not available on this report server. Verify that the delivery extension is installed".
How do I do? Because in the rsreportserver.config they appear as extensions (Report Server FileShare and Report Server Mail). Both arent working. Do I have to install something more or configure something to appear installed?
Thanks a lot
Hi,
compare your .config file with the entries here: Perhaps you screwed up the config file ?
<Extensions>
<Delivery>
<Extension Name="Report Server FileShare" Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<FileShareConfiguration>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
<RenderingExtension>RGDI</RenderingExtension>
</ExcludedRenderFormats>
</FileShareConfiguration>
</Configuration>
</Extension>
<Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<RSEmailDPConfiguration>
<SMTPServer></SMTPServer>
<SMTPServerPort></SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing></SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From></From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
<RenderingExtension>RGDI</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
<DefaultHostName></DefaultHostName>
<PermittedHosts></PermittedHosts>
</RSEmailDPConfiguration>
</Configuration>
</Extension>
<Extension Name="NULL" Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>
</Delivery>
(...)
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
-
I have the same problem with HTMLOWC rendering; other formats so far no problem. Installation is RS2005 on SQL2000 upgraded in place. File 'rsreportserver.config' looks fine and has the two HTMLOWC entries as above; it has not been manually edited.
Cannot load the DLL replincrementlsn extended procedure?
trying to setup a new push subscription and got the following error!
'Error 14053: Cannot load the DLL replincrementlsn extended procedure, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
The subscription could not be updated at this time.
The subscription could not be created.'
Anyone have any ideas - I think it has some .dll missing or a sp missing but I couldn't find any such file on the CD.
Any help much appreciated...
Regards
DavejWhat is the level of service pack on both the machines?|||Hi Satya,
SP3...|||Try installing SP3a.
Thursday, February 16, 2012
Cannot get subscription email when including report, but can get it when just sending link
When I set up an email subscription for a report, I can get the email notification if I only include a link to the report, but get the generic "Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information." error message when I attempt to include the actual report in the email; either as "Web Archive," or PDF." When I consult the ReportServer log file, I do not see any sort of exception that would indicate the true source of the error.
I have set the file security on the RSTempFiles folder to allow the IIS_WPG group to modify the folder, but when I looked into the RS config files, it looked as though SSRS wasn't configured to use temporary storage.
Any suggestions?
-Matthew
Noone has had any sort of similar issue as this? I find that hard to believe.
-Matthew
|||You may also want to make sure that the IIS_WPG user has permissions within the report server to view the report you are trying to email. The problem I am having is that I am unable to send emails with the report to anyone outside of my active directory domain. So if I try to send it to someone @.hotmail.com i receive the following error:
The e-mail address of one or more recipients is not valid.
Friday, February 10, 2012
Cannot find the identity range allocation entry for the Subscriber
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
>