<div dir="ltr">The new Scripted SQL connector on github is totally usable, only its not release yet. You need to build your own dependencies first: <a href="https://github.com/Evolveum/connector-legacy-libs">https://github.com/Evolveum/connector-legacy-libs</a> <div><br></div><div>M. <br clear="all"><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:13px"><p><strong>Martin Lízner</strong><br><span style="font-size:11px;color:rgb(128,128,128)">chief solution architect</span></p></div><p style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:11px">gsm: [+420] 737 745 571<br>e‑mail: <a href="mailto:martin.lizner@ami.cz" target="_blank">martin.lizner@ami.cz</a></p><p style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:11px"><strong>AMI Praha a.s.</strong><br>Pláničkova 11, 162 00 Praha 6</p><p style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:11px">tel.: [+420] 274 783 239 | web: <a href="http://www.ami.cz" target="_blank">www.ami.cz</a></p><p style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:10px;margin-top:20px"><img src="http://www.ami.cz/images/podpis/ami_logo.gif" alt="AMI Praha a.s." style="border:0px"></p><p style="font-family:Arial,sans-serif;font-size:11px;color:rgb(170,170,170)">Textem tohoto e‑mailu podepisující neslibuje uzavřít ani neuzavírá za společnost AMI Praha a.s.<br>jakoukoliv smlouvu. Každá smlouva, pokud bude uzavřena, musí mít výhradně písemnou formu.<br><span style="font-size:6px"> </span><br>Tento e‑mail je určen výhradně pro potřeby jeho adresáta/ů a může obsahovat důvěrné nebo osobní<br>informace. Nejste‑li zamýšleným příjemcem, je zakázáno jakékoliv zveřejňování, zprostředkování<br>nebo jiné použití těchto informací. Pokud jste obdrželi e‑mail neoprávněně, informujte o tom prosím<br>odesílatele a vymažte neprodleně všechny kopie tohoto e‑mailu včetně všech jeho příloh. Nakládáním<br>s neoprávněně získanými informacemi se vystavujete riziku právního postihu.</p></div></div></div></div></div></div></div></div></div></div></div></div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">st 26. 6. 2019 v 10:35 odesílatel Peter Holes <<a href="mailto:pholes@gmail.com">pholes@gmail.com</a>> napsal:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hi All,<br>
<br>
I would like to discuss an issue with ScriptedSQL connector, maybe<br>
somebody facing similar issue.. or my DB or midpoint configuration is<br>
not relevant.<br>
<br>
I am using an ScriptedSQL connector (v2.0) and midPoint 3.9, the<br>
version 2.1 on github has errors (unable to build the connector, due<br>
dependency issues). I try to prepare a searchScript.groovy based on<br>
samples, which pull data from SQL table.<br>
I have something like this:<br>
<br>
##<br>
..<br>
def sql = new Sql(connection)<br>
def result = [];<br>
<br>
<a href="http://log.info" rel="noreferrer" target="_blank">log.info</a>('### objectClass:' + objectClass);<br>
<br>
switch ( objectClass ) {<br>
case "ObjectClass: __ACCOUNT__":<br>
sql.eachRow("SELECT * FROM egje.dbo.employees where EMAIL is not NULL<br>
AND USERNAME is not NULL", {<br>
result.add([__UID__:it.OSCPV, __NAME__:it.OSCPV,<br>
givenname:it.GIVENNAME, lastname:it.FAMILYNAME, username:it.USERNAME,<br>
email:it.EMAIL])<br>
<a href="http://log.info" rel="noreferrer" target="_blank">log.info</a>("### [ScriptedSQL] attributes:oscpv:{0},givenname:<br>
{1},familyName: {2},username: {3},email: {4}",<br>
it.OSCPV,it.GIVENNAME,it.FAMILYNAME,it.USERNAME,it.EMAIL)<br>
})<br>
default:<br>
result;<br>
}<br>
//<a href="http://log.info" rel="noreferrer" target="_blank">log.info</a>('### nothing to do...{}', result);<br>
return result;<br>
..<br>
##<br>
<br>
I try to read the data to midPoint and create shadows (through browse<br>
myResource>Accoutns>Repository), but I get the errors in log file:<br>
"Paged search is requested, but the filtered results handler is<br>
enabled in effective (i.e. non-validation) mode. This is not<br>
supported."<br>
<br>
so, I update the resource configuration like this:<br>
<br>
<icfc:resultsHandlerConfiguration><br>
<icfc:enableNormalizingResultsHandler>false</icfc:enableNormalizingResultsHandler><br>
<icfc:enableFilteredResultsHandler>false</icfc:enableFilteredResultsHandler><br>
<icfc:filteredResultsHandlerInValidationMode>true</icfc:filteredResultsHandlerInValidationMode><br>
<icfc:enableAttributesToGetSearchResultsHandler>false</icfc:enableAttributesToGetSearchResultsHandler><br>
</icfc:resultsHandlerConfiguration><br>
<br>
and extends 2 resource capabilities:<br>
<br>
<cap:pagedSearch/><br>
<br>
<cap:countObjects><br>
<cap:simulate>pagedSearchEstimate</cap:simulate><br>
</cap:countObjects><br>
<br>
can anybody help, how to figure out of this issue?<br>
<br>
Thx for help.<br>
<br>
Peter.<br>
_______________________________________________<br>
midPoint mailing list<br>
<a href="mailto:midPoint@lists.evolveum.com" target="_blank">midPoint@lists.evolveum.com</a><br>
<a href="http://lists.evolveum.com/mailman/listinfo/midpoint" rel="noreferrer" target="_blank">http://lists.evolveum.com/mailman/listinfo/midpoint</a><br>
</blockquote></div>