[MGRENTITLE-26] mgr-tenant-entitlements - Keycloak resources creation issue Created: 29/Jan/24  Updated: 31/Jan/24  Resolved: 31/Jan/24

Status: Closed
Project: mgr-tenant-entitlements
Components: None
Affects versions: None
Fix versions: 1.0.1

Type: Bug Priority: P3
Reporter: Oleksandr Oliinyk Assignee: Oleksandr Oliinyk
Resolution: Done Votes: 0
Labels: back-end, epam-eureka, eureka-phase4, need-review
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original estimate: Not Specified

Attachments: PNG File image-2024-01-31-17-50-42-876.png     PNG File image-2024-01-31-18-45-22-882.png     PNG File image-2024-01-31-18-46-00-891.png    
Issue links:
Gantt End to Start
has to be done before MGRENTITLE-29 Release mgr-tenant-entitlements v1.0.1 Open
Sprint: Eureka Sprint 45
Story Points: 2
Development Team: Eureka

 Description   

Overview

Keycloak resource creation fails if:

1. folio_permissions attribute value is longer than 255 symbols (it's the case for /batch-voucher-storage/export-configurations/{id}/credentials)

2024-01-29 10:44:58,255 WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (executor-thread-21) SQL Error: 0, SQLState: 22001
2024-01-29 10:44:58,255 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (executor-thread-21) ERROR: value too long for type character varying(255)
2024-01-29 10:44:58,256 WARN  [com.arjuna.ats.arjuna] (executor-thread-21) ARJUNA012125: TwoPhaseCoordinator.beforeCompletion - failed for SynchronizationImple< 0:ffffac12000b:ab2d:65b75dd3:169e, org.hibernate.resource.transaction.backend.jta.internal.synchronization.RegisteredSynchronization@13d4bd58 >: org.hibernate.exception.DataException: could not execute statement [ERROR: value too long for type character varying(255)] [insert into RESOURCE_ATTRIBUTE (NAME,RESOURCE_ID,VALUE,ID) values (?,?,?,?)] 

2. an endpoint has additional handler in system interfaces such as _timer (i.e. /eholdings/loading/kb-credentials has _timer handler)



 Comments   
Comment by Yauhen Viazau [ 31/Jan/24 ]

Verified on "evrk" env - works as expected

Tested by adding entitlement for "app-platform-complete" application, which includes both cases mentioned in the description

Both resources mentioned in the description are shown in keycloak:

Generated at Thu Feb 08 22:18:31 UTC 2024 using Jira 1001.0.0-SNAPSHOT#100246-sha1:7a5c50119eb0633d306e14180817ddef5e80c75d.