LS Status Report Showing False Alert State
Nov 28, 2007
I have log shipping every 15 minutes working between 2 servers, and while the secondary server reports everything ok (time since last copy, restore are all under 15 minutes), the primary server reports that the time since last backup is 7400+ minutes. I have verified that the LS backup job has no failures. How can I correct this false error state and get the primary server to start reporting actual statuses?
The LS monitor is on the secondary server.
View 9 Replies
ADVERTISEMENT
Oct 23, 2007
I'm creating a generic alter that will catch ANY state change in my sql server mirroring setup. I currently have 5 databases that I"m mirroring.
The problem that I'm running into is my message looks like whats below. I'd like to make it more descriptive so I'd like to pull info from wmi about what server the alert came from, the specific databasebase and what is the event.
DATE/TIME: 10/23/2007 1:36:41 PM
DESCRIPTION:
COMMENT: (None)
JOB RUN: (None)
Here is how the alert is created.
*************************************
USE [msdb]
GO
/****** Object: Alert [DBM State: Automatic Failover] Script Date: 10/23/2007 13:53:34 ******/
EXEC msdb.dbo.sp_add_alert @name=N'DBM State: Automatic Failover',
@message_id=0,
@severity=0,
@enabled=1,
@delay_between_responses=0,
@include_event_description_in=1,
@category_name=N'[Uncategorized]',
@wmi_namespace=N'\.
ootMicrosoftSqlServerServerEventsMSSQLSERVER',
@wmi_query=N'SELECT * FROM DATABASE_MIRRORING_STATE_CHANGE',
@job_id=N'00000000-0000-0000-0000-000000000000'
View 1 Replies
View Related
Jun 3, 2015
my database is already deleted and there  is no job are running for  that database .previously we configure a log shipping for that database  and deleted.log shipping backup job also deleted.the log shipping alert job is throwing bellow error.
The log shipping primary database tes1 has backup threshold of 60 minutes and has not performed a backup log operation for 132722 minutes. Check agent log and logshipping monitor information.
View 4 Replies
View Related
Jul 24, 2003
Hi,
I ahve attached the bmp doc that will show my screen snapshot.
My SQL server Agent service indicator is not showing green as like other server. I have started the serice and running fine. I don't have any problem running the job.
My curious is why that indicator is not showing up.
Thanks,
Ravi
View 5 Replies
View Related
Aug 23, 1999
Has anyone had a problem with Enterprise Manager, running on NT4/SP4 desktop, not showing/reporting the status of a specified SQL Server (6.5). I have a list of 10 that have been working fine (i.e. green lights shows up, drill down and see SQL Executive Green light, etc.). I now have 1 that does not report the status. It was working fine, but the only change that I remember was to create a new Scheduling login, which I did, and then I re-registered it to use a non-sa login to see what the look/feel would be. It looked like from that point onward, is where I lost the status capability. I have re-registered it as SA, but it seems to be stuck and won't give me back the green light. Yes, the server is up and I can drill down, but I don't even see the SQL Executive service and green light. I'm sure there is some registry setting that needs to be kicked? Any Ideas?
View 1 Replies
View Related
Nov 1, 2007
Hi! Im just starting to learn how to use an SQL express database. I used it over at my campus and it worked fine and now when I try running it on my machine it gave me this error :
"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connection.(Provider : SQL Network Interfaces, error : 26 - Error locating server/ instance specified.)"
I know that by default SQL express doesnt not support remote connection but when i try to get the service status running, i got another error which is :
"The service did not respond to the start or control request in a timely fashion, you need administrator privileges to be able to start/stop this service. (SQLSAC)"
I am already logged on to the computer as an administrator but i still cant get the service to run! Pls help!
View 1 Replies
View Related
May 25, 2006
I am using Naive Bayes, Decision Trees, and Neural Net (SSAS 2005) to predict which of two states each record belongs to.
How can I enforce a different penalty for a false positive versus a false negative ? (I am assuming that in some sense the mining algorithms can then minimize the total penalty).
View 5 Replies
View Related
Feb 1, 2007
HI, there,
I added a new windows user "ReportUser" which is a local user (not in administrator group). When I connect to the report manage's web page, I use reportuser to log in (when the anonymous access is disabled it will ask a log in). Report builder icon is not showing up on the report manager home page.
If I log in as a user in administrator group, the reportr builder icon shows up so I can download it and build report.
I have assigned reportuser "Content manager" and "repoter builder" access to the home folder. Is there anything else I have to do to make the report build icon show up on the home page?
Thanks
Jack
View 5 Replies
View Related
Mar 8, 2007
I want to send an alert (email) to the subscriber of a report when the report fails to execute properly. I€™ve been looking through the documentation for RS 2005 and can not find how to set this functionality up.
View 1 Replies
View Related
Apr 10, 2007
Hi !
Is it possible to add an alert/warning via reportBuilder ?
An alert is for example a value which is superior of a nominal value for example...
I saw in a demo, it is possible to have it by creating a function, but this way is for the developper, if the user wants to add an alert himself ? how can he do ?
and maybe how can the developper help him ?
thank you for your answer
View 7 Replies
View Related
Jun 7, 2007
Hello
we have many report dashboard project where we have more then 100's of reports being viewed across the organization. at time then the report breaks for some reason like below i wanted the admin should get a mail alert.
Reporting Services Error
The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. (rsInvalidDataSourceCredentialSetting) Get Online Help
SQL Server Reporting Services
is this possible in any ways to achive.
/soni
View 1 Replies
View Related
Sep 20, 2007
When generating a SQL report, external images from a Sharepoint image library are not shown (red X).
An unattended execution account is set correctly, the image exists. I have tried with setting the UseSessionCookies to true/false. nothing seems to work.
Anyone any ideas wath else I can try?
View 1 Replies
View Related
Sep 9, 2015
I need to create a report showing the title the first and last name of all sales representatives-This is what I have so far but am having difficulty retrieving ONLY the "Sales Representatives" Titles.
Select Firstname, Lastname, Title
From Employees
Where ???
View 6 Replies
View Related
Jun 18, 2008
I have a report that pulls a customer balance.
In crystal there was a way to have the page not show up if it met a certain criteria(say if the balance was 0 or negative).
I'd rather not filter them in SQL because it takes a few calculations to figure out what their balance is, and I already have SRS doing that calculation.
So is there a way to have a report page not print based on a certain criteria?
View 4 Replies
View Related
Jul 11, 2007
Hi, I have 8 charts on a report that no longer show up on the report.
the datasets they are based on still produce data when queried.
All I see is white space plus the textbox titles?
The charts are there in layout view and still correctly reference the right datasets and fields.
View 1 Replies
View Related
Jun 4, 2007
I have a report that shows a header, details and a footer
The detail line never prints lines with asterixes in them, e.g.
"**blah blah**"
As soon as I delete the asterix from the database, the line appears on the report
Any ideas anyone?
View 14 Replies
View Related
Apr 29, 2008
Hi All,
I am using SQL Server 2008 Reporting Services Charts. I am using Chart Type as Column (3-D Cluster Cylinder). I am using X axis of graph as Time/Date field. I have two questions while displaying report in desired format:
1. Currently I have grouped Category field on Date field fetched from database. It groups values per day. Now whenever there is no data for a particular date, it skips that date in chart. How can I show each and every date on report graph in user given date range?
2. If there is no data for a legend of a chart, how can I display a Bar in Chart with value 0. This means, I have to show Bar with Zero value.
Currently if I Show data labels of Chart, it just shows data for 0 value but does not show Bar with 0 value which could be residing as flat on X axis for a particular legend.
Please help me resolving this issues for Chart graphs.
Please let me know if you need any more details.
Thanks in Advance.
Regards,
Ashwin B
View 1 Replies
View Related
Jan 16, 2007
I have a matrix report that I am using with MonthName(Fields!Month.Value) across the top of the report. However, when there is no data under the column, the month is skipped. So, for example, I get this:
January March
Actual Goal Actual Goal
25 25 30 35
I have tried adding
iif(Sum(Fields!Total.Value, "DatasetName")> 0, Sum(Fields!Total.Value, "DatasetName"),"N/A")
But it still is not showing up.
Any ideas?
Thanks,
SHP
View 5 Replies
View Related
Apr 22, 2008
I have a log shipping configuration where Server A is primary, B is secondary and C is the monitoring Server. When I run a query on both A and B I get similar results. Which means log shipping is working fine.
However when I run 'Transaction Log Shipping Status' Report on the monitor server I am unable to tell which files were recently copy and which files were last applied. or even when the last backup occurred or a copy was made. The columns are empty. I would like to find out what would cause this to heppen?
Also is there a way to find out the lsn of the databases on both primary and secondary servers.
thanks
View 3 Replies
View Related
Feb 21, 2007
I'm trying to
get reports and report server site aveable through user certificate.
Web site is
under default web site. Under default web site is certificate server web page,
it is aveable and configured the same way and it works if I use certificate.
If I type https://FQDN/Reports
, i get error The request failed with HTTP status 403: Forbidden. But if I type
https://FQDN/reportserver i can access.
Both sites are
aveable if I use only https. But if I but if i use Require client certificate,
than I get 403 error.
In rsreportserver.config,
there is <UrlRoot>https://NETBIOSServerName/reportserver</UrlRoot>,
does not help if I use FQDN.
If I enable anonymous
access, I can not access Reports site, an I get error 403, but on Reportserver
site I get following error :
Reporting
Services Error
--------------------------------------------------------------------------------
The permissions
granted to user 'MSVEPOIUSR_WEPO-DC' are insufficient for performing this
operation. (rsAccessDenied) Get Online Help
--------------------------------------------------------------------------------
SQL Server
Reporting Services
SQL is 2005 SP1
, and OS is Windows server 2003 SP1
View 1 Replies
View Related
Jan 16, 2007
I installed the Reporting Service for Share Point just fine but when I go to central admin I do not see the reporting service section. Any Ideas?
View 4 Replies
View Related
Jan 21, 2008
Hi,
I have a report with 5 filters which can be applied to it. The records are grouped by the Rotation programme there are on, with a subtotal for each unique programme name.
The report seems to work fine, but upon closer inspection - we noticed that 2 of the records are not being displayed. As a result, the total count is out by 2.
We tracked down the missing records so I ran the SQL query with a Where clause, and it was able to find the two records.
What could possibly cause this behaviour? Please see included SQL statement :
Code Block
SELECT Posts.PostNumber,COUNT(Posts.PostNumber) AS RPCount, Incumbents.Name AS IncumbentName, Grades.GradeTitle, Specialties.SpecialtyTitle,
Hospitals.Name AS Hospital, Genders.Gender, [Incumbent History].YearGraduated, COUNT([University Origins].Origin) AS OriginCount,
Incumbents.Nationality AS NationalityID, Countries.[Country Name] AS Nationality, [Rotation Programmes].[Programme Name],
Posts.[Post Approved for Training], [University Origins].Origin, Posts.OldPostNumber, [Rotation Programmes].[Programme ID]
FROM Posts INNER JOIN
Incumbents ON Posts.PostNumber = Incumbents.PostNumber INNER JOIN
[Incumbent History] ON Incumbents.[Incumbent ID] = [Incumbent History].IncumbentID INNER JOIN
Grades ON Incumbents.[Official Grade] = Grades.GradeID INNER JOIN
Specialties ON Posts.Specialty = Specialties.SpecialtyID INNER JOIN
Hospitals ON Posts.HospitalID = Hospitals.[Hospital ID] INNER JOIN
Genders ON Incumbents.GenderID = Genders.GenderID INNER JOIN
Countries ON Incumbents.[Country Of Birth] = Countries.[Country ID] INNER JOIN
[Rotation Programmes] ON Posts.[Rotation Programme] = [Rotation Programmes].[Programme ID] INNER JOIN
[University Origins] ON [University Origins].[Uni Origin ID] = Incumbents.[University Origin]
GROUP BY [Rotation Programmes].[Programme Name], Posts.PostNumber, Incumbents.Name, Grades.GradeTitle, Hospitals.Name, Genders.Gender,
[Incumbent History].YearGraduated, [University Origins].Origin, Incumbents.Nationality, Countries.[Country Name], [University Origins].Origin,
Posts.[Post Approved for Training], Posts.OldPostNumber, Specialties.SpecialtyTitle, [Rotation Programmes].[Programme ID]
View 12 Replies
View Related
Apr 22, 2008
I added tooltips to the column headings in a report deployed to SQL05 RSvc. When the report is viewed in the web-based report viewer, the tooltips display properly. The report is normally launched by a Winforms app that opens a window containing a .Net report viewer (2008 version). In this viewer, the tooltips do not display. Does the desktop viewer not support tooltips on report items?
View 3 Replies
View Related
Aug 24, 2007
Hi,
I am having a problem with Print button not showing up. I tried everything but I can get it to show itself on the toolbar. I am using reporting viewer on local report on the web page. I published my local report on the server but still not showing.
If anybody knows how to fix this problem please help.
I am also tring to insert a report parameter in the header section of the report but when I get to parameters section it tells me that "This report does not contain any parameteres".
Thanks in advance!
View 1 Replies
View Related
Nov 16, 2007
Hi all,
I want to show the above. Can someone elighten me how I can loop thru to concatanate the values?
Regards,
Farouk Yew
View 1 Replies
View Related
May 13, 2008
Hi All,
would like to make a report with sales figures per month even is there are no sales figures that month.
Report should still show the month.
Any help to get me started in the wright direction much appreciated
edwin
View 1 Replies
View Related
Apr 9, 2007
I have a package load all flat files under a directory. Some of them may fail because formatting issue.
What's the best way to generate a report at the end, shows the list of failed transfer? Maybe with error message.
Thanks
View 2 Replies
View Related
Aug 9, 2007
Hi,
I have used Report viewer control to show ssrs 2005 report in my aspx page.
Can we show the SSRS 2005 report on the aspx page in any other way?
any info on this is appreciated.
Thanks,
Srik
View 28 Replies
View Related
Jun 12, 2015
We have a SSRS report that runs on snapshots. The report contains a textbox that displays the report name using the Global!ReportName built-in field.Â
Recently, we changed the RDL name to something else but this seems to have affected the snapshots too. The older snapshots (generated before the name change) are showing the updated name.
Just wondering if there is some way to say that the snapshot will show the report name based on the time it was generated (same as the ExecutionTime built-in field). Why is there a difference?
View 3 Replies
View Related
Feb 4, 2008
When I deploy a report, and then browse to it with FireFox, I only see 2 inces of the report. I can scroll through the entire report, but only see the 2 inch window's worth at any time.
Its like the html element the report gets put into has a hard coded height, and doesnt auto size to show the eintire report.
It works fine with IE, but we are a FireFox shop.
Anyone know how to fix this?
View 1 Replies
View Related
Jan 9, 2008
Hello,
I have a report that is made out of many subreports.
It takes a long time to produce this report.
Is there a away of knowing and displaying to the user which sub report is produced now?
Is there a way of making status info sent to the UI? Somthing like OnStartPage/OnStartReport (now send status to UI somehow)?
TIA
I S
View 5 Replies
View Related
Jan 19, 2007
I have successfully installed the reporting services in SQLServer 2005 and have integrated with WSS 3.0. When I go to a site to add in the Viewer web part it is not there. Any ideas?
View 6 Replies
View Related
Aug 31, 2015
I created a re port using the Report builder. The report runs fine. I want to create a parameter on the report. I created a new dataset with the query "select distinct dept from table" . Then i created a new parameter to get the values from the second dataset. After running the reports when i selected 2 departemnts, its still showing all the records.
View 3 Replies
View Related
