nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

deploying replicant order column

System

i'm having an error with such portion of cofiguration in a user defined schema deployment :
<group name="replicants" table="CMS_CONS_IRRG_REP" root-group="no">
<attrmap>
<column name="PATH" data-type="VARCHAR(255)" value-from-field="path"/>
<column name="TITRE" data-type="VARCHAR(255)" value-from-field="txt_consigne/0/consignes/[0-13]/cti_n" is-replicant="yes"/>
<column name="REPORDER" data-type="NUMBER(30)" value-from-field="not-used" allows-null="yes" replicant-order-column="yes"/>
</attrmap>
<keys>
<primary-key>
<key-column name="PATH"/>

</primary-key>
<foreign-key parent-group ="irregularite">
<column-pair parent-column="PATH"/>

</foreign-key>
</keys>
</group>

has anyone tried a deployment of replicant order numbers ?
any sample will be welcome

thanks

Find more posts tagged with

Comments

Migrateduser

what's the error you are getting?

Migrateduser

Well Arm,
after some modifications here's teh errors i get :

INSERT:INSERT INTO CMS_CONS_IRRG_REV(CMS_CONS_IRRG_FRGN,STITRE,STEXTE,SDUREE,SDATE_REVISION,INUMERO_REVISION) VALUES (?,?,?,?,?,?)
Column: CMS_CONS_IRRG_FRGN, field: path, Index: 1,Converting 'templatedata/consignes/consigne_irregularites/data/consigne_irreg_03_fr.dcr' to VARCHAR
Column: STITRE, field: txt_consigne/0/consignes/1/cti_n, Index: 2,Converting 'Consigne 3- version 2' to VARCHAR
Column: STEXTE, field: txt_consigne/0/consignes/1/ctx_n, Index: 3,Converting '<p>Contenu de la consigne irrégularité numéro 3 version 2
' to VARCHAR
Column: SDUREE, field: txt_consigne/0/consignes/1/cti_n, Index: 4,Converting 'Consigne 3- version 2' to VARCHAR
Column: SDATE_REVISION, field: txt_consigne/0/consignes/1/ctd_n, Index: 5,Converting '' to VARCHAR
Column: INUMERO_REVISION, field: not_used, Index: 6,null
-- Updated

As u can see we get a null value for INUMERO_REVISION

*************************

the child group for replicants is the following one now :
<group name="replicants" table="CMS_CONS_IRRG_REV" root-group="no">
<attrmap>
<column name="CMS_CONS_IRRG_FRGN" data-type="VARCHAR(3209)" value-from-field="path"/>
<column name="STITRE" data-type="VARCHAR(160)" value-from-field="txt_consigne/0/consignes/[0-13]/cti_n" is-replicant="yes"/>
<column name="STEXTE" data-type="VARCHAR(4000)" value-from-field="txt_consigne/0/consignes/[0-13]/ctx_n" is-replicant="yes"/>
<column name="SDUREE" data-type="VARCHAR(150)" value-from-field="txt_consigne/0/consignes/[0-13]/cti_n" is-replicant="yes"/>
<column name="SDATE_REVISION" data-type="VARCHAR(200)" value-from-field="txt_consigne/0/consignes/[0-13]/ctd_n" is-replicant="yes"/>
<column name="INUMERO_REVISION" data-type="NUMBER(9)" value-from-field="not_used" replicant_order_column="yes"/>
</attrmap>
<keys>
<primary-key>
<key-column name="CMS_CONS_IRRG_FRGN"/>

</primary-key>

<foreign-key parent-group ="irregularite">
<column-pair parent-column="CMS_CONS_IRRG_PK"/>
<column-pair child-column="CMS_CONS_IRRG_FRGN"/>
</foreign-key>
</keys>
</group>

******************************************
We don't get a null pointer exception now - it was my previous error - but null values inserted in the column INUMERO_REVISION

thanks Miky

Migrateduser

Change replicant_order_column="yes" to replicant-order-column="yes" (replace underscore with hyphen and retry). .. Or was it just a typo in the posting?

Migrateduser

Arm...
replacing underscore with an hyphen generates a null pointer exception so ...

Migrateduser

please send me all the necessary reproduction information (config file, sample data, log outputs) throug private email. Thanks.

Migrateduser

Hi Arm,
well it works now but not really convenient for our purpose
many thanks
take care

Migrateduser

Did you have a resolution to this problem, as I have the same problem, when I try to deploy, the error message tells me that
buildreplicantorder fails, as it is a null value, even though in the dcr there are two replicants and I have set allow nulls to no in the DD.cfg.

Migrateduser

it would help to see the config file and the log file. you can either post it or send through private email.

Michael

Hey Miky
Any chance you could explain the resolution. We are having (what looks like) the same problem.
Cheers,
Michael

Migrateduser

Hi,
i'm facing a similar problem. 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 Smiley Very Happy

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