<div dir="ltr"><div dir="ltr"><div dir="ltr">I've encountered weird exception when creating new user. It takes ages, MP seems to be doing "something" for 30 seconds or so and then I'll see message below. We're using object template for users, but even when I turn on most verbal OT logging, no mappings are evaluated. After some research I've come across this clue...<b>bold part repeats all the time before exception:</b></div><div dir="ltr"><b><br></b></div><div dir="ltr"><div dir="ltr"><b>2019-01-04 18:09:06,736 [] [pool-5-thread-2] DEBUG (com.evolveum.midpoint.repo.sql.SqlRepositoryServiceImpl.performance): > search objects UserType</b></div><div dir="ltr"><b>2019-01-04 18:09:06,908 [] [pool-5-thread-2] DEBUG (com.evolveum.midpoint.repo.sql.SqlRepositoryServiceImpl): Searching objects of type 'UserType', query (on trace level), offset null, count 50, iterative false, strictlySequential null.<br></b></div><div dir="ltr"><b>2019-01-04 18:09:06,908 [] [pool-5-thread-2] TRACE (com.evolveum.midpoint.repo.sql.SqlRepositoryServiceImpl): Full query<br></b></div><div dir="ltr"><b>Filter:<br></b></div><div dir="ltr"><b>  REF:<br></b></div><div dir="ltr"><b>    PATH: personaRef<br></b></div><div dir="ltr"><b>    DEF: PRD:{.../common/common-3}personaRef {.../common/common-3}ObjectReferenceType[0,-1],RAM<br></b></div><div dir="ltr"><b>    VALUE:<br></b></div><div dir="ltr"><b>Paging:<br></b></div><div dir="ltr"><b>  Max size: 50<br></b></div><div dir="ltr"><b>  Oid greater than: ff2b06b7-d90a-4f59-a6b0-f0031b7f3dea</b><br></div><div dir="ltr">2019-01-04 18:09:06,908 [] [pool-5-thread-2] DEBUG (com.evolveum.midpoint.repo.sql.SqlRepositoryServiceImpl.performance): > search objects UserType<br></div><div dir="ltr">2019-01-04 18:09:07,065 [] [pool-5-thread-2] DEBUG (com.evolveum.midpoint.repo.sql.SqlRepositoryServiceImpl): Searching objects of type 'UserType', query (on trace level), offset null, count 50, iterative false, strictlySequential null.<br></div><div dir="ltr">2019-01-04 18:09:07,065 [] [pool-5-thread-2] TRACE (com.evolveum.midpoint.repo.sql.SqlRepositoryServiceImpl): Full query<br></div><div dir="ltr">Filter:<br></div><div dir="ltr">  REF:<br></div><div dir="ltr">    PATH: personaRef<br></div><div dir="ltr">    DEF: PRD:{.../common/common-3}personaRef {.../common/common-3}ObjectReferenceType[0,-1],RAM<br></div><div dir="ltr">    VALUE:<br></div><div dir="ltr">Paging:<br></div><div dir="ltr">  Max size: 50<br></div><div dir="ltr">  Oid greater than: ffa67e4d-3fb8-4df8-822c-a439e88ded85<br></div><div dir="ltr">2019-01-04 18:09:07,065 [] [pool-5-thread-2] DEBUG (com.evolveum.midpoint.repo.sql.SqlRepositoryServiceImpl.performance): > search objects UserType<br></div><div dir="ltr">2019-01-04 18:09:07,158 [] [pool-5-thread-2] DEBUG (com.evolveum.midpoint.repo.sql.SqlRepositoryServiceImpl): Searching objects of type 'UserType', query (on trace level), offset null, count 50, iterative false, strictlySequential null.<br></div><div dir="ltr">2019-01-04 18:09:07,158 [] [pool-5-thread-2] TRACE (com.evolveum.midpoint.repo.sql.SqlRepositoryServiceImpl): Full query<br></div><div dir="ltr">Filter:<br></div><div dir="ltr">  REF:<br></div><div dir="ltr">    PATH: personaRef<br></div><div dir="ltr">    DEF: PRD:{.../common/common-3}personaRef {.../common/common-3}ObjectReferenceType[0,-1],RAM<br></div><div dir="ltr">    VALUE:<br></div><div dir="ltr">Paging:<br></div><div dir="ltr">  Max size: 50<br></div><div dir="ltr">  Oid greater than: fff9b897-5935-4fc4-8e03-5da94633f847<br></div><div dir="ltr">2019-01-04 18:09:07,158 [] [pool-5-thread-2] DEBUG (com.evolveum.midpoint.repo.sql.SqlRepositoryServiceImpl.performance): > search objects UserType<br></div><div dir="ltr">2019-01-04 18:09:07,158 [] [pool-5-thread-2] WARN (com.evolveum.midpoint.model.impl.lens.LensOwnerResolver): More than one owner of user:null(9999999999): [user:00000000-0000-0000-0000-000000000002(administrator), user:00011e00-1fa5-471e-98d4-f9bb5c959afd(605619), user:0001ca96-ebd4-4a95-b419-fc5c132a94bd(400918), user:000d6993-fda4-4222-b948-1d1fdc2aeaf8(403016), user:00105aa4-78fe-40cb-a6f9-87b7a264e7d9(209094), user:00129a50-1f01-45ac-af16-bcec66064b22(105901), user:0014d0d4-c7c4-4c2f-8363-204677ec4a0c(110711), user:00155c40-eb35-4a9a-8f70-5d84d062e307(109376), user:0018e5c2-04a6-4b6a-8bdd-76ed2b9ac791(303942), user:001f2c56-8e0e-42b7-beb3-f4a90c388f3e(809518), user:001fad2f-523a-437d-8b05-17aed6d5e74a(700511), user:00212067-53ff-4981-92c4-2c90d21f0408(101272), user:0021526f-a06c-4f3a-8cd8-acda83da4fe6(704409), user:0028c0bf-ad29-4f9f-b7d9-6da0b68c363a(609298), user:002ba9f2-2ca5-42de-b490-0b001d62babf(810139), user:002c2112-b3ed-460d-b40a-8d84583a54a0(809864), user:00307028-1c77-462e-bb3a-109444609c71(105015), user:003076ab-4318-4054-b310-de565fcb3a37(607152), user:00348fe9-5056-4564-8bfa-1df925e40605(703163), user:0034b331-9400-4922-a144-2a02e2e0ffb7(111269), user:003a9970-6ff5-4694-8d55-8668d9132b36(711924), user:003c45f2-dbc8-4fed-834e-432d9f41708d(305799), user:003fbd15-9151-428d-a81d-d5363618a68f(506929), user:0043c989-2778-4e21-8c7c-a55457d5ab0c(050989), user:0048312c-a1f5-4a9b-9dd7-89ac85648672(701318), user:0049baa3-c532-40e2-9500-d2bd5d1d9ece(050369), user:004a47a1-bc88-46fa-8590-52f403c1b02c(706377), user:0051f34d-c917-490e-9704-fae1536abb62(403204), user:00600dbf-41d9-4e0e-a3d3-39e588b9a48c(506665), user:00633c9e-b946-4bd3-a49b-bbf0db57dbca(609087), user:0063f0b1-55d7-482f-aea9-5f98c87e225d(803030), user:0069b9be-c9d0-4faf-89b6-83161062b5d8(306420), user:006f8925-ee1f-476e-8db6-1e29515e7612(609485), user:0074ebcd-13be-4969-b4ea-74537926b52c(706990), user:00756d39-e23b-4b27-9cde-71a31af4974d(105300), user:00780e42-8922-43d7-a401-a32e99d85de2(802341), user:007a4fa8-7cc4-4e0e-8303-44576e3fc7d0(108095), user:007d88f4-311a-414c-b3b7-771bc6850355(602583), user:00815e5f-73ba-4618-9f6d-b474e0e942c9(401588), user:0081d5d6-6675-4c85-a99b-ee7cb0d3201d(202763), user:00835f0a-aec7-424a-b3ee-4522f0d2c786(704362), user:00851e75-56a7-4349-a258-f942c92f6ac1(506307), user:00854b97-f154-4853-b1ee-3b496ef7870a(204290), user:0089747e-ef1f-48a1-ba0d-bbcc1b7363c9(109927), user:008ab389-7f52-4ce4-a2e8-3b030b9b61ca(401153), user:008f2121-abf9-4541-ac8a-aab4156bd478(707141), user:0091f1a8-5a42-4b60-b2ff-59d39ad76675(601135), user:0092cbde-aebf-432d-a11e-839bd0d0894c(604102), user:00947b4a-5d89-4466-8ac7-e45fd72e13f0(507644), user:00983bea-3fc3-4e40-8383-8732a7ea0b60(110357), user:009e42a1-602d-49f4-b716-d50b07b46ad9(050580), user:00a69985-36c2-4b49-9e65-faddc878918d(507999), user:00a7b996-7346-4fbb-8150-ca30e87f3d86(705734), user:00abe081-4a66-47ff-8045-1872dfc913c5(809415), user:00ac5310-f5be-4a7c-af79-822b7568a689(804377), user:00b4df5a-0acc-415d-a7ef-234dd79a1630(111467), user:00bc2c11-8bdd-4a51-82d8-65a1b337565c(807654), user:00bf4a58-2a74-4b98-af03-34404b8e943c(809993), user:00c118ee-ab2a-4cd7-b7f7-f97ff0a7d143(709154), user:00c9470d-dc0c-4cfc-858c-13604555da39(209065), user:00cad65d-44c1-49e8-b26c-07995ff0e1c8(403147), user:00cf0446-f664-4a69-9a5f-2fb4cded1c71(102917), user:00d27db9-a261-49f0-864a-ac355034a215(501459), user:00d5760b-8f82-45b3-bab7-df33a6dd5c47(050358), user:00d89847-36ab-4a49-b591-7ede707966d7(306446), user:00d9dd71-e9ef-4e4e-a602-f70993b571c9(108484), user:00da372d-c00c-488c-8239-ec2d7e662b28(601108), user:00df9da0-539e-47d1-909b-db8b2bbbe29e(501766), user:00e0a85d-0ad5-490c-8f7c-9533aa7372e8(609501), user:00e5035f-d96b-49f1-80f6-4de53eebb631(110061), user:00ea855f-e7fc-473f-a2c0-38e10f14be3d(711891), user:00eaa844-51c8-4f24-b77a-bd9407603be2(209343), user:00ecc44d-a4f5-4d77-aff1-1e23b9898e30(806155), user:00ed0bdf-59ef-4780-8f4d-2b3705dbca7f(809534), user:00ed18e6-7b13-498e-96f2-83c300c1279e(050463), user:00efd346-0a54-435a-b813-533431ccb7bf(305506), user:00f1d058-3044-443a-9394-e57c72d4d328(050214), user:00f4ba7e-1a41-427f-8e6e-e49564fcb083(810121), user:00f799c4-b530-4194-8cae-9f7eed7b6557(703603), user:00fb6334-baa1-4f1f-9c69-d881d465ca89(109752), user:00fd0083-23ba-4320-9c5c-ddd7e93332ce(105204), user:00fefe97-dac4-4107-b640-103c86c83b73(609168), user:0103160d-c9c6-48f2-b598-e100f33105e1(601939), user:0103b647-2bbb-4bc1-b7fc-d0af6d512289(110764), user:01076f75-517c-43ef-b3b3-541adc5e54c0(704317), user:010967fd-3626-4f38-84ec-4cfd227bd59c(809448), user:0110a38f-3280-4071-805e-d1b54bdabcc7(701496), user:0111731b-d7e7-44ec-bb64-d141b883b4d8(608366), user:0112ec5a-73ba-4a5e-ad6d-e12197bc83de(108950), user:0113b767-0a3c-41d0-8577-11a542b1d3cd(205783), user:0119be5b-81da-48d3-9c4b-4b04fbb5d498(051085), user:011afb8d-a603-4d5d-b5b4-e4389af06c82(401523), user:011f0648-dab7-4c2f-8dcc-4cf50e5aaffb(103202), user:011fdd69-e983-40ea-acab-ea80c2ad5f0f(108748), user:0125dcde-67ed-4056-8a36-643b71913d0f(609509), user:0127573b-3a16-4f0a-a4a1-5e01108d577a(506830), user:012e580a-5b47-4644-8bb5-3d26f282c7da(110158), user:01365f3b-e03e-4a49-b065-fb22d4df4182(806801), user:01371a9b-84db-4dfe-bc05-0996b6d6c8cd(050641), user:01381e33-f2a8-4fb4-8f08-ac7f4d526117(301225), user:013e08dd-c31a-4879-a0b0-2e0b36a98a6f(010190), user:01447922-825a-4708-a65d-3ff4ea4520d1(111634), user:0148a57b-2f85-41c4-bcdb-cc6967d31f01(701444), user:0148a8a9-ed55-4bf8-9496-d7a7f6ab3ce6(104203), user:01492b38-0a4a-459a-a8e4-d93e31f4272c(307355), user:014ac377-d97a-4813-a435-eafc6873aa87(806476), user:014b51fc-efad-4ba0-be8e-dbe4d5577bbd(111523), user:014fc5f3-a331-46bb-8d21-4403a11acd5b(501458), user:015916c2-2fe6-4f69-b221-701aadd76662(208801), user:0159ebe7-5694-426f-a3b5-02be38895efb(111648), user:015ca4c9-16b7-4aff-99d2-e768529203e9(109659), user:015dc5e0-23d6-4867-af57-58c36dcd6e7c(803405), user:015e05dd-838d-4c48-adc0-4daa2311acde(501220), user:015e4c2b-c538-4d16-a007-4824824cdd30(109956), ....<br></div><div dir="ltr"><br></div><div>(and thousand other users, probably all identities we have in MP ~23k)</div><div><br></div><div>Any ideas, what we messed up? We have one inbound application, but this appears also when i create new user via GUI. I'm quite sure we were creating identities fine some time ago.Thank you for any help</div><div><br></div><div>Best regards,</div><div><br></div><div>Jan Melnik</div></div></div></div>