Uploaded image for project: 'AdMaxLocal'
  1. AdMaxLocal
  2. AML-2077

SEVERE null SQL validation when moving to Staging Area

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: Data Loader 1.0
    • Fix Version/s: Data Loader 1.0
    • Component/s: None
    • Labels:
      None
    • Environment:

      Build 405

    • Story Points:
      0
    • Sprint:
      Sprint 13

      Description

      When moving files to Staging Area (100 files when this happened) a SEVERE error for null SQL validation occurred when attempting to create a table for the BA.

      Section from log:

      Aug 6, 2013 12:07:10 PM com.thesearchagency.smbdataload.server.StagingAreaDriver tableStatement
      INFO: Using table: boilers_keywords
      Aug 6, 2013 12:07:10 PM com.thesearchagency.smbdataload.server.StagingAreaDriver createTable
      INFO: Populating the table...
      Aug 6, 2013 12:07:11 PM com.thesearchagency.smbdataload.server.StagingAreaDriver createTable
      INFO: Table populated.
      Aug 6, 2013 12:07:11 PM com.thesearchagency.smbdataload.server.StagingAreaDriver tableStatement
      INFO: Using table: boat_upholstery_keywords
      Aug 6, 2013 12:07:11 PM com.thesearchagency.smbdataload.server.StagingAreaDriver createTable
      INFO: Populating the table...
      Aug 6, 2013 12:07:20 PM com.thesearchagency.smbdataload.server.StagingAreaDriver createTable
      INFO: Table populated.
      Aug 6, 2013 12:07:22 PM com.thesearchagency.smbdataload.server.StagingAreaDriver createTable
      INFO: Table populated.
      Aug 6, 2013 12:07:25 PM com.thesearchagency.smbdataload.server.StagingAreaDriver createTable
      INFO: Table populated.
      Aug 6, 2013 12:07:26 PM com.thesearchagency.smbdataload.server.XmlParser parseSqlConfig
      SEVERE: Couldn't find a SQL validation definition for null
      Aug 6, 2013 12:07:26 PM com.thesearchagency.smbdataload.server.XmlParser parseSqlConfig
      SEVERE: Couldn't find a SQL validation definition for null
      Aug 6, 2013 12:07:26 PM com.thesearchagency.smbdataload.server.StagingAreaDriver runSQLStagingArea
      INFO: Running the following SQL validations:{1221=com.thesearchagency.smbdataload.shared.SQLValidationInfo@4dbb119a, 1220=com.thesearchagency.smbdataload.shared.SQLValidationInfo@4dbb1$
      Aug 6, 2013 12:07:26 PM com.thesearchagency.smbdataload.server.XmlParser parseSqlConfig
      SEVERE: Couldn't find a SQL validation definition for null
      Aug 6, 2013 12:07:26 PM com.thesearchagency.smbdataload.server.XmlParser parseSqlConfig
      SEVERE: Couldn't find a SQL validation definition for null
      Aug 6, 2013 12:07:26 PM com.thesearchagency.smbdataload.server.StagingAreaDriver runSQLStagingArea
      INFO: Running the following SQL validations:{1221=com.thesearchagency.smbdataload.shared.SQLValidationInfo@3480bd54, 1220=com.thesearchagency.smbdataload.shared.SQLValidationInfo@3480b$
      Aug 6, 2013 12:07:26 PM com.thesearchagency.smbdataload.server.XmlParser parseSqlConfig
      SEVERE: Couldn't find a SQL validation definition for null
      Aug 6, 2013 12:07:26 PM com.thesearchagency.smbdataload.server.XmlParser parseSqlConfig
      SEVERE: Couldn't find a SQL validation definition for null
      Aug 6, 2013 12:07:26 PM com.thesearchagency.smbdataload.server.StagingAreaDriver runSQLStagingArea
      INFO: Running the following SQL validations:{1221=com.thesearchagency.smbdataload.shared.SQLValidationInfo@700df0b9, 1220=com.thesearchagency.smbdataload.shared.SQLValidationInfo@700df$

      Continues for a bit...

      Aug 6, 2013 12:07:28 PM com.thesearchagency.smbdataload.server.StagingAreaDriver runSQLStagingArea
      INFO: Running the following SQL validations:{1221=com.thesearchagency.smbdataload.shared.SQLValidationInfo@5cf14920, 1220=com.thesearchagency.smbdataload.shared.SQLValidationInfo@5cf14$
      Aug 6, 2013 12:07:31 PM com.thesearchagency.smbdataload.server.StagingAreaDriver createTable
      INFO: Table populated.
      Aug 6, 2013 12:07:31 PM com.thesearchagency.smbdataload.server.XmlParser parseSqlConfig
      SEVERE: Couldn't find a SQL validation definition for null
      Aug 6, 2013 12:07:31 PM com.thesearchagency.smbdataload.server.XmlParser parseSqlConfig
      SEVERE: Couldn't find a SQL validation definition for null
      Aug 6, 2013 12:07:31 PM com.thesearchagency.smbdataload.server.StagingAreaDriver runSQLStagingArea
      INFO: Running the following SQL validations:{1221=com.thesearchagency.smbdataload.shared.SQLValidationInfo@72be7a2c, 1220=com.thesearchagency.smbdataload.shared.SQLValidationInfo@72be7$
      Aug 6, 2013 12:07:33 PM com.thesearchagency.smbdataload.server.StagingAreaDriver createTable
      INFO: Table populated.
      Aug 6, 2013 12:07:33 PM com.thesearchagency.smbdataload.server.XmlParser parseSqlConfig
      SEVERE: Couldn't find a SQL validation definition for null
      Aug 6, 2013 12:07:33 PM com.thesearchagency.smbdataload.server.XmlParser parseSqlConfig
      SEVERE: Couldn't find a SQL validation definition for null
      Aug 6, 2013 12:07:33 PM com.thesearchagency.smbdataload.server.StagingAreaDriver runSQLStagingArea
      INFO: Running the following SQL validations:{1221=com.thesearchagency.smbdataload.shared.SQLValidationInfo@2172451b, 1220=com.thesearchagency.smbdataload.shared.SQLValidationInfo@21724$
      Aug 6, 2013 12:07:43 PM com.thesearchagency.smbdataload.server.StagingAreaDriver createTable
      INFO: Table populated.
      Aug 6, 2013 12:07:44 PM com.thesearchagency.smbdataload.server.XmlParser parseSqlConfig
      SEVERE: Couldn't find a SQL validation definition for null
      Aug 6, 2013 12:07:44 PM com.thesearchagency.smbdataload.server.XmlParser parseSqlConfig
      SEVERE: Couldn't find a SQL validation definition for null
      Aug 6, 2013 12:07:44 PM com.thesearchagency.smbdataload.server.StagingAreaDriver runSQLStagingArea
      INFO: Running the following SQL validations:{1221=com.thesearchagency.smbdataload.shared.SQLValidationInfo@3c92cc9, 1220=com.thesearchagency.smbdataload.shared.SQLValidationInfo@3c92cc$

      Hangs after there

        Attachments

          Activity

            People

            • Assignee:
              dylan.kirby Dylan Kirby (Inactive)
              Reporter:
              endy.nicol Endy Nicol (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: