4 Replies Latest reply on Aug 21, 2013 12:46 PM by Pijush

    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