Populating data from MS CRM database to local database(Entitymanager) using EMDBLoader.exe.

Mar 24, 2008 at 6:00 AM
Hi,
I am working on MS CRM 4.0 toolkit to test my CRM application.I followed all the steps mentioned in Microsoft DynamicsTM CRM 4.0 Performance Toolkit document.
My problem is, the data is not getting populated into local Entitymanager database from CRM database when i use EMDBLoader.exe .

Please give me suggestions to resolve this problem.
Thanks in advance.
Mahendra.
Mar 24, 2008 at 7:31 PM
Edited Mar 24, 2008 at 10:10 PM
Hi Mahendra,
Few questions to get context:
1. Is the CRM database populated with relevant data?
2. When you ran runpopulation.cmd did you have any issues?

Here are a few suggestions to resolve the problem.
1. Open configsettings.xml file and increment the number for node reloadentitymanager. If you increment this number, the benchmark forces a copy of all the data from CRM database to EntityManager database.
2. Then rebuild the crm4_perf_toolkit solution.
3. Open Test Manager and right click a test such as createnewaccount and then select debug test.
4. Open the window "Output" and see what is being dumped in there. From there we will be able to narrow down the problem.

Could you also post the contents of the configsettings.xml file here so that I can see if there is anything wrong in the file?

Thanks,
Aditya.

mahendra_kotti wrote:
Hi,
I am working on MS CRM 4.0 toolkit to test my CRM application.I followed all the steps mentioned in Microsoft DynamicsTM CRM 4.0 Performance Toolkit document.
My problem is, the data is not getting populated into local Entitymanager database from CRM database when i use EMDBLoader.exe .

Please give me suggestions to resolve this problem.
Thanks in advance.
Mahendra.

Mar 25, 2008 at 9:12 AM
Edited Mar 26, 2008 at 9:50 AM
Hi Aditya,
Thanks for your response.

I am not using runpopulation.cmd to populate data in CRM database as my CRM application has some data.I am using this performance tool to test my existing test CRM application.
As you suggested, i incremented the node reloadentitymanager in configsettings.xml file and tested but no use getting the same error as previous.
Here i am copying the contents of the configsettings.xml file and errors i got during the test..

<?xml version="1.0"?>
<configsettings>
<reloadentitymanager value="2"/>
<configsku value="OnPremise"/>
<ignoretokencheck value="false"/>
<querystats value="true"/>
<webservicens value="http://schemas.microsoft.com/crm/2006/WebServices"/>
<crmdomain value="itl"/>
<runas userid="mscrmservice" password="@123"/>
<metabaseserver value="http://hydhtc75396"/>
<emsqlcnn value="Application Name=CRMPerfBenchMark;Server=.\SQLExpress;Initial Catalog=EntityManager;Integrated Security=sspi"/>
<alltasks value="false"/>
<bulkimportdir value="c:\bi\"/>
<helpandassistance value="false"/>
<reportserver value="http://hydhtc75396"/>
<parsedependentrequests value="false"/>
<bandwidthcapture value="false">
<netcapdir value="c:\netcap"/>
<bandwidthoutputdir value="C:\NetCap\6037\BenchMarkTestCases\ParsedFiles"/>
</bandwidthcapture>
<outlooksyncdir value="c:\outlooksyncdata"/>
<crmservers>
<crmserver>
<server value="http://hydhtc130510"/>
<discoveryserver value="http://hydhtc130510"/>
<apiserver value="http://hydhtc130510"/>
<organization name="test"/>
<sqlcnn value="Application Name=CRMPerfBenchMark;Server=hydhtc75396;Initial Catalog=titan_MSCRM;Integrated Security=sspi"/>
<configsqlcnn value="Application Name=CRMPerfBenchMark;Server=hydhtc75396;Initial Catalog=MSCRM_CONFIG;Integrated Security=sspi"/>
<AD>
<userbase value="mscrmservice"/>
<userpassword value="@123"/>
<start value="1"/>
<count value="200"/>
<outlookstart value="1"/>
<outlookcount value="200"/>
</AD>
</crmserver>
</crmservers>
</configsettings>


Error-------------------------------------------------------------------------------------------------------------------------------------------------------------------------


C:\Program Files\Microsoft Visual Studio 8\Common7\Tools\Bin\winnt>dbmon
3636: Connected to CRM SQL Database to retrieve buildnumber
3636: Connecting to EntityManager SQL: Application Name=CRMPerfBenchMark;Serve
r=.\SQLExpress;Initial Catalog=EntityManager;Integrated Security=sspi
3636: Connected to Entity Manager SQL Database
3636: Connecting up to CONFIG DB
3636: Connected to CONFIG DB
3636: Connecting to CRM SQL: Application Name=CRMPerfBenchMark;Server=hydhtc75
396;Initial Catalog=titan_MSCRM;Integrated Security=sspi
3636: Connected to CRM SQL Database
3636: Issuing SQL Command to set default password UPDATE Organization SET CrmSer
ver='http://hydhtc130510' where OrganizationId='ba4e71e4-7342-4279-8cb9-a437c9a8
c785'
3636: Read: 0 Users
3636: Issuing SQL Command to set default crmserver, password, OrganizationName U
PDATE SystemUser SET CrmServer='http://hydhtc130510', ApiServer='http://hydhtc13
0510', DiscoveryServer='http://hydhtc130510', UserPassword='infy@123', Organizat
ionName='titan' where OrganizationId='ba4e71e4-7342-4279-8cb9-a437c9a8c785'
3636: Read 1 BusinessUnits
3636: Exception: System.Data.SqlClient.SqlException: Incorrect syntax near 'a'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolea
n breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception
, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObj
ect stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cm
dHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, Tds
ParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, Run
Behavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBe
havior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehav
ior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult
result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehav
ior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, S
tring method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at CRMPerfBenchMark.EntityManager.ReadEntityFromTable(String EntityName, St
ring[] Props, String WHERE, String strORDERBY) in C:\CRM 4.0 Toolkit\CRM4PerfT
oolkit\CRMPerfBenchMark\Utilities\EntityManager.cs:line 1064
at CRMPerfBenchMark.EntityManager.ReadLeads() in C:\CRM 4.0 Toolkit\CRM4_Pe
rfToolkit\CRMPerf_BenchMark\Utilities\EntityManager.cs:line 1383
at CRMPerfBenchMark.EntityManager.LoadFromSQL() in C:\CRM 4.0 Toolkit\CRM4_
PerfToolkit\CRMPerf_BenchMark\Utilities\EntityManager.cs:line 690



Please give me suggestions to resolve this problem.
Thanks in advance.
Mahendra.


Mar 26, 2008 at 4:06 AM
Edited Mar 26, 2008 at 4:15 AM
Hi,
Looks like the Organization is set to "Test" in your configsettings.xml. Is it "Test" or "Titan" as the sql_cnn specifies. Secondly I am assuming your users are mscrmservice1 to mscrmservice200 with the same password.
It seems like no user data is being pulled for crm users as seen from - "Read: 0 Users". Something is wrong there. What are the test users on your system?
Just to clarify: For instance in our setup here, we install CRM as domain Administrator with domain name "Administrator" and our test users are crmusr1 to crmusr500. So for us the nodes are as follows:

<runas userid="administrator" ... />

<AD>
<userbase value="crmusr"/>
<password value="abcd" />
<start value="1"/>
<count value="500"/>
<outlookstart value="1"/>
<outlookcount value="500"/>
</AD>

Thanks,
Adi.