Hi,
i'm facing a similar problem as discussed with replicant column. when the faq table is already built and i deploy a new dcr to the table , it gives me the following error...
ERROR:
*******************************************************
SQLException occured in TDbSchemaGroupCfg
Exception Message: ORA-00001: unique constraint (INTERWOVEN.CZ_FAQ_KEY) violated
Vendor Error Code: 1
SQL state: 23000
*******************************************************
*******STACK TRACE*************
ERROR
oUpdate() failed for group [cz_faq].
-- Failed
ERROR:WriteTuple failure to consumer[0]
--------------------------------------------------
the following is my .cfg file ...
<column name="family" data-type="VARCHAR2(100)" value-from-field="family" allows-null="yes" is-url="no"/>
<column name="categories" data-type="VARCHAR2(150)" value-from-field="categories" allows-null="yes" is-url="no"/>
<column name="locale" data-type="VARCHAR2(2)" value-from-field="locale" allows-null="yes" is-url="no"/>
<column name="language" data-type="VARCHAR2(2)" value-from-field="language" allows-null="yes" is-url="no"/>
<column name="title" data-type="VARCHAR2(2000)" value-from-field="title" allows-null="yes" is-url="no"/>
<column name="question" data-type="CLOB" value-from-field="faq/[0-34]/question" is-replicant="yes" allows-null="no" is-
url="no"/>
<column name="answer" data-type="CLOB" value-from-field="faq/[0-34]/answer" is-replicant="yes" allows-null="yes" is-url
="no"/>
<column name="faqid" data-type="VARCHAR2(50)" value-from-field="faq/[0-34]/faqid" is-replicant="yes" allows-null="no"
is-url="no"/>
<column name="rep_order" data-type="VARCHAR2(50)" value-from-field="not-used" allows-null="no" replicant-order-column="
yes"/>
</attrmap>
<keys>
<primary-key>
<key-column name="faqid"/>
<key-column name="rep_order"/>
</primary-key>
</keys>
could someone give me suggestions as to how to go about it...
Thanks
