microsoft / CRM-Performance-Toolkit

The Microsoft Dynamics CRM 2015 Performance Toolkit was created by the Microsoft CRM product team to formalize performance testing of Microsoft CRM 2013 and later releases. The performance toolkit can be used by the Microsoft CRM partners and customers to collect data to support their CRM deployment decisions.
44 stars 18 forks source link

Eror running EMDBLoader.exe #23

Open Cwanara opened 8 years ago

Cwanara commented 8 years ago

I have an error when running .\EMDBLoader.exe to copy data from the CRM databases to the EntityManager database eror4

PS F:\CRMToolkit\CRM_Perf_Toolkit\EMDBLoader\bin\Debug> .\EMDBLoader.exe Initializing Entity Manager... Connecting to EntityManager SQL: Application Name=CRM_Perf_BenchMark;Server=DESKTOP-T7K4STA\SQLEXPRESS;Initial Catalog=EntityManager;Integrated Security=sspi Connected to Entity Manager SQL Database Connected to CRM SQL Database Issuing SQL Command to set default password UPDATE Organization SET ServerBaseUrl=@ServerBaseUrl where OrganizationId = @orgId Read: 1 Users Exception: System.ServiceModel.FaultException1[Microsoft.Xrm.Sdk.OrganizationServiceFault]: The value passed for ConditionOperator.In is empty (Fault Detail is equal to Microsoft.Xrm .Sdk.OrganizationServiceFault). SQL Exception: System.ServiceModel.FaultException1[Microsoft.Xrm.Sdk.OrganizationServiceFault]: The value passed for ConditionOperator.In is empty (Fault Detail is equal to Microsoft.Xrm .Sdk.OrganizationServiceFault). SQL Failure in loading EMDB from CRM. Error msg: The value passed for ConditionOperator.In is empty Entity Manager Database loading from CRM SQL Database failed. Server stack trace: at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc) at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation) at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

Exception rethrown at [0]: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) at Microsoft.Xrm.Sdk.IOrganizationService.RetrieveMultiple(QueryBase query) at Microsoft.Xrm.Sdk.Client.OrganizationServiceProxy.RetrieveMultipleCore(QueryBase query) at CommonTypes.EntityReader.ReadEntityFromTable(IOrganizationService proxy, String emdbSqlConnStr, String entityName, String[] props, FilterExpression where, String strO RDERBY, Nullable1 topRows, Guid orgId, Dictionary2 owners, String inEntityName, EntityType entityType) in f:\CRMToolkit\CRM_Perf_Toolkit\CommonTypes\EntityReader.cs:line 326 at CRM_Perf_BenchMark.EntityManager.ReadEntityFromTable(MultipleServersData serverData, String EntityName, String[] Props, FilterExpression Where, String strORDERBY, Nul lable`1 topRows, Guid orgId, String inEntityName, EntityType entityType) in f:\CRMToolkit\CRM_Perf_Toolkit\CRM_Perf_BenchMark\EntityManager\EntityManager.CrmDBReaders.cs:li ne 68 at CRM_Perf_BenchMark.EntityManager.ReadUsers(MultipleServersData serverData, Guid orgId) in f:\CRMToolkit\CRM_Perf_Toolkit\CRM_Perf_BenchMark\EntityManager\EntityManage r.CrmDBReaders.cs:line 713 at CRM_Perf_BenchMark.EntityManager.ReadAllEntitesFromCrmDBIntoEmDB(MultipleServersData serverData) in f:\CRMToolkit\CRM_Perf_Toolkit\CRM_Perf_BenchMark\EntityManager\En tityManager.cs:line 796 at CRM_Perf_BenchMark.EntityManager.RefreshEmDbFromCrmDbs(String buildNumber) in f:\CRMToolkit\CRM_Perf_Toolkit\CRM_Perf_BenchMark\EntityManager\EntityManager.cs:line 76 2 at CRM_Perf_BenchMark.EntityManager.LoadFromCRM() in f:\CRMToolkit\CRM_Perf_Toolkit\CRM_Perf_BenchMark\EntityManager\EntityManager.cs:line 730