I have a couple of scripts which update the usp_lrel_asset_chgnr table in order to automatically attach CIs to Change Orders. Due to the amount of our CIs per CO, it saves about 3 hours of manual work to run these two scripts. The problem is I have to increment the id field in that table within my script, leaving SDM in a state where the cache needs to be updated with the pdm_key_refresh command.
this can cause data corruption. I've not had any issues in test, and have needed to run it once in production.
Can anyone speak to the actual dangers of running this command twice on a weekly basis?
Thanks in advance,