We are facing an issue where when we re-xog a dynamic lookup with changed sql the dynamic lookup is getting corrupted i.e. Internal Name and hidden key of the lookup is getting blank though xog result is showing success
After that even if i use the original lookup to xog or use the original query back it is not getting restored though here too xog result is showing success
Is there a way to restore this anyhow without obviously using the old backup / cloning entire DB from working environment
Also please confirm if if the issue is happening because the first field of the sql is getting changed in the changed sql than the original one
Sounds BUGGY - don't normally have any problem XOG-ing in changes to dynamic lookups.
(sorry don't have an answer as to "how to fix" - if it is a known BUG at your version support might know, i.e. raise a support call)
When I asked support they are not able to help properly and again they are suggesting me for cloning
What version of CA PPM ore you on? Do you have an example of the XOG that is giving you problems?