locked
Error running EMDBLoader : CRM Performance Toolkit 2015 RRS feed

  • Question

  • Please Help, I have an error when running .\EMDBLoader.exe with Powershell to copy data from the CRM 2015 On Prem databases to the EntityManager database at my client

    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



    • Edited by cwanara Monday, July 11, 2016 10:54 PM
    Monday, July 11, 2016 10:53 PM