DCS driver and surpassing entitlement value character limit

Hey everyone,

I am having some issues with the DCS driver and reporting - i think caused by surpassing the character limit for the db column. After creating a role with some dynamic entitlement that resulted in a string quite a bit longer than the limit i get errors around the system.

From the DCS driver trace i get the following:

 

 

Status: Error Message: <description>Unable to process [modify] event from DCS driver; Object DN: cn=kcruz,ou=users,o=data, Structural class: inetOrgPerson, Reason: com.netiq.persist.PersistenceException:Batch entry 0 i nsert into idm_rpt_data.idmrpt_idv_identity_trust (trust_obj_id, identity_id, trust_type_id, trust_status, request_date, request_comment, requester_id, cause, cause_type, approval_info, trust_params, idv_ent_re f, idmrpt_valid_from, idmrpt_deleted, trust_start_time, trust_expiration_time, idmrpt_syn_state, idv_ent_id, trust_id) values ('64f4eeab0fc24bfebf6132561945b0db', 'bf781819f50647b3a2168449dcbab78d', 'RESOURCE_A SSIGNMENT', 1, '2021-03-25 11:56:21 01', 'Created by the Role Driver', '153d68b2eb174db29cdb3c648366fc06', NULL, 'role driver', NULL, NULL, '&lt;?xml version="1.0" encoding="UTF-8"?>&lt;ref>&lt;src>UA&lt;/src>& lt;id/>&lt;param>{"ID":"Role=KYSagsbehandler#ydelseskoder=00697e02-7244-469d-8e56-2d93abf1e2bd,019359e0-d674-4cde-9938-af38b37c899f,050152a2-e6ef-4dba-b05d-916827d8dfce,050655b7-61c1-494d-88a7-14d6bb8b616a,052a e8d8-a36b-4f26-b109-e7d6f21e7bf2,06fd4d86-4f9b-4860-adbd-3f79ec72337a,0a82e123-6638-4b7a-97e8-1ff606774cc8,0c2d1a76-99c4-45a1-aa87-760437c8ebb1,0da6f5ee-5367-452f-b54f-f7b52916815c,0f2a1db9-5436-414a-8a5a-f067e 5a34dd3,0f538062-94bc-4c46-a9f9-045d19de0da6,1110f5f5-5e01-45f1-bc49-42b65e5f0c5a,11b3ec88-6a9c-4bef-8f59-bb892ca2106d,120f445a-bfa2-4b2d-bff2-56a1a32eb0ed,134c1ca1-0f31-495b-bdb0-ff367a27bce7,15b59ec7-a0a9-492 6-9c7e-5c030ff8903b,15c10eed-95a6-417c-9617-844a0afd9a7e,186ba734-c441-4f2d-8698-2f62a7a1caab,188bd9a2-6502-4874-b082-01a32adb0007,1b979426-f4c7-4376-b460-3603237cf36f,1e9cc9e2-904a-45d0-8317-6e59c5b1edaa,2232a acb-ad24-48f1-b9b4-21bcab5de5d3,22c008af-d5fb-40aa-9 e7e-cbd681601bba,235dc550-e61a-442d-8312-ebfed1a42105,255dd16d-0934-4506-bcc4-110173ad2414,26f1a952-f33d-4634-ac46-a4cfc194ef27,282d2f86-07b5-40d1-a193-98066588410a,2af7f1ce-3483-466c-b5ab-1c2f2d05f92d,2c18da79 -d1e0-4dad-813d-160c5c96595d,2e02de1f-7266-4981-a586-afb681709064,2e9dc2e5-5dc5-43f7-91f8-034d2c90a5ec,3115bf56-ae04-4879-8b56-3f393abf14ec,31dbb957-b206-40bd-9cb7-becbd1f9fd96,3a0a6354-22cb-472c-9174-d0b261e23 d7c,3a0fe7a6-8db5-42ec-9749-eea9582a763a,3c65c69c-8c8f-4c0b-8484-ad12b871da06,3d9f7bb1-8ab8-496e-995c-f00ef87054c7,4152131e-1937-415c-8e93-1d3553e59eab,4239917f-2cd0-47c5-ba91-be97f42e9e5c,4310bc7c-9f8a-47d7-8b b1-b8f97b7b9603,43e6f3df-baae-41b8-92cc-31894dff7e5e,45ff5d92-353c-417f-a496-ec8c48be3a1f,46ed7d4f-5dc5-429c-b6bd-14c209fce16a,49114432-732e-4c68-adff-f1c32a63670b,4c1fe1ee-c277-48c4-a831-b684de5645b5,4e4d69e0-7c37-45c3-92e5-bc9753166b18,506e5809-a09c-45c3-a699-bc492b39410c,507215c6-6157-4213-bb1f-71df64714cfe,5289b68b-286b-4e23-8385-81c8401ca24a,536c5025-3b2b-46c9-97cb-dfc8c328f7b6,5458d49c-0ee8-4d50-bfe7-b8d06fcee918,55d6217d-3e7d-4f90-adde-43561d95bb24,58996e9e-282e-45e0-b393-6839d3c2ad59,5bb10c00-2011-456c-b475-38d97ee09443,5d4bc109-2c4d-4a4b-a375-c828cf1fc759,5d4f62df-6033-4f5b-8519-4d0ffdcdc2b1,5ecbd769-d818-4de4-9c0e-9d735f56b321,5f3a215d-ec28-414a-aa2c-0bb8a34e5bba,614adf82-4121-4a3d-893e-83b688acbc42,6180283f-8b9f-44b6-8f85-8d6a0daefa1b,644dffaa-17b3-46f8-bda3-09f2cee383f6,64bd8e2c-c650-497e-8753-017bc40ee8f5,66b9382c-f65b-4ddd-9263-315332228ba2,66e1300b-e136-4a6d-a781-40f3885d92bd,674914d9-6680-4f00-b005-e2cc595cd694,719c67b8-21a1-48c0-a44f-6c5f61f30c47,71d6ad29-4474-4dc4-8373-131fef40bf05,727f21ef-91c1-41a9-b4a9-67589ef6ae8b,771678e8-cda6-4153-a6cc-b3ac8d8cc074,80670820-5812 -4dd3-b064-34ccfb77e2c6,80b53ed3-fa2a-47ff-af8b-2d059e6e45c6,80eb11d0-a259-48a7-860d-d9ac1bf34586,8135def6-b4af-4aea-80ba-8609e1df735c,831e11dd-5c43-47fc-bce2-637a074585de,87755fb9-50c0-452e-beb3-3ffaea4bb316,8a8ca1a8-7c2b-4891-bf22-d0b2cfaeec4c,8b1e1dbf-3e53-49d3-8b55-f15ccb310bab,8cce3a8b-900a-4bcc-a724-d5a92a9eb996,8f441ad6-6b76-4f26-accb-ec2c277b440b,8fcbdb6d-b16b-4176-b64b-8886b936d91e,91e7acce-433a-46c9-a446-c1dbe14263e8,962979cf-c48c-4a71-bbf4-3d59d892257c,9f674d43-7f4e-4ec3-9a25-5e986d67329a,a0e1d1dd-922a-403d-8156-29c41e56b7c9,a49d4bc5-8942-4dcb-91ee-5f2d64a72c3d,a71c6213-89ea-480f-93a2-a9b8c6189e07,a838169d-a87a-4b0a-9c45-975135d2badd,a87d5fb5-674c-434b-8938-8098377f721b,abcb6dfb-0ad1-4c20-bb56-b23b7aa9c5e4,acb2fa6a-403d-4880-9139-769f260c8d1e,acc0f2c4-71b4-4ef6-b737-a8604f9e75d4,af14f0bf-2ead-417d-868a-f02e1b1d039c,b16c8eef-a221-48f2-9bd1-e4d7243988d0,b4329803-d0a8-4a50-9366-3a26122509b1,ba2e9f20-01b7-4202-9861-c3fa9101db84,bc2dcb65-f1b8-4d5b-ae08-f7f8a13519b2,bc90e9bc-4340-47ee-bcf4-ef957df2ef58,be841b29-9980-4387-b7c2-1ecdeb6ed3a8,be8ae065-9e01-4790-bfd1-6ead7d783e08,c45cb9a2-46eb-49e4-97c2-f331fb9ab42a,c49d8b1c-469a-4e59-bb5a-ee5f141a77e3,c4b4c7a3-24b0-489c-97e5-f381d7468497,ca8769ff-f7cf-4e04-86b2-201127584b45,cc629eb7-baa1-4810-be86-3cc428526841,d16cebbe-0ce6-493f-a6ff-c92d65423f8b,d47bb892-66d1-4f44-8da0-4cd984334340,d69e7bdd-f1a0-4295-91f5-b4ee6ee769f1,d7a7e1ef-fac6-4c6b-9aff-ba93456e5039,d886aace-5b25-4f77-8634-a6bd90b198f6,dce2fc2f-2c46-4ebf-90ca-8c17fb0a225d,dce46660-904c-4218-b7dc-e752d236c6a1,de795893-350a-431b-bd79-5bc0f0870d8d,dea6e11b-e860-4466-bb0c-e12c03b68c48,deac3a72-e1a1-4a73-8541-a7e52773b2bc,e14a0631-c318-4e27-b648-cf66edfe59c8,e3b95b6e-77f3-4083-9f00-f2cde7116d7b,e3c304 a5-3223-4b41-b5b2-ef38733f69d8,e4483160-37d6-4868-8ccb-cc9d8e3c6a6b,e4e20014-5619-4da0-a9bb-31701653d038,e7d4bb8f-7701-4649-9168-f71faa88b6f9,e8583923-1902-40cc-a0a7-c95c168b199b,e88e9a35-b122-435c-b964-0341dad40c6e,ea3ba003-03fe-4298-97ea-1742804515ca,ebd6d4b1-ac23-4a61-a7e7-9fd26c862143,ecc85947-671a-4a37-8b0d-7529187aece6,ed26cc31-17ac-4f0b-ab01-95809edc435c,ee9d4208-8e5c-43e5-aaaf-2f6072089101,f418921e-1ebd-436a-8aab-d75d93058a72,f7908e32-49ee-457a-9e85-eed171fc4e03,fc2ed4ec-c281-4262-a53c-1ffa396ecba9,ff4aa85e-5217-45f0-81e9-6f971845ddc8#CVR=29188645"}&lt;/param>&lt;/ref>', '2021-03-25 11:56:21 01', '0', '2021-03-25 11:56:21 01', NULL, 1, 'bc4eff8ae6ee493a9b2d58bc8ccca238', 'ba9fa71e9c734e00b93c0c29c1642450') was aborted: ERROR: value too long for type character varying(2000) Call getNextException to see other errors in the batch. ERROR: value too long for type character varying(2000)

 

 

DCS Trace. This same message repeats over and over.

 

 

[03/25/21 13:52:48.831]:DATACOLLSVC01 :DCSSubscriberShim: sED:: Attempting to send data over domain:8443/.../event [03/25/21 13:52:49.512]:DATACOLLSVC01 :DCSSubscriberShim: RESTConnection : Event data send to Data Collection Service returned code : 200 [03/25/21 13:52:49.513]:DATACOLLSVC01 :DCSShim: CacheReader:processBatch - Unexpected error while sending processing cache. Reason : java.lang.Exception: Error parsing JSON object. [03/25/21 13:52:49.531]:DATACOLLSVC01 :DCSSubscriberShim: sED:: Driver UUID is :f89cd000a814492fb7fcb86d3176dd99 [03/25/21 13:52:49.534]:DATACOLLSVC01 :DCSSubscriberShim: sED:: Attempting to send data over domain:8443/.../event

 

 

Probably because the part of the entitlement value is cut off? 

I'm also getting this in ndstrace, which is probably related. Again, repeating rapidly over and over.

 

 

java.lang.IllegalStateException: MapImpl 'com.microfocus.database.zoomdb.hashmap.HashMapImpl@DCS_EVENT_CACHE' is closed. at com.microfocus.database.zoomdb.map.MapImpl.ensureOpen(Unknown Source) at com.microfocus.database.zoomdb.map.MapImpl.values(Unknown Source) at com.novell.nds.dirxml.driver.dcsshim.persist.BatchFile.getBatchEvents(Unknown Source) at com.novell.nds.dirxml.driver.dcsshim.persist.CacheReader.processBatch(Unknown Source) at com.novell.nds.dirxml.driver.dcsshim.persist.CacheReader.run(Unknown Source) java.lang.IllegalStateException: MapImpl 'com.microfocus.database.zoomdb.hashmap.HashMapImpl@DCS_EVENT_CACHE' is closed. at com.microfocus.database.zoomdb.map.MapImpl.ensureOpen(Unknown Source) at com.microfocus.database.zoomdb.map.MapImpl.values(Unknown Source) at com.novell.nds.dirxml.driver.dcsshim.persist.BatchFile.getBatchEvents(Unknown Source) at com.novell.nds.dirxml.driver.dcsshim.persist.CacheReader.processBatch(Unknown Source) at com.novell.nds.dirxml.driver.dcsshim.persist.CacheReader.run(Unknown Source) java.lang.IllegalStateException: MapImpl 'com.microfocus.database.zoomdb.hashmap.HashMapImpl@DCS_EVENT_CACHE' is closed. at com.microfocus.database.zoomdb.map.MapImpl.ensureOpen(Unknown Source) at com.microfocus.database.zoomdb.map.MapImpl.values(Unknown Source) at com.novell.nds.dirxml.driver.dcsshim.persist.BatchFile.getBatchEvents(Unknown Source)

 

 

How should i handle this, because it seems to be preventing DCS events from being processed?

I don't see the particular event in the immediate queue of the driver, but might it come from somewhere else?

I am not very familiar with either the intricacies of the DCS driver or zoomdb, so i might be missing something obvious.

 

Any help and suggestions will be appreciated.