Intermittent 404 issues for customers who came from another DB engine #30243
Labels
Next LTS Release
Shortlisted of issues that will be included in the upcoming LTS
OKR : Customer Success
Owned by Arno
OKR : Customer Support
Owned by Scott
Priority : 1 Show Stopper
Team : Bug Fixers
Type : Defect
Parent Issue
#30000
Problem Statement
After getting the new logs, saw that the 404 was coming from the Identifier:
The code we use to get the identifier is the following:
core/dotCMS/src/main/java/com/dotmarketing/business/IdentifierFactoryImpl.java
Lines 145 to 176 in 5a7e977
Looking at the code, this column full_path_lc should be a function, not a column (at least in Postgres); for customers that were migrated from another DB engine, this was kept as a column and wasn't being filled.
Steps to Reproduce
Only Reproducible with customer data.
Acceptance Criteria
Pages and Files should return 200.
Create a UT that does the following:
1- Remove full_path_lc column:
2- Create the function if it doesn’t exists:
3- Create index (first check if exists):
dotCMS Version
22.03 LTS and 24.04 LTS.
Proposed Objective
Customer Success
Proposed Priority
Priority 1 - Show Stopper
External Links... Slack Conversations, Support Tickets, Figma Designs, etc.
https://helpdesk.dotcms.com/a/tickets/27067
Assumptions & Initiation Needs
No response
Quality Assurance Notes & Workarounds
No response
Sub-Tasks & Estimates
No response
The text was updated successfully, but these errors were encountered: