Uploaded image for project: 'AdMax'
  1. AdMax
  2. ADMAX-3094

Tagging: Some tagsheets upload fails with "java.sql.SQLException"

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Not a Bug
    • Affects Version/s: Graffiti v1.00
    • Fix Version/s: None
    • Component/s: Reporting
    • Labels:
      None
    • Environment:

      Services-Tagging-Phase-I# 170

      AdMax-Tagging-Phase-I# 132

      Jboss: staging-jboss5, staging-db6, staging-db7

      UI: Client-st

      Jboss: staging-jboss5

      Description

      1. Login to Admax

      2. Navigate to Home -> Reporting ->Create Reports

      3. Submit a report for Distribution by month for all its accounts, for last 12 months (R-364-777)

      => Donwload the report from View Reports page (tagsheet attached)

      4. Navigate to Home -> Reporting ->Apply Tags, and try uploading the tagsheet

      => the upload fails after some time without any error

      observed that the "errorText" column in tagImportJobs table in staging-db5 shows an error message as

      "java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction

      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)"

      Note:

      For checking the failed upload taghseets T-216, 217, 218, 219, 224

        Attachments

          Activity

            People

            • Assignee:
              abhiram Abhiram Bhagwat
              Reporter:
              saravanan.t Saravanan (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: