BookmarkSubscribeRSS Feed
🔒 This topic is locked. We are no longer accepting replies to this topic. Need further help? Please sign in and ask a new question.
SAS_TSNEWS
Moderator

UPDATE: a patch is now available. See the SAS note for details.

Description

KB0042055:   ReportServiceGroup fails to initialize and "DatabaseException...." occurs after upgrade to SAS® Viya® Stable 2025.07

 

Symptoms

In this scenario, the following symptoms occur:

  • SAS® Visual Analytics reports stop responding during the Opening report step. 
  • The sas-report-services-group pod fails to start.
  • Any table in the reportservicesgroup database schema might be impacted and referenced in an error.
  • Database Exceptions such as the following are present in the sas-report-services-group pod log:
 liquibase.exception.DatabaseException: ERROR: could not create unique index "report_data_pk"  Detail: Key (report_id)=(576160ef-d652-463c-b0dc-f0ada4a2fbd0) is duplicated. [Failed SQL:  (0) ALTER  TABLE reportservicesgroup.report_data ADD CONSTRAINT report_data_pk  PRIMARY KEY (report_id)]

 

Affected Environments

You encounter this issue if the following is true:

  • You initially installed your SAS Viya LTS or Stable release at 2024.06 or earlier. 
  • You upgrade to SAS Viya Stable 2025.07.

See SAS support article KB0042055 for more guidance and next actions.