<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-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_-606256283480385253m_-2929190180891312852signature_old"><span><div id="gmail-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_-606256283480385253h5"><div><br></div>
<div id="gmail-m_-606256283480385253m_-2929190180891312852xd47b695649214b0"><blockquote cite="http://CALOh8ePvnw2z_Sf+_0_YRD6+qapTx7QBoruc0J41R09HzqCmHA@mail.gmail.com" type="cite" class="gmail-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_-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_-606256283480385253m_-2929190180891312852m_7039477441610316745signature_old"><div id="gmail-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_-606256283480385253m_-2929190180891312852h5"><div><br></div>
<div id="gmail-m_-606256283480385253m_-2929190180891312852m_7039477441610316745xee0dd7edfc81411"><blockquote cite="http://CALOh8eNZCzHS66AKvKoTkgG7+AYq2kVikSnJV23L_b6AwsJudQ@mail.gmail.com" type="cite" class="gmail-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_-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_-606256283480385253m_-2929190180891312852m_7039477441610316745m_-7827408678551299757signature_old"><div id="gmail-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"><div><br></div></div></div><span class="gmail-HOEnZb"><font color="#888888">-- <br><div class="gmail-m_-606256283480385253gmail_signature">s pozdravom<div><br></div><div>Gustáv Pálos<br clear="all"><div><br></div>-- <br><div class="gmail_signature" data-smartmail="gmail_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></div></blockquote></div></div></div>