62965 - A SAS® Visual Investigator upgrade fails with a TDCUnhandledServerException and a ValidationException

Problem Note 62965: A SAS® Visual Investigator upgrade fails with a TDCUnhandledServerException and a ValidationException

After you try to upgrade from SAS^® Visual Investigator 10.3.1 to SAS^® Visual Investigator 10.4, the upgrade might fail and the following exceptions appear in the logs.

A TDCUnhandledServerException appears in the svi-alerts log:

com.sas.fcs.tdc.exceptions.TDCUnhandledServerException: Error response from REST PUT. Status Code: 400 {"errorCode":"DH3708","message":"The following item cannot be changed: relationship internal status","version":1,"httpStatusCode":400}

at com.sas.fcs.tdc.rest.util.ExceptionHelper.logAndThrowHttpClientErrorException(ExceptionHelper.java:419)

at com.sas.fcs.tdc.services.util.RestTemplateUtils.putObject(RestTemplateUtils.java:157)

at com.sas.fcs.tdc.services.datahub.DatahubStoredObjectService.upsertStoredObject(DatahubStoredObjectService.java:87)

at com.sas.fcs.tdc.install.AlertStoredObjectInstaller.createStoredObject(AlertStoredObjectInstaller.java:70)

at com.sas.fcs.tdc.install.AlertStoredObjectInstaller.execute(AlertStoredObjectInstaller.java:58)

A ValidationException appears in the datahub log:

 2018-08-29T16:02:50.34-0400 [APP/PROC/WEB/0] OUT 2018-08-29 20:02:50.347 DEBUG 10 --- [nio-8080-exec-5] c.s.f.d.c.DataHubExceptionHandler        : sas.svi-alert@@cyberdyne [63c17e6908711569] The following item cannot be changed: relationship internal status

   2018-08-29T16:02:50.34-0400 [APP/PROC/WEB/0] OUT com.sas.fcs.datahub.ValidationException: The following item cannot be changed: relationship internal status

   2018-08-29T16:02:50.34-0400 [APP/PROC/WEB/0] OUT   at com.sas.fcs.datahub.core.services.validator.RelationshipValidator.checkManaged(RelationshipValidator.java:275)

   2018-08-29T16:02:50.34-0400 [APP/PROC/WEB/0] OUT   at com.sas.fcs.datahub.core.services.validator.RelationshipValidator.validate(RelationshipValidator.java:104)

   2018-08-29T16:02:50.34-0400 [APP/PROC/WEB/0] OUT   at com.sas.fcs.datahub.core.services.validator.StoredObjectValidator.lambda$checkRelationshipsToThisObject$7(StoredObjectValidator.java:678)

   2018-08-29T16:02:50.34-0400 [APP/PROC/WEB/0] OUT   at java.util.ArrayList.forEach(ArrayList.java:1257)

   2018-08-29T16:02:50.34-0400 [APP/PROC/WEB/0] OUT   at com.sas.fcs.datahub.core.services.validator.StoredObjectValidator.checkRelationshipsToThisObject(StoredObjectValidator.java:677)

The upgrade fails when Alerts entities have a managed relationship.

Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.

Verify That the Update Is Installed

To verify that the fix is installed, run the following rpm command:

rpm -qa | grep sas-svi-visual-investigator-7.1.56

To complete this process, make sure that the package version that is shown in the rpm output either matches or is newer than 7.1.56 with the following command:

rpm -qi sas-svi-visual-investigator

Additional Assistance

If you need additional assistance, contact SAS Technical Support.

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SAS System	SAS Visual Investigator	Linux for x64	10.4		Viya

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

Date Modified:	2018-10-04 11:56:13
Date Created:	2018-09-20 15:14:20

Type:	Problem Note
Priority:	alert