Query gets inactive while moving from SAP BW 7.0 to SAP BW 7.4

Hi Team,

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’ .

Before: –

After :-

Now, query gets activate. Kindly run through RSRT and check.

Thanks,

Chandresh