Anyone have an idea why query builder would be just spinning. How would I fix this? This is on IFS10 UPD8
Solved
Query Builder spinning
Best answer by astark
Thank you to everyone that has responded to this post. That has resulted in finally getting a solution. Here is what has our query builder now running:
run the following:
--------------------------------------------
declare
lu_name_ VARCHAR2(30);
pck_ VARCHAR2(2000);
begin
FOR rec_ IN (SELECT lu_name lu_name FROM dictionary_sys_tab) LOOP
BEGIN
lu_name_ := rec_.lu_name;
pck_ := Dictionary_SYS.Get_Base_Package(lu_name_);
EXCEPTION
WHEN OTHERS THEN
Dbms_Output.Put_line(lu_name_);
END;
END LOOP;
end;
-----------------------------------
If you get data back you have to change the LU name in the view in the comment section for all invalid lu names,
i.e. FROM:
COMMENT ON TABLE AGRX1APP.AGR_RESOURCE_EMP_LOAD_CAPACITY IS 'LU=AGR_RESOURCE_EMP_LOAD_CAPACITY^PROMPT=AGR_RESOURCE_EMP_LOAD_CAPACITY^MODULE=CUSOBJ^';
TO:
COMMENT ON TABLE AGRX1APP.AGR_RESOURCE_EMP_LOAD_CAPACITY IS 'LU=AgrResrceEmpLoadCapacity^PROMPT=Agr Resrce Emp Load Capacity^MODULE=CUSOBJ^';
If you do not get anything, execute the following script
-----------------------------
BEGIN
Dictionary_SYS.Rebuild_Dictionary_Storage_(0,'FULL'); COMMIT;
END;
----------------------------
Then refresh all the caches in refresh server caches in IFS.
This topic has been closed for comments
Hope you have a good Christmas.
Great, that should help show that this is just not an isolated issue. What oracle version are you on? We are on 19c.
Merry Christmas to you as well!
Hi
Unfortunately no, IFS is having a hard time figuring it out. They think it might be due to an Oracle version issue (we are on 19c) so I don't know what you are running but I would definitely put up a ticket and you can reference our ticket number G2223598 so they know there is another customer with the same issue.
Hopefully with more customers experiencing the problem a resolution can be reached. We just upgraded to IFS10 UPD10 as well.
Anne
Thank you for the quick response Anne!
I will be sure to bring this up with my team today, and try to get another ticket with IFS open.
+15Hi
Could you please have a look at the response which I posted on the following question,
You might be having a similar issue.
Cheers !
Dhananjaya.
Thank you to everyone that has responded to this post. That has resulted in finally getting a solution. Here is what has our query builder now running:
run the following:
--------------------------------------------
declare
lu_name_ VARCHAR2(30);
pck_ VARCHAR2(2000);
begin
FOR rec_ IN (SELECT lu_name lu_name FROM dictionary_sys_tab) LOOP
BEGIN
lu_name_ := rec_.lu_name;
pck_ := Dictionary_SYS.Get_Base_Package(lu_name_);
EXCEPTION
WHEN OTHERS THEN
Dbms_Output.Put_line(lu_name_);
END;
END LOOP;
end;
-----------------------------------
If you get data back you have to change the LU name in the view in the comment section for all invalid lu names,
i.e. FROM:
COMMENT ON TABLE AGRX1APP.AGR_RESOURCE_EMP_LOAD_CAPACITY IS 'LU=AGR_RESOURCE_EMP_LOAD_CAPACITY^PROMPT=AGR_RESOURCE_EMP_LOAD_CAPACITY^MODULE=CUSOBJ^';
TO:
COMMENT ON TABLE AGRX1APP.AGR_RESOURCE_EMP_LOAD_CAPACITY IS 'LU=AgrResrceEmpLoadCapacity^PROMPT=Agr Resrce Emp Load Capacity^MODULE=CUSOBJ^';
If you do not get anything, execute the following script
-----------------------------
BEGIN
Dictionary_SYS.Rebuild_Dictionary_Storage_(0,'FULL'); COMMIT;
END;
----------------------------
Then refresh all the caches in refresh server caches in IFS.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.