SA / GDC: Locations in GDC security profile can be deleted

Problem Symptoms:

• Previewing record set with associated Data Change Rule sets results in error message: "Failed to retrieve preview records."
• Global Data Change data change jobs fail or don't complete

Defect Status

Issue 16384-18017/VYG-456 is fixed in Voyager 8.1.2.

If you are experiencing the symptoms above, contact Voyager Support for assistance.

Replication steps:

1. In SysAdmin, create a new location in System > Locations. Note the location_id for this new location in the database.
2. Add the newly created location to a GDC Security profile in Security > GDC Security Profiles > [profile].
3. Go back to the Locations area and delete the location; location will be deleted
4. In the database, query for the location_id in the security profile: select * from gdc_security_locs where location_id=[location_id from first step];
5. Note that the rows associating the deleted location with the security profile are still in the database.
6. If you go into GDC and use the Preview tab to preview a data change, get "Failed to retrieve preview records"
7. If you try to run a data change job, job will remain in a status of "Running" in the Job Management, but will fail & not complete, and will log ERROR com.exlibris.voyager.jobd.JobExecutor - Job Failed to run properly: null in jobd.log

Workaround

Going forward, ensure that the location is moved from Selected to Available in all GDC Security Profiles prior to deleting in SysAdmin.

• Article last edited: 04-Feb-2014