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