[midPoint] dirsync cookie size

Andrew Morgan morgan at oregonstate.edu
Tue Sep 4 02:09:47 CEST 2018


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:

Caused by: java.sql.BatchUpdateException: (conn:2031) Data too long for 
column 'stringValue' at row 1
Query is: insert into m_object_ext_string (item_id, owner_oid, ownerType, 
stringValue) values (?, ?, ?, ?), parameters 
[3,'f82fdd36-4c48-4fb6-a63a-41b7a4c3d87c',0,'TVN
EUwMAAAAnXGd2x0LUAQAAAAAAAAAAYAEAAKtAqxsAAAAAAAAAAAAAAACrQKsbAAAAAHPlzWqF1FtDm1ZrUmr4u/MBAAAAAAAAAA4AAAAAAAAAhqWdCK+vK02geidsZEcwPLtShAEAAAAArof1HJPRtky2F91ymoTezNjxBg
AAAAAA46GJMRVAcU2tKRkmqVaV1J+dagAAAAAAcrUjMp5l50+jD8wFx6wJJjHD2xIAAAAAdpm4VNLlFka4g0XbrKotWMDcdgEAAAAAWKaYVZylhU6lcupRoF3dJ2Gu8xwAAAAAGuwbW5pZ9Uyj9C51G+Cn+XAreCwAAAAAc
+XNaoXUW0ObVmtSavi788RAqxsAAAAAFP87ecztkkC/rUXsZKbD3DJFlC8AAAAAQSkin09ZxEuR3AkpCse6hldb+AIAAAAAZTmHyMWZlEip9Ud4ctmZQcz3AAAAAAAApJnX7Zy8A0KPlWzyWh3+kBnSbAAAAAAAjuvm8MeE
6UOQ5G8LLXFnsb/YBQAAAAAAoalZ8hHbSUiEDZ030itBSixrzQEAAAAA']

stringValue is varchar(191), but the dirsync cooke is huge - 560 
characters long.

Is this a known issue?

Thanks,

Andy Morgan
Systems Administrator, Identity & Access Management
Information Services | Oregon State University
541-737-8877 | is.oregonstate.edu



More information about the midPoint mailing list