use hspc_5_utdhstage;
A resource that has this problem:
select * from HFJ_RESOURCE where res_id=19073;
select pid, RES_DELETED_AT, RES_ID, RES_TYPE, RES_VER, FORCED_ID_PID from HFJ_RES_VER where RES_ID = 19073;
A resource that doesn't have this problem:
select * from HFJ_RESOURCE where res_id=19235;
select pid, RES_DELETED_AT, RES_ID, RES_TYPE, RES_VER, FORCED_ID_PID from HFJ_RES_VER where RES_ID = 19235;