.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

LS Status Report showing false alert state

Posted By:      Posted Date: September 04, 2010    Points: 0   Category :Sql Server
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 Complete Post

More Related Resource Links

Showing filtered Records in Crystal Report as per User Requirement


ReportDocument reportDocument = new ReportDocument();
    ParameterField paramField = new ParameterField();
    ParameterFields paramFields = new ParameterFields();
    ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
    protected void Page_Load(object sender, EventArgs e)
        if (!IsPostBack)
            paramField.Name = "@Ext";
            //*Remember to reconstruct the paramDiscreteValue and paramField objects
            paramDiscreteValue.Value = 44854
            CrystalReportViewer1.ParameterFieldInfo = paramFields;

Content and Structure Report not showing all items

I have an environment where the Site Owner is not seeing all items pending approval when they access that view from the root node in the Content And Structure section.

We can see pending items in this view if they access some of the lower level nodes in the tree structure, just not from the top node.

I've noticed that the second level nodes are not inheriting permissions from the root node, but I'm not sure if that is relevant. I've also checked the CAML for the Pending Approval view and it has not been altered in any way.

Any ideas?

Howe to do :Excel export button in report viewer visible false...?

hi all,  How I can do avoid to display  Excel export in ReportViewer..? if I Use //-------------------------- reportViewer1.ShowExportButton = false; //---------------------------------------------------- Both the buttons will be disabled...for only Excel button How can I...?    

Build a weekly status report for a team

I am using an InfoPath form to build a weekly status report for a large team. Each section must submit the form, then I want them to merge and still contain who submitted which portion. I have gotten as far as getting the template to be on the server, updating it with new data, but when I merge the data it does not retain the project name or delineate which project submitted which part of the data. Below is a generic list of the form. I would like to merge all of the basic reports into one large report which still shows the same basic information in a large merged document. Is this possible? and if so how? Thanks in advance for your help Program:   this is a dropdown list of the programs                            Date: date picker   Received From:          Upcoming Events     Team Vacation     Program Risks    

Customising Report Category and Status

Hi there,   Does anyone know how to customise the Report Category and Report Status in SharePoint?   At the moment we are stuck with the defaults (below)   Report Category: Category 1 Category 2 Category 3   Report Status Final Preliminary Period To Date   Thanks.   Regards, Jamie

Using browser / URL to load report, with rc:Toolbar=false, report does not refresh


I've got an app that hosts a browser control. In it, I loop through a set of reports (displaying a dashboard of them). The problem is, I don't want the toolbar to display, so I'm using rc:Toolbar=false. This gets the toolbar to not display, but the problem is, the reports don't refresh (I have timestamps in the reports, and they remain the same).

I'm not caching the reports- I have them set to the default setting of run the report each time.

So, how can I get both the toolbar hidden AND the report to be refreshed? I tried looking at the stylesheets, but can't figure out how to hide the entire report toolbar using those.



Alert email showing local url not internet url


I have setup SharePoint to be accessed via the internet and configured aam.

I can access the site from the Internet, but whenever i setup an alert on a library, the email that is sent out contains a link showing the internal url, not the Internet URL.

I need the email to show the external URL.

Any ideas?

SQL Server 2008 R2 Disk Usage report showing incorrect data file


When I go to ANY database (System, AdventureWorks*, user) in Managemant Studio, I right-click on the db, select Reports, select Standard Reports, and select Disk Usage.  The disk usage report shows the correct db on top, but always only shows AdventureWorks_Data.mdf when I expand Disk Space Used by Data Files section.  This happens to any db I try.  When I look at Database Properties/Files for that database, the logical and physical file names are correct.

Since the correct files appear in Database Properties/Files, I'm hoping it's just a bug in the report.  Same thing happens if I run a Disk Usage by Table report for ANY database,  The tables for AdventureWorks always only appear,

Thanks,  Mike

Status of Accessing Nested Objects in Data Source of Local Report Does Not Function


We recently upgraded out platform to .NET 4.  We are also using Microsoft Reporting dlls.  Unfortunately, we found that the upgrade broke all of our reports.  Researching the cause, we found this article:


It seems that this issue has been open for some time now and I have not seen a good workaround (except for the shim class which is not really feasible for us).  Can I please get a status update for this?  Is there some other type of resolution?

Thank you,

Benjamin Strum 

Ben Strum

Value in cube not showing in SSRS report



I'm scratching my head on this one!

I have an MDX query which gives me the value 287529 for a field. I can see this in SSAS, excel, and in the query designer is SSRS but when the report renders it brings back 0 for that field.

All other fields are okay its just that one. I have taken off alll cell formatting in the mdx script and on the report.


Any iedas...


Many thanks.



SharePoint Search Service is not getting started. Its showing Starting status in Central Administart



I am using SharePoint 2007 and I am trying to start SharePoint Search Service on my server throgh central Administrator.But its not getting started and its showing starting status there.

I think this service got stucked. Please let me know If you have any solution for this.



Rajavi B


SSRS report export to CSV showing column headers always in English inspite of the selected locale.


We are encoutering an issue with SSRS report export to CSV showing column headers always in English, regardless of locale.


We are using SSRS to display report results in a report viewer window launched from an ASP.net page.


When the report viewer is lauched in fr-CA locale, the report viewer window content is in French. However, when the results are exported to CSV, all the column header labels inside the CSV are always in English.


Showing #Error in SSRS adhoc report


Hi ,

Im facing one issues by using Varbinary data type field in ssrs adhoc report.

While running it is showing as #Error in the adhoc report.

Pls help me how to solve.







Pre-upgrade Checker - Customized List views that will not be upgraded report showing TONS of lists

OK - so, I haven't tried the actual upgrade yet, but I'm definitely concerned about the quantity of lists/pages that are showing up in this section of the report.  It appears that just about every list (and page?) shows up in this report.  I'm talking almost 9000 lines.  I've only just recently taken ownership of the SharePoint farm, but I find it hard to believe that all of these items have been manually customized.  Has anyone seen this before or have any idea as to why I'm seeing this?  Running MOSS SP2...

email alert notification when task status column value is chaned


Hi All,

I am creating a document library in which there are few columns present (like Assigned To,Task Status,Reviewr etc.)

I want to send alert or email notification when the status value is changed. Alert should go to "Assigned To" selected value from the Reveiwers name.

I have tried this with "alert me" functionality provided by WSS 2007 but I think it will not sufficient for me?.

I am not able to proceed please help me?

SSRS 2008 R2 report builder 3.0 map wizard bubble color not showing up


Some blog posts out there show an option for bubble color in the map wizard. Currently I only see an option for size.

Is this something that didn't make it out of beta?


WorkflowStatus column showing status 8 across all ListItems


Hi All,

I have a list that has a two out of the box workflows i.e. Approval Workflows and one custom workflow (C#) attached to it.

We know that for each Workflow, a new column is automatically  created in the list; showing the status of the workflow.

From the front end I see, that these columns show the correct status i.e. In Progress / Completed etc.

However suddenly from past few days the internal value of these columns is showing 8 which is in correct and because of which the custom workflow has stopped working. The code for the custom workflow has not changed and the same code is being re-used on other list and workflow status is showing correctly on those lists.

Here are the status values as shown in the MSDN documentation:


NotStarted Workflow has not started.
  FailedOnStart Indicates that the workflow encountered an error when it started.
  InProgress Workflow is currently in progress.
  ErrorOccurred An error occurred during the execution of the workflow.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend