[midPoint] Ynt: Re: Re: Listing Users

[Pálos Gustáv]

Hi Emir,

you can create DB view and over it ignore not needed lines and use it in
resource.

Best regards,

Gustav



> 2016-12-06 15:14 GMT+01:00 Emir Özbek <emir.ozbek at basistek.com>:
>
>> 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 <+420%20737%20745%20571>
>> e-mail: martin.lizner at ami.cz <jmeno.prijmeni at ami.cz>
>>
>>
>> AMI Praha a.s.
>> Pláničkova 11
>> 162 00 Praha 6
>> tel.: [+420] 274 783 239 <+420%20274%20783%20239>
>> web: www.ami.cz
>>
>>
>>
>> [image: AMI Praha a.s.] <http://www.skyidentity.com/>
>>
>> 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 <jmeno.prijmeni at ami.cz>
>>>
>>>
>>> AMI Praha a.s.
>>> Pláničkova 11
>>> 162 00 Praha 6
>>> tel.: [+420] 274 783 239
>>> web: www.ami.cz
>>>
>>>
>>>
>>> [image: AMI Praha a.s.] <http://www.skyidentity.com/>
>>>
>>> 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
>>>> <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
>>>>
>>>>
>>>>
>>>
>> _______________________________________________
>> midPoint mailing list
>> midPoint at lists.evolveum.com
>> http://lists.evolveum.com/mailman/listinfo/midpoint
>>
>>
>
>
> --
> s pozdravom
>
> Gustáv Pálos
>
> --
> Gustáv Pálos
> Identity Engineer
> evolveum.com
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20161206/2fe880e8/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/2fe880e8/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/2fe880e8/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/2fe880e8/attachment-0002.png>