[midPoint] Live Sync Task with DatabaseConnector

[Gómez Martínez, Elsa]

Hello!

I'm using a Database Connector (PostgresSQL) and I have created a Livesync task in order to sync the users (inserts or updates) from the database into MidPoint.
I have configure my changelog column with a TIMESTAMPZ column in database that register the changes.

However, when I run the task I'm getting an error.
1000000000000000838

com.evolveum.midpoint.common.operation.liveSync

FATAL_ERROR

9/26/19 5:04:33 PM

Internal Error: DB error: org.postgresql.util.PSQLException(ERROR: the operator does not exist: time stamp with time zone> variable character? Tip: No operator matches the name and type of arguments. Can it be necessary to add explicit type conversations? Position: 346)


What is happening? Do I have to use some expression to convert the type?

Thanks!
Elsa


[minsait]<http://www.minsait.com/>


Elsa Gómez Martínez

Ciberseguridad


Espacio Virtual:
https://join.indra.es<https://join.indra.es/>
egomezm at cms.indra.es<mailto:egomezm at cms.indra.es>
ID: 269068
[https://emailingindra.indra.es/archivos/1/12316_mates-firma-interna.png]<https://apps.indraweb.net/mates?utm_source=Notificacion-Mates&utm_medium=email&utm_content=Firma&utm_campaign=Firma-interna&recognise-direct=egomezm>



________________________________

Este correo electrónico y, en su caso, cualquier fichero anexo al mismo, contiene información de carácter confidencial exclusivamente dirigida a su destinatario o destinatarios. Si no es vd. el destinatario indicado, queda notificado que la lectura, utilización, divulgación y/o copia sin autorización está prohibida en virtud de la legislación vigente. En el caso de haber recibido este correo electrónico por error, se ruega notificar inmediatamente esta circunstancia mediante reenvío a la dirección electrónica del remitente.
Evite imprimir este mensaje si no es estrictamente necesario.

This email and any file attached to it (when applicable) contain(s) confidential information that is exclusively addressed to its recipient(s). If you are not the indicated recipient, you are informed that reading, using, disseminating and/or copying it without authorisation is forbidden in accordance with the legislation in effect. If you have received this email by mistake, please immediately notify the sender of the situation by resending it to their email address.
Avoid printing this message if it is not absolutely necessary.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20190926/1291a0ca/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 3646 bytes
Desc: image001.png
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20190926/1291a0ca/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 2554 bytes
Desc: image002.png
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20190926/1291a0ca/attachment-0001.png>