We have faced the issue that when we are moving query from SAP BW 7.0 to BW 7.4, it gets inactive.
Solution : Change the CACHEMODE to “Local Database”
Goto Tcode : se11 –> Enter table name RSRREPDIR –> Enter CompId –> Execute
Then Edit the CACHEMODE column and change it to ‘D’ .
Now, query gets activate. Kindly run through RSRT and check.