Forum Stats

  • 3,853,853 Users
  • 2,264,287 Discussions
  • 7,905,483 Comments

Discussions

Ant Propagation Issue - Manual Elections

653189
653189 Member Posts: 101
edited Sep 26, 2008 2:26PM in WebLogic Portal
Hi All ,

we are working on weblogic portal 10.2 with My SQL 5.0 DB.

Initially, we have created 2 environments.

For the fist time I was able to migrate the data from environment1 to environment2.

Later, I have created some content types and contents in Environment 1.


After that When I am trying to migrate from Environment 1 to environment 2, Its giving error like
" Need to create Manual Elections for the type xyz"

This type of error is coming for all the types and contents created in environment 1.


I want to migrate whole environment1 data to environement2, even some extra content present at environment2.


Pls suggest me in this regard.


Srinivas

Answers

  • 648793
    648793 Member Posts: 96
    Srinivas, Are you trying for selected propagation or complete propagation? If you are using Ant task, please list down all those task you are calling during the propagation.

    Also post the complete error here. Also check your admin servers of both environments for any error.
  • 653189
    653189 Member Posts: 101
    Hi Rajeev,

    Thanks for your kindly help......
    I have provided the information as required in 3 points below...Pls suggest this....

    *1.Ant Task Excution Order*

    I am executing following selected targets , in the following order

    pingSrc, pingDest, lockSrc, lockDest, downloadSrc, downloadDest, validateSrc, validateDest, diff, combine, validateCombined, extractCombined, insertCombined , uploadCombined, commit, unlockSrc, unlockDest,


    *2.Error Stack Trace at destination*

    com.bea.content.RepositoryException: com.mysql.jdbc.exceptions.MySQLIntegrityCon
    straintViolationException: Cannot add or update a child row: a foreign key const
    raint fails (`WEBLOGIC/CMV_NODE_VERSION_PROPERTY`, CONSTRAINT `FK1_CMV_ND_VER_PR
    P` FOREIGN KEY (`NODE_ID`, `NODE_VERSION_ID`) REFERENCES `cmv_node_version` (`NO
    DE_ID`, `NODE_VERSION_ID`))
    at com.bea.content.internal.server.dao.DaoBase.doDatabaseAction(DaoBase.
    java:301)
    at com.bea.content.internal.server.dao.DaoBase.doExecuteActionAndCloseCo
    nnection(DaoBase.java:254)
    at com.bea.content.virtual.internal.server.dao.VersionPropertyDao.insert
    (VersionPropertyDao.java:119)
    at com.bea.content.virtual.internal.server.persister.JDBCVirtualPersiste
    r.createVersionProperty(JDBCVirtualPersister.java:367)
    at com.bea.content.virtual.internal.server.persister.JDBCVirtualPersiste
    r.createNode(JDBCVirtualPersister.java:230)
    Truncated. see log file for complete stacktrace
    com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Cannot add
    or update a child row: a foreign key constraint fails (`WEBLOGIC/CMV_NODE_VERSI
    ON_PROPERTY`, CONSTRAINT `FK1_CMV_ND_VER_PRP` FOREIGN KEY (`NODE_ID`, `NODE_VERS
    ION_ID`) REFERENCES `cmv_node_version` (`NODE_ID`, `NODE_VERSION_ID`))
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:925)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2864)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1567)
    at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedSt
    atement.java:1154)
    at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPrepared
    Statement.java:679)
    Truncated. see log file for complete stacktrace
    >
    <Sep 25, 2008 6:08:09 PM IST> <Error> <InventoryServices> <BEA-000000> <Encounte
    red an UNRECOVERABLE exception while processing election [Application:ContentSer
    vices:BEA Repository:ContentNodes:Singapore:Partners:PartnersContent]. Problem:
    [com.bea.content.RepositoryException: com.mysql.jdbc.exceptions.MySQLIntegrityCo
    nstraintViolationException: Cannot add or update a child row: a foreign key cons
    traint fails (`WEBLOGIC/CMV_NODE_VERSION_PROPERTY`, CONSTRAINT `FK1_CMV_ND_VER_P
    RP` FOREIGN KEY (`NODE_ID`, `NODE_VERSION_ID`) REFERENCES `cmv_node_version` (`N
    ODE_ID`, `NODE_VERSION_ID`))]. This election will not be processed further.>
    <Sep 25, 2008 6:08:09 PM IST> <Error> <ContentManagement> <BEA-000000> <
    com.bea.content.RepositoryException: com.mysql.jdbc.exceptions.MySQLIntegrityCon
    straintViolationException: Cannot add or update a child row: a foreign key const
    raint fails (`WEBLOGIC/CMV_NODE_VERSION_PROPERTY`, CONSTRAINT `FK1_CMV_ND_VER_PR
    P` FOREIGN KEY (`NODE_ID`, `NODE_VERSION_ID`) REFERENCES `cmv_node_version` (`NO
    DE_ID`, `NODE_VERSION_ID`))
    at com.bea.content.internal.server.dao.DaoBase.doDatabaseAction(DaoBase.
    java:301)
    at com.bea.content.internal.server.dao.DaoBase.doExecuteActionAndCloseCo
    nnection(DaoBase.java:254)
    at com.bea.content.virtual.internal.server.dao.VersionPropertyDao.insert
    (VersionPropertyDao.java:119)
    at com.bea.content.virtual.internal.server.persister.JDBCVirtualPersiste
    r.createVersionProperty(JDBCVirtualPersister.java:367)
    at com.bea.content.virtual.internal.server.persister.JDBCVirtualPersiste
    r.createNode(JDBCVirtualPersister.java:230)
    Truncated. see log file for complete stacktrace
    com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Cannot add
    or update a child row: a foreign key constraint fails (`WEBLOGIC/CMV_NODE_VERSI
    ON_PROPERTY`, CONSTRAINT `FK1_CMV_ND_VER_PRP` FOREIGN KEY (`NODE_ID`, `NODE_VERS
    ION_ID`) REFERENCES `cmv_node_version` (`NODE_ID`, `NODE_VERSION_ID`))
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:925)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2864)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1567)
    at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedSt
    atement.java:1154)
    at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPrepared
    Statement.java:679)
    Truncated. see log file for complete stacktrace
    >
    <Sep 25, 2008 6:08:09 PM IST> <Error> <InventoryServices> <BEA-000000> <Encounte
    red an UNRECOVERABLE exception while processing election [Application:ContentSer
    vices:BEA Repository:ContentNodes:delete]. Problem: [com.bea.content.RepositoryE
    xception: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException:
    Cannot add or update a child row: a foreign key constraint fails (`WEBLOGIC/CMV_
    NODE_VERSION_PROPERTY`, CONSTRAINT `FK1_CMV_ND_VER_PRP` FOREIGN KEY (`NODE_ID`,
    `NODE_VERSION_ID`) REFERENCES `cmv_node_version` (`NODE_ID`, `NODE_VERSION_ID`))
    ]. This election will not be processed further.>
    <Sep 25, 2008 6:08:12 PM IST> <Warning> <InventoryServices> <BEA-000000> <Add el
    ection [Application:ContentServices:BEA Repository:ContentNodes:Canada:imageCont
    ent] cannot be processed because the items parent does not exist.>
    <Sep 25, 2008 6:08:12 PM IST> <Error> <InventoryServices> <BEA-000000> <The Inve
    ntory Tree could not process [1] election items.>
    <Sep 25, 2008 6:08:12 PM IST> <Error> <InventoryServices> <BEA-000000> <The comm
    it operation failed to process [48] elections.>
    <Sep 25, 2008 6:08:12 PM IST> <Error> <InventoryServices> <BEA-000000> <[Applica
    tion:ContentServices:BEA Repository:ContentNodes:Canada] failed to [add]>
    <Sep 25, 2008 6:08:12 PM IST> <Error> <InventoryServices> <BEA-000000> <[Applica
    tion:ContentServices:BEA Repository:ContentNodes:Malasia] failed to [add]>
    <Sep 25, 2008 6:08:12 PM IST> <Error> <InventoryServices> <BEA-000000> <[Applica
    tion:ContentServices:BEA Repository:ContentNodes:Singapore:Corporate:Accolades:B
    randon-hall.com] failed to [add]>
    <Sep 25, 2008 6:08:12 PM IST> <Error> <InventoryServices> <BEA-000000> <[Applica
    tion:ContentServices:BEA Repository:ContentNodes:Singapore:Corporate:Accolades:e
    AsiaAward,2004] failed to [add]>
    <Sep 25, 2008 6:08:12 PM IST> <Error> <InventoryServices> <BEA-000000> <[Applica
    tion:ContentServices:BEA Repository:ContentNodes:Singapore:Corporate:Brand:Brand
    Page] failed to [add]>
    <Sep 25, 2008 6:08:12 PM IST> <Error> <InventoryServices> <BEA-000000> <[Applica
    tion:ContentServices:BEA Repository:ContentNodes:Singapore:Corporate:MissionAndV
    alues:Customer Focus] failed to [add]>
    <Sep 25, 2008 6:08:12 PM IST> <Error> <InventoryServices> <BEA-000000> <[Applica
    tion:ContentServices:BEA Repository:ContentNodes:Singapore:Corporate:MissionAndV
    alues:Innovation] failed to [add]>
    <Sep 25, 2008 6:08:12 PM IST> <Error> <InventoryServices> <BEA-000000> <[Applica
    tion:ContentServices:BEA Repository:ContentNodes:Singapore:Corporate:MissionAndV
    alues:Integrity] failed to [add]>
    <Sep 25, 2008 6:08:12 PM IST> <Error> <InventoryServices> <BEA-000000> <[Applica
    tion:ContentServices:BEA Repository:ContentNodes:Singapore:Corporate:MissionAndV
    alues:Quality] failed to [add]>
    <Sep 25, 2008 6:08:12 PM IST> <Error> <InventoryServices> <BEA-000000> <[Applica
    tion:ContentServices:BEA Repository:ContentNodes:Singapore:Corporate:MissionAndV
    alues:Teamwork] failed to [add]>
    <Sep 25, 2008 6:08:12 PM IST> <Error> <InventoryServices> <BEA-000000> <[Applica
    tion:ContentServices:BEA Repository:ContentNodes:Singapore:Corporate:Overview:Ov
    erview] failed to [add]>
    <Sep 25, 2008 6:08:12 PM IST> <Error> <InventoryServices> <BEA-000000> <[Applica
    tion:ContentServices:BEA Repository:ContentNodes:Singapore:Corporate:Quality:Qua
    lity] failed to [add]>




    *3. Error shown in commit.log*


    INFO (Sep 25, 2008 6:07:57 PM IST): The commit operation will attempt to process [55] elections.
    ERROR (Sep 25, 2008 6:08:12 PM IST): The commit operation failed to process [48] elections.
    ERROR (Sep 25, 2008 6:08:12 PM IST): [Application:ContentServices:BEA Repository:ContentNodes:Canada] failed to [add]
    ERROR (Sep 25, 2008 6:08:12 PM IST): [Application:ContentServices:BEA Repository:ContentNodes:Malasia] failed to [add]
    ERROR (Sep 25, 2008 6:08:12 PM IST): [Application:ContentServices:BEA Repository:ContentNodes:Singapore:Corporate:Accolades:Brandon-hall.com] failed to [add]
    ERROR (Sep 25, 2008 6:08:12 PM IST): [Application:ContentServices:BEA Repository:ContentNodes:Singapore:Corporate:Accolades:eAsiaAward,2004] failed to [add]
    ERROR (Sep 25, 2008 6:08:12 PM IST): [Application:ContentServices:BEA Repository:ContentNodes:Singapore:Corporate:Brand:BrandPage] failed to [add]
    ERROR (Sep 25, 2008 6:08:12 PM IST): [Application:ContentServices:BEA Repository:ContentNodes:Singapore:Corporate:MissionAndValues:Customer Focus] failed to [add]
    ERROR (Sep 25, 2008 6:08:12 PM IST): [Application:ContentServices:BEA Repository:ContentNodes:Singapore:Corporate:MissionAndValues:Innovation] failed to [add]
    ERROR (Sep 25, 2008 6:08:12 PM IST): [Application:ContentServices:BEA Repository:ContentNodes:Singapore:Corporate:MissionAndValues:Integrity] failed to [add]
    ERROR (Sep 25, 2008 6:08:12 PM IST): [Application:ContentServices:BEA Repository:ContentNodes:Singapore:Corporate:MissionAndValues:Quality] failed to [add]
    ERROR (Sep 25, 2008 6:08:12 PM IST): [Application:ContentServices:BEA Repository:ContentNodes:Singapore:Corporate:MissionAndValues:Teamwork] failed to [add]
    ERROR (Sep 25, 2008 6:08:12 PM IST): [Application:ContentServices:BEA Repository:ContentNodes:Singapore:Corporate:Overview:Overview] failed to [add]
    ERROR (Sep 25, 2008 6:08:12 PM IST): [Application:ContentServices:BEA Repository:ContentNodes:Singapore:Corporate:Quality:Quality] failed to [add]
    ERROR (Sep 25, 2008 6:08:12 PM IST): [Application:ContentServices:BEA Repository:ContentNodes:Singapore:Corporate:Security:Security] failed to [add]
    ERROR (Sep 25, 2008 6:08:12 PM IST): [Application:ContentServices:BEA Repository:ContentNodes:Singapore:Corporate:Technology:Technology] failed to [add]
    ERROR (Sep 25, 2008 6:08:12 PM IST): [Application:ContentServices:BEA Repository:ContentNodes:Singapore:CustomerCare:ContactInformation:Call Center] failed to [add]
    ERROR
  • 648793
    648793 Member Posts: 96
    Hi

    You can do a couple of things.
    1) extractCombined, and insertCombined are not required. You can remove them.
    2) Enable logging of propagation (http://edocs.beasys.com/wlp/docs100/prodOps/propToolAdvanced.html#wp1071690 search for "Configuring the Propagation Servlet ")
    3) its seems from the log that your propagation failed on "a foreign key constraint fails". I am not sure this is an issue. You may see the actual error after logging enabled.
This discussion has been closed.