Ravendra's Blog

June 1, 2010

TFS Reports on Attachments and Long Text


Reporting on Attachments and long text fields are not supported by Team foundation server (even up to latest TFS 2010). In case you need to report on fields of type Attachment and Long text then you need to directly query TFS project collection database.

Attachments are stored at [dbo].[Attachments] table.

Following Query can be helpful to extract actual attachment content.

Create procedure [dbo].[GetWeeklyUpdateAttachment]

@projectName as
				varchar(256)

as

begin

declare @SQL nvarchar(4000),

        @ReportFrom nvarchar (100),

        @ReportTo nvarchar (100)

 

select @ReportFrom=ColName from Fields where name ='ReportFrom'

select @ReportTo=ColName from Fields where name ='ReportTo'

 

select @SQL =
				'Select top 1 [FileId]

      ,[FileGuid]

      ,[FileContent]

      ,[IdentityName]

      ,[ProjectUri]

  FROM [dbo].[Attachments] at

 inner join dbo.WorkItemFiles f on at.FileGuid = f.FilePath

 where f.RemovedDate = @MaxDate

 and f.Id = (select top 1 b.ID from 

    WorkItemsAre b 

    inner join xxTree a  on a.ID = b.AreaID

    WHERE    a.[Team Project] = @projectName2 

         and b.[Work Item Type] = @TypeName

        order by '
				+ @ReportTo +
				' desc)'

 

Exec
				sp_executesql
				@SQL,
				N'@TypeName nVarChar(100),@projectName2 nVarChar(100), @MaxDate datetime', @TypeName =
				'Weekly Project Update',  @projectName2 = @projectName, @MaxDate =
				'9999-01-01 00:00:00.000'

 

End

 

Long text are stored at [dbo].[WorkItemLongTexts] table

Following Query may be customized to find exact description field, Value of FldID need to be modified by field id of your description field.

 

Create PROCEDURE [dbo].[GetWeeklyProjectUpdateDescription]

    @projectName as
				nvarchar(256)
			

AS

BEGIN

    SET
				NOCOUNT
				ON;

 

declare @SQL nvarchar(4000),

        @ReportFrom nvarchar (100),

        @ReportTo nvarchar (100)

,@NextMilestone1 nvarchar(200)

 

select @ReportFrom=ColName from Fields where name ='ReportFrom'

select @ReportTo=ColName from Fields where name ='ReportTo'

 

select @SQL =
				'Select top 1 WORDS 

FROM WorkItemLongTexts l

WHERE    FldID = 52

    and l.ID = (select top 1 b.Id from 

    WorkItemsAre b 

    JOIN xxTree a on a.ID = b.AreaID

        and a.[Team Project] = @projectName2 

         and b.[Work Item Type] = @TypeName

        order by '
				+ @ReportTo +
				' desc)

        order by AddedDate desc'

 

Exec
				sp_executesql
				@SQL,
				N'@TypeName nVarChar(100),@projectName2 nVarChar(100)', @TypeName =
				'Weekly Project Update',  @projectName2 = @projectName

 

END

May 27, 2010

List of email subscriptions across TFS project/Collection

Filed under: Team foundation server 2010, TFS, Email Alert — Ravendra Mishra @ 4:53 pm

Following query can be used to get list of all TFS email alert subscriptions.

List of subscriptions is maintained in tbl_EventSubscription table of each collection database.

Use following query to find list of subscriptions. (Replace Tfs_TFSSupport by required project collection database name).

SELECT [Id]


				,[EventType]


				,[Expression]


				,[SubscriberId]


				,[Schedule]


				,[DeliveryType]


				,[Address]


				,[Classification]

  FROM [Tfs_TFSSupport].[dbo].[tbl_EventSubscription]

 

May 24, 2010

Things to know

Filed under: Uncategorized — Ravendra Mishra @ 5:04 pm

.Net performance related links

http://msdn.microsoft.com/en-us/library/ms173196(v=vs.80).aspx

Asp.net interview questions

http://www.interviewquestionseasy.com/55-asp-dot-net-interview-questions.html

Sharepoint interview quetions

http://mysharepointwork.blogspot.com/2009/09/sharepoint-object-model.html

C#

 Class/Struct, Value/Ref type, Boxing/ Unboxing, PassByValue, PassByRef, System.Object, GetHashCode, Equals, ==, IComparable

Managed Code, MSIL, byte code, CLR, CTS, JIT, CLS,

Assembly (Private, Shared, Satellite, local, global), Manifest, Metadata, GAC, Strong Name, ILDASM, Gacutil, Delay Signing,

garbage collection, Compaction, Pining, Finalize, Destructor, Dispose, GC.SuppressFinalize, Resurrection,

process, apartments, threads, task

Localization, globalization

Static Class/Method, Interface, Abstract class, Polymorphism, Sealed class, virtual, Derived, final, private, public, internal, protected,

System exception, Application exception,

CCW, RCW, PInvoke

[DllImport(“Kernel32.dll”)]
static extern int Sleep(long dwMilliseconds);

Thread, Sleep/Interrupt, Suspend/Resume, Abort, Wait, Join,

BeginInvoke, EndInvoke, IAsyncResult, WaitOne, Callback method

Lock, Monitor, Mutex, Reader/Writer, ManualResetEvent/AutoResetEvent

Abstract class/method, interfaces, virtual, override, new

Indexer, Extension methods, Enumerator

Serialization, Remoting, Web services

ADO.NET, Dataset, DataAdapter, Commands, SQlConnection

Debug, trace, logging,

Yield, dynamic

Delegate, Event, MulticastDelegate, Asynchronous delegate, IAsyncResult

Threading, Wait, Join, Task, Thread Safety, AppDomain

AsParallel,AsParallel().WithDegreeOfParallelism(6),
AsParallel().WithCancellation (cancelSource.Token), 
Parallel.foreach, ThreadLocal<T>, Task.Factory.StartNew, Task.WaitAll , Task.WaitAny ,
AggregateException, TaskCreationOptions, CancellationToken , TaskContinuationOptions, 
ContinueWith, TaskFactory ,

http://www.albahari.com/threading/

Serialization, XML Serialization, Binary, Benefits

XML, Parsing

Attributes
Linq, Lambda express, anonymous methods, extension methods, anonymous types, generic, partial classes

Threading, Deadlock, Synchronization

Dataset, SQLConnection, Adapter, Command etc..

Unity, Inversion of control, dependency injection, interception patterns

ASP.Net

Page lifecycle

state management (viewstate, cookies, hidden files, querystring, control state and Application state, session, profiles)

Cache (Dependency (File Based, Time, Key Dependency), Expiration), Cache Callback, Page output caching, page fragment caching

Application,

AJAX, HttpHandler, HttpModule, scriptmanager, updatepanel,

session, state,

WCF

http://wcftutorial.net/

Unification of NET remoting, MSMQ , Web services , COM+

Transport scheme(TCP, HTTP, Peer network, IPC or Pipe, MSMQ)

Hosting (IIS, SelfHosting, Windows Activation Service)

EndPoint, Address, Binding, contract

ServiceContract, OperationContract,

DataContract (DataMember, IsRequired, Order), KnownType, Serializable,

FaultContract

MessageContract, MessageHeader, MessageBodyMember

WSDL, WS-Policy

ServiceBehaviour (PerSession, PerCall, Single)

two way (http://msdn.microsoft.com/en-us/library/ms731064.aspx), security, Asynchronous, Transaction)

OperationContract overloading not supported due to limitation in WSDL (Use name property for overloads, this will be used to create method names in proxy)

receiving/sending messages to/from WCF service (instead of operation parameter)

OperationContext.Current.IncomingMessageHeaders.GetHeader(Of String)(“ServiceMessage”, “ns”))

OperationContext.Current.OutgoingMessageHeaders.Add(header)

SQL

Stored procedure vs User defined function

http://chiragrdarji.wordpress.com/2007/04/17/difference-between-user-defined-function-and-stored-procedure/

Delete vs Truncate

http://codebetter.com/raymondlewallen/2005/05/09/the-difference-in-truncate-and-delete-in-sql-server/

Correlated subquery and Subqueries

Temporary table, Global Temporary table vs table variable

http://www.sqlteam.com/article/temporary-tables

Clustered / Non clustered index

Exception handling

Locking

Trigger

Cursor

Dynamic parameters in sql stored procedure

Profiling, performance tunning

Design Patterns

 

Prism, CompositePresentationEvent

MVVM, MVP, Observer, Repository, Facade

Unity how to resolve with multiple parameter constructor http://classicalprogrammer.wikidot.com/registering-constructor-parameter-with-unity-container

WPF

 

Event, AttachedEvent, Routed Event (Tunnelling, Bubbeling)

IValueConverter, ObservableCollection, INotifyPropertyChanged

Page, Class, User Control, Context, DataContext

Command, CommandParameter, CommandBinding, RoutedCommand (Execute, CanExecute),

Resources, Resource Dictionary, Managed Dictionary, Static Resource

Content, Template, ItemTemplate, DataTemplate, ControlTemplate, ContentPresenter,

Style, Trigger, MultiDataTrigger, Setter,

Dependency Propery, DependencyObject, Binding, TemplateBinding, Path, Mode, RelativeSource, AncestorType, Converter (Convert/ConvertBack),

Transform, StoryBoard, VisualStateManager, Animation,

KeyboardNavigation.TabNavigation,

Brush, Panels, TextBlock (Inline, Run), Grid, DataGrid,

Stored procedure vs User defined functions

Filed under: sql — Ravendra Mishra @ 1:20 pm

Sr No.

User Defined Functions

Stored Procedures

1

UDF are simpler to invoke than Stored Procedures from inside another SQL statement.

They are Complex to Invoke.

2

SQL functions that return non-deterministic values are not allowed to be called from inside User Defined Functions. GETDATE is an example of a non-deterministic function. Every time the function is called, a different value is returned. Therefore, GETDATE cannot be called from inside a UDF you create, but could not be used inside the function itself.

Non-deterministic values are not allowed to be called from inside Stored Procedure.

3

The User Defined Function must be prefaced with the owner name, DBO in this case.

Not mandatory.

4

When call function then the parameter must transmit full.

Ex:
CREATE FUNCTION ftest(@val01 varchar(10),@val02 varchar(10) )

CREATE PROCEDURE pTest(

@val01 varchar(10) = ’10,
@val02 varchar(10) = NULL
)
Call:
dbo.ftest(@val01,@val02) —-> OK
dbo.ftest(@val01) —-> NOT OK

When call store procedure then the parameter allow empty.

CREATE PROCEDURE pTest(

@val01 varchar(10) = ’10,
@val02 varchar(10) = NULL
)
Call:
dbo.ftest(@val01,@val02) —-> OK
dbo.ftest(@val01) —-> NOT OK

pTest(@val01,@val02) —-> OK
pTest(@val01) —-> OK

5

A UDF is always used to return a value or a table object.

You can also get values back from a stored procedure by the return code (integer only) or an output parameter.

6

Function return type could be scalar or table or table values(SQL Server).

Stored procedure returns always integer value by default zero.

7

Stored Procedure is pre compiled execution plan

Functions are not precompiled.

8

Function returns only one value at a time.

Stored Procedure returns more than one value at a time.

9

We can call the functions in SQL statements (select max(sal) from emp).

We cannot call Stored Procedures in SQL Statements.

10

Function do not return the images, text.

Stored Procedure returns all.

11

Functions are used for computations.

Procedures can be used for performing business logic.

12

Functions MUST return a value.

Procedures need not be.

13

Function parameters are always IN, no OUT is possible

Stored procedures can have input and output parameters, while user defined functions only can have input parameters. Output parameters must be returned as return values.

14

UDF can be used in the SQL Statements anywhere in the WHERE/HAVING/SELECT section

Stored procedures cannot be.

15

If you have an operation such as a query with a FROM clause that requires a rowset be drawn from a table or set of tables, then a function will be your appropriate choice.

However, when you want to use that same rowset in your application the better choice would be a stored procedure.

16

Easy to create a function.

Skill Expertise is required to create a stored Procedure.

 

Stored Procedure
================
A stored procedure is a program (or procedure) which is
physically stored within a database. They are usually written in
a proprietary database language like PL/SQL for Oracle database
or PL/PgSQL for PostgreSQL. The advantage of a stored procedure
is that when it is run, in response to a user request, it is run
directly by the database engine, which usually runs on a separate
database server. As such, it has direct access to the data it
needs to manipulate and only needs to send its results back to
the user, doing away with the overhead of communicating large
amounts of data back and forth.

User-defined function
=====================

A user-defined function is a routine that encapsulates useful
logic for use in other queries. While views are limited to a
single SELECT statement, user-defined functions can have multiple SELECT statements and provide more powerful logic than is possible with views.

1>Procedure can return zero or n values whereas function can return one value which is mandatory.

2>Procedures can have input,output parameters for it whereas functions can have only input parameters.

3>Procedure allow select as well as DML statement in it whereas function allow only select statement in it.

4>Functions can be called from procedure whereas procedures cannot be called from function.

5>Exception can be handled by try-catch block in a procedure whereas try-catch block cannot be used in a function.

6>We can go for transaction management in procedure whereas we can’t go in function.

7>Procedures can not be utilized in a select statement whereas function can be embedded in a select statement.

May 18, 2010

C# Extension Methods and Indexers

Filed under: c#, .Net, Extension methods, Indexer — Ravendra Mishra @ 4:57 pm

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

 

namespace ClassLibrary1

{


///
<summary>


/// The indexers in C# can be overloaded just likemember functions


/// There is no concept of static Indexer


/// A Base class indexer can be polymorphicalyoverridden in a Derived class.


/// But remember that the modifiers likevirtual, override etc are using at property level, not at accessorlevel.


/// Abstract Indexers


/// An indexer inside a class can be declared asabstract by using the keyword abstract.


/// Remember that an abstractindexer in a class carries no code at all. The get/set accessors


/// aresimply represented with a semicolon. In the derived class we mustimplement both set and get assessors.


/// If the abstract class contains only set accessor, we can implement only set in the derived class.


/// Indexers & Properties


/// 1. An index is identified by it’s signature. But a property is identified it’s name.


/// 2. An indexer is always an instance member, but a property can be static also.


/// 3. An indexer is accessed through an element access. But a property is through a member access.


///
</summary>


public
class
IndexerDemo

{


private
string[] data;

 


public IndexerDemo(int Size)

{

data = new
string[Size];

}

 


public
string
this[int index]

{


get

{


return data[index];

}


set

{

data[index] = value;

}

}

 


public
int
this[string str]

{


get

{


for (int i = 0; i < 5; i++)


if (data[i] == str)


return i;

 


throw
new
IndexOutOfRangeException(str + ” is not a key.”);

}

}

}

 


///
<summary>


/// Demo of extension method


/// Extension methods enable you to “add” methods to existing types (Class/Interface) without creating a new derived type,


/// recompiling, or otherwise modifying the original type. Extension methods are a special kind of static method,


/// but they are called as if they were instance methods on the extended type.


/// The most common extension methods are the LINQ standard query operators that add query functionality


/// to the existing System.Collections.IEnumerable and System.Collections.Generic.IEnumerable<T> types.


/// 1. Extension methods need to be deinfed at top level (Non nested) static class


/// 2. First parameter of Extension method should be of the type on which this method is going to be implemented.


/// 3. extension methods are to extend a class or interface, but not to override them.


/// If same signature method is present in type definition (instance method) and also as extension method


/// then instance method will be called.


/// 4. In general, we recommend that you implement extension methods sparingly and only when you have to. Whenever possible,


/// client code that must extend an existing type should do so by creating a new type derived from the existing type.

 


///
</summary>


public
static
class
MyExtensions

{


public
static
int WordCount(this
String str)

{


return str.Split(new
char[] { ‘ ‘, ‘.’, ‘?’ }, StringSplitOptions.RemoveEmptyEntries).Length;

}

 


public
static
int FindIndex(this
IndexerDemo obj, String str )

{


for (int i = 0; i < 5; i++)


if (obj[i] == str)


return i;

 


throw
new
IndexOutOfRangeException(str + ” is not a key.”);

}

}

 


public
class
test

{


public
static
void Main()

{


String str = “Hello”;

str.WordCount();

 


IndexerDemo obj = new
IndexerDemo(5);

 


foreach (string s in obj)

{

 

}

 

obj[4]=“Hello”;

 

System.Console.WriteLine(obj[4]);

System.Console.WriteLine(obj[“Hello”]);

System.Console.WriteLine(obj.FindIndex(“Hello1”));

 

}

}

}

May 11, 2010

How to Create Analysis Database

Filed under: MSAS, Microsoft Analysis Services, OLAP, MDX, Cube, SSIS — Ravendra Mishra @ 4:58 pm

Open business intelligence studio and create new analysis server project.

Create new data source. This is the source of data based on which olap database will be created. This may be the SQL database where your tables are stored.

Create new data source view.

Create new cube. Select the data source, select measure and dimension tables.

This is what it gives when you click Next button

 

Next you need to select dimension tables

 

Rebuild the database to check if everything is ok. Once build is successful try to deploy it.

Right click on the project and change properties to specify the server name where you want to deploy this database. Deployment progress is displayed on separate window

May 10, 2010

How to update the MSProject Field Mapping in TFS

Filed under: Team foundation server 2010 — Ravendra Mishra @ 1:36 pm

Below are the steps for How to update the MSProject Field Mapping in TFS.

Uploads or downloads the file that defines how fields are mapped between Microsoft Office Project and Team Foundation Server. To use this tool, you must be a member of either the Team Foundation Administrators group or the Project Administrators group for the team project that you specify.

Usage: TFSFieldMapping upload | download /collection:CollectionURI /teamproject:ProjectName /mappingfile:MappingFile

upload Uploads the field mapping file for the team project that you
specify.
download Downloads the field mapping file for the team project that you
specify.
CollectionURI The URI of the team project collection. http://ServerName:Port/VirtualDirectoryName/CollectionName.

Below are the example steps:

1. Download the MS Project field mapping file from TFS:

C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE>tfsfieldmapping  download /collection:”http://serverName:8080/tfs/tfs support” /teamproject:”tfs testing” /mappingfile:”c:\FileMapping.xml”

2. Update and save FileMapping.xml

3. Upload the MS Project field mapping file to TFS:

C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE>tfsfieldmapping  upload /collection:”http://serverName:8080/tfs/tfs support” /teamproject:”tfs testing” /mappingfile:”c:\FileMapping.xml”

Team foundation server 2010 warehouse rebuilt

Filed under: Team foundation server 2010 — Ravendra Mishra @ 12:55 pm

Few days ago suddenly I realised that warehouse database is not being synchronized with latest changes. Tried to rebuilt it using warehouse services. These can be found at url http://localhost:8080/tfs/teamfoundation/administration/v3.0/warehousecontrolservice.asmx of the TFS application server.

Though it didn’t work (This used to work). This time I got following when I checked for GetProcessingStatus

<?xml version=”1.0″ encoding=”utf-8″ ?>


<WarehouseProcessingStatus xmlns:xsd=”http://www.w3.org/2001/XMLSchema xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance xmlns=”http://schemas.microsoft.com/TeamFoundation/2005/06/Services/Controller/03“>


<RequestTimeUtc>2010-05-10T12:42:24.4621235Z</RequestTimeUtc>


<WarehouseProcessingOnlineStatus>Started</WarehouseProcessingOnlineStatus>


<AnalysisProcessingOnlineStatus>Started</AnalysisProcessingOnlineStatus>


<JobProcessingStatus>Idle</JobProcessingStatus>


<JobsRunning>0</JobsRunning>


<JobsQueued>0</JobsQueued>


<Instance Name=”TEAM FOUNDATION JobProcessingStatus=”Idle JobsRunning=”0 JobsQueued=”0“>


<Jobs>


<Job Name=”Full Analysis Database Sync JobProcessingStatus=”Idle“>


<LastRun QueueTimeUtc=”2010-05-10T01:00:00Z ExecutionStartTimeUtc=”2010-05-10T01:00:01.51Z EndTimeUtc=”2010-05-10T01:01:02.72Z Result=”Failed“>


<ResultMessage>[Full Analysis Database Sync]: —> AnalysisDatabaseProcessingType=Full. —> Microsoft.TeamFoundation.Server.WarehouseException: TF221122: An error occurred running job Full Analysis Database Sync for team project collection or Team Foundation server TEAM FOUNDATION. —> Microsoft.TeamFoundation.Server.WarehouseException: Failed to Process Analysis Database ‘Tfs_AnalysisServer’. —> Microsoft.TeamFoundation.Server.WarehouseException: Error during OLE DB operation. Error Code = 0xC1060000, External Code = 0x80004005: Login timeout expired HYT00 A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. 08001 SQL Server Network Interfaces: Error getting enabled protocols list from registry [xFFFFFFFF]. 08001. Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of ‘Tfs_AnalysisDataSource’, Name of ‘Tfs_TAnalysisDataSource’. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of ‘Configuration’, Name of ‘Test Configuration’ was being processed. Errors in the OLAP storage engine: An error occurred while the ‘Configuration ID’ attribute of the ‘Test Configuration’ dimension from the ‘Tfs_Analysis’ database was being processed. Internal error: The operation terminated unsuccessfully. Internal error: The operation terminated unsuccessfully. Server: The operation has been cancelled. Error during OLE DB operation. Error Code = 0xC1060000, External Code = 0x80004005: Login timeout expired HYT00 A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. 08001 SQL Server Network Interfaces: Error getting enabled protocols list from registry [xFFFFFFFF]. 08001. Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of ‘Tfs_AnalysisDataSource’, Name of ‘Tfs_AnalysisDataSource’. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of ‘Configuration’, Name of ‘Test Configuration’ was being processed. Errors in the OLAP storage engine: An error occurred while the ‘Configuration Name’ attribute of the ‘Test Configuration’ dimension from the ‘Tfs_Analysis’ database was being processed. Internal error: The operation terminated unsuccessfully. Internal error: The operation terminated unsuccessfully. Error during OLE DB operation. Error Code = 0xC1060000, External Code = 0x80004005: Login timeout expired HYT00 A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. 08001 SQL Server Network Interfaces: Error getting enabled protocols list from registry [xFFFFFFFF]. 08001. Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of ‘Tfs_AnalysisDataSource’, Name of ‘Tfs_AnalysisDataSource’. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of ‘Result’, Name of ‘Test Result’ was being processed. Errors in the OLAP storage engine: An error occurred while the ‘Outcome’ attribute of the ‘Test Result’ dimension from the ‘Tfs_Analysis’ database was being processed. Internal error: The operation terminated unsuccessfully. Internal error: The operation terminated unsuccessfully. Error during OLE DB operation. Error Code = 0xC1060000, External Code = 0x80004005: Login timeout expired HYT00 A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. 08001 SQL Server Network Interfaces: Error getting enabled protocols list from registry [xFFFFFFFF]. 08001. Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of ‘Tfs_AnalysisDataSource’, Name of ‘Tfs_AnalysisDataSource’. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of ‘Result’, Name of ‘Test Result’ was being processed. Errors in the OLAP storage engine: An error occurred while the ‘Resolution State’ attribute of the ‘Test Result’ dimension from the ‘Tfs_Analysis’ database was being processed. Internal error: The operation terminated unsuccessfully. Internal error: The operation terminated unsuccessfully. at Microsoft.TeamFoundation.Warehouse.TFSOlapProcessComponent.ExecuteXmla(String finalXmla) at Microsoft.TeamFoundation.Warehouse.TFSOlapProcessComponent.ProcessOlap(AnalysisDatabaseProcessingType processingType, WarehouseChanges warehouseChanges) — End of inner exception stack trace — at Microsoft.TeamFoundation.Warehouse.TFSOlapProcessComponent.ProcessOlap(AnalysisDatabaseProcessingType processingType, WarehouseChanges warehouseChanges) at Microsoft.TeamFoundation.Warehouse.AnalysisDatabaseSyncJobExtension.RunInternal(TeamFoundationRequestContext requestContext, TeamFoundationJobDefinition jobDefinition, DateTime queueTime, String& resultMessage) at Microsoft.TeamFoundation.Warehouse.WarehouseJobExtension.Run(TeamFoundationRequestContext requestContext, TeamFoundationJobDefinition jobDefinition, DateTime queueTime, String& resultMessage) — End of inner exception stack trace —</ResultMessage>


</LastRun>


<NextRun
QueueTimeUtc=”2010-05-10T13:00:00Z JobState=”QueuedScheduled” />


</Job>


<Job Name=”Incremental Analysis Database Sync JobProcessingStatus=”Idle“>


<LastRun
QueueTimeUtc=”2010-05-10T12:32:11.053Z ExecutionStartTimeUtc=”2010-05-10T12:32:12.35Z EndTimeUtc=”2010-05-10T12:33:35.503Z Result=”Succeeded” />


<NextRun
QueueTimeUtc=”2010-05-10T13:02:11.053Z JobState=”QueuedScheduled” />


</Job>


</Jobs>

……

…..

So I tried another option to rebuild the warehouse database from scratch using “Team foundation server admin console” utility from application server box. Go to reporting section and click rebuild. This is supposed to rebuild Warehouse and Analysis database.

Using this step warehouse database was rebuilt successfully but Analysis database is not completely rebuild yet. I am able to see only “Team System” cube in the database. Though I am expecting at least five cubes in this database. So I went to Edit option of the above screen, Navigate to Analysis tab and specify new database name.

This step successfully created analysis database as expected with all the cubes etc. Surprisingly this step also changed report server data source connection definition as well and they are pointing to newly created database.

April 29, 2010

TFS Warehouse controller service

Filed under: Team foundation server 2010,TFS — Ravendra Mishra @ 11:10 am

Team foundation server 2010 warehouse controller services can be accessed from following link on TFS App server

http://<TFS App Server>:8080/tfs/teamfoundation/administration/v3.0/warehousecontrolservice.asmx

It gives following services in the list. Highlighted ones are specially useful to synchronize warehouse and olap databases.

April 28, 2010

Explorer view of MOSS 2007 site not working on IE8

Filed under: Sharepoint — Ravendra Mishra @ 11:13 am

Explorer view of MOSS 2007 site not working on IE8

when I’m working in shared documents, I’m trying to use the explorer view. It says ” Please wait while Explorer View is loaded. If Explorer View does not appear, your browser may not support it. ”

 


 

This seems a known issue; If you are not able to carry out your work without explorer view then you may try following options to make it work:

 

 

  • If still not working then try below (Make sure Web Client Network Protocol is installed in your client machine)

1. Go to START > RUN

2. Type _services.msc_

3. Locate the _WebClient_ service

4. Open the service and make sure startup is set to _Automatic_. If service is already stopped, you’ll have to hit _START_ after setting to Automatic.

 

  • Try deleting all the temp files in the following locations:

    c:\documents and settings\[Username]\nethood
    c:\documents and settings\[Username]\application data\microsoft\web server extensions\cache

    Then try running these commands in sequence

    net stop webclient
    net stop mrxdav
    net start webclient

 

  • Actions -> Open With Windows Explorer this will open a new Windows Explorer window that is in reality a web folder to the Document Library.
« Previous PageNext Page »

Create a free website or blog at WordPress.com.