Failed to Update ServiceDesk from 14600 to 14830
Hi,
I am trying to update service desk from version 14600 to 14830 by following the instruction from https://www.manageengine.com/products/service-desk/on-premises/service-packs.html
but the update always failed at migrating constrains and indexes (around 8%)
2025-01-31 15:38:05 +07 [15523] : [9444] : [740]STATEMENT: CREATE INDEX workordertodescription_fk_idx ON public.workordertodescription USING btree (workorderid);
2025-01-31 15:38:07 +07 [0] : [9444] : [741]ERROR: there is no unique constraint matching given keys for referenced table "adsadsyncobjects"
2025-01-31 15:38:07 +07 [0] : [9444] : [742]STATEMENT: ALTER TABLE ONLY public.adsadsyncobjattributes
ADD CONSTRAINT adsadsyncobjattributes_fk FOREIGN KEY (object_id) REFERENCES public.adsadsyncobjects(object_id) ON DELETE CASCADE;
2025-01-31 15:38:07 +07 [0] : [9444] : [743]ERROR: there is no unique constraint matching given keys for referenced table "adsadsyncobjects"
2025-01-31 15:38:07 +07 [0] : [9444] : [744]STATEMENT: ALTER TABLE ONLY public.adsadsyncobjvsmanadatorysync
FYI I am using Postgresql database
Thank you