Search Wiki:
The SharePoint 2007 Test Data Population Tool (WSSDW.exe) is a capacity planning and performance testing tool that populates data for testing SharePoint deployments. The SharePoint 2007 Test Data Population Tool is available as a command-line executable program that extracts information about how to populate the server from an XML configuration file, and calls Microsoft .NET assembly: WSSDWLib.dll. The tool is explained in the article, Plan capacity by using the SharePoint 2007 Test Data Population Tool.

Use this tool to populate test data for SharePoint capacity planning. Also included are some sample test scripts that can be used for performance and load testing SharePoint and Excel Services with the test data. These tools are being provided as is and there is no ongoing support for these tools. Please send email to sptdata@microsoft.com with feedback.

Excel Services performance testing samples have now beed added as a download. These samples include about a dozen performance testing scripts and are based on the "Microsoft Visual Studio 2005 Team Edition for Software Testers" performance testing tool.

For additional SharePoint performance and capacity planning information, see Plan for performance and capacity:
http://technet2.microsoft.com/Office/en-us/library/8dd52916-f77d-4444-b593-1f7d6f330e5f1033.mspx?mfr=true

For additional Excel Services performance and capacity planning information, see Determine resource requirements to support Excel Services:
http://technet2.microsoft.com/Office/en-us/library/fb6928ce-49f8-492a-abff-5bd00ed588e21033.mspx

Last edited Sep 11 2007 at 2:10 AM  by sptdatapop, version 10
Comments
sheetalkjain wrote  Jan 12 2007 at 2:31 AM  
The help file is corrupted.. I could not see any sample.xml

mrichman wrote  Jan 12 2007 at 5:26 PM  
Where is the test data?

xujiefreebird wrote  Jan 24 2007 at 11:44 AM  
How to use?

xujiefreebird wrote  Jan 24 2007 at 11:44 AM  
How to use?

sptdatapop wrote  Jan 27 2007 at 1:02 AM  
The help file (.chm file) looks corrupted because Windows has special security restrictions for CHM files.You have to follow the following steps to view the chm file:

1 - Save the CHM file to your local machine
2 - Right click on the file and choose "Properties"
3 - In the properties page it will say "This file came from another computer and might be blocked to help protect this computer". Click the "Unblock" button next to this text.
4 - Click OK to close the properties window.
5 - Open the CHM file. You will now be able to view the contents.

sptdatapop wrote  Jan 27 2007 at 1:03 AM  
You can check out the help file (.chm file) to see how to use the tool. There are sample test datas for your reference

sptdatapop wrote  Feb 5 2007 at 4:49 PM  
Excel Services performance testing samples have now beed added as a download. These samples include about a dozen performance testing scripts and are based on the "Microsoft Visual Studio 2005 Team Edition for Software Testers" performance testing tool.

sptdatapop wrote  Feb 9 2007 at 10:40 PM  
MOSS and WSS performance testing samples have now beed added as a download. These samples include about a dozen performance testing scripts each and are based on the "Microsoft Visual Studio 2005 Team Edition for Software Testers" performance testing tool.

marceljeanneau wrote  Mar 14 2007 at 3:37 PM  
This tool doesn't work on MOSS deplyments other than in English right? I'm trying to install it on MOSS in Spanish and it doesn't work. I'll try to add an English language pack to see if that makes it.

marceljeanneau wrote  Mar 14 2007 at 4:55 PM  
I already tried to deploy the sample data by installing the English language pack and creating a new site collection in English but I get the following error:
-----
C:\MOSSDPT>mossdw.exe CmsHierarchyRootWebSample.xml http://moss/sitios/auto
Importing file: CmsShared.xml
Setting global property parenttype=Article Page
Error: there is no known class which can handle tag Sites
Node Xml: <Sites name="" openmode="openexisting"></Sites>
Error: there is no known class which can handle tag Sites
Node Xml: <Sites name="" openmode="openexisting"></Sites>

Time to complete execution: 00:00:00.3004320

C:\MOSSDPT>
-----
Should I change the .xml sample files? I really don't know what to do.

Carsten wrote  Mar 16 2007 at 3:40 PM  
I think the examples are outdated - some old stuff, maybe?

Teo wrote  Jun 8 2007 at 9:44 AM  
I tried over both, English and Spanish installations........ I got the same errors......... I think all is about the XML and the permissions over the server. One question, someone knows if the tool generate some kind of output file with the result of the Test?

chaitu wrote  Aug 10 2007 at 6:05 PM  
Hello, I installed Moss_Data_Population_Tool.chm and i even unblocked the content, the problem is now am just able to see only the Main Menu(left hand display) but not the data of the menu items in the right hand side display. what could be the reson? do i need to install MOSS 2007 on my system to see the working manual of 'Microsoft Office SharePoint Server Test Data Load Tool'?

gillen138 wrote  Sep 12 2007 at 9:09 PM  
Will this work with SPS 2003 as well or is this only for WSS 3.0 and MOSS? I tried running it but get the following error: There is no known class which can handle tag WSSDWLib.

Any ideas?

daniela wrote  Sep 18 2007 at 10:07 AM  
I have some problem with the xml file of Data population Tool.
I tried to test the sample on "Publishing web pages", but it doesn't work.

---
>mossdw.exe CmsHierarchyRootWebSample.xml http://targetSiteUrl

Importing file: CmsShared.xml
Setting global property parenttype=Article Page
Error: There is no known class which can handle tag Sites
Node Xml: <Sites name="" openmode="openexisting"></Sites>
Error: There is no known class which can handle tag Sites
Node Xml: <Sites name="" openmode="openexisting"></Sites>

Time to complete execution: 00:00:17.0929842
----

Are in MOSSDWLib.dll the tags used in the xml files?
Any news? There is another library?

AnwarPV wrote  Oct 15 2007 at 2:56 PM  

Hi
When I run MOSSDW using the command

> mossdw.exe MySiteSample.xml http://targetSiteUrl

it throws the error messages as below

Processing: TestTopology
Attributes:
Setting environment variable startat=1
Setting environment variable numofusers=100
Setting environment variable endat=100
Setting global property propertyfile=TestPropertyFile.xml
Setting global property addblog=false
Processing: TestPortalSite
Attributes: Url: http://mossserver;
Error: Exception has been thrown: MOSSPerfTools.ContentDataManagement.CdmException: Connect failed in class MOSSPerfTool
s.Portal.TestPortalSite - object does not exist
at MOSSPerfTools.ContentDataManagement.ContentObjectBase.Connect()
at MOSSPerfTools.Portal.TestPortalSite.CreateInternal()
at MOSSPerfTools.ContentDataManagement.ContentObjectBase.Create(ContentObjectCreationType type)
at MOSSPerfTools.MOSSDW_Base.DoDataWriteOperation(IContentObject co)
at MOSSPerfTools.MOSSDW_Base.ProcessTag()

Time to complete execution: 00:00:01.1250000

Any solution for this problem?

timoteo wrote  Oct 19 2007 at 9:10 PM  
I was able to successfully run the wssdw.exe on my MOSS server using the sample file in that download. I was not able to run the MOSSDW.exe using the sample file provided.
I recommend that you supply the the domain\admin account anywhere you see "impersonate" for the load data.
I saw many of the errors listed above using the MOSSDW.

Also when doing the actual load test using the samples and Visual Studio I recommend only editing the .csv files using notepad.

AnwarPV wrote  Oct 22 2007 at 7:07 PM  
Thanks for the information; the wssdw.exe is working on my MOSS server.
Earlier I used the wssdw.exe on WSS 3.0 and was successful running it, since MOSSDW.exe is available for MOSS server; I always tried using it on MOSS server.

Now we need to investigate whether wssdw.exe could populate all the objects of MOSS server.

filion wrote  Nov 1 2007 at 3:42 PM  
>mossdw.exe CmsHierarchyRootWebSample.xml http://targetSiteUrl

Importing file: CmsShared.xml
Setting global property parenttype=Article Page
Error: There is no known class which can handle tag Sites
Node Xml: <Sites name="" openmode="openexisting"></Sites>
Error: There is no known class which can handle tag Sites
Node Xml: <Sites name="" openmode="openexisting"></Sites>

Anyone was able to solve this issue ?

bsieloff wrote  Nov 15 2007 at 4:33 PM  
Greetings,
Can the tools support creating other document libraries, besides the standard, such as a Slide Library or a Report Library? I have tried....(TAG listed below) but was unsuccesful. Perhaps my syntax is incorect.
<Lists name="Product Ideas" template="SlideLibrary" openmode="OpenOrCreate" enableversion="false" requireapproval="false" />

crol wrote  Dec 5 2007 at 12:52 PM  
When I try to execute "mossdw.exe MySiteSample.xml http://targetsiteurl" , th efollowing error appears:
Processing: TestPortalSite
Attributes: Url: http://mossserver;
Error: Exception has been thrown: MOSSPerfTools.ContentDataManagement.CdmException: Connect failed in class MOSSPerfTools.Portal.TestPortalSite - object does not exist
at MOSSPerfTools.ContentDataManagement.ContentObjectBase.Connect()
at MOSSPerfTools.Portal.TestPortalSite.CreateInternal()
at MOSSPerfTools.ContentDataManagement.ContentObjectBase.Create(ContentObjectCreationType type)
at MOSSPerfTools.MOSSDW_Base.DoDataWriteOperation(IContentObject co)
at MOSSPerfTools.MOSSDW_Base.ProcessTag()
I've tried with other samplefiles and this or other messages appeared (for example: Error: There is no known class which can handle tag Sites)As somebody commneted before, I've tried to execute wssdw.exe and message error apperared too. So, could somebody guide me to solve this issue?
Any help will be welcome.
Thanks

rayudu wrote  Mar 6 at 8:29 AM  
Hello, I am using the wssdw.exe and its working fine. I want to know how to create a page in the site. In MOSSDW.exe the tag is TestPage. Is there any similar kind of command in WSSDW? Anyone can help me. Thanks in advance...

guyleejr wrote  Mar 27 at 6:33 PM  
crol...

I know it's been a while since you posted, but I may have your solution.

Ran into the same thing and found I was logged in as myself on the box. I think you need to use elevated permissions in order to run the command. You can right click the shortcut to "Command" , choose "Run as", and select the MOSS Farm Admin account.

I hope this helps out.

Updating...