When the Solarwinds backup is failing with the error “UNIQUE constraint failed: Node.NodeId, Node.SessionId. Error code: 19:2067 (constraint failed)” while trying to backup the location “D:\oracle\Temp” this is because the files are being locked while trying to run the job. To resolve this error, please exclude this folder by using these instructions:

  1. Launch the Backup Manager client on the  specific server by going to the browser and entering http://localhost:5000.
  2. Click on the Backup tab.
  3. On the Files and Folders section, click on Edit.
  4. Browse from there to the specific location you’re looking for, in this case the D:\ORA\temp folder and uncheck the box to exclude it.
  5. Then start a manual backup.