Clearing promotion reference in main session table when promotion is deleted -refs #6215