DD fails when renaming a file

kajjubee

Hi experts,
We use DD to deploy content in the DCR to the DB. The primary key is set as the file_id in the DD script and the DB. However when we deploy, this is what I see in the logs:
DBD: RowsExistForPathELECT COUNT(*) FROM fileinfo WHERE file_path = ?

Is this a default behavior of DD to search the records based on file_path but not the real primary key (file_id in our case)?

The problem with the above is when we rename a file, eventhough the file_id remains the same, the above query is run resulting in an insert because the new file_path doesn't exist. (It should have found the file_id instead and done an update). This fails because the file_id, being the primary key already exists.

Anyway to change this behavior of the above query( built-in?) to look for file_id instead of file_path like :
SELECT COUNT(*) FROM fileinfo WHERE file_id = ?

The result of this would be accurate as even if we change the file_path, it should update and not insert...

Any ideas?

Thanks,
K

Platform:
TeamSite 6.7.1, Solaris 9
OD 6.1.1

kajjubee

This is what I got from support:
By default, a column mapped to a path variable is the PK unless delete-tracker is set to "yes"

Also this article might be helpful:
https://support.interwoven.com/kb/kb_show_article2.asp?ArticleID=57589

cheers,
K