<div dir="ltr">Hi Palos,<div><br></div><div>First of all, thank you all for your support.</div><div>We can manage our db table by modifying sql query as you suggest, but there is an issue I want to ask.</div><div><br></div><div>Actually, I expect that reconciliation will be run for all data, errored datas will be logged so our customer can check and correct their data.</div><div>But when there exists any errored data, reconciliation all stops, it does not continue on next correct data. I want reconciliation to be continue on all datas,</div><div>errors will be logged but all correct datas will be progressed. Is there any way to do this? We have already checked "Enable writing empty string" as true, but nothing changed. (Also tried false or undefined value )</div><div><br></div><div>Thank you for your support.</div><div><br></div><div><br><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Dec 6, 2016 at 5:40 PM, Pálos Gustáv <span dir="ltr"><<a href="mailto:gustav.palos@evolveum.com" target="_blank">gustav.palos@evolveum.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Hi Emir,<div><br></div><div>you can create DB view and over it ignore not needed lines and use it in resource.</div><div><br></div><div>Best regards,</div><div><br></div><div>Gustav</div><div class="gmail_extra"><br><div class="gmail_quote"><br><span dir="ltr"></span><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div class="gmail_extra"><div><div class="gmail-m_-6294254758063951929gmail-h5"><br><div class="gmail_quote">2016-12-06 15:14 GMT+01:00 Emir Özbek <span dir="ltr"><<a href="mailto:emir.ozbek@basistek.com" target="_blank">emir.ozbek@basistek.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><u></u><div><div>So I checked the table, and recognized that the column (say column1) which I was using as "key column" is empty for 691st user. Then I assigned another column (column2) as the key column just to see if that empty box was the problem. And yes, that is the problem. But I must use column1 as the key column. <br><br></div><div>In this case, is there a way to skip an empty value and continue listing without system being closed?</div><div id="gmail-m_-6294254758063951929gmail-m_-606256283480385253m_-2929190180891312852signature_old"><span><div id="gmail-m_-6294254758063951929gmail-m_-606256283480385253m_-2929190180891312852x24d9db0869644fc"><div><div><br></div><div><br></div><img src="cid:em37a8af31-df8d-4d9e-8f49-011214ce065d@dell001" border="0"></div></div><div><br></div><div><br></div><div><br></div>
<div>------ Yanıtlanan İleti ------</div>
<div>Gönderen: "Martin Lízner - AMI Praha a.s." <<a href="mailto:martin.lizner@ami.cz" target="_blank">martin.lizner@ami.cz</a>></div>
<div>Alıcı: "Emir Özbek" <<a href="mailto:emir.ozbek@basistek.com" target="_blank">emir.ozbek@basistek.com</a>></div>
</span><div>Bilgilendir: "midPoint General Discussion" <<a href="mailto:midpoint@lists.evolveum.com" target="_blank">midpoint@lists.evolveum.com</a>></div>
<div>Tarih: 5.12.2016 23:51:36</div>
<div>Konu: Re: Re: [midPoint] Listing Users</div><div><div class="gmail-m_-6294254758063951929gmail-m_-606256283480385253h5"><div><br></div>
<div id="gmail-m_-6294254758063951929gmail-m_-606256283480385253m_-2929190180891312852xd47b695649214b0"><blockquote cite="http://CALOh8ePvnw2z_Sf+_0_YRD6+qapTx7QBoruc0J41R09HzqCmHA@mail.gmail.com" type="cite" class="gmail-m_-6294254758063951929gmail-m_-606256283480385253m_-2929190180891312852cite2">
<div dir="ltr">Hm, that could be almost anything as a problem :-/ Did you check idm.log? I also suggest turning the trace on for org.identityconnectors.databas<wbr>etable package. There might be some wrong value on your 691st user.. but I cannot see what may conflict with string type. Maybe try to narrow down the set of attributes you are syncing from this table so you can limit the scope. Or try creating new extended attribute - just to make sure there is no problem with already stored values. M.<div><br></div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail-m_-6294254758063951929gmail-m_-606256283480385253m_-2929190180891312852gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><table style="font-family:verdana,arial,helvetica,sans-serif;border-collapse:collapse;padding:0px;margin:0px;border-width:0px;border-style:solid;width:482px"><tbody><tr style="padding:0px;margin:0px;border:0px solid gray"><td colspan="2" style="color:rgb(0,0,0);font-family:arial,sans-serif;font-size:11px;vertical-align:bottom;padding:0px;border:0px solid gray"><p><span style="font-size:14px;font-weight:bold">Martin Lízner</span><br>solution architect<br><br>gsm: <a href="tel:+420%20737%20745%20571" value="+420737745571" target="_blank">[+420] 737 745 571</a><br>e-mail: <a href="mailto:jmeno.prijmeni@ami.cz" target="_blank">martin.lizner@ami.cz</a></p></td><td style="color:rgb(0,0,0);font-family:verdana,arial,helvetica,sans-serif;font-size:10px;border-width:0px 1px 0px 0px;border-style:solid;border-color:gray rgb(204,204,204) gray gray;padding:0px"> </td><td style="color:rgb(0,0,0);font-family:verdana,arial,helvetica,sans-serif;font-size:10px;padding:0px;border:0px solid gray"> </td><td style="color:rgb(0,0,0);font-family:arial,sans-serif;font-size:11px;vertical-align:bottom;padding:0px;border:0px solid gray"><p>AMI Praha a.s.<br>Pláničkova 11<br>162 00 Praha 6<br>tel.: <a href="tel:+420%20274%20783%20239" value="+420274783239" target="_blank">[+420] 274 783 239</a><br>web: <a href="http://www.ami.cz/" target="_blank">www.ami.cz</a></p></td><td style="color:rgb(0,0,0);font-family:verdana,arial,helvetica,sans-serif;font-size:10px;border-width:0px 1px 0px 0px;border-style:solid;border-color:gray rgb(204,204,204) gray gray;padding:0px"> </td><td style="color:rgb(0,0,0);font-family:verdana,arial,helvetica,sans-serif;font-size:10px;padding:0px;border:0px solid gray"> </td><td style="color:rgb(0,0,0);font-family:arial,sans-serif;font-size:11px;margin:8px;border:0px solid gray"><p><img src="http://www.ami.cz/images/podpis/ami_logo.gif" alt="" style="border: 0px;"></p></td></tr><tr style="padding:0px;margin:0px;border:0px solid gray"><td colspan="8" style="color:rgb(0,0,0);font-family:verdana,arial,helvetica,sans-serif;font-size:10px;padding:0px;border:0px solid gray"></td></tr><tr style="padding:0px;margin:0px;border:0px solid gray"><td colspan="8" style="color:rgb(128,128,128);font-family:arial,sans-serif;font-size:11px;padding:0px;border:0px solid gray"><table style="font-family:verdana,arial,helvetica,sans-serif;border-collapse:collapse;padding:0px;margin:0px;border-width:0px;border-style:solid;width:482px"><tbody><tr style="padding:0px;margin:0px;border:0px solid gray"><td colspan="7" style="color:rgb(0,0,0);font-family:verdana,arial,helvetica,sans-serif;font-size:10px;padding:0px;width:480px;border:0px solid gray"><br><a href="http://www.skyidentity.com/" target="_blank"><img src="http://www.ami.cz/images/podpis/AMI-podpis-Sky.png" alt="AMI Praha a.s." style="border: 0px; width: 480px; height: 82px;"></a></td></tr><tr style="padding:0px;margin:0px;border:0px solid gray"><td colspan="7" style="font-family:arial,sans-serif;padding:0px;border:0px solid gray"><br></td></tr></tbody></table>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.</td></tr></tbody></table></div><br></div></div></div></div></div></div></div>
<br><div class="gmail_quote">2016-12-05 13:10 GMT+01:00 Emir Özbek <span dir="ltr"><<a href="mailto:emir.ozbek@basistek.com" target="_blank">emir.ozbek@basistek.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><u></u><div><div>Hi Martin,</div><div><br></div><div>I tried the solution you gave and changed all attribute types to string in xsd. As a result, it fixed the error but closed again while there are 690 users. Now i do not get any error messages but still cannot reach to 7302 users. Is there any other solution for this?</div><div><br></div><div>Thank you for your interest,</div><div>Emir.</div><div id="gmail-m_-6294254758063951929gmail-m_-606256283480385253m_-2929190180891312852m_7039477441610316745signature_old"><div id="gmail-m_-6294254758063951929gmail-m_-606256283480385253m_-2929190180891312852m_7039477441610316745x6b6044a76cf04da"><div><div><br></div><div><br></div><img src="cid:em67a42964-7e55-4f55-ab7b-dd1ee9e268eb@dell001" border="0"></div><div><br></div><div><br></div><div><br></div>
<div>------ Yanıtlanan İleti ------</div>
<div>Gönderen: "Martin Lízner - AMI Praha a.s." <<a href="mailto:martin.lizner@ami.cz" target="_blank">martin.lizner@ami.cz</a>></div>
<div>Alıcı: "Emir Özbek" <<a href="mailto:emir.ozbek@basistek.com" target="_blank">emir.ozbek@basistek.com</a>>; "midPoint General Discussion" <<a href="mailto:midpoint@lists.evolveum.com" target="_blank">midpoint@lists.evolveum.com</a>></div>
<div>Tarih: 3.12.2016 16:29:42</div>
<div>Konu: Re: [midPoint] Listing Users</div><div><div class="gmail-m_-6294254758063951929gmail-m_-606256283480385253m_-2929190180891312852h5"><div><br></div>
<div id="gmail-m_-6294254758063951929gmail-m_-606256283480385253m_-2929190180891312852m_7039477441610316745xee0dd7edfc81411"><blockquote cite="http://CALOh8eNZCzHS66AKvKoTkgG7+AYq2kVikSnJV23L_b6AwsJudQ@mail.gmail.com" type="cite" class="gmail-m_-6294254758063951929gmail-m_-606256283480385253m_-2929190180891312852m_7039477441610316745cite2">
<div dir="ltr">Hi, my guess is that you are using DabaseTable connector and you are trying to fill custom attribute in user extended schema. This connector is not very good at working with various column types, so my advice would be doing everything in varchar/string. First try changing your custom attribute in xsd to string type. If it does not help, change column type in DB or your schema handling. M.</div><div class="gmail_extra"><br clear="all"><div><div class="gmail-m_-6294254758063951929gmail-m_-606256283480385253m_-2929190180891312852m_7039477441610316745gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><table style="font-family:verdana,arial,helvetica,sans-serif;border-collapse:collapse;padding:0px;margin:0px;border-width:0px;border-style:solid;width:482px"><tbody><tr style="padding:0px;margin:0px;border:0px solid gray"><td colspan="2" style="color:rgb(0,0,0);font-family:arial,sans-serif;font-size:11px;vertical-align:bottom;padding:0px;border:0px solid gray"><p><span style="font-size:14px;font-weight:bold">Martin Lízner</span><br>solution architect<br><br>gsm: <a href="tel:%5B%2B420%5D%20737%20745%20571" value="+420737745571" target="_blank">[+420] 737 745 571</a><br>e-mail: <a href="mailto:jmeno.prijmeni@ami.cz" target="_blank">martin.lizner@ami.cz</a></p></td><td style="color:rgb(0,0,0);font-family:verdana,arial,helvetica,sans-serif;font-size:10px;border-width:0px 1px 0px 0px;border-style:solid;border-color:gray rgb(204,204,204) gray gray;padding:0px"> </td><td style="color:rgb(0,0,0);font-family:verdana,arial,helvetica,sans-serif;font-size:10px;padding:0px;border:0px solid gray"> </td><td style="color:rgb(0,0,0);font-family:arial,sans-serif;font-size:11px;vertical-align:bottom;padding:0px;border:0px solid gray"><p>AMI Praha a.s.<br>Pláničkova 11<br>162 00 Praha 6<br>tel.: <a href="tel:%5B%2B420%5D%20274%20783%20239" value="+420274783239" target="_blank">[+420] 274 783 239</a><br>web: <a href="http://www.ami.cz/" target="_blank">www.ami.cz</a></p></td><td style="color:rgb(0,0,0);font-family:verdana,arial,helvetica,sans-serif;font-size:10px;border-width:0px 1px 0px 0px;border-style:solid;border-color:gray rgb(204,204,204) gray gray;padding:0px"> </td><td style="color:rgb(0,0,0);font-family:verdana,arial,helvetica,sans-serif;font-size:10px;padding:0px;border:0px solid gray"> </td><td style="color:rgb(0,0,0);font-family:arial,sans-serif;font-size:11px;margin:8px;border:0px solid gray"><p><img src="http://www.ami.cz/images/podpis/ami_logo.gif" alt="" style="border: 0px;"></p></td></tr><tr style="padding:0px;margin:0px;border:0px solid gray"><td colspan="8" style="color:rgb(0,0,0);font-family:verdana,arial,helvetica,sans-serif;font-size:10px;padding:0px;border:0px solid gray"></td></tr><tr style="padding:0px;margin:0px;border:0px solid gray"><td colspan="8" style="color:rgb(128,128,128);font-family:arial,sans-serif;font-size:11px;padding:0px;border:0px solid gray"><table style="font-family:verdana,arial,helvetica,sans-serif;border-collapse:collapse;padding:0px;margin:0px;border-width:0px;border-style:solid;width:482px"><tbody><tr style="padding:0px;margin:0px;border:0px solid gray"><td colspan="7" style="color:rgb(0,0,0);font-family:verdana,arial,helvetica,sans-serif;font-size:10px;padding:0px;width:480px;border:0px solid gray"><br><a href="http://www.skyidentity.com/" target="_blank"><img src="http://www.ami.cz/images/podpis/AMI-podpis-Sky.png" alt="AMI Praha a.s." style="border: 0px; width: 480px; height: 82px;"></a></td></tr><tr style="padding:0px;margin:0px;border:0px solid gray"><td colspan="7" style="font-family:arial,sans-serif;padding:0px;border:0px solid gray"><br></td></tr></tbody></table>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.</td></tr></tbody></table></div><br></div></div></div></div></div></div></div>
<br><div class="gmail_quote">2016-12-02 14:54 GMT+01:00 Emir Özbek <span dir="ltr"><<a href="mailto:emir.ozbek@basistek.com" target="_blank">emir.ozbek@basistek.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><u></u>
<div><div>Hello everybody,<br><br>I am working on a project with a user list of 7302 users but when i import and run the .xml file , it closes while there are 630 or 690 users. Also, i get this error message ; "<i>Failed to reconciliation: java.lang.IllegalArgumentExcep<wbr>tion: Expected class java.math.BigInteger type, but got class java.lang.Integer in inbound expression for {<a href="http://midpoint.evolveum.com/xml/ns/public/resource/instance-3" target="_blank">http://midpoint.evolveum.com/<wbr>xml/ns/public/resource/instanc<wbr>e-3</a>}guzergah_id in resource:ef2bc95b-76e0-48e2-86<wbr>d6-3d4f02d3deee(Localhost DBTable)</i>". I also have an .xsd file for extension attributes.<br><br>So my first question is, how should i resolve this error? Is it about the .xsd file or something else? And the second question ; is problem with the number of users (problem to reach 7302) has any connection with this error message? If not, what should i do to resolve it? I am using midpoint version 3.4.1. and sqljdbc 4.2.<br><br>This is my first project on midpoint so i am not much familiar with it, any help would be appreciated.<br><br></div><div>Thanks in advance,<br>Emir.</div><div id="gmail-m_-6294254758063951929gmail-m_-606256283480385253m_-2929190180891312852m_7039477441610316745m_-7827408678551299757signature_old"><div id="gmail-m_-6294254758063951929gmail-m_-606256283480385253m_-2929190180891312852m_7039477441610316745m_-7827408678551299757x225e4cc79591449"><div><div><br></div><div><br></div><img src="cid:em275b8404-cf98-4bae-876e-d725a5262fca@dell001" border="0"><div><br></div>
</div></div><br>______________________________<wbr>_________________<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/mail<wbr>man/listinfo/midpoint</a><br>
<br></div></div><br></blockquote>
</div></div>
</blockquote></div></div></div></div></div></div><br></blockquote>
</div></div>
</blockquote></div></div></div></div></div><br>______________________________<wbr>_________________<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/mail<wbr>man/listinfo/midpoint</a><br>
<br></blockquote></div><br><br clear="all"><span class="gmail-HOEnZb"><font color="#888888"><div><br></div></font></span></div></div><span class="gmail-HOEnZb"><font color="#888888"><span class="gmail-m_-6294254758063951929gmail-HOEnZb"><font color="#888888">-- <br><div class="gmail-m_-6294254758063951929gmail-m_-606256283480385253gmail_signature">s pozdravom<div><br></div><div>Gustáv Pálos<br clear="all"><div><br></div>-- <br><div class="gmail-m_-6294254758063951929gmail_signature"><div dir="ltr"><div>Gustáv Pálos</div><div>Identity Engineer</div><a href="http://evolveum.com/" rel="noreferrer" style="color:rgb(17,85,204);font-size:12.8px" target="_blank">evolveum.com</a><br></div></div>
<br></div></div>
</font></span></font></span></div></blockquote></div></div></div>
<br>______________________________<wbr>_________________<br>
midPoint mailing list<br>
<a href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a><br>
<a href="http://lists.evolveum.com/mailman/listinfo/midpoint" rel="noreferrer" target="_blank">http://lists.evolveum.com/<wbr>mailman/listinfo/midpoint</a><br>
<br></blockquote></div><br></div></div></div>