<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">Hi,<br>
<br>
One way or another, lookup table is supposed to work for integer
properties. If it does not then it is a bug. Please report the bug
in jira, we will have a look.<br>
<br>
<pre class="moz-signature" cols="72">--
Radovan Semancik
Software Architect
evolveum.com</pre>
<br>
<br>
On 8/23/19 9:52 AM, Ivan Noris wrote:<br>
</div>
<blockquote type="cite"
cite="mid:8457664e-f578-d465-44b0-d51da537264b@evolveum.com">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<p>Hi Chris,</p>
<p>I tried to replicate. And have a different error.</p>
<p>I created extension xsd:int, created a lookup table, attached
to <item> in object template.</p>
<p>The lookup values are displayed, but attempt to save end with:</p>
<p>2019-08-23 09:45:12,956 [] [pool-3-thread-1] ERROR
(com.evolveum.midpoint.web.component.progress.ProgressPanel):
Error executing changes.<br>
com.evolveum.midpoint.util.exception.SystemException: Can't
extract value for saving from prism property value PPV(String:1)
expected return type class java.lang.Long, actua<br>
l type class java.lang.String<br>
at
com.evolveum.midpoint.repo.sql.helpers.BaseHelper.handleGeneralRuntimeException(BaseHelper.java:173)<br>
at
com.evolveum.midpoint.repo.sql.helpers.BaseHelper.handleGeneralException(BaseHelper.java:153)<br>
at
com.evolveum.midpoint.repo.sql.helpers.ObjectUpdater.modifyObjectAttempt(ObjectUpdater.java:528)<br>
at
com.evolveum.midpoint.repo.sql.SqlRepositoryServiceImpl.modifyObject(SqlRepositoryServiceImpl.java:640)<br>
at
com.evolveum.midpoint.repo.cache.RepositoryCache.modifyObject(RepositoryCache.java:1069)<br>
at
com.evolveum.midpoint.model.impl.lens.ChangeExecutor.executeModification(ChangeExecutor.java:1539)<br>
at
com.evolveum.midpoint.model.impl.lens.ChangeExecutor.executeDelta(ChangeExecutor.java:954)<br>
at
com.evolveum.midpoint.model.impl.lens.ChangeExecutor.executeChanges(ChangeExecutor.java:201)<br>
at
com.evolveum.midpoint.model.impl.lens.Clockwork.lambda$processSecondary$0(Clockwork.java:801)<br>
at
com.evolveum.midpoint.model.impl.lens.ClockworkMedic.partialExecute(ClockworkMedic.java:217)<br>
at
com.evolveum.midpoint.model.impl.lens.ClockworkMedic.partialExecute(ClockworkMedic.java:163)<br>
at
com.evolveum.midpoint.model.impl.lens.Clockwork.processSecondary(Clockwork.java:799)<br>
at
com.evolveum.midpoint.model.impl.lens.Clockwork.click(Clockwork.java:623)<br>
at
com.evolveum.midpoint.model.impl.lens.Clockwork.run(Clockwork.java:209)<br>
at
com.evolveum.midpoint.model.impl.controller.ModelController.executeChanges(ModelController.java:565)<br>
at
com.evolveum.midpoint.web.component.progress.ProgressPanel$14.callWithContextPrepared(ProgressPanel.java:601)<br>
at
com.evolveum.midpoint.web.component.progress.ProgressPanel$14.callWithContextPrepared(ProgressPanel.java:587)<br>
at
com.evolveum.midpoint.web.component.SecurityContextAwareCallable.call(SecurityContextAwareCallable.java:59)<br>
at
java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)<br>
at
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)<br>
at
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)<br>
at java.base/java.lang.Thread.run(Thread.java:834)<br>
</p>
<p>(no 500 internal server error though. This is master on Java
11)</p>
<p>So it looks that midPoint is not correctly assuming integer
(long??) vs. string...</p>
<p>I remember earlier issue: <a class="moz-txt-link-freetext"
href="https://jira.evolveum.com/browse/MID-4506"
moz-do-not-send="true">https://jira.evolveum.com/browse/MID-4506</a>,
but that one was checked (by me) to work in March... Maybe a
regression.<br>
</p>
<p>Please create a JIRA issue for your case if you need to use
integer lookup table values; and I will attach this also there.</p>
<p>Best regards,</p>
<p>Ivan<br>
</p>
<div class="moz-cite-prefix">On 21. 8. 2019 15:13, Chris Woods
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:9b9c1168538f47b895000bd77efa9e85@rohde-schwarz.com">
<meta http-equiv="Content-Type" content="text/html;
charset=UTF-8">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:"Arial Unicode MS";
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:"Arial Black";
panose-1:2 11 10 4 2 1 2 2 2 4;}
@font-face
{font-family:"\@Arial Unicode MS";
panose-1:2 11 6 4 2 2 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin-top:0cm;
margin-right:0cm;
margin-bottom:6.0pt;
margin-left:0cm;
line-height:112%;
font-size:10.0pt;
font-family:"Arial",sans-serif;
mso-fareast-language:EN-US;}
h1
{mso-style-priority:12;
mso-style-link:"\00DCberschrift 1 Zchn";
margin-top:18.0pt;
margin-right:0cm;
margin-bottom:6.0pt;
margin-left:21.25pt;
mso-add-space:auto;
text-indent:-21.25pt;
line-height:112%;
page-break-after:avoid;
mso-list:l2 level1 lfo2;
font-size:20.0pt;
font-family:"Arial Narrow",sans-serif;
color:#009DEC;
mso-fareast-language:EN-US;
font-weight:normal;}
h1.CxSpFirst
{mso-style-priority:12;
mso-style-link:"\00DCberschrift 1 Zchn";
mso-style-type:export-only;
margin-top:18.0pt;
margin-right:0cm;
margin-bottom:0cm;
margin-left:21.25pt;
margin-bottom:.0001pt;
mso-add-space:auto;
text-indent:-21.25pt;
line-height:112%;
page-break-after:avoid;
mso-list:l2 level1 lfo2;
font-size:20.0pt;
font-family:"Arial Narrow",sans-serif;
color:#009DEC;
mso-fareast-language:EN-US;
font-weight:normal;}
h1.CxSpMiddle
{mso-style-priority:12;
mso-style-link:"\00DCberschrift 1 Zchn";
mso-style-type:export-only;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:21.25pt;
margin-bottom:.0001pt;
mso-add-space:auto;
text-indent:-21.25pt;
line-height:112%;
page-break-after:avoid;
mso-list:l2 level1 lfo2;
font-size:20.0pt;
font-family:"Arial Narrow",sans-serif;
color:#009DEC;
mso-fareast-language:EN-US;
font-weight:normal;}
h1.CxSpLast
{mso-style-priority:12;
mso-style-link:"\00DCberschrift 1 Zchn";
mso-style-type:export-only;
margin-top:0cm;
margin-right:0cm;
margin-bottom:6.0pt;
margin-left:21.25pt;
mso-add-space:auto;
text-indent:-21.25pt;
line-height:112%;
page-break-after:avoid;
mso-list:l2 level1 lfo2;
font-size:20.0pt;
font-family:"Arial Narrow",sans-serif;
color:#009DEC;
mso-fareast-language:EN-US;
font-weight:normal;}
p.MsoListBullet, li.MsoListBullet, div.MsoListBullet
{mso-style-priority:17;
margin-top:0cm;
margin-right:0cm;
margin-bottom:6.0pt;
margin-left:21.25pt;
text-indent:-21.25pt;
line-height:112%;
mso-list:l1 level1 lfo4;
font-size:10.0pt;
font-family:"Arial",sans-serif;
mso-fareast-language:EN-US;}
p.MsoTitle, li.MsoTitle, div.MsoTitle
{mso-style-priority:10;
mso-style-link:"Titel Zchn";
margin-top:18.0pt;
margin-right:102.05pt;
margin-bottom:6.0pt;
margin-left:0cm;
mso-add-space:auto;
line-height:112%;
font-size:26.0pt;
font-family:"Arial Narrow",sans-serif;
color:#009DEC;
mso-fareast-language:EN-US;}
p.MsoTitleCxSpFirst, li.MsoTitleCxSpFirst, div.MsoTitleCxSpFirst
{mso-style-priority:10;
mso-style-link:"Titel Zchn";
mso-style-type:export-only;
margin-top:18.0pt;
margin-right:102.05pt;
margin-bottom:0cm;
margin-left:0cm;
margin-bottom:.0001pt;
mso-add-space:auto;
line-height:112%;
font-size:26.0pt;
font-family:"Arial Narrow",sans-serif;
color:#009DEC;
mso-fareast-language:EN-US;}
p.MsoTitleCxSpMiddle, li.MsoTitleCxSpMiddle, div.MsoTitleCxSpMiddle
{mso-style-priority:10;
mso-style-link:"Titel Zchn";
mso-style-type:export-only;
margin-top:0cm;
margin-right:102.05pt;
margin-bottom:0cm;
margin-left:0cm;
margin-bottom:.0001pt;
mso-add-space:auto;
line-height:112%;
font-size:26.0pt;
font-family:"Arial Narrow",sans-serif;
color:#009DEC;
mso-fareast-language:EN-US;}
p.MsoTitleCxSpLast, li.MsoTitleCxSpLast, div.MsoTitleCxSpLast
{mso-style-priority:10;
mso-style-link:"Titel Zchn";
mso-style-type:export-only;
margin-top:0cm;
margin-right:102.05pt;
margin-bottom:6.0pt;
margin-left:0cm;
mso-add-space:auto;
line-height:112%;
font-size:26.0pt;
font-family:"Arial Narrow",sans-serif;
color:#009DEC;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#009DEC;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#933973;
text-decoration:underline;}
span.berschrift1Zchn
{mso-style-name:"\00DCberschrift 1 Zchn";
mso-style-priority:12;
mso-style-link:"\00DCberschrift 1";
font-family:"Arial Narrow",sans-serif;
color:#009DEC;}
span.TitelZchn
{mso-style-name:"Titel Zchn";
mso-style-priority:10;
mso-style-link:Titel;
font-family:"Arial Narrow",sans-serif;
color:#009DEC;}
span.E-MailFormatvorlage21
{mso-style-type:personal-compose;
font-family:"Arial",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
font-family:"Arial",sans-serif;
mso-fareast-language:EN-US;}
.MsoPapDefault
{mso-style-type:export-only;
margin-bottom:6.0pt;
line-height:112%;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:-119;
mso-list-type:simple;
mso-list-template-ids:-460561208;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:18.0pt;
mso-level-number-position:left;
margin-left:18.0pt;
text-indent:-18.0pt;
font-family:Symbol;}
@list l1
{mso-list-id:610864188;
mso-list-template-ids:-1039730736;}
@list l1:level1
{mso-level-number-format:bullet;
mso-level-style-link:Aufz\00E4hlungszeichen;
mso-level-text:\0131;
mso-level-tab-stop:21.25pt;
mso-level-number-position:left;
margin-left:21.25pt;
text-indent:-21.25pt;
mso-ansi-font-size:9.0pt;
mso-bidi-font-size:9.0pt;
mso-ascii-font-family:"Arial Black";
mso-hansi-font-family:"Arial Black";
mso-bidi-font-family:"Arial Black";}
@list l1:level2
{mso-level-number-format:bullet;
mso-level-text:\25AA;
mso-level-tab-stop:42.55pt;
mso-level-number-position:left;
margin-left:42.5pt;
text-indent:-21.25pt;
mso-ansi-font-size:9.0pt;
mso-bidi-font-size:9.0pt;
font-family:"Arial",sans-serif;}
@list l1:level3
{mso-level-number-format:bullet;
mso-level-text:\25AA;
mso-level-tab-stop:63.8pt;
mso-level-number-position:left;
margin-left:63.75pt;
text-indent:-21.25pt;
mso-ansi-font-size:9.0pt;
mso-bidi-font-size:9.0pt;
font-family:"Arial",sans-serif;}
@list l1:level4
{mso-level-number-format:bullet;
mso-level-text:\25AA;
mso-level-tab-stop:3.0cm;
mso-level-number-position:left;
margin-left:85.0pt;
text-indent:-21.25pt;
mso-ansi-font-size:9.0pt;
mso-bidi-font-size:9.0pt;
font-family:"Arial",sans-serif;}
@list l1:level5
{mso-level-number-format:bullet;
mso-level-text:\25AA;
mso-level-tab-stop:106.3pt;
mso-level-number-position:left;
margin-left:106.25pt;
text-indent:-21.25pt;
mso-ansi-font-size:9.0pt;
font-family:"Arial",sans-serif;}
@list l1:level6
{mso-level-number-format:bullet;
mso-level-text:\25AA;
mso-level-tab-stop:127.6pt;
mso-level-number-position:left;
margin-left:127.5pt;
text-indent:-21.25pt;
mso-ansi-font-size:9.0pt;
mso-bidi-font-size:9.0pt;
font-family:"Arial",sans-serif;}
@list l1:level7
{mso-level-number-format:bullet;
mso-level-text:\25AA;
mso-level-tab-stop:148.85pt;
mso-level-number-position:left;
margin-left:148.75pt;
text-indent:-21.25pt;
mso-ansi-font-size:9.0pt;
font-family:"Arial",sans-serif;}
@list l1:level8
{mso-level-number-format:bullet;
mso-level-text:\25AA;
mso-level-tab-stop:6.0cm;
mso-level-number-position:left;
margin-left:170.0pt;
text-indent:-21.25pt;
mso-ansi-font-size:9.0pt;
mso-bidi-font-size:9.0pt;
font-family:"Arial",sans-serif;}
@list l1:level9
{mso-level-number-format:bullet;
mso-level-text:\25AA;
mso-level-tab-stop:191.35pt;
mso-level-number-position:left;
margin-left:191.25pt;
text-indent:-21.25pt;
mso-ansi-font-size:9.0pt;
mso-bidi-font-size:9.0pt;
mso-ascii-font-family:Arial;
mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial;}
@list l2
{mso-list-id:628360796;
mso-list-template-ids:-1252723272;}
@list l2:level1
{mso-level-style-link:"\00DCberschrift 1";
mso-level-text:%1;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:21.25pt;
text-indent:-21.25pt;}
@list l2:level2
{mso-level-text:"%1\.%2";
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:29.75pt;
text-indent:-29.75pt;}
@list l2:level3
{mso-level-text:"%1\.%2\.%3";
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:38.25pt;
text-indent:-38.25pt;}
@list l2:level4
{mso-level-text:"%1\.%2\.%3\.%4";
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:46.8pt;
text-indent:-46.8pt;}
@list l2:level5
{mso-level-text:"%1\.%2\.%3\.%4\.%5";
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:55.3pt;
text-indent:-55.3pt;}
@list l2:level6
{mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6";
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:63.8pt;
text-indent:-63.8pt;}
@list l2:level7
{mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6\.%7";
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:72.3pt;
text-indent:-72.3pt;}
@list l2:level8
{mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6\.%7\.%8";
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:80.8pt;
text-indent:-80.8pt;}
@list l2:level9
{mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6\.%7\.%8\.%9";
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:89.3pt;
text-indent:-89.3pt;}
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">Hi,<o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US">is it possible that
Lookup Tables can only be bound to attributes defined as
xsd:string in a schema extension? I have one binding in
the object template that works fine (xsd:string attribute)
and another binding (xsd:int) that, when active, causes a
500 Internal Server Error when trying to edit a user.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Can someone confirm
this behaviour? <o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Thanks in advance.<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">Chris<o:p></o:p></span></p>
</div>
<br>
<br>
<p style="font-size: 8.0pt;">Content provided within this e-mail
including any attachments, is for the use of the intended
recipients and may contain Rohde & Schwarz company
restricted information. Any unauthorized use, disclosure, or
distribution of this communication in whole or in part is
strictly prohibited. If you are not the intended recipient,
please notify the sender by reply email or by telephone and
delete the communication in its entirety.</p>
<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" moz-do-not-send="true">midPoint@lists.evolveum.com</a>
<a class="moz-txt-link-freetext" href="http://lists.evolveum.com/mailman/listinfo/midpoint" moz-do-not-send="true">http://lists.evolveum.com/mailman/listinfo/midpoint</a>
</pre>
</blockquote>
<pre class="moz-signature" cols="72">--
Ivan Noris
Senior Identity Engineer
evolveum.com
</pre>
<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>
<br>
<br>
<pre class="moz-signature" cols="72">
</pre>
</body>
</html>