SQL deletion of metadata

Hi there

TS 6.7.1, OD 6.02.

We are deploying data to a SQL database, but when DCR records are moved or deleted, the associated metadata isn't removed from the db. We have the relevant deployment in dd.xml, and OD picks this up OK. What doesn't appear in the logs is the delete statement which I'd expect to see. So, my question is where are these queries formed? I've gone through the (somewhat confusing) documentation, but haven't found the answer.

Thanks in advance for your help

Paul

Find more posts tagged with

Comments

dazzlad

This is always a great deal of fun.

It may help to post your dd.xml here.

Are you using 'path' as the primary key of your root group?

nakumar

Are you using DAS or standalone DD deployments?

prof_brazen_guff

Thanks for the responses, copy of dd attached. We're using standalone deployments.

Any advice gratefully received as this one is driving me insane!

Paul