Uploaded image for project: 'Yell'
  1. Yell
  2. YELL-865

Not able to run migration scripts in same environment

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: Point Radii Implementation
    • Fix Version/s: None
    • Component/s: Point Radii Migration
    • Labels:
      None

      Description

      We are not able to run both migration scripts in same environment, we are facing following issue in respective environment

      Environment: ST2

      In ST2 we are able to run Phase1 and Phase2 script (Abbas), but not able to run location-target-remover (Ajay) script, getting following exception

      Script used:
      java -jar location-target-remover-0.0.1-SNAPSHOT.jar -s 9649 -h 4 -d 3 -e 9649

      [26 Dec 2013 09:07:40,112-LocationTargetRemover:ERROR:pool-1-thread-1] LocationTargetRemover aborted!
      org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown database 'content_editor_google'
      at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)
      at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:577)
      at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641)
      at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:670)
      at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:678)
      at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:710)

      Environment: YELL1

      In YELL1 we are able to run location-target-remover (Ajay) script but not able to run Phase1 script (Abbas), getting following exception

      Script used:
      sh GoogleMigratorPhase1.sh phase1 nophase2

      2013-12-26 09:28:29 INFO DriverManagerDataSource:155 - Loaded JDBC driver: com.mysql.jdbc.Driver
      2013-12-26 09:28:29 INFO GTCampaignDAO:311 - [getGTCampaigns] Starting ....
      Exception in thread "main" java.lang.NumberFormatException: null
      at java.lang.Long.parseLong(Long.java:372)
      at java.lang.Long.parseLong(Long.java:461)
      at com.thesearchagency.GTCampaignDAO.getGTCampaigns(GTCampaignDAO.java:338)
      at com.thesearchagency.GTCampaignManager.main(GTCampaignManager.java:45)

        Attachments

          Activity

            People

            • Assignee:
              muhammad.abbas Muhammad Abbas (Inactive)
              Reporter:
              sharath.tn Sharath TN (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: