How do I resolve the error, ‘DRM_RW_Trigger: Open failed – path does not exist’ following a recent DRM upgrade?
1. Let’s start by trying to find the trigger causing the error. You can run this script against each database and it will return a list of triggers.
SELECT * FROM SysObjects WHERE XTYPE = ‘TR’ order by name
2. See if you can find the trigger in the list. If so, you can then try disabling the trigger. You will need to fill in the missing information.
ALTER TABLE xxx DISABLE TRIGGER yyy
Xxx will be the table name the trigger is applied to and yyy will be the trigger name. This information will be in the script result from #1.
Use this if you need to enable it again.
ALTER TABLE xxx ENABLE TRIGGER yyy
3. After disabling the trigger see if you still get the error. If not, then you should be able to drop the trigger.
drop trigger yyy
Yyy will be the trigger name.
If you do still receive the error, then please take a screen shot of it. Also, confirm if it is always the same error regardless if you are closing out of different GP windows. Send your information to support@rocktonsoftware.com for further assistance.