64353 - SAS® Visual Analytics reports can become corrupted after editing a data source join or an aggregated data source

Problem Note 64353: SAS® Visual Analytics reports can become corrupted after editing a data source join or an aggregated data source

After editing a data source join or aggregated data source in a SAS Visual Analytics report, you might find that the report can no longer be saved manually. Automatic saves might still occur. If the automatic save occurs, you might find that the report no longer opens in SAS Visual Analytics or SAS^® Report Viewer. For example, when saving the report, you might see the following error:

In the Reports service log, you might see errors similar to the following when saving or opening the report:

2019-06-19 10:13:59.643 ERROR 3076 --- [uto-1-exec-1019] com.sas.bireport.models.ReportElement    : sasdemo(44c9cbe0) [aa885173eef8fc83] Unexpected second use of unique name bi32 on elements of type DataItem and DataItem

2019-06-19 10:13:59.643 ERROR 3076 --- [uto-1-exec-1019] com.sas.bireport.models.ReportElement    : sasdemo(44c9cbe0) [aa885173eef8fc83] Unexpected second use of unique name bi32 on elements of type DataItem and DataItem

2019-06-19 10:13:59.643 ERROR 3076 --- [uto-1-exec-1019] com.sas.bireport.models.ReportElement    : sasdemo(44c9cbe0) [aa885173eef8fc83] -----------> The previous error is FATAL.

2019-06-19 10:13:59.643 ERROR 3076 --- [uto-1-exec-1019] com.sas.bireport.models.ReportElement    : sasdemo(44c9cbe0) [aa885173eef8fc83] -----------> The previous error is FATAL.

2019-06-19 10:13:59.644  WARN 3076 --- [uto-1-exec-1019] com.sas.bireport.models.ReportElement    : sasdemo(44c9cbe0) [aa885173eef8fc83] One or more fatal errors occurred while attempting to open the report.

2019-06-19 10:13:59.645 ERROR 3076 --- [uto-1-exec-1019] c.s.r.p.ReportContentsController         : sasdemo(44c9cbe0) [aa885173eef8fc83] [ERROR_FAILED_UPDATE_fmt] A system error occurred. Action: PUT content (json/json) (Identifier: ea5a5fd6-3845-4ff2-8691-3d5a275f789c) - The update failed.

com.sas.report.service.commons.logging.StackDecoratedThrowable: Root Cause:          java.lang.Exception: One or more fatal errors occurred while attempting to open the report.

        at com.sas.bireport.models.xml.XML.readReport(XML.java:660)

        at com.sas.bireport.models.xml.XML.readReport(XML.java:456)

        at com.sas.bireport.models.util.ReportXmlUtil.convertXml2XmlVersion(ReportXmlUtil.java:332)

...

Which Caused:        java.io.IOException: One or more fatal errors occurred while attempting to open the report.

        at com.sas.bireport.models.xml.XML.readReport(XML.java:674)

        at com.sas.bireport.models.xml.XML.readReport(XML.java:456)

        at com.sas.bireport.models.util.ReportXmlUtil.convertXml2XmlVersion(ReportXmlUtil.java:332)

To repair the report, an administrator should export the report from SAS^® Environment Manager and send the .json export file to SAS Technical Support.

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
Product Family	Product	System	Reported	Fixed*	Reported	Fixed*
SAS System	SAS Visual Analytics	Cloud Foundry	8.3	8.4	Viya	Viya
		Linux for x64	8.3	8.4	Viya	Viya
		Microsoft® Windows® for x64	8.3	8.4	Viya	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.

Type:	Problem Note
Priority:	high

Date Modified:	2019-08-21 14:50:49
Date Created:	2019-06-19 09:55:06