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