<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Georgia;
panose-1:2 4 5 2 5 4 5 2 3 3;}
@font-face
{font-family:"helvetica neue";}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML con formato previo Car";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:Consolas;
mso-fareast-language:EN-US;}
span.EstiloCorreo17
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.HTMLconformatoprevioCar
{mso-style-name:"HTML con formato previo Car";
mso-style-priority:99;
mso-style-link:"HTML con formato previo";
font-family:Consolas;}
.MsoChpDefault
{mso-style-type:export-only;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 3.0cm 70.85pt 3.0cm;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="ES" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-US">Hello!<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">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.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">I have configure my changelog column with a TIMESTAMPZ column in database that register the changes.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">However, when I run the task I’m getting an error.<o:p></o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="0" style="width:801.0pt;background:white;border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="border:none;border-top:solid #F4F4F4 1.0pt;background:#F9F9F9;padding:3.75pt 3.75pt 3.75pt 3.75pt">
<p class="MsoNormal" style="margin-bottom:15.0pt"><span style="font-size:10.5pt;font-family:"helvetica neue";color:#333333;mso-fareast-language:ES">1000000000000000838<o:p></o:p></span></p>
</td>
<td valign="top" style="border:none;border-top:solid #F4F4F4 1.0pt;background:#F9F9F9;padding:3.75pt 3.75pt 3.75pt 3.75pt">
<p class="MsoNormal" style="margin-bottom:15.0pt"><span lang="EN-US" style="font-size:10.5pt;font-family:"helvetica neue";color:#333333;mso-fareast-language:ES">com.evolveum.midpoint.common.operation.liveSync<o:p></o:p></span></p>
</td>
<td valign="top" style="border:none;border-top:solid #F4F4F4 1.0pt;background:#F9F9F9;padding:3.75pt 3.75pt 3.75pt 3.75pt">
<p class="MsoNormal" style="margin-bottom:15.0pt"><span style="font-size:10.5pt;font-family:"helvetica neue";color:#333333;mso-fareast-language:ES">FATAL_ERROR<o:p></o:p></span></p>
</td>
<td valign="top" style="border:none;border-top:solid #F4F4F4 1.0pt;background:#F9F9F9;padding:3.75pt 3.75pt 3.75pt 3.75pt">
<p class="MsoNormal" style="margin-bottom:15.0pt"><span style="font-size:10.5pt;font-family:"helvetica neue";color:#333333;mso-fareast-language:ES">9/26/19 5:04:33 PM<o:p></o:p></span></p>
</td>
<td valign="top" style="border:none;border-top:solid #F4F4F4 1.0pt;background:#F9F9F9;padding:3.75pt 3.75pt 3.75pt 3.75pt">
<p class="MsoNormal" style="margin-bottom:15.0pt"><span lang="EN-US" style="font-size:10.5pt;font-family:"helvetica neue";color:#333333;mso-fareast-language:ES">Internal Error: DB error: org.postgresql.util.PSQLException(ERROR:
</span><span lang="EN" style="font-size:10.5pt;font-family:"helvetica neue";color:#333333;mso-fareast-language:ES">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)<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">What is happening? Do I have to use some expression to convert the type?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Thanks!<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Elsa<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="0" style="width:240.0pt">
<tbody>
<tr>
<td width="320" style="width:240.0pt;padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal"><a href="http://www.minsait.com/" target="_blank" title="Minsait"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:blue;mso-fareast-language:ES;text-decoration:none"><img border="0" width="301" height="48" style="width:3.1354in;height:.5in" id="Imagen_x0020_1" src="cid:image001.png@01D5748C.B7EEC660" alt="minsait"></span></a><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#004254;mso-fareast-language:ES"><o:p></o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="0" style="width:240.0pt;border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal" style="line-height:18.75pt"><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:#0A0A0A;mso-fareast-language:ES"> <o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal" style="line-height:10.5pt"><span style="font-size:10.0pt;font-family:"Georgia",serif;color:#004254;mso-fareast-language:ES">Elsa Gómez Martínez<o:p></o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="0" style="width:240.0pt;border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="padding:0cm 0cm 0cm 0cm"></td>
</tr>
</tbody>
</table>
<p class="MsoNormal" style="line-height:10.5pt"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#999999;mso-fareast-language:ES">Ciberseguridad<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Arial",sans-serif;mso-fareast-language:ES"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#004254;mso-fareast-language:ES">Espacio Virtual:
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#999999;border:none windowtext 1.0pt;padding:0cm;background:white;mso-fareast-language:ES"><a href="https://join.indra.es/"><span style="color:#999999">https://join.indra.es</span></a></span><span style="color:#999999;border:none windowtext 1.0pt;padding:0cm;background:white;mso-fareast-language:ES"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#004254;mso-fareast-language:ES"><a href="mailto:egomezm@cms.indra.es"><span style="color:#004254">egomezm@cms.indra.es</span></a>
</span><span style="mso-fareast-language:ES"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#004254;mso-fareast-language:ES">ID: 269068<o:p></o:p></span></p>
<p class="MsoNormal"><a href="https://apps.indraweb.net/mates?utm_source=Notificacion-Mates&utm_medium=email&utm_content=Firma&utm_campaign=Firma-interna&recognise-direct=egomezm"><span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:#1A3B47;mso-fareast-language:ES;text-decoration:none"><img border="0" width="140" height="44" style="width:1.4583in;height:.4583in" id="Imagen_x0020_2" src="cid:image002.png@01D5748C.B7EEC660" alt="https://emailingindra.indra.es/archivos/1/12316_mates-firma-interna.png"></span></a><span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:ES"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#004254;mso-fareast-language:ES"><o:p> </o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<br>
<hr>
<font face="Arial" color="Gray" size="1"><br>
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.<br>
Evite imprimir este mensaje si no es estrictamente necesario.<br>
<br>
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.<br>
Avoid printing this message if it is not absolutely necessary.<br>
</font>
</body>
</html>