<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<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">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">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>