Uploaded image for project: 'SMB - Optus'
  1. SMB - Optus
  2. OPTUS-115

After migrating the legacy accounts, hasModifier value of HighEndMobile hasn't set to true.

          Details

          • Type: Bug
          • Status: Closed
          • Priority: Major
          • Resolution: Fixed
          • Affects Version/s: 1.5.3
          • Fix Version/s: None
          • Component/s: Other / Misc.
          • Labels:
            None
          • Environment:

            QA environment

            SMB Core - 1.5.3 - RELEASE : Build 22
            SMB - Optus - 1.5.3 – RELEASE : Build 26
            SMB Core - Bid Manager - 1.5.3 - RELEASE: Build 23

            Description

            After migrating the legacy accounts, hasModifier value hasn't set to true for platform : HighEnd Mobile

            1.Run the migration script for legacy account

            nohup /usr/local/tsa/bidmgr/google-enhanced-campaign-migrator.sh -d3 --seuser 57523

            2. Check in the DB

            Before Migration
            mysql> select * from gce_campaignTargetMap Ct,gce_target t where Ct.campaignID in (select id from gce_campaign where searchEngineUserID=57523) and Ct.targetID=t.id;
            -----------------------------------------------------------------------------------------------------------------------

            campaignID targetID isExclude hasBidModifier id targetType code description criterionID

            -----------------------------------------------------------------------------------------------------------------------

            1754 1 false false 1 network GoogleSearch Google Search 0
            1754 2 false false 2 network SearchNetwork Search Partners 0
            1754 3 false false 3 network ContentNetwork Content Network (Selected Placements) 0
            1754 13 false false 13 language en English 1000
            1754 1454 false false 1454 platform Desktop Desktop 30000
            1754 1456 false false 1456 platform Tablet Tablet 30002
            1755 1 false false 1 network GoogleSearch Google Search 0
            1755 2 false false 2 network SearchNetwork Search Partners 0
            1755 13 false false 13 language en English 1000
            1755 57 false false 57 country AU Australia 2036
            1755 1454 false false 1454 platform Desktop Desktop 30000
            1755 1456 false false 1456 platform Tablet Tablet 30002
            1756 1 false false 1 network GoogleSearch Google Search 0
            1756 2 false false 2 network SearchNetwork Search Partners 0
            1756 3 false false 3 network ContentNetwork Content Network (Selected Placements) 0
            1756 13 false false 13 language en English 1000
            1756 1455 false false 1455 platform HighEndMobile HighEndMobile 30001

            -----------------------------------------------------------------------------------------------------------------------
            17 rows in set (0.03 sec)

            After Migration

            mysql> select * from gce_campaignTargetMap Ct,gce_target t where Ct.campaignID in (select id from gce_campaign where searchEngineUserID=57523) and Ct.targetID=t.id;
            -----------------------------------------------------------------------------------------------------------------------

            campaignID targetID isExclude hasBidModifier id targetType code description criterionID

            -----------------------------------------------------------------------------------------------------------------------

            1754 1 false false 1 network GoogleSearch Google Search 0
            1754 2 false false 2 network SearchNetwork Search Partners 0
            1754 3 false false 3 network ContentNetwork Content Network (Selected Placements) 0
            1754 13 false false 13 language en English 1000
            1754 1454 false false 1454 platform Desktop Desktop 30000
            1754 1456 false false 1456 platform Tablet Tablet 30002
            1755 1 false false 1 network GoogleSearch Google Search 0
            1755 2 false false 2 network SearchNetwork Search Partners 0
            1755 13 false false 13 language en English 1000
            1755 57 false false 57 country AU Australia 2036
            1755 1454 false false 1454 platform Desktop Desktop 30000
            1755 1456 false false 1456 platform Tablet Tablet 30002
            1756 1 false false 1 network GoogleSearch Google Search 0
            1756 2 false false 2 network SearchNetwork Search Partners 0
            1756 3 false false 3 network ContentNetwork Content Network (Selected Placements) 0
            1756 13 false false 13 language en English 1000
            1756 1455 false false 1455 platform HighEndMobile HighEndMobile 30001

            -----------------------------------------------------------------------------------------------------------------------
            17 rows in set (0.00 sec)

            Expected:

            For HighEndMobile platform, hasModifier value should be "true"

              Attachments

                Activity

                  People

                  • Assignee:
                    manasa.denning Manasa Denning
                    Reporter:
                    atul.sanagar Atul Sanagar (Inactive)
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    3 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: