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.

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and save with the early bird rate—just $795!

Register now

Discussion stats
  • 0 replies
  • 1441 views
  • 0 likes
  • 1 in conversation