Error Number 14161
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Replication Warning: Subscription expiration alert doesn't work SQL Server > SQL Server Replication Question 0 Sign in to vote I am having the same trouble withgetting the "Replication Warning: Subscription expiration" alert to work. It does not alert before the subscription is marked expired and needs to be reintialized. Does anyone know how to configure that alert so that it works if the default: SQL Server event Alert\14160 is not what makes the alert fire. And possibly an easyway to test it. Thanks! As I try to trouble shoot I found a table MSpublicationthresholds that has a column: shouldalert: A value of 1 indicates that an alert should be generated when the metric exceeds the defined threshold. I cannot figure how to set that value other than directly update the table. Note replication monitor interface has an enable check box that affects this field: isenabled: A value of 1 indicates that monitoring is enabled for this replication performance metric. It is as though you can't turn shouldalert on via the GUI. Even if I do manually change it or with the proc below, there is still the question about having to reconfigure the default alert to get it to work? There is the proc that the replmon uses to change the isenabled value: exec [distribution].sys.sp_replmonitorchangepublicationthreshold @publisher = N'ASTOF-DBA03T', @publisher_db = N'PublTest', @publication = N'TestPub', @metric_id = 1, @value = 75, @shouldalert = 0, @mode = 1 But shouldalert is 0 If anyone has solved this before I would appreciate the help. Thanks! Thursday, July 01, 2010 4:19 PM Reply | Quote Answers 0 Sign in to vote Hi, Please check the replication alerts and warnings configuration using the following steps: 1.Connect to an instance of SQL Server in SQL Server Management Studio, and then expand the server node. 2.Right-click the Replication folder or any of its subfolders, and then click Launch Replicati
SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums SQL Server 2005 Forums Replication (2005) Latency https://social.msdn.microsoft.com/Forums/sqlserver/en-US/bdf9a094-9d1a-4de0-8851-2d3de4f16393/replication-warning-subscription-expiration-alert-doesnt-work?forum=sqlreplication alert not firing. Reply to Topic Printer Friendly Author Topic suresha_b Yak Posting Veteran India 82 Posts Posted-08/13/2008: 08:12:59 Transactional replication latency alert is not firing. What could be the reason?Latency is exceeding the threshold. "Performance cretical" is displayed in the Replication Monitor. But alert is not firing. rmiao Flowing Fount http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=108734 of Yak Knowledge USA 7266 Posts Posted-08/13/2008: 22:59:51 How did you configure the alert? suresha_b Yak Posting Veteran India 82 Posts Posted-08/14/2008: 00:52:17 An alert named "Replication Warning: Transactional replication latency (Threshold: latency)" was already there in the distributor for error number 14161. I just selected "Notify operators" under response.If I manually raise the error as follows, it sends email.raiserror(14161,10,1, '0', '30', 'Testing') Edited by - suresha_b on 08/14/2008 00:55:45 Zaheer Starting Member USA 2 Posts Posted-05/11/2010: 22:43:55 I've the same scenario, Transactional replication in SQL Server 2005 with SP3 + HF 4266, the Replication Warning Latency Alert is not sending any notification when it meet or exceeds the defined threshold. Alert history shows 0 occurrences. Any help will be apprecaited. Topic Reply to Topic Printer Friendly Jump To: Select Forum General SQL Server Forums New to SQL Server Programming New to SQL Server Administration Script Library Data Corruption Issues Database Design and Applic
happen in the database engine. You can have SQL Server Agent to monitor the EventLog for some specific SQL Server errors, and let Agent can notify an operator (send e-mail) and/or http://www.karaszi.com/sqlserver/util_agent_alerts.asp start a job. The problem has always been to know what alerts to http://psoug.org/oraerror/ORA-14161.htm define - this article is an attempt to rectify that. You might already have some monitoring application that has support for SQL Server, like OP5 ,HP Operations Manager or Microsoft Operations Manager. If you do and are happy with that solution, then stick with it. But if you don't have such a error number solution, or if you feel that your current software's support for SQL Server EventLog monitoring can be improved, then read on. Acknowledgements Thanks to: Stefan K., message 833 Versions etc. This article applies to SQL Server 2005 and later, where not noted otherwise. Article written: 2009-05-29 Modified 2011-09-15: Cleaned up T-SQL code so you can execute all in one go 2012-07-03: Added message 833 Intended error number 14161 audience I assume a reasonable knowledge level of SQL Server. You should be able to find your way around the tools and understand the most common terms and acronyms. If you don't meet those criteria, then I suggest you buy some tool which has an interface which is easier to use, hand this over to a senior DBA or perhaps hire a consultant to do the planning and implementation. If you want to use the T-SQL script at the end of this article, then you should be able to read and have a grasp of what it does. The e-mail part You probably want to send an email when the event occurs. I suggest you use the Database Mail support which was introduced in SQL Server 2005 - a pure SMTP implementation. I discourage you from using the old "SQL Mail" support since it uses MAPI. SQL Server Books Online describes how to configure Database Mail, so I won't talk about it here. Check out Dan Guzman's script to configure Database Mail using T-SQL instead of running the Wizard on each SQL Server Instance. Frequency of EventLog polling You can control this
Library mySQL Code Library PHP Code Library JavaScript Code Library Oracle Terms & Definitions Oracle Error Codes PSOUG Community Blogs Oracle Jobs Board PSOUG Forum Oracle User Group Directory Free Oracle Magazines Online Learning Center PSOUG Presentations Advanced Code Search News and Events Sponsors Page Submit Code Contact Us Oracle Error: ORA-14161 Error Description: Subpartition number string: sum of PCTUSED and PCTFREE may not exceed 100 Error Cause: The sum of PCTUSED and PCTFREE for a subpartition whose number (subpartitions are numbered starting with 1) is displayed in this message exceeds 100. Note that if PCTUSED and/or PCTFREE values for this subpartition were not specified explicitly, default values at partition-level would be used. If, in turn, default PCTUSED and/or PCTFREE values at partition-level were not specified, default values for the partitioned table or index would be used. If those values were also not specified explicitly, system defaults would be used. Action: Ensure that a sum of PCTUSED and PCTFREE for the subpartition does not exceed 100. There haven't been any comments added for this error yet. You may add one if you like. Add a comment Name: Email: URL: Chars left:1000 (1000 max) (No HTML, but newlines will be preserved) Home : Code Library : Sponsors : Privacy : Terms of Use : Contact Us 149 users online © 2009 psoug.org PSOUG LOGIN Username: Password: Forgot your password?