[midPoint] Ynt: Re: Re: Listing Users

Wed Dec 7 13:06:47 CET 2016

Hi Palos,

First of all, thank you all for your support.
We can manage our db table by modifying sql query as you suggest, but there
is an issue I want to ask.

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.
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,
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 )

Thank you for your support.

On Tue, Dec 6, 2016 at 5:40 PM, Pálos Gustáv <gustav.palos at evolveum.com>
wrote:

> 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
>>
>>
> _______________________________________________
> 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/20161207/d88a99f6/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/20161207/d88a99f6/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/20161207/d88a99f6/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/20161207/d88a99f6/attachment-0002.png>