<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
@font-face
{font-family:Georgia;
panose-1:2 4 5 2 5 4 5 2 3 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
pre
{mso-style-priority:99;
mso-style-link:"HTML con formato previo Car";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
mso-fareast-language:ES;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif;
mso-fareast-language:ES;}
span.HTMLconformatoprevioCar
{mso-style-name:"HTML con formato previo Car";
mso-style-priority:99;
mso-style-link:"HTML con formato previo";
font-family:Consolas;
mso-fareast-language:EN-US;}
span.EstiloCorreo22
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EstiloCorreo23
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EstiloCorreo24
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EstiloCorreo25
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EstiloCorreo26
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 3.0cm 70.85pt 3.0cm;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:610208563;
mso-list-type:hybrid;
mso-list-template-ids:-1416844216 201981967 201981977 201981979 201981967 201981977 201981979 201981967 201981977 201981979;}
@list l0:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=ES link="#0563C1" vlink="#954F72"><div class=WordSection1><p class=MsoNormal><span style='color:#1F497D'>Thank you Ivan!<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>It worked perfectly!<o:p></o:p></span></p><div><p class=MsoNormal><span style='font-size:8.0pt;font-family:"Arial",sans-serif;color:#004254;mso-fareast-language:ES'><o:p> </o:p></span></p></div><p class=MsoNormal><o:p> </o:p></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span style='mso-fareast-language:ES'>De:</span></b><span style='mso-fareast-language:ES'> midPoint <midpoint-bounces@lists.evolveum.com> <b>En nombre de </b>Ivan Noris<br><b>Enviado el:</b> jueves, 23 de enero de 2020 12:28<br><b>Para:</b> midpoint@lists.evolveum.com<br><b>Asunto:</b> Re: [midPoint] Outbound mapping PostgresDB<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p>Hi Elsa,<span style='font-size:12.0pt;mso-fareast-language:ES'><o:p></o:p></span></p><p>my thoughts:<o:p></o:p></p><p>1. keyColumn is incorrectly set to "id". That's a number. It should be set to "username". Then it should not complain anymore.<o:p></o:p></p><p>2. AFAIK DBTable connector does not support two identifiers. icfs:uid will be always returned the same value as icfs:name. This is one of the oldest connectors (from OpenICF/ICF)<o:p></o:p></p><p>3. you need to only use icfs:name in the schema handling. Do not use ri:username mapping.<o:p></o:p></p><p>That should help.<o:p></o:p></p><p>If you need two identifiers, you have two options:<o:p></o:p></p><p>a) use ScriptedSQL connector, or<o:p></o:p></p><p>b) endorse <a href="https://jira.evolveum.com/browse/MID-2265">https://jira.evolveum.com/browse/MID-2265</a> (DatabaseTable connector rewrite) using your/your client subscription.<o:p></o:p></p><p>Best regards,<o:p></o:p></p><p>Ivan<o:p></o:p></p><div><p class=MsoNormal>On 23. 1. 2020 12:19, Gómez Martínez, Elsa wrote:<o:p></o:p></p></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><p class=MsoNormal><span lang=EN-US>Sorry, I forgot to attach the file.</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US>Elsa</span><o:p></o:p></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span style='mso-fareast-language:ES'>De:</span></b><span style='mso-fareast-language:ES'> Gómez Martínez, Elsa <br><b>Enviado el:</b> jueves, 23 de enero de 2020 12:19<br><b>Para:</b> midPoint General Discussion <a href="mailto:midpoint@lists.evolveum.com"><midpoint@lists.evolveum.com></a><br><b>Asunto:</b> RE: [midPoint] Outbound mapping PostgresDB</span><o:p></o:p></p></div></div><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal><span style='font-size:8.0pt;font-family:"Arial",sans-serif;color:#004254;mso-fareast-language:ES'> </span><o:p></o:p></p><p class=MsoNormal>Hi Ivan,<o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal><span lang=EN-US>This is the resource schema for icfs:name and username</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black;mso-fareast-language:ES'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES'><</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F;mso-fareast-language:ES'>xsd:element</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;mso-fareast-language:ES'> <span style='color:#7F007F'>minOccurs</span><span style='color:black'>=</span><i><span style='color:#2A00FF'>"0"</span></i> <span style='color:#7F007F'>name</span><span style='color:black'>=</span><i><span style='color:#2A00FF'>"username"</span></i> <span style='color:#7F007F'>type</span><span style='color:black'>=</span><i><span style='color:#2A00FF'>"xsd:string"</span></i><span style='color:teal'>></span></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black;mso-fareast-language:ES'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES'><</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F;mso-fareast-language:ES'>xsd:annotation</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black;mso-fareast-language:ES'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES'><</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F;mso-fareast-language:ES'>xsd:appinfo</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black;mso-fareast-language:ES'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES'><</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F;mso-fareast-language:ES'>a:displayOrder</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES'>></span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black;mso-fareast-language:ES'>130</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES'></</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F;mso-fareast-language:ES'>a:displayOrder</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black;mso-fareast-language:ES'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES'><</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F;mso-fareast-language:ES'>ra:frameworkAttributeName</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES'>></span><u><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black;mso-fareast-language:ES'>username</span></u><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES'></</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F;mso-fareast-language:ES'>ra:frameworkAttributeName</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black;mso-fareast-language:ES'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES'></</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F;mso-fareast-language:ES'>xsd:appinfo</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black;mso-fareast-language:ES'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES'></</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F;mso-fareast-language:ES'>xsd:annotation</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black;mso-fareast-language:ES'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES'></</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F;mso-fareast-language:ES'>xsd:element</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black;mso-fareast-language:ES'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES'><</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F;mso-fareast-language:ES'>xsd:element</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;mso-fareast-language:ES'> <span style='color:#7F007F'>ref</span><span style='color:black'>=</span><i><span style='color:#2A00FF'>"icfs:name"</span></i><span style='color:teal'>></span></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black;mso-fareast-language:ES'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES'><</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F;mso-fareast-language:ES'>xsd:annotation</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black;mso-fareast-language:ES'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES'><</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F;mso-fareast-language:ES'>xsd:appinfo</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black;mso-fareast-language:ES'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES'><</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F;mso-fareast-language:ES'>a:displayName</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES'>></span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black;mso-fareast-language:ES'>ConnId Name</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES'></</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F;mso-fareast-language:ES'>a:displayName</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black;mso-fareast-language:ES'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES'><</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F;mso-fareast-language:ES'>a:displayOrder</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES'>></span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black;mso-fareast-language:ES'>110</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES'></</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F;mso-fareast-language:ES'>a:displayOrder</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black;mso-fareast-language:ES'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES'><</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F;mso-fareast-language:ES'>ra:frameworkAttributeName</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES'>></span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black;mso-fareast-language:ES'>__NAME__</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES'></</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F;mso-fareast-language:ES'>ra:frameworkAttributeName</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black;mso-fareast-language:ES'> </span><span style='font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES'></</span><span style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F;mso-fareast-language:ES'>xsd:appinfo</span><span style='font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt;font-family:Consolas;color:black;mso-fareast-language:ES'> </span><span style='font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES'></</span><span style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F;mso-fareast-language:ES'>xsd:annotation</span><span style='font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES'>></span><o:p></o:p></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:Consolas;color:black;mso-fareast-language:ES'> </span><span style='font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES'></</span><span style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F;mso-fareast-language:ES'>xsd:element</span><span style='font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES'>></span><o:p></o:p></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES'> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US>I add the complete resource XML file. I have made some changes to hide some critical information.</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US>Regards,</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US>Elsa</span><o:p></o:p></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span style='mso-fareast-language:ES'>De:</span></b><span style='mso-fareast-language:ES'> midPoint <<a href="mailto:midpoint-bounces@lists.evolveum.com">midpoint-bounces@lists.evolveum.com</a>> <b>En nombre de </b>Ivan Noris<br><b>Enviado el:</b> jueves, 23 de enero de 2020 12:11<br><b>Para:</b> <a href="mailto:midpoint@lists.evolveum.com">midpoint@lists.evolveum.com</a><br><b>Asunto:</b> Re: [midPoint] Outbound mapping PostgresDB</span><o:p></o:p></p></div></div><p class=MsoNormal> <o:p></o:p></p><p>Hi Elsa,<o:p></o:p></p><p>I'd recommend to check the resource schema. Namely, icfs:name and ri:username.<o:p></o:p></p><p>From the log it looks like the format for the attribute where you put "alex" is Long.<o:p></o:p></p><p>Also if you're using the DBTable connector and if "username" column is the primary key, you cannot use "ri:username" and "icfs:name" together.<o:p></o:p></p><p>You have not sent the whole resource example, so I just guess that <keyColumn> is username in your configuration properties.<o:p></o:p></p><p>Try to comment the mapping for ri:username and see if it helps. But if you check the configuration properties and schema (not schema handling), it should help.<o:p></o:p></p><p>Disclaimer: I'm not using DBTable in any recent midpoint deployment. Someone from this list certainly does.<o:p></o:p></p><p>Best regards,<o:p></o:p></p><p>Ivan<o:p></o:p></p><div><p class=MsoNormal>On 23. 1. 2020 11:42, Gómez Martínez, Elsa wrote:<o:p></o:p></p></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><p class=MsoNormal><span style='color:#1F497D'>Hi Ivan,</span><o:p></o:p></p><p class=MsoNormal><span style='color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>I add the midPoint.log file with the error part from one simple test.</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Steps:</span><o:p></o:p></p><p class=MsoListParagraph style='text-indent:-18.0pt;mso-list:l0 level1 lfo2'><![if !supportLists]><span style='mso-list:Ignore'>1.<span style='font:7.0pt "Times New Roman"'> </span></span><![endif]><span lang=EN-US style='color:#1F497D'>Create user “alex” from MidPoint GUI</span><o:p></o:p></p><p class=MsoListParagraph style='text-indent:-18.0pt;mso-list:l0 level1 lfo2'><![if !supportLists]><span style='mso-list:Ignore'>2.<span style='font:7.0pt "Times New Roman"'> </span></span><![endif]><span lang=EN-US style='color:#1F497D'>Assign the resource </span><u><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black;background:#E8F2FE;mso-fareast-language:ES'>Localhost</span></u><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black;background:#E8F2FE;mso-fareast-language:ES'> PostgreSQL DBTable</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>020-01-23 10:59:09,806 [] [pool-3-thread-5] ERROR (com.evolveum.midpoint.web.component.progress.ProgressPanel): Error executing changes.</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>com.evolveum.midpoint.util.exception.ConfigurationException: Configuration error: For input string: "alex"</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'> at com.evolveum.midpoint.provisioning.ucf.impl.connid.ConnIdUtil.processConnIdException(ConnIdUtil.java:168)</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'> at com.evolveum.midpoint.provisioning.ucf.impl.connid.ConnIdUtil.processConnIdException(ConnIdUtil.java:94)</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'> at com.evolveum.midpoint.provisioning.ucf.impl.connid.ConnectorInstanceConnIdImpl.addObject(ConnectorInstanceConnIdImpl.java:869)</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'> at com.evolveum.midpoint.provisioning.impl.ResourceObjectConverter.addResourceObject(ResourceObjectConverter.java:266)</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'> at com.evolveum.midpoint.provisioning.impl.ShadowCache.addShadowAttempt(ShadowCache.java:554)</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'> at com.evolveum.midpoint.provisioning.impl.ShadowCache.addShadow(ShadowCache.java:496)</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'> at com.evolveum.midpoint.provisioning.impl.ProvisioningServiceImpl.addObject(ProvisioningServiceImpl.java:280)</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'> at com.evolveum.midpoint.model.impl.lens.ChangeExecutor.addProvisioningObject(ChangeExecutor.java:1580)</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'> at com.evolveum.midpoint.model.impl.lens.ChangeExecutor.executeAddition(ChangeExecutor.java:1362)</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'> at com.evolveum.midpoint.model.impl.lens.ChangeExecutor.executeDelta(ChangeExecutor.java:938)</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'> at com.evolveum.midpoint.model.impl.lens.ChangeExecutor.executeChanges(ChangeExecutor.java:326)</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'> at com.evolveum.midpoint.model.impl.lens.Clockwork.lambda$processSecondary$0(Clockwork.java:796)</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'> at com.evolveum.midpoint.model.impl.lens.ClockworkMedic.partialExecute(ClockworkMedic.java:211)</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'> at com.evolveum.midpoint.model.impl.lens.ClockworkMedic.partialExecute(ClockworkMedic.java:154)</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'> at com.evolveum.midpoint.model.impl.lens.Clockwork.processSecondary(Clockwork.java:794)</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'> at com.evolveum.midpoint.model.impl.lens.Clockwork.click(Clockwork.java:615)</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'> at com.evolveum.midpoint.model.impl.lens.Clockwork.run(Clockwork.java:200)</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'> at com.evolveum.midpoint.model.impl.controller.ModelController.executeChanges(ModelController.java:556)</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'> at com.evolveum.midpoint.web.component.progress.ProgressPanel$14.callWithContextPrepared(ProgressPanel.java:592)</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'> at com.evolveum.midpoint.web.component.progress.ProgressPanel$14.callWithContextPrepared(ProgressPanel.java:578)</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'> at com.evolveum.midpoint.web.component.SecurityContextAwareCallable.call(SecurityContextAwareCallable.java:50)</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'> at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'> at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'> at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'> at java.base/java.lang.Thread.run(Thread.java:834)</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal><span style='color:#1F497D'>Regards,</span><o:p></o:p></p><p class=MsoNormal><span style='color:#1F497D'>Elsa</span><span style='font-size:8.0pt;font-family:"Arial",sans-serif;color:#004254;mso-fareast-language:ES'> </span><o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span style='mso-fareast-language:ES'>De:</span></b><span style='mso-fareast-language:ES'> midPoint <a href="mailto:midpoint-bounces@lists.evolveum.com"><midpoint-bounces@lists.evolveum.com></a> <b>En nombre de </b>Ivan Noris<br><b>Enviado el:</b> jueves, 23 de enero de 2020 8:45<br><b>Para:</b> <a href="mailto:midpoint@lists.evolveum.com">midpoint@lists.evolveum.com</a><br><b>Asunto:</b> Re: [midPoint] Outbound mapping PostgresDB</span><o:p></o:p></p></div></div><p class=MsoNormal> <o:p></o:p></p><p>Hi Elsa,<o:p></o:p></p><p>can you please check midpoint.log? There should be something more.<o:p></o:p></p><p>Regards,<o:p></o:p></p><p>Ivan<o:p></o:p></p><div><p class=MsoNormal>On 22. 1. 2020 15:51, Gómez Martínez, Elsa wrote:<o:p></o:p></p></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><p class=MsoNormal>Hello!<o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal><span lang=EN-US>I am trying to mapping the users from MidPoint to a PostgreSQL Database but I am having the next error:</span><o:p></o:p></p><p class=MsoNormal style='margin-left:36.0pt;background:white'><b><span lang=EN-US style='font-size:10.5pt;font-family:"Helvetica",sans-serif;color:red;mso-fareast-language:ES'>Save (GUI)</span></b><span lang=EN-US style='font-size:10.5pt;font-family:"Helvetica",sans-serif;color:red;mso-fareast-language:ES'> Configuration error: For input string: "superuserTest"</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US> </span><o:p></o:p></p><table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width=0 style='width:943.2pt;background:white;border-collapse:collapse'><tr><td valign=top style='border:solid #F4F4F4 1.0pt;background:#F9F9F9;padding:3.75pt 3.75pt 3.75pt 3.75pt'><p class=MsoNormal><span lang=EN-US style='font-size:10.5pt;font-family:"Helvetica",sans-serif;color:#333333;mso-fareast-language:ES'>Account (default) on Basic PostgreSQL DBTable</span><o:p></o:p></p></td><td valign=top style='border:solid #F4F4F4 1.0pt;border-left:none;background:#F9F9F9;padding:3.75pt 3.75pt 3.75pt 3.75pt'></td><td valign=top style='border:solid #F4F4F4 1.0pt;border-left:none;background:#F9F9F9;padding:3.75pt 3.75pt 3.75pt 3.75pt'><p class=MsoNormal><span style='font-size:10.5pt;font-family:"Helvetica",sans-serif;color:#333333;mso-fareast-language:ES'>Add:Fatal error -> superuserTest</span><o:p></o:p></p></td></tr></table><p class=MsoNormal><span lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US>I am using the next git sample:</span><o:p></o:p></p><p class=MsoNormal><a href="https://github.com/Evolveum/midpoint-samples/blob/master/samples/resources/databasetable/postgresql/resource-dbtable-postgresql.xml"><span lang=EN-US>https://github.com/Evolveum/midpoint-samples/blob/master/samples/resources/databasetable/postgresql/resource-dbtable-postgresql.xml</span></a><o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal><span lang=EN-US>And this is my schema handling configuration (my username is my unique identifier):</span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'><</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>schemaHandling</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'><</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>objectType</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas'> <span style='color:#7F007F'>id</span><span style='color:black'>=</span><i><span style='color:#2A00FF'>"5"</span></i><span style='color:teal'>></span></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'><</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>displayName</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'>Default Account</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'></</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>displayName</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'><</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>default</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'>true</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'></</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>default</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'><</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>objectClass</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'>ri:AccountObjectClass</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'></</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>objectClass</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'><</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>attribute</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas'> <span style='color:#7F007F'>id</span><span style='color:black'>=</span><i><span style='color:#2A00FF'>"6"</span></i><span style='color:teal'>></span></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'><</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>c:ref</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'>icfs:uid</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'></</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>c:ref</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'><</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>displayName</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'>User ID</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'></</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>displayName</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'><</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>limitations</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'><</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>access</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'><</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>read</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'>true</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'></</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>read</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'></</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>access</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'></</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>limitations</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'></</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>attribute</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'><</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>attribute</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas'> <span style='color:#7F007F'>id</span><span style='color:black'>=</span><i><span style='color:#2A00FF'>"7"</span></i><span style='color:teal'>></span></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'><</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>c:ref</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'>icfs:name</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'></</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>c:ref</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'><</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>displayName</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'>Name</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'></</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>displayName</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'><</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>limitations</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'><</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>minOccurs</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'>0</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'></</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>minOccurs</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'><</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>access</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'><</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>read</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'>true</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'></</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>read</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'><</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>add</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'>true</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'></</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>add</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'><</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>modify</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'>true</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'></</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>modify</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'></</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>access</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'></</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>limitations</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'><</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>outbound</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'><</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>source</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'><</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>c:path</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'>$user/name</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'></</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>c:path</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'></</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>source</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'></</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>outbound</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'></</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>attribute</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'><</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>attribute</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas'> <span style='color:#7F007F'>id</span><span style='color:black'>=</span><i><span style='color:#2A00FF'>"4"</span></i><span style='color:teal'>></span></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'><</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>c:ref</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'>ri:username</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'></</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>c:ref</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'><</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>displayName</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><u><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'>Username</span></u><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'></</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>displayName</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'><</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>outbound</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'><</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>source</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'><</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>c:path</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'>$user/name</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'></</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>c:path</span><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span style='font-size:10.0pt;font-family:Consolas;color:teal'></</span><span style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>source</span><span style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span style='font-size:10.0pt;font-family:Consolas;color:teal'></</span><span style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>outbound</span><span style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><o:p></o:p></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span style='font-size:10.0pt;font-family:Consolas;color:teal'></</span><span style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>attribute</span><span style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US>And my database schema:</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal><span style='mso-fareast-language:ES'><img border=0 width=1138 height=234 style='width:11.8541in;height:2.4375in' id="Imagen_x0020_3" src="cid:image001.png@01D5D1EE.83EA7520"></span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US>One example user:</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal><span style='mso-fareast-language:ES'><img border=0 width=1262 height=256 style='width:13.1458in;height:2.6666in' id="Imagen_x0020_4" src="cid:image002.png@01D5D1EE.83EA7520"></span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US>Could anyone help me?</span><o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal>Thanks a lot!<o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width=0 style='width:240.0pt'><tr><td width=320 style='width:240.0pt;padding:0cm 0cm 0cm 0cm'><p class=MsoNormal><a href="http://www.minsait.com/" target="_blank" title=Minsait><span style='font-size:12.0pt;text-decoration:none'><img border=0 width=301 height=48 style='width:3.1354in;height:.5in' id="Imagen_x0020_1" src="cid:image003.png@01D5D1EE.83EA7520" alt=minsait></span></a><o:p></o:p></p><table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width=0 style='width:240.0pt;border-collapse:collapse'><tr><td valign=top style='padding:0cm 0cm 0cm 0cm'><p class=MsoNormal style='line-height:18.75pt'><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:#0A0A0A;mso-fareast-language:ES'> </span><o:p></o:p></p></td></tr></table><p class=MsoNormal style='line-height:10.5pt'><span style='font-size:10.0pt;font-family:"Georgia",serif;color:#004254;mso-fareast-language:ES'>Elsa Gómez Martínez</span><o:p></o:p></p><table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width=0 style='width:240.0pt;border-collapse:collapse'><tr><td valign=top style='padding:0cm 0cm 0cm 0cm'></td></tr></table><p class=MsoNormal style='line-height:10.5pt'><span style='font-size:9.0pt;font-family:"Arial",sans-serif;color:#999999;mso-fareast-language:ES'>Ciberseguridad</span><o:p></o:p></p></td></tr></table><p class=MsoNormal><span style='font-size:8.0pt;font-family:"Arial",sans-serif;mso-fareast-language:ES'> </span><o:p></o:p></p><p class=MsoNormal><span style='font-size:9.0pt;font-family:"Arial",sans-serif;color:#004254;mso-fareast-language:ES'>Espacio Virtual: </span><o:p></o:p></p><p class=MsoNormal><span style='font-size:8.0pt;font-family:"Arial",sans-serif;color:#999999;border:none windowtext 1.0pt;padding:0cm;background:white;mso-fareast-language:ES'><a href="https://join.indra.es/"><span style='color:#999999'>https://join.indra.es</span></a></span><o:p></o:p></p><p class=MsoNormal><span style='font-size:8.0pt;font-family:"Arial",sans-serif;color:#004254;mso-fareast-language:ES'><a href="mailto:egomezm@cms.indra.es"><span style='color:#004254'>egomezm@cms.indra.es</span></a> </span><o:p></o:p></p><p class=MsoNormal><span style='font-size:8.0pt;font-family:"Arial",sans-serif;color:#004254;mso-fareast-language:ES'>ID: 269068</span><o:p></o:p></p><p class=MsoNormal><a href="https://apps.indraweb.net/mates?utm_source=Notificacion-Mates&utm_medium=email&utm_content=Firma&utm_campaign=Firma-interna&recognise-direct=egomezm"><span style='font-size:10.5pt;font-family:"Arial",sans-serif;color:#1A3B47;mso-fareast-language:ES;text-decoration:none'><img border=0 width=140 height=44 style='width:1.4583in;height:.4583in' id="Imagen_x0020_2" src="cid:image004.png@01D5D1EE.83EA7520" alt="https://emailingindra.indra.es/archivos/1/12316_mates-firma-interna.png"></span></a><o:p></o:p></p><p class=MsoNormal><span style='font-size:8.0pt;font-family:"Arial",sans-serif;color:#004254;mso-fareast-language:ES'> </span><o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:12.0pt'><br><br><br></span><o:p></o:p></p><pre>_______________________________________________<o:p></o:p></pre><pre>midPoint mailing list<o:p></o:p></pre><pre><a href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a><o:p></o:p></pre><pre><a href="http://lists.evolveum.com/mailman/listinfo/midpoint">http://lists.evolveum.com/mailman/listinfo/midpoint</a><o:p></o:p></pre></blockquote><pre>-- <o:p></o:p></pre><pre>Ivan Noris<o:p></o:p></pre><pre>Senior Identity Engineer<o:p></o:p></pre><pre>evolveum.com<o:p></o:p></pre><p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:12.0pt'> </span><o:p></o:p></p><pre>_______________________________________________<o:p></o:p></pre><pre>midPoint mailing list<o:p></o:p></pre><pre><a href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a><o:p></o:p></pre><pre><a href="http://lists.evolveum.com/mailman/listinfo/midpoint">http://lists.evolveum.com/mailman/listinfo/midpoint</a><o:p></o:p></pre></blockquote><pre>-- <o:p></o:p></pre><pre>Ivan Noris<o:p></o:p></pre><pre>Senior Identity Engineer<o:p></o:p></pre><pre>evolveum.com<o:p></o:p></pre><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;mso-fareast-language:ES'><br><br><o:p></o:p></span></p><pre>_______________________________________________<o:p></o:p></pre><pre>midPoint mailing list<o:p></o:p></pre><pre><a href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a><o:p></o:p></pre><pre><a href="http://lists.evolveum.com/mailman/listinfo/midpoint">http://lists.evolveum.com/mailman/listinfo/midpoint</a><o:p></o:p></pre></blockquote><pre>-- <o:p></o:p></pre><pre>Ivan Noris<o:p></o:p></pre><pre>Senior Identity Engineer<o:p></o:p></pre><pre>evolveum.com<o:p></o:p></pre></div></body></html>