Details
- 
    Type:Bug 
- 
    Status: Resolved
- 
    Priority:Major 
- 
    Resolution: Fixed
- 
    Affects Version/s: unspecified
- 
    Fix Version/s: None
- 
    Component/s: Yell Budgeting Tool
- 
    Labels:None
- 
    Environment:Operating System: Windows XP 
 Platform: PC
- 
        Bugzilla Id:3564
Description
Builds:
BM trunk build 2450
yell-budget-service-1.0-p1597-r25060.ear
svc-rptv2.1-p1596-r25011.ear
tsaapp@tvvm-staging-xml1:/usr/local/tsa/bidmgr$ ./budget_reportdata.sh -d4
2010-02-25 10:40:10.019 (3) [main]: Debug Level set to 4
2010-02-25 10:40:10.031 (3) [main]: Running MTD Report!
2010-02-25 10:40:10.033 (3) [main]: Requesting report for Account #null for 
Thu Feb 25 00:00:00 PST 2010
2010-02-25 10:40:10.034 (3) [main]: Requesting WSDL from http://svc-
rptv2.svc.thesearchagency.com:8080/svc-rptv2.1/ReportService2.1?wsdl with 
180000 ms timeout
log4j:WARN No appenders could be found for logger 
(org.apache.axis.i18n.ProjectResourceBundle).
log4j:WARN Please initialize the log4j system properly.
2010-02-25 10:40:14.231 (4) [main]: no account, or instance for 
databaseInstance, skipping lookup...
2010-02-25 10:40:14.644 (4) [main]: opened [jdbc:mysql://tsacommon-01-
write/tsacommon?
useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontT
rackOpenResources=true&jdbcCompliantTruncation=false]
2010-02-25 10:40:14.772 (4) [main]: spike: SQL->[select * from 
`tsacommon`.`databaseInstances` where ((`type`="mysql") and (`name`="global-
yell")) limit 1]
2010-02-25 10:40:14.902 (4) [main]: time=0.128
2010-02-25 10:40:14.903 (4) [main]: Query executed in 0.128s
2010-02-25 10:40:14.906 (4) [main]:   Record Loaded
2010-02-25 10:40:14.907 (4) [main]: DataCache: put key global-yell
2010-02-25 10:40:14.910 (4) [main]: closed [jdbc:mysql://tsacommon-01-
write/tsacommon?
useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontT
rackOpenResources=true&jdbcCompliantTruncation=false]
2010-02-25 10:40:14.914 (3) [main]: DatabasePool with a limit of 80 created
2010-02-25 10:40:14.921 (4) [ConnectionCloser]: Starting DatabasePool 
ConnectionCloserThread
2010-02-25 10:40:14.966 (4) [main]: opened [jdbc:mysql://yell-01-
write:3306/yell?
useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontT
rackOpenResources=true&jdbcCompliantTruncation=false]
2010-02-25 10:40:14.967 (4) [main]: Created new Object
2010-02-25 10:40:14.967 (4) [main]: spike: SQL->[select @@version]
2010-02-25 10:40:14.970 (4) [main]: time=0.0030
2010-02-25 10:40:14.970 (4) [main]: Query executed in 0.003s
2010-02-25 10:40:14.971 (4) [main]: test query succeeded, returned "5.0.30-
enterprise-gpl"
2010-02-25 10:40:14.972 (4) [main]: spike: SQL->[select accountID from 
yell.yellAccounts]
2010-02-25 10:40:14.975 (4) [main]: time=0.0030
2010-02-25 10:40:14.975 (4) [main]: Query executed in 0.003s
2010-02-25 10:40:14.977 (2) [main]: Error parsing  , skipping over that id.
2010-02-25 10:40:15.792 (3) [main]: Report ID :: 158287
2010-02-25 10:40:15.857 (4) [main]: Account# 17, 289, 485, 618,  ID(158287) 
waiting for ReportService
2010-02-25 10:40:20.979 (4) [main]: Account# 17, 289, 485, 618,  ID(158287) 
waiting for ReportService
2010-02-25 10:40:26.087 (4) [main]: Account# 17, 289, 485, 618,  ID(158287) 
waiting for ReportService
2010-02-25 10:40:31.124 (4) [main]: Account# 17, 289, 485, 618,  ID(158287) 
waiting for ReportService