Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Blocker
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 1.2.0
-
Component/s: Data Summarization
-
Labels:None
-
Environment:
optus-qa-smb1 50.57.178.209
optus-qa-agency1 50.57.178.216
optus-qa-mysql1 50.57.144.182
Description
Precondition:
Added account-5843 ,searchEnginusers and searchEngineAccounts.
1. Ran the calldatascript.
[tsaapp@optus-qa-agency1 bidmgr]$ ./calldata.sh /var/local/tsa/config/com.thesearchagency.datafeeds.calldata.properties
2012-01-17 14:25:48.364 (3) [main]: Debug Level set to 3
2012-01-17 14:25:48.374 (3) [main]: Observing directory: /var/local/tsa/calldata/
2.Placed csv to the location /var/local/tsa/calldata/
[gsingh@optus-qa-agency1 ~]$ sudo cp call_data_2011-12-26_s1.csv /var/local/tsa/calldata/
[tsaapp@optus-qa-agency1 bidmgr]$ ./calldata.sh /var/local/tsa/config/com.thesearchagency.datafeeds.calldata.properties
2012-01-17 14:25:48.364 (3) [main]: Debug Level set to 3
2012-01-17 14:25:48.374 (3) [main]: Observing directory: /var/local/tsa/calldata/
2012-01-17 14:26:08.483 (3) [Thread-1]: Processing [/var/local/tsa/calldata/call_data_2011-12-26_s1.csv]
2012-01-17 14:26:08.485 (3) [pool-1-thread-1]: Waiting for done file [/var/local/tsa/calldata/call_data_2011-12-26_s1.csv.done]
3.Run touch command
[gsingh@optus-qa-agency1 ~]$ sudo touch /var/local/tsa/calldata/call_data_2011-12-26_s1.csv.done
now calldata script started processing the file.
[tsaapp@optus-qa-agency1 bidmgr]$ ./calldata.sh /var/local/tsa/config/com.thesearchagency.datafeeds.calldata.properties
2012-01-17 14:25:48.364 (3) [main]: Debug Level set to 3
2012-01-17 14:25:48.374 (3) [main]: Observing directory: /var/local/tsa/calldata/
2012-01-17 14:26:08.483 (3) [Thread-1]: Processing [/var/local/tsa/calldata/call_data_2011-12-26_s1.csv]
2012-01-17 14:26:08.485 (3) [pool-1-thread-1]: Waiting for done file [/var/local/tsa/calldata/call_data_2011-12-26_s1.csv.done]
2012-01-17 14:26:22.514 (3) [pool-1-thread-1]: ======== Starting Call Data Load ========
2012-01-17 14:26:22.514 (3) [pool-1-thread-1]: Loading filename: /var/local/tsa/calldata/call_data_2011-12-26_s1.csv
2012-01-17 14:26:22.526 (3) [pool-1-thread-1]: DatabasePool with a limit of 80 created
2012-01-17 14:26:22.814 (3) [pool-1-thread-1]: DatabasePool with a limit of 80 created
2012-01-17 14:26:22.847 (3) [pool-1-thread-1]: Created call products for 3 new accounts.
2012-01-17 14:26:22.858 (3) [pool-1-thread-1]: Lines processed: 1
2012-01-17 14:26:22.859 (3) [pool-1-thread-1]: Invalid lines: 0
2012-01-17 14:26:22.859 (3) [pool-1-thread-1]: ======== Finished Call Data Load (COMPLETED) ========
2012-01-17 14:26:22.862 (3) [pool-1-thread-1]: Executing [/usr/local/tsa/bidmgr/whsumm.sh --client -d3 --date 2011-12-26 --end 2011-12-27 -dsrt 0 -a 5843]
.
.
.
2012-01-17 14:26:23.361 (2) [P1T1]: Exception [creating pooled Database]:java.sql.SQLException: Access denied for user 'perfsum'@'50-57-178-216.static.cloud-ips.com' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670)
at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
5. Checked the /etc/hosts for ipaddress - 50.57.178.216
[gsingh@optus-qa-agency1 tsa]$ fgrep 50.57.178.216 /etc/hosts
50.57.178.216 optus-qa-agency1
50.57.178.216 reportservice-01-write bidmanagerservice-01-write alertservice-01-write thresholdservice-01-write
50.57.178.216 svc-uiv1.svc.thesearchagency.com svc-rptv1.svc.thesearchagency.com svc-bidmgrv1.svc.thesearchagency.com svc-alertv2.svc.thesearchagency.com svc-thresholdv2.svc.thesearchagency.com svc-useracctv2.svc.thesearchagency.com svc-clusterv2.svc.thesearchagency.com svc-creativev2.svc.thesearchagency.com svc-rptv2.svc.thesearchagency.com
