[midPoint] Outbound mapping PostgresDB
Gómez Martínez, Elsa
egomezm at minsait.com
Thu Jan 23 11:42:20 CET 2020
Hi Ivan,
I add the midPoint.log file with the error part from one simple test.
Steps:
1. Create user “alex” from MidPoint GUI
2. Assign the resource Localhost PostgreSQL DBTable
020-01-23 10:59:09,806 [] [pool-3-thread-5] ERROR (com.evolveum.midpoint.web.component.progress.ProgressPanel): Error executing changes.
com.evolveum.midpoint.util.exception.ConfigurationException: Configuration error: For input string: "alex"
at com.evolveum.midpoint.provisioning.ucf.impl.connid.ConnIdUtil.processConnIdException(ConnIdUtil.java:168)
at com.evolveum.midpoint.provisioning.ucf.impl.connid.ConnIdUtil.processConnIdException(ConnIdUtil.java:94)
at com.evolveum.midpoint.provisioning.ucf.impl.connid.ConnectorInstanceConnIdImpl.addObject(ConnectorInstanceConnIdImpl.java:869)
at com.evolveum.midpoint.provisioning.impl.ResourceObjectConverter.addResourceObject(ResourceObjectConverter.java:266)
at com.evolveum.midpoint.provisioning.impl.ShadowCache.addShadowAttempt(ShadowCache.java:554)
at com.evolveum.midpoint.provisioning.impl.ShadowCache.addShadow(ShadowCache.java:496)
at com.evolveum.midpoint.provisioning.impl.ProvisioningServiceImpl.addObject(ProvisioningServiceImpl.java:280)
at com.evolveum.midpoint.model.impl.lens.ChangeExecutor.addProvisioningObject(ChangeExecutor.java:1580)
at com.evolveum.midpoint.model.impl.lens.ChangeExecutor.executeAddition(ChangeExecutor.java:1362)
at com.evolveum.midpoint.model.impl.lens.ChangeExecutor.executeDelta(ChangeExecutor.java:938)
at com.evolveum.midpoint.model.impl.lens.ChangeExecutor.executeChanges(ChangeExecutor.java:326)
at com.evolveum.midpoint.model.impl.lens.Clockwork.lambda$processSecondary$0(Clockwork.java:796)
at com.evolveum.midpoint.model.impl.lens.ClockworkMedic.partialExecute(ClockworkMedic.java:211)
at com.evolveum.midpoint.model.impl.lens.ClockworkMedic.partialExecute(ClockworkMedic.java:154)
at com.evolveum.midpoint.model.impl.lens.Clockwork.processSecondary(Clockwork.java:794)
at com.evolveum.midpoint.model.impl.lens.Clockwork.click(Clockwork.java:615)
at com.evolveum.midpoint.model.impl.lens.Clockwork.run(Clockwork.java:200)
at com.evolveum.midpoint.model.impl.controller.ModelController.executeChanges(ModelController.java:556)
at com.evolveum.midpoint.web.component.progress.ProgressPanel$14.callWithContextPrepared(ProgressPanel.java:592)
at com.evolveum.midpoint.web.component.progress.ProgressPanel$14.callWithContextPrepared(ProgressPanel.java:578)
at com.evolveum.midpoint.web.component.SecurityContextAwareCallable.call(SecurityContextAwareCallable.java:50)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:834)
Regards,
Elsa
De: midPoint <midpoint-bounces at lists.evolveum.com> En nombre de Ivan Noris
Enviado el: jueves, 23 de enero de 2020 8:45
Para: midpoint at lists.evolveum.com
Asunto: Re: [midPoint] Outbound mapping PostgresDB
Hi Elsa,
can you please check midpoint.log? There should be something more.
Regards,
Ivan
On 22. 1. 2020 15:51, Gómez Martínez, Elsa wrote:
Hello!
I am trying to mapping the users from MidPoint to a PostgreSQL Database but I am having the next error:
Save (GUI) Configuration error: For input string: "superuserTest"
Account (default) on Basic PostgreSQL DBTable
Add:Fatal error -> superuserTest
I am using the next git sample:
<https://github.com/Evolveum/midpoint-samples/blob/master/samples/resources/databasetable/postgresql/resource-dbtable-postgresql.xml> https://github.com/Evolveum/midpoint-samples/blob/master/samples/resources/databasetable/postgresql/resource-dbtable-postgresql.xml
And this is my schema handling configuration (my username is my unique identifier):
<schemaHandling>
<objectType id="5">
<displayName>Default Account</displayName>
<default>true</default>
<objectClass>ri:AccountObjectClass</objectClass>
<attribute id="6">
<c:ref>icfs:uid</c:ref>
<displayName>User ID</displayName>
<limitations>
<access>
<read>true</read>
</access>
</limitations>
</attribute>
<attribute id="7">
<c:ref>icfs:name</c:ref>
<displayName>Name</displayName>
<limitations>
<minOccurs>0</minOccurs>
<access>
<read>true</read>
<add>true</add>
<modify>true</modify>
</access>
</limitations>
<outbound>
<source>
<c:path>$user/name</c:path>
</source>
</outbound>
</attribute>
<attribute id="4">
<c:ref>ri:username</c:ref>
<displayName>Username</displayName>
<outbound>
<source>
<c:path>$user/name</c:path>
</source>
</outbound>
</attribute>
And my database schema:
One example user:
Could anyone help me?
Thanks a lot!
<http://www.minsait.com/>
Elsa Gómez Martínez
Ciberseguridad
Espacio Virtual:
<https://join.indra.es/> https://join.indra.es
<mailto:egomezm at cms.indra.es> egomezm at cms.indra.es
ID: 269068
<https://apps.indraweb.net/mates?utm_source=Notificacion-Mates&utm_medium=email&utm_content=Firma&utm_campaign=Firma-interna&recognise-direct=egomezm>
_______________________________________________
midPoint mailing list
midPoint at lists.evolveum.com <mailto:midPoint at lists.evolveum.com>
http://lists.evolveum.com/mailman/listinfo/midpoint
--
Ivan Noris
Senior Identity Engineer
evolveum.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20200123/1ab695ed/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 54881 bytes
Desc: not available
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20200123/1ab695ed/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 8943 bytes
Desc: not available
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20200123/1ab695ed/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 3646 bytes
Desc: not available
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20200123/1ab695ed/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.png
Type: image/png
Size: 2554 bytes
Desc: not available
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20200123/1ab695ed/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: midpoint.log
Type: application/octet-stream
Size: 21533 bytes
Desc: not available
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20200123/1ab695ed/attachment.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 6049 bytes
Desc: not available
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20200123/1ab695ed/attachment.bin>
More information about the midPoint
mailing list