I'll try to explain the problem as best I can, but feel free to ask for clarification if you need it.
Basically, one table that I'm deploying to seems to be causing problems for DD. Log1.txt shows a successful deployment. It writes 2 elements to the FEATURES_TEST table in as it should. The elements are taken from a replicant container.
When I deploy a second DCR, as shown in log2.txt, instead of only updating the elements associated to its own file, it deletes every element in the FEATURES_TEST table and writes its own (none, in this case).
I've identified one line in the log that seems a little peculiar:
[html]
DBD: SelectCurrentRows
ELECT FEATURE,TO_CHAR(START_DATE,'MM/DD/YYYY') AS START_DATE,TO_CHAR(END_DATE,'MM/DD/YYYY') AS END_DATE,REPORDER,LOCATION_ID,ID FROM FEATURES_TEST ORDER BY ID
[/html]
It should have a WHERE clause (notice the 2 spaces before the ORDER BY clause, where there WHERE should be) to find only the relevant items in the table, but instead selects all elements and then deletes any which it can't find a match for in its DCR.
Anyone encountered anything similar or have any ideas of places to look?
Thanks,
jul
PS: Forgot to mention OD6.1, TS6.7.1SP1 on Solaris
