[midPoint] Ynt: Re: Re: Listing Users

[Emir Özbek]

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.

In this case, is there a way to skip an empty value and continue listing 
without system being closed?





------ Yanıtlanan İleti ------
Gönderen: "Martin Lízner - AMI Praha a.s." <martin.lizner at ami.cz>
Alıcı: "Emir Özbek" <emir.ozbek at basistek.com>
Bilgilendir: "midPoint General Discussion" <midpoint at lists.evolveum.com>
Tarih: 5.12.2016 23:51:36
Konu: Re: Re: [midPoint] Listing Users

>Hm, that could be almost anything as a problem :-/ Did you check 
>idm.log? I also suggest turning the trace on for 
>org.identityconnectors.databasetable 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.
>
>
>Martin Lízner
>solution architect
>
>gsm: [+420] 737 745 571
>e-mail: martin.lizner at ami.cz
>
>
>AMI Praha a.s.
>Pláničkova 11
>162 00 Praha 6
>tel.: [+420] 274 783 239
>web: www.ami.cz
>
>
>
>
>
>Textem tohoto e-mailu podepisující neslibuje uzavřít ani neuzavírá za 
>společnost AMI Praha a.s.
>jakoukoliv smlouvu. Každá smlouva, pokud bude uzavřena, musí mít 
>výhradně písemnou formu.
>
>
>2016-12-05 13:10 GMT+01:00 Emir Özbek <emir.ozbek at basistek.com>:
>>Hi Martin,
>>
>>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?
>>
>>Thank you for your interest,
>>Emir.
>>
>>
>>
>>
>>
>>------ Yanıtlanan İleti ------
>>Gönderen: "Martin Lízner - AMI Praha a.s." <martin.lizner at ami.cz>
>>Alıcı: "Emir Özbek" <emir.ozbek at basistek.com>; "midPoint General 
>>Discussion" <midpoint at lists.evolveum.com>
>>Tarih: 3.12.2016 16:29:42
>>Konu: Re: [midPoint] Listing Users
>>
>>>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.
>>>
>>>Martin Lízner
>>>solution architect
>>>
>>>gsm: [+420] 737 745 571
>>>e-mail: martin.lizner at ami.cz
>>>
>>>
>>>AMI Praha a.s.
>>>Pláničkova 11
>>>162 00 Praha 6
>>>tel.: [+420] 274 783 239
>>>web: www.ami.cz
>>>
>>>
>>>
>>>
>>>
>>>Textem tohoto e-mailu podepisující neslibuje uzavřít ani neuzavírá za 
>>>společnost AMI Praha a.s.
>>>jakoukoliv smlouvu. Každá smlouva, pokud bude uzavřena, musí mít 
>>>výhradně písemnou formu.
>>>
>>>
>>>2016-12-02 14:54 GMT+01:00 Emir Özbek <emir.ozbek at basistek.com>:
>>>>Hello everybody,
>>>>
>>>>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 ; "Failed to reconciliation: 
>>>>java.lang.IllegalArgumentException: Expected class 
>>>>java.math.BigInteger type, but got class java.lang.Integer in 
>>>>inbound expression for 
>>>>{http://midpoint.evolveum.com/xml/ns/public/resource/instance-3}guzergah_id 
>>>>in resource:ef2bc95b-76e0-48e2-86d6-3d4f02d3deee(Localhost 
>>>>DBTable)". I also have an .xsd file for extension attributes.
>>>>
>>>>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.
>>>>
>>>>This is my first project on midpoint so i am not much familiar with 
>>>>it, any help would be appreciated.
>>>>
>>>>Thanks in advance,
>>>>Emir.
>>>>
>>>>
>>>>
>>>>
>>>>_______________________________________________
>>>>midPoint mailing list
>>>>midPoint at lists.evolveum.com
>>>>http://lists.evolveum.com/mailman/listinfo/midpoint
>>>>
>>>>
>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20161206/b60ffa0a/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Ekran Alıntısı.PNG
Type: image/png
Size: 51942 bytes
Desc: not available
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20161206/b60ffa0a/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Ekran Alıntısı.PNG
Type: image/png
Size: 51942 bytes
Desc: not available
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20161206/b60ffa0a/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Ekran Alıntısı.PNG
Type: image/png
Size: 51942 bytes
Desc: not available
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20161206/b60ffa0a/attachment-0002.png>