Involvement: cannot bulk load for Change Initiatives

[davidwatkins73]

Description

Attempting to bulk load involvements gives an error:

14:19:31.219 [qtp1440558136-19] ERROR org.finos.waltz.web.Main - Illegal Argument Exception: Cannot find lookup map for id for entity kind: CHANGE_INITIATIVE
java.lang.IllegalArgumentException: Cannot find lookup map for id for entity kind: CHANGE_INITIATIVE
	at org.finos.waltz.data.EntityAliasPopulator.fetchEntityIdLookupMap(EntityAliasPopulator.java:61)
	at org.finos.waltz.service.bulk_upload.BulkUploadService.resolveInvolvements(BulkUploadService.java:141)
	at org.finos.waltz.service.bulk_upload.BulkUploadService.resolve(BulkUploadService.java:56)
	at org.finos.waltz.web.endpoints.api.BulkUploadEndpoint.resolveRoute(BulkUploadEndpoint.java:81)
	at org.finos.waltz.web.endpoints.EndpointUtilities.lambda$wrapListHandler$0(EndpointUtilities.java:100)
	at spark.ResponseTransformerRouteImpl$1.handle(ResponseTransformerRouteImpl.java:47)
	at spark.http.matching.Routes.execute(Routes.java:61)
       ...snip...
	at java.lang.Thread.run(Thread.java:748)

Waltz Version

1.47

Steps to Reproduce

Upload a sample file to the bulk invovlement editor

Expected Result

Involvements are created

Actual Result

Error thrown

[davidwatkins73]

Fails for Org units too.

Tasks:

• fix for CI
• fix for OU

[davidwatkins73]

Some stuff for test data generation:

-- first needed to set some ext ids on the demo org unit table
    
-- update organisational_unit set external_id = concat('OU_', id);


-- generate junk ou involvements
select ou.external_id, p.email
from organisational_unit ou
cross join person p
where p.id = ou.id
limit 100;

-- generate junk ci involvements
select ci.external_id, p.email
from change_initiative ci
         cross join person p
where p.id = ci.id
limit 100;


-- generate junk app involvements
select app.asset_code, p.email
from application app
         cross join person p
where p.id = app.id
limit 100;