Analytical Engine Running for more than 12+ hrs in PROD. Works OK in UAT instance

Hi All,

We need URGENT Help.

We have a GO LIVE  impacted as the Analytical Engine is running for more than 12+ hrs in PROD. It completes in UAT instacne in less tahn 2 hrs.

Upon checking we find two profiles do not exist in PROD for Init_params_0 or Init_Params_1. These exist in UAT instance for either init_params_0 or Init_params_1.

 

select  * from dem7302.init_params_1 where  pname like 'last_date_backup'

--Does not exist

 

select  * from dem7302.init_params_1 where pname like 'resetforevals'

----Does not exist

 

select * from dem7302. init_params_1 where pname like 'runinsertunits'

----Does not exist