we have install the demand server and client recently (APP9) and willing to use for or business.
very simple SQL statement has been written as the master flow to check whether its working!
Select contract, part_no, planned_date, planned_qty from IFSAPP.external_invent_part_issue_pub where contract = 'ABC' and Customer_No ='99999'
when I ran this above SQL it in our environment via SQL developer, it returns with 50 records in 6-7 seconds.
but when I ran the “Qualify” job via the Server Dashboard, it takes 25,000 s ( almost 7 hours)- Strange!
I would expect the qualify job will create the IFS forecast parts records with in the similar time frame like SQL developer query. can not understand why this was taking hours??
really appreciate anyone has any suggestions or thoughts?