4 Replies Latest reply: Aug 21, 2013 7:46 AM by Pijush RSS

    Errors encountered while doing BCC Full deployment in the Applying phase

    Pijush

      Errors encountered while doing BCC Full deployment in the Applying phase. The stack trace is as below:-

       

      **** Warning    Fri Aug 02 09:43:24 BST 2013    1375433004207   /atg/epub/PublishingRepository  Using default JDBC type for: project:tar814 could not find this column in the table's meta data

      **** debug      Fri Aug 02 09:52:54 BST 2013    1375433574278   /atg/epub/DeploymentServer      Run first apply phase: true

      **** debug      Fri Aug 02 09:52:54 BST 2013    1375433574279   /atg/epub/DeploymentServer      Switch switchable CA datasources:

      **** debug      Fri Aug 02 09:52:54 BST 2013    1375433574279   /atg/epub/DeploymentServer        isDeploymentRollback(): false

      **** debug      Fri Aug 02 09:52:54 BST 2013    1375433574284   /atg/epub/DeploymentServer        Current Target live datasource name: DataSourceA

      **** debug      Fri Aug 02 09:52:54 BST 2013    1375433574285   /atg/epub/DeploymentServer        CA switching datasource: /atg/commerce/jdbc/ProductCatalogSwitchingDataSource_production

      **** debug      Fri Aug 02 09:52:54 BST 2013    1375433574285   /atg/epub/DeploymentServer          Current live datasource name: DataSourceB

      **** debug      Fri Aug 02 09:52:54 BST 2013    1375433574285   /atg/epub/DeploymentServer          Current offline datasource name: DataSourceA

      **** debug      Fri Aug 02 09:52:54 BST 2013    1375433574286   /atg/epub/DeploymentServer          The current CA live datasource is pointing at the Target offline datasource. No CA switch necessary.

      **** debug      Fri Aug 02 09:52:54 BST 2013    1375433574287   /atg/epub/DeploymentServer      Switchable CA datasources switched.

      **** info       Fri Aug 02 09:52:54 BST 2013    1375433574307   /atg/epub/DeploymentServer      DirectSQLReplicationAdapter: Starting FIRST phase data transfer.

      **** Error      Fri Aug 02 09:53:12 BST 2013    1375433592737   /com/screwfix/content/block/BlockRepository-ver SQL Statement Failed: [++ReplicationSQL++]

      **** Error      Fri Aug 02 09:53:12 BST 2013    1375433592737   /com/screwfix/content/block/BlockRepository-ver INSERT

      **** Error      Fri Aug 02 09:53:12 BST 2013    1375433592737   /com/screwfix/content/block/BlockRepository-ver INTO ndcatalog2.extn_block_link

      **** Error      Fri Aug 02 09:53:12 BST 2013    1375433592737   /com/screwfix/content/block/BlockRepository-ver      (

      **** Error      Fri Aug 02 09:53:12 BST 2013    1375433592737   /com/screwfix/content/block/BlockRepository-ver        renderer_id,

      **** Error      Fri Aug 02 09:53:12 BST 2013    1375433592737   /com/screwfix/content/block/BlockRepository-ver        link,

      **** Error      Fri Aug 02 09:53:12 BST 2013    1375433592737   /com/screwfix/content/block/BlockRepository-ver        block_id

      **** Error      Fri Aug 02 09:53:12 BST 2013    1375433592737   /com/screwfix/content/block/BlockRepository-ver      )

      **** Error      Fri Aug 02 09:53:12 BST 2013    1375433592737   /com/screwfix/content/block/BlockRepository-ver SELECT

      **** Error      Fri Aug 02 09:53:12 BST 2013    1375433592737   /com/screwfix/content/block/BlockRepository-ver        t1.renderer_id,

      **** Error      Fri Aug 02 09:53:12 BST 2013    1375433592737   /com/screwfix/content/block/BlockRepository-ver        t1.link,

      **** Error      Fri Aug 02 09:53:12 BST 2013    1375433592737   /com/screwfix/content/block/BlockRepository-ver        t1.block_id

      **** Error      Fri Aug 02 09:53:12 BST 2013    1375433592737   /com/screwfix/content/block/BlockRepository-ver FROM

      **** Error      Fri Aug 02 09:53:12 BST 2013    1375433592737   /com/screwfix/content/block/BlockRepository-ver        extn_block_link t1,

      **** Error      Fri Aug 02 09:53:12 BST 2013    1375433592737   /com/screwfix/content/block/BlockRepository-ver        extn_block t2

      **** Error      Fri Aug 02 09:53:12 BST 2013    1375433592737   /com/screwfix/content/block/BlockRepository-ver WHERE t2.asset_version =

      **** Error      Fri Aug 02 09:53:12 BST 2013    1375433592737   /com/screwfix/content/block/BlockRepository-ver        ( SELECT MAX ( asset_version )

      **** Error      Fri Aug 02 09:53:12 BST 2013    1375433592737   /com/screwfix/content/block/BlockRepository-ver          FROM extn_block

      **** Error      Fri Aug 02 09:53:12 BST 2013    1375433592737   /com/screwfix/content/block/BlockRepository-ver          WHERE

      **** Error      Fri Aug 02 09:53:12 BST 2013    1375433592737   /com/screwfix/content/block/BlockRepository-ver            (

      **** Error      Fri Aug 02 09:53:12 BST 2013    1375433592737   /com/screwfix/content/block/BlockRepository-ver              (

      **** Error      Fri Aug 02 09:53:12 BST 2013    1375433592737   /com/screwfix/content/block/BlockRepository-ver                checkin_date <= ?

      **** Error      Fri Aug 02 09:53:12 BST 2013    1375433592737   /com/screwfix/content/block/BlockRepository-ver              )

      **** Error      Fri Aug 02 09:53:12 BST 2013    1375433592737   /com/screwfix/content/block/BlockRepository-ver            )

      **** Error      Fri Aug 02 09:53:12 BST 2013    1375433592737   /com/screwfix/content/block/BlockRepository-ver            AND branch_id = ?

      **** Error      Fri Aug 02 09:53:12 BST 2013    1375433592737   /com/screwfix/content/block/BlockRepository-ver            AND block_id = t2.block_id

      **** Error      Fri Aug 02 09:53:12 BST 2013    1375433592737   /com/screwfix/content/block/BlockRepository-ver        )

      **** Error      Fri Aug 02 09:53:12 BST 2013    1375433592737   /com/screwfix/content/block/BlockRepository-ver AND t2.version_deleted = ?

      **** Error      Fri Aug 02 09:53:12 BST 2013    1375433592737   /com/screwfix/content/block/BlockRepository-ver AND t2.branch_id = ?

      **** Error      Fri Aug 02 09:53:12 BST 2013    1375433592737   /com/screwfix/content/block/BlockRepository-ver AND t1.asset_version =  t2.asset_version

      **** Error      Fri Aug 02 09:53:12 BST 2013    1375433592737   /com/screwfix/content/block/BlockRepository-ver AND t1.block_id = t2.block_id

      **** Error      Fri Aug 02 09:53:12 BST 2013    1375433592737   /com/screwfix/content/block/BlockRepository-ver

      **** Error      Fri Aug 02 09:53:12 BST 2013    1375433592737   /com/screwfix/content/block/BlockRepository-ver -- Parameters --

      **** Error      Fri Aug 02 09:53:12 BST 2013    1375433592737   /com/screwfix/content/block/BlockRepository-ver p[1] = {pd: checkin_date} 2013-07-30 10:23:57.867 (java.sql.Timestamp)

      **** Error      Fri Aug 02 09:53:12 BST 2013    1375433592737   /com/screwfix/content/block/BlockRepository-ver p[2] = {pd: branch_id} 10500 (java.lang.String)

      **** Error      Fri Aug 02 09:53:12 BST 2013    1375433592737   /com/screwfix/content/block/BlockRepository-ver p[3] = {pd: version_deleted} false (java.lang.Boolean)

      **** Error      Fri Aug 02 09:53:12 BST 2013    1375433592737   /com/screwfix/content/block/BlockRepository-ver p[4] = {pd: branch_id} 10500 (java.lang.String)

      **** Error      Fri Aug 02 09:53:12 BST 2013    1375433592737   /com/screwfix/content/block/BlockRepository-ver [--ReplicationSQL--]

      **** Error      Fri Aug 02 09:53:12 BST 2013    1375433592737   /com/screwfix/content/block/BlockRepository-ver         java.sql.SQLSyntaxErrorException: ORA-00904: "RENDERER_ID": invalid identifier

       

      Please note that we are migrating from ATG 2007 to ATG 10.0.1...Also we are doing deployment in this new environment for the first time only.

      Thanks a lot

      Pijush