When trying to perform a Partial Reload on QV Desktop:
It returns an error:
However normal reload works fine.
Mapping Tables are created during reload and removed when reload finishes. On the other hand, Partial Reload always ignores the LOAD statements that do not have "ADD" or "REPLACE" prefix.
As a result, when doing a Partial Reload, Mapping Tables are not created. But other statements such as "RENAME" still refers to the Mapping Tables -- there isn't any. That is why the error occurs.
To resolve this, we need to make sure Mapping Tables are created during both normal reload and Partial Reload by adding "ADD" prefix to their LOAD statement.
For more information regarding Partial Reload, please refer to Article #5334
To resolve the problem, simply add "ADD" prefix to the MAPPING LOAD statement for EVERY Mapping Table.