SharePoint - data not copied from the StagingDB to the ReportingDB

Asked By Jayanarayan on 26-Jun-12 02:35 AM
Earn up to 20 extra points for answering this tough question.
hi

I am unable to view the web analytic report. when i checked my sql sever for details the aggregation has not happened in reporting DB.  Please let me know the solution.

With Regards

M C Jayanarayan
DL M replied to Jayanarayan on 28-Jun-12 05:29 AM
Use this Query [WebAnalyticsSvcApp_ReportingDB].[dbo].[WASetting] (This table only has four rows)

for reference :- http://blogs.msdn.com/b/sharepoint_strategery/archive/2012/03/16/troubleshooting-sharepoint-2010-web-analytics.aspx
Jayanarayan replied to DL M on 28-Jun-12 05:44 AM
hi

thank you sir. I had seen this document.  Based on this i had actually configured my timer jobs at midnight. But server is physically down during that period. But now after changing the scheduled jobs in central admin the staging DB shows LastLoggingExtractionTime as yesterdays date. But the reporting database does not reflect the new data. data is not being copied from StagingDB to the ReportingDB. Kindly help further.
help
I have downloaded and installed Sharepoint 3.0 on my server 2003 machine after installing .Net framework 3.0 and ASP 2.0 (embedded version of SQL Sever auto-installed with sharepoint). IIS had been previously installed. (Sharepoint installation disabled the default web site.) The sharepoint start page came up automatically, as advertised, in and IE window on the server. Unfortunately, I could not access the sharepoint from any other (client) machines. I always received 401 Access Denied. I checked and found
I have SBS 2008 premium and am trying to use the included sql reporting services in integration mode with sharepoint 3.0 component of SBS 2008. Can I do this or do I need to download Office Sharepoint Server onto the SQL server (2nd standard server license from SBS) and if I do this can I use it in a Sharepoint farm to be able to publish sql reports on my companyweb? Windows Server SBS Discussions SharePoint (1) Office (1) Report (1) Preconfigures
Hi All, I've my own MS SQL database server running (not the Sharepoint SQL sever) with a lot of tables. I managed to retrieve data from this database and display the information on the Sharepoint page. Now I want to edit the data. In other words I like to create
How do i create a "Linked Data Source" for a SQL Query and table SharePoint Hi I am a newbie to Sharepoint designer. i have an external sql sever db connected to SPD. now when i create a linked data source between and existing a table data connection, i get error which i press show data. any help pls? SharePoint Discussions SPD (1) Sharepoint (1) Galant (1) Could you provide a little more info as to the type of we could just imagine. keywords: How, do, i, create, a, "Linked, Data, Source", for, a, SQL, Query, and, table description: Hi I am a newbie to Sharepoint designer. i have an
Hi, -> I installed window's 2003-> .net framework 3.0 -> vs 2005-> sql 2005 -> sharepoint sever. . ., The same software's i installed in other system it is working fyn (window's 1. Windows Server 2003 > SP1 > Frame word 2.0 (visual studio 2005)> Frameword 3.0 > sql server 2005 > MOSS 2007 or 2. Windows Server 2003 > SP1 > Visual Studio 2008 > sql server 2005 > MOSS 2007 Try with any one of above, you will get. Regards, Venkatesh have any problem while installing just ask me keywords: Windows Server 2003, Visual Studio 2008, SharePoint, MOSS 2007, Application, Frame description: installation problem Hi, -I installed window's 2003-.net framework 3.0 - vs 2005-sql 2005 -sharepoint sever. . ., The same software's i installed in other s
Im using the following connection string for making connection in c#.net 2005 with sql server 2000 one machine IP address is 192.168.0.1 with internet connection Second can not run on both machine, because this facility is not ava) On Both machine sql server 2000 (sql client server, local machine) is installed Data Source = 192.168.0.1;Initial Catalog = Collonizer 2.0.0.0, culture = neutral, publickeytoken = b77a5c561934e089' failed IS THERE ANY NEED TO INSTALL SQL SERVER 2000 IN REMOTE SERVER MODE AND ON SECOND MACHINE ONLY CLIENT TOOL SHOULD INSTALL group for my custom assembly."> <IMembershipCondition class = "UrlMembershipCondition" version = "1" Url = "C: \ Program Files \ Microsoft SQL Server \ MSSQL \ Reporting Services \ ReportServer \ bin \ MyCustomAssembly.dll" / > < / CodeGroup> I'm working on my local have a dll outside the GAC that's trying to access some part of the SharePoint Object Model. Fix: There's a couple of ways to resolve this issue. • Put you
I am currently running SharePoint Portal Server 2003 with SP2 and WSS with SP2, combined with a separate SQL 2000 database server. However, I have been notified that I need to move the SharePoint databases over to a new SQL 2005 server. Questions. . . 1) Can SPS 2003 use SQL 2005? 2) If so, how do I do this. . . upgrade current SQL box and then
We have SQL 2008 installed on separate machine but in same domain, installed all as per the instructions here http: / / blogs.msdn.com / sharepoint / using full installation. Started wizard, inserted sql server \ instance name, username / password, port number. It starts but hangs on second stage. Looks like something went wrong with creation AdminContent database. SQL Databases show following databases:Sharepoint_config and long one having Admin_content. Did I miss something making fresh installation? I've installed sharepoint 2007 before on other 2 machines (one for MOSSportal and second with SQL2008 with instance everything went fine but now. . . . Errors in EvenViewer: 1) Event Type: Error Event Source: Windows SharePoint Services 3 Event Category: General Event ID: 27745 Description: The description for Event ID ( 27745 ) in Source ( Windows SharePoint Services 3 ) cannot be found. The local computer may not have the necessary registry information
Can I place my SQL on a separate server from any of my Sharepoint servers? Will this effect performance? Tanxs Billy SharePoint Setup Discussions SharePoint (1) Matteo (1) Tanxs (1) Infrastructor (1) Windowsserver (1) Proliant (1) Bf5d (1) Docs (1 probably always effect performance in a good way! This is called a small farm in SharePoint. / Daniel Bugday Thanks for reply. I was going to put my Sharepoint SQL on a separate server, then split my Sharepoint farm over 2 other servers but
I am unable to debug SP in sql 2005, so I red thru the news articles and found out the feature has been VS 2005. My qestion is, I have a SBS 2003 premium installation which has the SQL server full installation but I cannot find the "Step Into Stored Procedure" and "Allow SQL CLR Debugging" options in my sever explore data connection. Is there anything missing at my end. The SQL server is running fine. The following services are running VS 2005 remote debugger SQL server SQL server agent SQL server browser SQL server fill text search Also how do