<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi Elsa,</p>
<p>my thoughts:</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.<br>
</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)<br>
</p>
<p>3. you need to only use icfs:name in the schema handling. Do not
use ri:username mapping.</p>
<p>That should help.</p>
<p>If you need two identifiers, you have two options:</p>
<p>a) use ScriptedSQL connector, or</p>
<p>b) endorse <a class="moz-txt-link-freetext" href="https://jira.evolveum.com/browse/MID-2265">https://jira.evolveum.com/browse/MID-2265</a>
(DatabaseTable connector rewrite) using your/your client
subscription.</p>
<p>Best regards,</p>
<p>Ivan<br>
</p>
<div class="moz-cite-prefix">On 23. 1. 2020 12:19, Gómez Martínez,
Elsa wrote:<br>
</div>
<blockquote type="cite"
cite="mid:VI1P193MB0285416A0F7240A25048FE02A20F0@VI1P193MB0285.EURP193.PROD.OUTLOOK.COM">
<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;}
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;}
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.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-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]-->
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-US">Sorry, I forgot to
attach the file.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Elsa<o:p></o:p></span></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 class="moz-txt-link-rfc2396E" href="mailto:midpoint@lists.evolveum.com"><midpoint@lists.evolveum.com></a><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 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>
<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<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black;mso-fareast-language:ES"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES"
lang="EN-US"><</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F;mso-fareast-language:ES"
lang="EN-US">xsd:element</span><span
style="font-size:10.0pt;font-family:Consolas;mso-fareast-language:ES"
lang="EN-US"> <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><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black;mso-fareast-language:ES"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES"
lang="EN-US"><</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F;mso-fareast-language:ES"
lang="EN-US">xsd:annotation</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES"
lang="EN-US">></span><span
style="font-size:10.0pt;font-family:Consolas;mso-fareast-language:ES"
lang="EN-US"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black;mso-fareast-language:ES"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES"
lang="EN-US"><</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F;mso-fareast-language:ES"
lang="EN-US">xsd:appinfo</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES"
lang="EN-US">></span><span
style="font-size:10.0pt;font-family:Consolas;mso-fareast-language:ES"
lang="EN-US"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black;mso-fareast-language:ES"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES"
lang="EN-US"><</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F;mso-fareast-language:ES"
lang="EN-US">a:displayOrder</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES"
lang="EN-US">></span><span
style="font-size:10.0pt;font-family:Consolas;color:black;mso-fareast-language:ES"
lang="EN-US">130</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES"
lang="EN-US"></</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F;mso-fareast-language:ES"
lang="EN-US">a:displayOrder</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES"
lang="EN-US">></span><span
style="font-size:10.0pt;font-family:Consolas;mso-fareast-language:ES"
lang="EN-US"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black;mso-fareast-language:ES"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES"
lang="EN-US"><</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F;mso-fareast-language:ES"
lang="EN-US">ra:frameworkAttributeName</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES"
lang="EN-US">></span><u><span
style="font-size:10.0pt;font-family:Consolas;color:black;mso-fareast-language:ES"
lang="EN-US">username</span></u><span
style="font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES"
lang="EN-US"></</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F;mso-fareast-language:ES"
lang="EN-US">ra:frameworkAttributeName</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES"
lang="EN-US">></span><span
style="font-size:10.0pt;font-family:Consolas;mso-fareast-language:ES"
lang="EN-US"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black;mso-fareast-language:ES"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES"
lang="EN-US"></</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F;mso-fareast-language:ES"
lang="EN-US">xsd:appinfo</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES"
lang="EN-US">></span><span
style="font-size:10.0pt;font-family:Consolas;mso-fareast-language:ES"
lang="EN-US"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black;mso-fareast-language:ES"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES"
lang="EN-US"></</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F;mso-fareast-language:ES"
lang="EN-US">xsd:annotation</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES"
lang="EN-US">></span><span
style="font-size:10.0pt;font-family:Consolas;mso-fareast-language:ES"
lang="EN-US"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black;mso-fareast-language:ES"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES"
lang="EN-US"></</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F;mso-fareast-language:ES"
lang="EN-US">xsd:element</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES"
lang="EN-US">></span><span
style="font-size:10.0pt;font-family:Consolas;mso-fareast-language:ES"
lang="EN-US"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black;mso-fareast-language:ES"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES"
lang="EN-US"><</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F;mso-fareast-language:ES"
lang="EN-US">xsd:element</span><span
style="font-size:10.0pt;font-family:Consolas;mso-fareast-language:ES"
lang="EN-US"> <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><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black;mso-fareast-language:ES"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES"
lang="EN-US"><</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F;mso-fareast-language:ES"
lang="EN-US">xsd:annotation</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES"
lang="EN-US">></span><span
style="font-size:10.0pt;font-family:Consolas;mso-fareast-language:ES"
lang="EN-US"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black;mso-fareast-language:ES"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES"
lang="EN-US"><</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F;mso-fareast-language:ES"
lang="EN-US">xsd:appinfo</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES"
lang="EN-US">></span><span
style="font-size:10.0pt;font-family:Consolas;mso-fareast-language:ES"
lang="EN-US"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black;mso-fareast-language:ES"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES"
lang="EN-US"><</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F;mso-fareast-language:ES"
lang="EN-US">a:displayName</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES"
lang="EN-US">></span><span
style="font-size:10.0pt;font-family:Consolas;color:black;mso-fareast-language:ES"
lang="EN-US">ConnId Name</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES"
lang="EN-US"></</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F;mso-fareast-language:ES"
lang="EN-US">a:displayName</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES"
lang="EN-US">></span><span
style="font-size:10.0pt;font-family:Consolas;mso-fareast-language:ES"
lang="EN-US"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black;mso-fareast-language:ES"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES"
lang="EN-US"><</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F;mso-fareast-language:ES"
lang="EN-US">a:displayOrder</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES"
lang="EN-US">></span><span
style="font-size:10.0pt;font-family:Consolas;color:black;mso-fareast-language:ES"
lang="EN-US">110</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES"
lang="EN-US"></</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F;mso-fareast-language:ES"
lang="EN-US">a:displayOrder</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES"
lang="EN-US">></span><span
style="font-size:10.0pt;font-family:Consolas;mso-fareast-language:ES"
lang="EN-US"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black;mso-fareast-language:ES"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES"
lang="EN-US"><</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F;mso-fareast-language:ES"
lang="EN-US">ra:frameworkAttributeName</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES"
lang="EN-US">></span><span
style="font-size:10.0pt;font-family:Consolas;color:black;mso-fareast-language:ES"
lang="EN-US">__NAME__</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES"
lang="EN-US"></</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F;mso-fareast-language:ES"
lang="EN-US">ra:frameworkAttributeName</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES"
lang="EN-US">></span><span
style="font-size:10.0pt;font-family:Consolas;mso-fareast-language:ES"
lang="EN-US"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black;mso-fareast-language:ES"
lang="EN-US"> </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><span
style="font-size:10.0pt;font-family:Consolas;mso-fareast-language:ES"><o:p></o:p></span></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><span
style="font-size:10.0pt;font-family:Consolas;mso-fareast-language:ES"><o:p></o:p></span></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">><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:Consolas;color:teal;mso-fareast-language:ES"><o:p> </o:p></span></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.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Regards,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Elsa<o:p></o:p></span></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"
moz-do-not-send="true">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"
moz-do-not-send="true">midpoint@lists.evolveum.com</a><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>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 style="color:#1F497D" lang="EN-US">I
add the midPoint.log file with the error part from one
simple test.</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US">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
style="color:#1F497D" lang="EN-US">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
style="color:#1F497D" lang="EN-US">Assign the resource </span><u><span
style="font-size:10.0pt;font-family:Consolas;color:black;background:#E8F2FE;mso-fareast-language:ES"
lang="EN-US">Localhost</span></u><span
style="font-size:10.0pt;font-family:Consolas;color:black;background:#E8F2FE;mso-fareast-language:ES"
lang="EN-US"> PostgreSQL DBTable</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US">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 style="color:#1F497D" lang="EN-US">com.evolveum.midpoint.util.exception.ConfigurationException:
Configuration error: For input string: "alex"</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US">
at
com.evolveum.midpoint.provisioning.ucf.impl.connid.ConnIdUtil.processConnIdException(ConnIdUtil.java:168)</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US">
at
com.evolveum.midpoint.provisioning.ucf.impl.connid.ConnIdUtil.processConnIdException(ConnIdUtil.java:94)</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US">
at
com.evolveum.midpoint.provisioning.ucf.impl.connid.ConnectorInstanceConnIdImpl.addObject(ConnectorInstanceConnIdImpl.java:869)</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US">
at
com.evolveum.midpoint.provisioning.impl.ResourceObjectConverter.addResourceObject(ResourceObjectConverter.java:266)</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US">
at
com.evolveum.midpoint.provisioning.impl.ShadowCache.addShadowAttempt(ShadowCache.java:554)</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US">
at
com.evolveum.midpoint.provisioning.impl.ShadowCache.addShadow(ShadowCache.java:496)</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US">
at
com.evolveum.midpoint.provisioning.impl.ProvisioningServiceImpl.addObject(ProvisioningServiceImpl.java:280)</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US">
at
com.evolveum.midpoint.model.impl.lens.ChangeExecutor.addProvisioningObject(ChangeExecutor.java:1580)</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US">
at
com.evolveum.midpoint.model.impl.lens.ChangeExecutor.executeAddition(ChangeExecutor.java:1362)</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US">
at
com.evolveum.midpoint.model.impl.lens.ChangeExecutor.executeDelta(ChangeExecutor.java:938)</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US">
at
com.evolveum.midpoint.model.impl.lens.ChangeExecutor.executeChanges(ChangeExecutor.java:326)</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US">
at
com.evolveum.midpoint.model.impl.lens.Clockwork.lambda$processSecondary$0(Clockwork.java:796)</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US">
at
com.evolveum.midpoint.model.impl.lens.ClockworkMedic.partialExecute(ClockworkMedic.java:211)</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US">
at
com.evolveum.midpoint.model.impl.lens.ClockworkMedic.partialExecute(ClockworkMedic.java:154)</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US">
at
com.evolveum.midpoint.model.impl.lens.Clockwork.processSecondary(Clockwork.java:794)</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US">
at
com.evolveum.midpoint.model.impl.lens.Clockwork.click(Clockwork.java:615)</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US">
at
com.evolveum.midpoint.model.impl.lens.Clockwork.run(Clockwork.java:200)</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US">
at
com.evolveum.midpoint.model.impl.controller.ModelController.executeChanges(ModelController.java:556)</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US">
at
com.evolveum.midpoint.web.component.progress.ProgressPanel$14.callWithContextPrepared(ProgressPanel.java:592)</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US">
at
com.evolveum.midpoint.web.component.progress.ProgressPanel$14.callWithContextPrepared(ProgressPanel.java:578)</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US">
at
com.evolveum.midpoint.web.component.SecurityContextAwareCallable.call(SecurityContextAwareCallable.java:50)</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US">
at
java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US">
at
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US">
at
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US">
at java.base/java.lang.Thread.run(Thread.java:834)</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US"> </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"
moz-do-not-send="true"><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"
moz-do-not-send="true">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
style="font-size:10.5pt;font-family:"Helvetica",sans-serif;color:red;mso-fareast-language:ES"
lang="EN-US">Save (GUI)</span></b><span
style="font-size:10.5pt;font-family:"Helvetica",sans-serif;color:red;mso-fareast-language:ES"
lang="EN-US"> 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"
style="width:943.2pt;background:white;border-collapse:collapse"
width="0" cellspacing="0" cellpadding="0" border="0">
<tbody>
<tr>
<td style="border:solid #F4F4F4
1.0pt;background:#F9F9F9;padding:3.75pt 3.75pt
3.75pt 3.75pt" valign="top">
<p class="MsoNormal"><span
style="font-size:10.5pt;font-family:"Helvetica",sans-serif;color:#333333;mso-fareast-language:ES"
lang="EN-US">Account (default) on Basic
PostgreSQL DBTable</span><o:p></o:p></p>
</td>
<td style="border:solid #F4F4F4
1.0pt;border-left:none;background:#F9F9F9;padding:3.75pt
3.75pt 3.75pt 3.75pt" valign="top"><br>
</td>
<td style="border:solid #F4F4F4
1.0pt;border-left:none;background:#F9F9F9;padding:3.75pt
3.75pt 3.75pt 3.75pt" valign="top">
<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>
</tbody>
</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"
moz-do-not-send="true"><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
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"><</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">schemaHandling</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><o:p></o:p></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"><</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">objectType</span><span
style="font-size:10.0pt;font-family:Consolas"
lang="EN-US"> <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
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"><</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">displayName</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US">Default Account</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"></</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">displayName</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><o:p></o:p></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"><</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">default</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US">true</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"></</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">default</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><o:p></o:p></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"><</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">objectClass</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US">ri:AccountObjectClass</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"></</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">objectClass</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><o:p></o:p></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"><</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">attribute</span><span
style="font-size:10.0pt;font-family:Consolas"
lang="EN-US"> <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
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"><</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">c:ref</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US">icfs:uid</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"></</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">c:ref</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><o:p></o:p></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"><</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">displayName</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US">User ID</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"></</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">displayName</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><o:p></o:p></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"><</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">limitations</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><o:p></o:p></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"><</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">access</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><o:p></o:p></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"><</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">read</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US">true</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"></</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">read</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><o:p></o:p></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"></</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">access</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><o:p></o:p></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"></</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">limitations</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><o:p></o:p></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"></</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">attribute</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><o:p></o:p></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"><</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">attribute</span><span
style="font-size:10.0pt;font-family:Consolas"
lang="EN-US"> <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
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"><</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">c:ref</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US">icfs:name</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"></</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">c:ref</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><o:p></o:p></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"><</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">displayName</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US">Name</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"></</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">displayName</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><o:p></o:p></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"><</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">limitations</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><o:p></o:p></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"><</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">minOccurs</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US">0</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"></</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">minOccurs</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><o:p></o:p></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"><</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">access</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><o:p></o:p></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"><</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">read</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US">true</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"></</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">read</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><o:p></o:p></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"><</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">add</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US">true</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"></</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">add</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><o:p></o:p></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"><</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">modify</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US">true</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"></</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">modify</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><o:p></o:p></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"></</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">access</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><o:p></o:p></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"></</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">limitations</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><o:p></o:p></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"><</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">outbound</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><o:p></o:p></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"><</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">source</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><o:p></o:p></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"><</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">c:path</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US">$user/name</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"></</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">c:path</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><o:p></o:p></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"></</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">source</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><o:p></o:p></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"></</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">outbound</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><o:p></o:p></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"></</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">attribute</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><o:p></o:p></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"><</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">attribute</span><span
style="font-size:10.0pt;font-family:Consolas"
lang="EN-US"> <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
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"><</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">c:ref</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US">ri:username</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"></</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">c:ref</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><o:p></o:p></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"><</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">displayName</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><u><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US">Username</span></u><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"></</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">displayName</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><o:p></o:p></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"><</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">outbound</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><o:p></o:p></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"><</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">source</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><o:p></o:p></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"><</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">c:path</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US">$user/name</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US"></</span><span
style="font-size:10.0pt;font-family:Consolas;color:#3F7F7F"
lang="EN-US">c:path</span><span
style="font-size:10.0pt;font-family:Consolas;color:teal"
lang="EN-US">></span><o:p></o:p></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:Consolas;color:black"
lang="EN-US"> </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
style="width:11.8541in;height:2.4375in"
id="Imagen_x0020_3"
src="cid:part6.1D106226.FDE7BEF2@evolveum.com"
class="" width="1138" height="234" border="0"></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
style="width:13.1458in;height:2.6666in"
id="Imagen_x0020_4"
src="cid:part7.DAE45578.A4EA6F2C@evolveum.com"
class="" width="1262" height="256" border="0"></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" style="width:240.0pt"
width="0" cellspacing="0" cellpadding="0" border="0">
<tbody>
<tr>
<td style="width:240.0pt;padding:0cm 0cm 0cm 0cm"
width="320">
<p class="MsoNormal"><a
href="http://www.minsait.com/" target="_blank"
title="Minsait" moz-do-not-send="true"><span
style="font-size:12.0pt;text-decoration:none"><img
style="width:3.1354in;height:.5in"
id="Imagen_x0020_1"
src="cid:part8.5A782F80.6DBA4D3F@evolveum.com"
alt="minsait" class="" width="301"
height="48" border="0"></span></a><o:p></o:p></p>
<table class="MsoNormalTable"
style="width:240.0pt;border-collapse:collapse"
width="0" cellspacing="0" cellpadding="0"
border="0">
<tbody>
<tr>
<td style="padding:0cm 0cm 0cm 0cm"
valign="top">
<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>
</tbody>
</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"
style="width:240.0pt;border-collapse:collapse"
width="0" cellspacing="0" cellpadding="0"
border="0">
<tbody>
<tr>
<td style="padding:0cm 0cm 0cm 0cm"
valign="top"><br>
</td>
</tr>
</tbody>
</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>
</tbody>
</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/" moz-do-not-send="true"><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"
moz-do-not-send="true"><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"
moz-do-not-send="true"><span
style="font-size:10.5pt;font-family:"Arial",sans-serif;color:#1A3B47;mso-fareast-language:ES;text-decoration:none"><img
style="width:1.4583in;height:.4583in"
id="Imagen_x0020_2"
src="cid:part12.07488FCC.C2E2B1C9@evolveum.com"
alt="https://emailingindra.indra.es/archivos/1/12316_mates-firma-interna.png"
class="" width="140" height="44" border="0"></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>
</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" moz-do-not-send="true">midPoint@lists.evolveum.com</a><o:p></o:p></pre>
<pre><a href="http://lists.evolveum.com/mailman/listinfo/midpoint" moz-do-not-send="true">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;font-family:"Times New
Roman",serif;mso-fareast-language:ES"><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" moz-do-not-send="true">midPoint@lists.evolveum.com</a><o:p></o:p></pre>
<pre><a href="http://lists.evolveum.com/mailman/listinfo/midpoint" moz-do-not-send="true">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>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
midPoint mailing list
<a class="moz-txt-link-abbreviated" href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a>
<a class="moz-txt-link-freetext" href="http://lists.evolveum.com/mailman/listinfo/midpoint">http://lists.evolveum.com/mailman/listinfo/midpoint</a>
</pre>
</blockquote>
<pre class="moz-signature" cols="72">--
Ivan Noris
Senior Identity Engineer
evolveum.com
</pre>
</body>
</html>