[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