COMBO_DATA_TBL missing data for departments after upgrade from 9.1 to 9.2

 

Good Afternoon

 

To those who have upgraded from 9.1 to 9.2, has your combo edits (PS_COMBO_DATA_TBL) data gone missing (not all of them)?

 

select A.DEPTID,A.DESCR,A.MANAGER_ID FROM PS_DEPT_TBL A WHERE A.EFF_STATUS = 'A' AND NOT EXISTS (SELECT * FROM PS_COMBO_DATA_TBL WHERE  A.DEPTID = DEPTID) 

AND A.EFFDT = (SELECT MAX(A1.EFFDT) FROM PS_DEPT_TBL A1 WHERE A.DEPTID = A1.DEPTID AND A1.EFFDT <= GETDATE())

 

If so, what did it and how you resolved it please?

 

This has clearly stumped us as there are no customizations and the data which went missing was very much available in our old production.