Problem Note 63235: The sas-viya-reportdistribution-default service fails to start after SAS® Visual Analytics is upgraded
 |  |  |  |  |
After you upgrade SAS® Visual Analytics 8.2 to SAS® Visual Analytics 8.3, the sas-viya-reportdistribution-default service might fail to start if there are existing report distributions. When this problem occurs, you see an error similar to the following in the sas-reportdistribution log:
2018-09-19 13:22:10.169 ERROR 376 --- [ main]
liquibase :
service classpath:/db/changelog/db.changelog-master.yaml:
classpath:/db/changelog/db.changelog-master.yaml::
add-transform-to-reports-list::SAS:
Change Set classpath:/db/changelog/db.changelog-master.yaml::
add-transform-to-reports-list::SAS failed.
Error: ERROR: column "report_request_id" contains null values
[Failed SQL: ALTER TABLE reportdistribution_provider.REPORTS_LIST
ADD REPORT_REQUEST_ID VARCHAR(36) NOT NULL]
liquibase :
service classpath:/db/changelog/db.changelog-master.yaml:
classpath:/db/changelog/db.changelog-master.yaml::
add-transform-to-reports-list::SAS:
Change Set classpath:/db/changelog/db.changelog-master.yaml::
add-transform-to-reports-list::SAS failed.
Error: ERROR: column "report_request_id" contains null values
[Failed SQL: ALTER TABLE reportdistribution_provider.REPORTS_LIST
ADD REPORT_REQUEST_ID VARCHAR(36) NOT NULL]
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Visual Analytics | Linux for x64 | 8.3 | 8.4 | Viya | Viya |
| Microsoft® Windows® for x64 | 8.3 | 8.4 | Viya | Viya | ||
An update for this issue is available for SAS Viya 3.4. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.4 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.4&softwareContextId=softwareUpdates
If you have existing report distributions, the sas-viya-reportdistribution-default service might fail to start after you upgrade from SAS® Visual Analytics 8.2 to SAS® Visual Analytics 8.3.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2019-01-02 16:49:44 |
| Date Created: | 2018-11-15 13:30:02 |