Public bug reported:
Tested in Evergreen 3.14.4
The issue appears to be related to the handling of table aliases within
the Angular reports interface and may be isolated to the Item Transit
table, specifically action.transit_copy, though broader impact is
possible.
A report template was configured using the Item Transit Source,
selecting transits within a specified date range and filtering by
selected source org unit(s). The template is designed to display the
source and destination org units associated with each transit.
Upon execution, the following database error is returned:
DBD::Pg::st execute failed: ERROR: table name
"d839d609421bbf9b2fffd9683986b202" specified more than once at
/opt/sequoia/apps/evergreen/bin/clark-kent.pl line 256.
This error results from the report generator assigning the same alias to
multiple joins of the same table. The SQL generated includes the same internal
alias more than once, causing a conflict during execution. A screenshot of the
generated SQL illustrates the duplicate alias issue.
** Affects: ubuntu
Importance: Undecided
Status: Invalid
** Attachment added: "Screenshot_20250407_103243.png"
https://bugs.launchpad.net/bugs/2106409/+attachment/5870062/+files/Screenshot_20250407_103243.png
** Changed in: ubuntu
Status: New => Invalid
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/2106409
Title:
Angular reports: Linking the same table twice is causing an error.
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+bug/2106409/+subscriptions
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
