SUPPORT / SAMPLES & SAS NOTES
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)
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)
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 | ||