dbschema.cfg - adding new column

I've added the following new field in a DCT:

<item name="EmailLink">
<label>Email Link</label>
<text required="f" size="40" maxlength="40"/>
</item>

And I've made the corresponding change to the database and dbschema.cfg:

<column name="primary_image_email_link" data-type="varchar2(255)" allows-null="yes" is-url="no" value-from-field="PrimaryImage/0/EmailLink"/>

However I get the following SQL error message when I try to deploy a DCR with the new field:

AS: *******STACK TRACE*************
java.sql.SQLException: ORA-02291: integrity constraint (CM_OWNER.FK_MASTER_RELATION_TARGET_TYPE) violated - parent key not found
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:822)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1446)

Find more posts tagged with

Comments

iwovGraduate

Did you create that column in the db table ?

myr

Yes, I added the following column in the MASTER table:

PRIMARY_IMAGE_EMAIL_LINK

with the following attributes:
VARCHAR2(40)
NULL(Y)

Migrateduser

did u update the *_dd.file? the error appears to be related to the way your DB keys are setup. plz post yer dbschema.cfg file

-------------------
World of Warcraft  Illidan/Horde

myr

Please find attached the dbschema file. Also we just upgraded to OD 6.0.2. Thanks.

myr

Thanks for everyone's input. I was able to get this to work.