In agile plm if the user’s persoanl searches messes up, run the below query and check is the exact user ids are facings problems
select * from query where type=0 and id!=149;


If the same users are facing the problem, then run the following snippet in the lower environments and check if problem fixed and run the following scripts in PROD

drop table query_bk;
create table query_bk as select * from query where type=0 and id!=149;
drop table foldering_bk;
create table foldering_bk as select * from foldering ;
drop table criteria_bk;
create table criteria_bk as select * from criteria where query_id in (select id from query_bk);
drop table select_list_bk;
create table select_list_bk as select * from select_list where query_id in (select id from query_bk);

delete from foldering where folderid in (select id from folder where description=’Personal Searches’) and objectid not in (select id from query) and classid = 5;
delete foldering where objectid in (select id from query where type=0 and id !=149);
delete criteria where query_id in (select id from query where type=0 and id !=149);
delete select_list where query_id in (select id from query where type=0 and id !=149);
delete from query where type=0 and id!=149;
commit;