[midPoint] Issue importing users

Thu Aug 27 22:20:26 CEST 2020

Hi -

I was hoping for some help. I've been trying to import users for the first time from a CSV and have been consistently running into the following error.

Operation
operation.com.evolveum.midpoint.model.impl.sync.SynchronizeAccountResultHandler.handle
Message
Failed to import: Error occurred during resource object shadow owner lookup, reason: Couldn't convert query.
Parameters
object

[shadow:17dd8d4f-6400-4dd4-bc06-2f94f27157ca(AA12929000)]

Context
progress

[1]

Error
Error occurred during resource object shadow owner lookup, reason: Couldn't convert query.

com.evolveum.midpoint.util.exception.SystemException: Error occurred during resource object shadow owner lookup, reason: Couldn't convert query. at com.evolveum.midpoint.model.impl.sync.SynchronizationServiceImpl.setupSituation(SynchronizationServiceImpl.java:573) at com.evolveum.midpoint.model.impl.sync.SynchronizationServiceImpl.notifyChange(SynchronizationServiceImpl.java:145) at com.evolveum.midpoint.provisioning.impl.ChangeNotificationDispatcherImpl.notifyChange(ChangeNotificationDispatcherImpl.java:170) at com.evolveum.midpoint.model.impl.sync.SynchronizeAccountResultHandler.handleObjectInternal(SynchronizeAccountResultHandler.java:202) at com.evolveum.midpoint.model.impl.sync.SynchronizeAccountResultHandler.handleObject(SynchronizeAccountResultHandler.java:120) at com.evolveum.midpoint.repo.common.task.AbstractSearchIterativeResultHandler.processRequest(AbstractSearchIterativeResultHandler.java:343) at com.evolveum.midpoint.repo.common.task.AbstractSearchIterativeResultHandler.handle(AbstractSearchIterativeResultHandler.java:188) at com.evolveum.midpoint.model.impl.importer.ImportAccountsFromResourceTaskHandler.importSingleShadow(ImportAccountsFromResourceTaskHandler.java:330) at com.evolveum.midpoint.model.impl.controller.ModelController.importFromResource(ModelController.java:1399) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at org.apache.wicket.proxy.LazyInitProxyFactory$JdkHandler.invoke(LazyInitProxyFactory.java:521) at com.sun.proxy.$Proxy226.importFromResource(Unknown Source) at com.evolveum.midpoint.web.page.admin.resources.ResourceContentPanel.importResourceObject(ResourceContentPanel.java:909) at com.evolveum.midpoint.web.page.admin.resources.ResourceContentPanel$13$1.onSubmit(ResourceContentPanel.java:810) at com.evolveum.midpoint.web.component.menu.cog.MenuLinkPanel.onSubmit(MenuLinkPanel.java:103) at com.evolveum.midpoint.web.component.menu.cog.MenuLinkPanel$1.onSubmit(MenuLinkPanel.java:51) at org.apache.wicket.ajax.markup.html.form.AjaxSubmitLink$1.onSubmit(AjaxSubmitLink.java:111) at org.apache.wicket.ajax.form.AjaxFormSubmitBehavior$AjaxFormSubmitter.onSubmit(AjaxFormSubmitBehavior.java:223) at org.apache.wicket.markup.html.form.Form.delegateSubmit(Form.java:1308) at org.apache.wicket.markup.html.form.Form.process(Form.java:1001) at org.apache.wicket.markup.html.form.Form.onFormSubmitted(Form.java:825) at org.apache.wicket.ajax.form.AjaxFormSubmitBehavior.onEvent(AjaxFormSubmitBehavior.java:176) at org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:127) at org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:598) at org.apache.wicket.core.request.handler.ListenerRequestHandler.internalInvoke(ListenerRequestHandler.java:306) at org.apache.wicket.core.request.handler.ListenerRequestHandler.invoke(ListenerRequestHandler.java:280) at org.apache.wicket.core.request.handler.ListenerRequestHandler.invokeListener(ListenerRequestHandler.java:222) at org.apache.wicket.core.request.handler.ListenerRequestHandler.respond(ListenerRequestHandler.java:208) at org.apache.wicket.request.cycle.RequestCycle$HandlerExecutor.respond(RequestCycle.java:914) at org.apache.wicket.request.RequestHandlerExecutor.execute(RequestHandlerExecutor.java:65) at org.apache.wicket.request.cycle.RequestCycle.execute(RequestCycle.java:282) at org.apache.wicket.request.cycle.RequestCycle.processRequest(RequestCycle.java:253) at org.apache.wicket.request.cycle.RequestCycle.processRequestAndDetach(RequestCycle.java:221) at org.apache.wicket.protocol.http.WicketFilter.processRequestCycle(WicketFilter.java:275) at org.apache.wicket.protocol.http.WicketFilter.processRequest(WicketFilter.java:206) at org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.java:299) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.evolveum.midpoint.web.util.MidPointProfilingServletFilter.doFilter(MidPointProfilingServletFilter.java:85) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.evolveum.midpoint.web.security.filter.MidpointAuthFilter$VirtualFilterChain.doFilter(MidpointAuthFilter.java:276) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91) at com.evolveum.midpoint.web.security.filter.MidpointAuthFilter$VirtualFilterChain.doFilter(MidpointAuthFilter.java:289) at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137) at com.evolveum.midpoint.web.security.filter.MidpointAuthFilter$VirtualFilterChain.doFilter(MidpointAuthFilter.java:289) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119) at com.evolveum.midpoint.web.security.filter.MidpointAuthFilter$VirtualFilterChain.doFilter(MidpointAuthFilter.java:289) at com.evolveum.midpoint.web.security.filter.MidpointAnonymousAuthenticationFilter.doFilter(MidpointAnonymousAuthenticationFilter.java:90) at com.evolveum.midpoint.web.security.filter.MidpointAuthFilter$VirtualFilterChain.doFilter(MidpointAuthFilter.java:289) at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170) at com.evolveum.midpoint.web.security.filter.MidpointAuthFilter$VirtualFilterChain.doFilter(MidpointAuthFilter.java:289) at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63) at com.evolveum.midpoint.web.security.filter.MidpointAuthFilter$VirtualFilterChain.doFilter(MidpointAuthFilter.java:289) at org.springframework.security.web.session.ConcurrentSessionFilter.doFilter(ConcurrentSessionFilter.java:155) at com.evolveum.midpoint.web.security.filter.MidpointAuthFilter$VirtualFilterChain.doFilter(MidpointAuthFilter.java:289) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200) at com.evolveum.midpoint.web.security.filter.MidpointAuthFilter$VirtualFilterChain.doFilter(MidpointAuthFilter.java:289) at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116) at com.evolveum.midpoint.web.security.filter.MidpointAuthFilter$VirtualFilterChain.doFilter(MidpointAuthFilter.java:289) at com.evolveum.midpoint.web.security.filter.RedirectForLoginPagesWithAuthenticationFilter.doFilterInternal(RedirectForLoginPagesWithAuthenticationFilter.java:39) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:118) at com.evolveum.midpoint.web.security.filter.MidpointAuthFilter$VirtualFilterChain.doFilter(MidpointAuthFilter.java:289) at org.springframework.security.web.csrf.CsrfFilter.doFilterInternal(CsrfFilter.java:124) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:118) at com.evolveum.midpoint.web.security.filter.MidpointAuthFilter$VirtualFilterChain.doFilter(MidpointAuthFilter.java:289) at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:74) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:118) at com.evolveum.midpoint.web.security.filter.MidpointAuthFilter$VirtualFilterChain.doFilter(MidpointAuthFilter.java:289) at com.evolveum.midpoint.web.security.filter.MidpointAuthFilter.processingOfAuthenticatedRequest(MidpointAuthFilter.java:243) at com.evolveum.midpoint.web.security.filter.MidpointAuthFilter.doFilterInternal(MidpointAuthFilter.java:180) at com.evolveum.midpoint.web.security.filter.MidpointAuthFilter.doFilter(MidpointAuthFilter.java:98) at com.evolveum.midpoint.web.security.filter.MidpointFilterChainProxy$VirtualFilterChain.doFilter(MidpointFilterChainProxy.java:173) at com.evolveum.midpoint.web.security.filter.TranslateExeptionFilter.doFilterInternal(TranslateExeptionFilter.java:30) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:118) at com.evolveum.midpoint.web.security.filter.MidpointFilterChainProxy$VirtualFilterChain.doFilter(MidpointFilterChainProxy.java:176) at org.springframework.security.web.session.ConcurrentSessionFilter.doFilter(ConcurrentSessionFilter.java:155) at com.evolveum.midpoint.web.security.filter.MidpointFilterChainProxy$VirtualFilterChain.doFilter(MidpointFilterChainProxy.java:176) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) at com.evolveum.midpoint.web.security.filter.MidpointFilterChainProxy$VirtualFilterChain.doFilter(MidpointFilterChainProxy.java:176) at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:118) at com.evolveum.midpoint.web.security.filter.MidpointFilterChainProxy$VirtualFilterChain.doFilter(MidpointFilterChainProxy.java:176) at com.evolveum.midpoint.web.security.filter.MidpointFilterChainProxy.doFilterInternal(MidpointFilterChainProxy.java:95) at com.evolveum.midpoint.web.security.filter.MidpointFilterChainProxy.doFilter(MidpointFilterChainProxy.java:56) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:118) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:118) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:118) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.filterAndRecordMetrics(WebMvcMetricsFilter.java:114) at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:104) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:118) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:118) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.evolveum.midpoint.web.boot.TrailingSlashRedirectingFilter.doFilterInternal(TrailingSlashRedirectingFilter.java:60) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:118) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:526) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at com.evolveum.midpoint.web.boot.NodeIdHeaderValve.invoke(NodeIdHeaderValve.java:46) at com.evolveum.midpoint.web.boot.TomcatRootValve.invoke(TomcatRootValve.java:62) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:860) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834) Caused by: com.evolveum.midpoint.util.exception.SchemaException: Couldn't convert query. at com.evolveum.midpoint.model.impl.sync.SynchronizationExpressionsEvaluator.findFocusesByCorrelationRule(SynchronizationExpressionsEvaluator.java:188) at com.evolveum.midpoint.model.impl.sync.SynchronizationExpressionsEvaluator.findFocusesByCorrelationRule(SynchronizationExpressionsEvaluator.java:93) at com.evolveum.midpoint.model.impl.sync.SynchronizationServiceImpl.determineSituationWithCorrelation(SynchronizationServiceImpl.java:673) at com.evolveum.midpoint.model.impl.sync.SynchronizationServiceImpl.setupSituation(SynchronizationServiceImpl.java:568) ... 135 more Caused by: com.evolveum.midpoint.util.exception.SchemaException: Couldn't evaluate expressionExpressionType(variable=[],evaluator=path:$account/attributes/login): No definition for item login in IDI(old=RAC(attributes):[PCV(null):[RA({.../resource/instance-3}Last_x20Name):[PPV(String: REDACTED)], RA({.../resource/instance-3}First_x20Name):[PPV(String: REDACTED)], RA({.../resource/instance-3}Associate_x20ID):[PPV(String:AA12929000)], RA({.../resource/instance-3}Job_x20Title_x20Description):[PPV(String: REDACTED)], RA({.../resource/instance-3}Home_x20Department_x20Description):[PPV(String:IT Infrastructure)]]], delta=null, new=RAC(attributes):[PCV(null):[RA({.../resource/instance-3}Last_x20Name):[PPV(String: REDACTED)], RA({.../resource/instance-3}First_x20Name):[PPV(String:Abdullahi)], RA({.../resource/instance-3}Associate_x20ID):[PPV(String:AA12929000)], RA({.../resource/instance-3}Job_x20Title_x20Description):[PPV(String: REDACTED)], RA({.../resource/instance-3}Home_x20Department_x20Description):[PPV(String:IT Infrastructure)]]]) at com.evolveum.midpoint.repo.common.expression.ExpressionUtil.evaluateFilterExpressionsInternal(ExpressionUtil.java:637) at com.evolveum.midpoint.repo.common.expression.ExpressionUtil.evaluateQueryExpressions(ExpressionUtil.java:474) at com.evolveum.midpoint.model.impl.sync.SynchronizationExpressionsEvaluator.evaluateQueryExpressions(SynchronizationExpressionsEvaluator.java:357) at com.evolveum.midpoint.model.impl.sync.SynchronizationExpressionsEvaluator.updateFilterWithAccountValues(SynchronizationExpressionsEvaluator.java:351) at com.evolveum.midpoint.model.impl.sync.SynchronizationExpressionsEvaluator.findFocusesByCorrelationRule(SynchronizationExpressionsEvaluator.java:176) ... 138 more Caused by: com.evolveum.midpoint.util.exception.SchemaException: No definition for item login in IDI(old=RAC(attributes):[PCV(null):[RA({.../resource/instance-3}Last_x20Name):[PPV(String: REDACTED)], RA({.../resource/instance-3}First_x20Name):[PPV(String: REDACTED)], RA({.../resource/instance-3}Associate_x20ID):[PPV(String:REDACTED)], RA({.../resource/instance-3}Job_x20Title_x20Description):[PPV(String: REDACTED)], RA({.../resource/instance-3}Home_x20Department_x20Description):[PPV(String: REDACTED)]]], delta=null, new=RAC(attributes):[PCV(null):[RA({.../resource/instance-3}Last_x20Name):[PPV(String: REDACTED)], RA({.../resource/instance-3}First_x20Name):[PPV(String: REDACTED)], RA({.../resource/instance-3}Associate_x20ID):[PPV(String:AA12929000)], RA({.../resource/instance-3}Job_x20Title_x20Description):[PPV(String: REDACTED)], RA({.../resource/instance-3}Home_x20Department_x20Description):[PPV(String: REDACTED)]]]) at com.evolveum.midpoint.prism.util.ItemDeltaItem.findIdi(ItemDeltaItem.java:302) at com.evolveum.midpoint.model.common.expression.evaluator.PathExpressionEvaluator.evaluate(PathExpressionEvaluator.java:141) at com.evolveum.midpoint.repo.common.expression.Expression.evaluateExpressionEvaluators(Expression.java:221) at com.evolveum.midpoint.repo.common.expression.Expression.evaluate(Expression.java:154) at com.evolveum.midpoint.repo.common.expression.ExpressionUtil.evaluateExpression(ExpressionUtil.java:761) at com.evolveum.midpoint.repo.common.expression.ExpressionUtil.evaluateExpression(ExpressionUtil.java:773) at com.evolveum.midpoint.repo.common.expression.ExpressionUtil.evaluateExpression(ExpressionUtil.java:744) at com.evolveum.midpoint.repo.common.expression.ExpressionUtil.evaluateFilterExpressionsInternal(ExpressionUtil.java:605)

Much appreciated
Jenna Warman
IT Security Analyst
203-653-6295
100 First Stamford Place, 2nd Floor|Stamford,CT 06902| www.carecentrix.com<http://www.carecentrix.com/>

[cid:image003.jpg at 01D5C6D5.0163A960]

________________________________
This communication is intended only for the use of the individual or entity named as the addressee. It may contain information that is privileged and/or confidential under applicable law. If you are not the intended recipient or such recipient's employee or agent, you are hereby notified that any dissemination, copy or disclosure of this communication is strictly prohibited. If you have received this communication in error, please immediately notify CareCentrix Compliance Hot Line at (877) 848-8229 and notify the sender by electronic mail. Please delete this communication without making any copies. Thank you for your cooperation.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20200827/80083e99/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 3271 bytes
Desc: image001.jpg
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20200827/80083e99/attachment.jpg>