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

CallDataFeed:Calldata script doesn't process the file if calldatafile has a single row entry.

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Not a Bug
    • Affects Version/s: 1.1.1
    • Fix Version/s: 1.2.0
    • Component/s: Data Summarization
    • Labels:
      None
    • Environment:

      /usr/local/tsa/tsa-build-bidmgr-2012-02-16-p514-r2ebf9d777a4a54586d47ae36f1d4ef73dd3e2f2e

      Description

      Calldata script doesn't process the file if calldata file has a single row entry.

      Step:

      1.Start the calldata script

      [tsaapp@optus-qa-agency1 bidmgr]$ ./calldata.sh /var/local/tsa/config/com.thesearchagency.datafeeds.calldata.properties

      2012-02-25 00:52:00.305 (3) [main]: Debug Level set to 3

      2012-02-25 00:52:00.316 (3) [main]: Observing directory: /var/local/tsa/calldata/

      2.Place the file to /var/local/tsa/calldata

      [gsingh@optus-qa-agency1 tmp]$ sudo cp call_data_2012-02-11_s1.csv /var/local/tsa/calldata/

      2012-02-25 00:52:18.430 (3) [Thread-1]: Processing [/var/local/tsa/calldata/call_data_2012-02-11_s1.csv]

      3.gsingh@optus-qa-agency1 tmp]$ sudo touch /var/local/tsa/calldata/call_data_2012-02-11_s1.csv.done

      2012-02-25 00:52:18.432 (3) [pool-1-thread-1]: Waiting for done file [/var/local/tsa/calldata/call_data_2012-02-11_s1.csv.done]

      2012-02-25 00:52:30.458 (3) [pool-1-thread-1]: ======== Starting Call Data Load ========

      2012-02-25 00:52:30.458 (3) [pool-1-thread-1]: Loading filename: /var/local/tsa/calldata/call_data_2012-02-11_s1.csv

      2012-02-25 00:52:30.471 (3) [pool-1-thread-1]: DatabasePool with a limit of 80 created

      2012-02-25 00:52:30.685 (1) [pool-1-thread-1]: Data rows in file (0) not equal to rows loaded in databse (0), manual intervention required

      2012-02-25 00:52:30.688 (3) [pool-1-thread-1]: Lines processed: 0

      2012-02-25 00:52:30.688 (3) [pool-1-thread-1]: Invalid lines: 0

      2012-02-25 00:52:30.688 (3) [pool-1-thread-1]: ======== Finished Call Data Load (FAILED) ========

      2012-02-25 00:52:30.688 (1) [pool-1-thread-1]: Invalid status for datafeed [FAILED], manual intervention requred

      P.S.

      It is observed that file gets processed if it has more than 1 row

      [gsingh@optus-qa-agency1 tmp]$ sudo vi call_data_2012-02-13_s1.csv

      CUST ID DATE CALL COUNT

      12568678 12/02/2012 44

      12568678 13/02/2012 120

      [tsaapp@optus-qa-agency1 bidmgr]$ ./calldata.sh /var/local/tsa/config/com.thesearchagency.datafeeds.calldata.properties --backout

      2012-02-25 00:26:56.746 (3) [main]: Debug Level set to 3

      2012-02-25 00:26:56.756 (3) [main]: Observing directory: /var/local/tsa/calldata/

      2012-02-25 00:27:07.821 (3) [Thread-1]: Processing [/var/local/tsa/calldata/call_data_2012-02-13_s1.csv]

      2012-02-25 00:27:07.823 (3) [pool-1-thread-1]: Waiting for done file [/var/local/tsa/calldata/call_data_2012-02-13_s1.csv.done]

      2012-02-25 00:27:15.841 (3) [pool-1-thread-1]: ======== Starting Call Data Load ========

      2012-02-25 00:27:15.841 (3) [pool-1-thread-1]: Loading filename: /var/local/tsa/calldata/call_data_2012-02-13_s1.csv

      2012-02-25 00:27:15.854 (3) [pool-1-thread-1]: DatabasePool with a limit of 80 created

      2012-02-25 00:27:16.154 (3) [pool-1-thread-1]: DatabasePool with a limit of 80 created

      2012-02-25 00:27:16.232 (3) [pool-1-thread-1]: Lines processed: 1

      2012-02-25 00:27:16.232 (3) [pool-1-thread-1]: Invalid lines: 0

      2012-02-25 00:27:16.233 (3) [pool-1-thread-1]: ======== Finished Call Data Load (COMPLETED) ========

      2012-02-25 00:27:16.236 (3) [pool-1-thread-1]: Executing [/usr/local/tsa/bidmgr/whsumm.sh --client -d3 --date 2012-02-13 --end 2012-02-14 -dsrt 0 -a 5843,5860,541]

      2012-02-25 00:27:16.433 (3) [main]: Debug Level set to 3

      2012-02-25 00:27:16.435 (3) [main]: Licensing environment detected, loading configuration.

      2012-02-25 00:27:16.436 (3) [main]: Loaded property: tsa.google.mcc.email=tsaoptapi@gmail.com

        Attachments

          Activity

            People

            • Assignee:
              therouxj Jeff Theroux
              Reporter:
              atul.sanagar Atul Sanagar (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: