<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">
Hi Andrew,
<div class=""><br class="">
</div>
<div class="">I wanted to enable AD live sync on our production env and I got the same issue. I’ve created
<a href="https://jira.evolveum.com/browse/MID-4878" class="">https://jira.evolveum.com/browse/MID-4878</a> since this blocks our deployment.<br class="">
<div class="">
<div style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;">
<br class="Apple-interchange-newline">
Davy Priem<br class="">
<b class="">IT technical management</b><br class="">
<br class="">
VIVES University of Applied Sciences | Dienst IT<br class="">
Doorniksesteenweg 145 | 8500 Kortrijk<br class="">
</div>
<span style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;"><br class="">
</span></div>
<div><br class="">
<blockquote type="cite" class="">
<div class="">Op 4 sep. 2018, om 02:09 heeft Andrew Morgan <<a href="mailto:morgan@oregonstate.edu" class="">morgan@oregonstate.edu</a>> het volgende geschreven:</div>
<br class="Apple-interchange-newline">
<div class="">
<div class="">I want to use LiveSync against Active Directory. I tested this against a DEV AD forest successfully. However, our production AD forest sends back a dirsync cookie that is too large to store in the database. Here is the error message:<br class="">
<br class="">
Caused by: java.sql.BatchUpdateException: (conn:2031) Data too long for column 'stringValue' at row 1<br class="">
Query is: insert into m_object_ext_string (item_id, owner_oid, ownerType, stringValue) values (?, ?, ?, ?), parameters [3,'f82fdd36-4c48-4fb6-a63a-41b7a4c3d87c',0,'TVN<br class="">
EUwMAAAAnXGd2x0LUAQAAAAAAAAAAYAEAAKtAqxsAAAAAAAAAAAAAAACrQKsbAAAAAHPlzWqF1FtDm1ZrUmr4u/MBAAAAAAAAAA4AAAAAAAAAhqWdCK+vK02geidsZEcwPLtShAEAAAAArof1HJPRtky2F91ymoTezNjxBg<br class="">
AAAAAA46GJMRVAcU2tKRkmqVaV1J+dagAAAAAAcrUjMp5l50+jD8wFx6wJJjHD2xIAAAAAdpm4VNLlFka4g0XbrKotWMDcdgEAAAAAWKaYVZylhU6lcupRoF3dJ2Gu8xwAAAAAGuwbW5pZ9Uyj9C51G+Cn+XAreCwAAAAAc<br class="">
+XNaoXUW0ObVmtSavi788RAqxsAAAAAFP87ecztkkC/rUXsZKbD3DJFlC8AAAAAQSkin09ZxEuR3AkpCse6hldb+AIAAAAAZTmHyMWZlEip9Ud4ctmZQcz3AAAAAAAApJnX7Zy8A0KPlWzyWh3+kBnSbAAAAAAAjuvm8MeE<br class="">
6UOQ5G8LLXFnsb/YBQAAAAAAoalZ8hHbSUiEDZ030itBSixrzQEAAAAA']<br class="">
<br class="">
stringValue is varchar(191), but the dirsync cooke is huge - 560 characters long.<br class="">
<br class="">
Is this a known issue?<br class="">
<br class="">
Thanks,<br class="">
<br class="">
Andy Morgan<br class="">
Systems Administrator, Identity & Access Management<br class="">
Information Services | Oregon State University<br class="">
541-737-8877 | <a href="http://is.oregonstate.edu" class="">is.oregonstate.edu</a><br class="">
_______________________________________________<br class="">
midPoint mailing list<br class="">
<a href="mailto:midPoint@lists.evolveum.com" class="">midPoint@lists.evolveum.com</a><br class="">
http://lists.evolveum.com/mailman/listinfo/midpoint<br class="">
</div>
</div>
</blockquote>
</div>
<br class="">
</div>
</body>
</html>