tsaapp@tvvm-staging-xml1:/usr/local/tsa/bidmgr$ ./budget_reportdata.sh -d 3 -a 17 -T 2009-11-01
2011-07-17 21:12:29.523 (3) [main]: Debug Level set to 3
2011-07-17 21:12:30.095 (3) [main]: Running MTD Report!
2011-07-17 21:12:30.107 (3) [main]: Requesting report for Account #(17) for Sun Nov 01 00:00:00 PDT 2009
2011-07-17 21:12:30.109 (3) [main]: Requesting WSDL from http://svc-rptv2.svc.thesearchagency.com:8080/svc-rptv2.1/ReportService2.1?wsdl with 180000 ms timeout
2011-07-17 21:12:41.737 (3) [main]: Report ID :: 336635
2011-07-17 21:12:42.098 (3) [main]: Report ok for Account #(17) for Sun Nov 01 00:00:00 PDT 2009
2011-07-17 21:12:42.219 INFO [YellDAO]: Entered getDataBySECriteria(Integer, Timestamp)!
2011-07-17 21:12:42.279 INFO [Version]: Hibernate Annotations 3.3.1.GA
2011-07-17 21:12:42.323 INFO [Environment]: Hibernate 3.2.6
2011-07-17 21:12:42.822 INFO [Environment]: hibernate.properties not found
2011-07-17 21:12:42.838 INFO [Environment]: Bytecode provider name : cglib
2011-07-17 21:12:42.855 INFO [Environment]: using JDK 1.4 java.sql.Timestamp handling
2011-07-17 21:12:43.270 INFO [Configuration]: configuring from resource: yell_service_hibernate.cfg.xml
2011-07-17 21:12:43.282 INFO [Configuration]: Configuration resource: yell_service_hibernate.cfg.xml
2011-07-17 21:12:44.067 INFO [Configuration]: Configured SessionFactory: YellBudgetServiceSessionFactory
2011-07-17 21:12:45.071 INFO [AnnotationBinder]: Binding entity from annotated class: com.thesearchagency.yell.model.YellAccounts
2011-07-17 21:12:45.239 INFO [EntityBinder]: Bind entity com.thesearchagency.yell.model.YellAccounts on table yellAccounts
2011-07-17 21:12:45.635 INFO [AnnotationBinder]: Binding entity from annotated class: com.thesearchagency.yell.model.recurse.BudgetNode
2011-07-17 21:12:45.667 INFO [EntityBinder]: Bind entity com.thesearchagency.yell.model.recurse.BudgetNode on table BudgetNode
2011-07-17 21:12:46.476 INFO [AnnotationBinder]: Binding entity from annotated class: com.thesearchagency.yell.model.recurse.Budget
2011-07-17 21:12:46.490 INFO [EntityBinder]: Bind entity com.thesearchagency.yell.model.recurse.Budget on table Budget
2011-07-17 21:12:46.532 INFO [AnnotationBinder]: Binding entity from annotated class: com.thesearchagency.yell.model.recurse.CurrentMonth
2011-07-17 21:12:46.534 INFO [EntityBinder]: Bind entity com.thesearchagency.yell.model.recurse.CurrentMonth on table CurrentMonth
2011-07-17 21:12:47.260 INFO [AnnotationBinder]: Binding entity from annotated class: com.thesearchagency.yell.model.recurse.PerformanceData
2011-07-17 21:12:47.263 INFO [EntityBinder]: Bind entity com.thesearchagency.yell.model.recurse.PerformanceData on table PerformanceData
2011-07-17 21:12:47.368 INFO [AnnotationBinder]: Binding entity from annotated class: com.thesearchagency.yell.model.recurse.NextMonth
2011-07-17 21:12:47.372 INFO [EntityBinder]: Bind entity com.thesearchagency.yell.model.recurse.NextMonth on table NextMonth
2011-07-17 21:12:47.391 INFO [AnnotationBinder]: Binding entity from annotated class: com.thesearchagency.yell.model.recurse.PreviousMonth
2011-07-17 21:12:47.394 INFO [EntityBinder]: Bind entity com.thesearchagency.yell.model.recurse.PreviousMonth on table PreviousMonth
2011-07-17 21:12:47.410 INFO [AnnotationBinder]: Binding entity from annotated class: com.thesearchagency.yell.model.recurse.Children
2011-07-17 21:12:47.410 INFO [EntityBinder]: Bind entity com.thesearchagency.yell.model.recurse.Children on table Children
2011-07-17 21:12:47.824 INFO [AnnotationBinder]: Binding entity from annotated class: com.thesearchagency.yell.model.recurse.YellError
2011-07-17 21:12:47.828 INFO [EntityBinder]: Bind entity com.thesearchagency.yell.model.recurse.YellError on table YellError
2011-07-17 21:12:48.196 INFO [AnnotationConfiguration]: Hibernate Validator not found: ignoring
2011-07-17 21:12:48.230 INFO [ConnectionProviderFactory]: Initializing connection provider: org.hibernate.connection.C3P0ConnectionProvider
2011-07-17 21:12:48.240 INFO [C3P0ConnectionProvider]: C3P0 using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://yell-01-write:3306/yell
2011-07-17 21:12:48.242 INFO [C3P0ConnectionProvider]: Connection properties: {autoReconnect=true, is-connection-validation-required=true, user=spike, password=****, autocommit=false, autoReconnectForPools=true}
2011-07-17 21:12:48.242 INFO [C3P0ConnectionProvider]: autocommit mode: false
2011-07-17 21:12:48.314 INFO [MLog]: MLog clients using log4j logging.
2011-07-17 21:12:49.088 INFO [C3P0Registry]: Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace: 10]
2011-07-17 21:12:49.904 INFO [C3P0ConnectionProvider]: JDBC isolation level: READ_COMMITTED
2011-07-17 21:12:50.100 INFO [AbstractPoolBackedDataSource]: Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@920d6257 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@226d15b6 [ acquireIncrement -> 1, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, debugUnreturnedConnectionStackTraces -> false, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hge6tn8hghsj0w15wb0h5|5006279d, idleConnectionTestPeriod -> 100, initialPoolSize -> 1, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 100, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 200, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 1, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@a8d2c48f [ description -> null, driverClass -> null, factoryClassLocation -> null, identityToken -> 1hge6tn8hghsj0w15wb0h5|609a18a0, jdbcUrl -> jdbc:mysql://yell-01-write:3306/yell, properties -> {autoReconnect=true, is-connection-validation-required=true, user=******, password=******, autocommit=false, autoReconnectForPools=true} ], preferredTestQuery -> null, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false; userOverrides: {} ], dataSourceName -> null, factoryClassLocation -> null, identityToken -> 1hge6tn8hghsj0w15wb0h5|6f03fcaa, numHelperThreads -> 3 ]
2011-07-17 21:12:52.022 INFO [SettingsFactory]: RDBMS: MySQL, version: 5.0.30-enterprise-gpl
2011-07-17 21:12:52.025 INFO [SettingsFactory]: JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.0.4 ( $Date: 2006-10-19 17:47:48 +0200 (Thu, 19 Oct 2006) $, $Revision: 5908 $ )
2011-07-17 21:12:52.088 INFO [Dialect]: Using dialect: org.hibernate.dialect.MySQLInnoDBDialect
2011-07-17 21:12:52.106 INFO [TransactionFactoryFactory]: Using default transaction strategy (direct JDBC transactions)
2011-07-17 21:12:52.113 INFO [TransactionManagerLookupFactory]: No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
2011-07-17 21:12:52.113 INFO [SettingsFactory]: Automatic flush during beforeCompletion(): disabled
2011-07-17 21:12:52.114 INFO [SettingsFactory]: Automatic session close at end of transaction: disabled
2011-07-17 21:12:52.114 INFO [SettingsFactory]: JDBC batch size: 15
2011-07-17 21:12:52.114 INFO [SettingsFactory]: JDBC batch updates for versioned data: disabled
2011-07-17 21:12:52.118 INFO [SettingsFactory]: Scrollable result sets: enabled
2011-07-17 21:12:52.118 INFO [SettingsFactory]: JDBC3 getGeneratedKeys(): enabled
2011-07-17 21:12:52.118 INFO [SettingsFactory]: Connection release mode: auto
2011-07-17 21:12:52.122 INFO [SettingsFactory]: Maximum outer join fetch depth: 2
2011-07-17 21:12:52.122 INFO [SettingsFactory]: Default batch fetch size: 1
2011-07-17 21:12:52.124 INFO [SettingsFactory]: Generate SQL with comments: disabled
2011-07-17 21:12:52.124 INFO [SettingsFactory]: Order SQL updates by primary key: disabled
2011-07-17 21:12:52.124 INFO [SettingsFactory]: Order SQL inserts for batching: disabled
2011-07-17 21:12:52.124 INFO [SettingsFactory]: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
2011-07-17 21:12:52.133 INFO [ASTQueryTranslatorFactory]: Using ASTQueryTranslatorFactory
2011-07-17 21:12:52.161 INFO [SettingsFactory]: Query language substitutions: {}
2011-07-17 21:12:52.162 INFO [SettingsFactory]: JPA-QL strict compliance: disabled
2011-07-17 21:12:52.162 INFO [SettingsFactory]: Second-level cache: enabled
2011-07-17 21:12:52.162 INFO [SettingsFactory]: Query cache: disabled
2011-07-17 21:12:52.162 INFO [SettingsFactory]: Cache provider: org.hibernate.cache.NoCacheProvider
2011-07-17 21:12:52.165 INFO [SettingsFactory]: Optimize cache for minimal puts: disabled
2011-07-17 21:12:52.165 INFO [SettingsFactory]: Structured second-level cache entries: disabled
2011-07-17 21:12:52.181 INFO [SettingsFactory]: Statistics: disabled
2011-07-17 21:12:52.181 INFO [SettingsFactory]: Deleted entity synthetic identifier rollback: disabled
2011-07-17 21:12:52.185 INFO [SettingsFactory]: Default entity-mode: pojo
2011-07-17 21:12:52.185 INFO [SettingsFactory]: Named query checking : enabled
2011-07-17 21:12:52.474 INFO [Version]: Hibernate Search 3.0.0.GA
java.lang.NoClassDefFoundError: javax/transaction/Synchronization
        at org.hibernate.search.backend.WorkerFactory.createWorker(WorkerFactory.java:38)
        at org.hibernate.search.impl.SearchFactoryImpl.<init>(SearchFactoryImpl.java:100)
        at org.hibernate.search.impl.SearchFactoryImpl.getSearchFactory(SearchFactoryImpl.java:172)
        at org.hibernate.search.event.FullTextIndexEventListener.initialize(FullTextIndexEventListener.java:44)
        at org.hibernate.event.EventListeners.initializeListeners(EventListeners.java:417)
        at org.hibernate.cfg.Configuration.getInitializedEventListeners(Configuration.java:1310)
        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1300)
        at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:859)
        at com.thesearchagency.yell.dao.util.YellServiceHibernateUtil.<init>(YellServiceHibernateUtil.java:32)
        at com.thesearchagency.yell.dao.util.YellServiceHibernateUtil.getInstance(YellServiceHibernateUtil.java:49)
        at com.thesearchagency.yell.dao.util.YellServiceHibernateUtil.getSessionFactory(YellServiceHibernateUtil.java:62)
        at com.thesearchagency.yell.dao.YellDAO.beginPrivateTransaction(YellDAO.java:681)
        at com.thesearchagency.yell.dao.YellDAO.getDataBySECriteria(YellDAO.java:158)
        at com.thesearchagency.searchengines.budget.reporting.PerformanceCalculator.getDataByCriteria(PerformanceCalculator.java:86)
        at com.thesearchagency.searchengines.budget.reporting.PerformanceCalculator.getDataRow(PerformanceCalculator.java:66)
        at com.thesearchagency.searchengines.budget.reporting.PerformanceCalculator.updatePerformanceData(PerformanceCalculator.java:45)
        at com.thesearchagency.searchengines.budget.reporting.reports.BudgettingReport.executePerformanceOperations(BudgettingReport.java:311)
        at com.thesearchagency.searchengines.budget.reporting.ReportRunner.executePerformanceOperations(ReportRunner.java:90)
        at com.thesearchagency.searchengines.budget.reporting.ReportRunner.executeReportOperations(ReportRunner.java:69)
        at com.thesearchagency.searchengines.budget.reporting.ReportRunner.main(ReportRunner.java:60)
2011-07-17 21:12:52.554 ERROR [YellServiceHibernateUtil]: Initializing the Yell Service Hibernate Configuration...
2011-07-17 21:12:52.554 INFO [YellDAO]: Entered getNodeBySEAcctId(Integer)!
2011-07-17 21:12:52.556 (2) [main]: No yell mapping found for seacct id :: 43, skipping report section!
2011-07-17 21:12:52.558 INFO [YellDAO]: Entered getDataBySECriteria(Integer, Timestamp)!
2011-07-17 21:12:52.558 INFO [YellDAO]: Entered getNodeBySEAcctId(Integer)!
2011-07-17 21:12:52.558 (2) [main]: No yell mapping found for seacct id :: 33984, skipping report section!
2011-07-17 21:12:52.560 INFO [YellDAO]: Entered getDataBySECriteria(Integer, Timestamp)!
2011-07-17 21:12:52.561 INFO [YellDAO]: Entered getNodeBySEAcctId(Integer)!
2011-07-17 21:12:52.561 (2) [main]: No yell mapping found for seacct id :: 32362, skipping report section!
2011-07-17 21:12:52.562 INFO [YellDAO]: Entered getDataBySECriteria(Integer, Timestamp)!
2011-07-17 21:12:52.562 INFO [YellDAO]: Entered getNodeBySEAcctId(Integer)!
2011-07-17 21:12:52.564 (2) [main]: No yell mapping found for seacct id :: 33696, skipping report section!
2011-07-17 21:12:52.614 (3) [main]: Deleted report for Account #(17) for Sun Nov 01 00:00:00 PDT 2009
2011-07-17 21:12:52.616 (3) [main]: Running Yesterday Report!
2011-07-17 21:12:52.617 (3) [main]: Requesting report for Account #(17) for Sun Nov 01 00:00:00 PDT 2009
2011-07-17 21:12:52.618 (3) [main]: Requesting WSDL from http://svc-rptv2.svc.thesearchagency.com:8080/svc-rptv2.1/ReportService2.1?wsdl with 180000 ms timeout
2011-07-17 21:13:03.089 (3) [main]: Report ID :: 336636
2011-07-17 21:13:08.295 (3) [main]: Report ok for Account #(17) for Sun Nov 01 00:00:00 PDT 2009
2011-07-17 21:13:08.307 INFO [YellDAO]: Entered getDataBySECriteria(Integer, Timestamp)!
2011-07-17 21:13:08.309 INFO [YellDAO]: Entered getNodeBySEAcctId(Integer)!
2011-07-17 21:13:08.309 (2) [main]: No yell mapping found for seacct id :: 43, skipping report section!
2011-07-17 21:13:08.310 INFO [YellDAO]: Entered getDataBySECriteria(Integer, Timestamp)!
2011-07-17 21:13:08.310 INFO [YellDAO]: Entered getNodeBySEAcctId(Integer)!
2011-07-17 21:13:08.311 (2) [main]: No yell mapping found for seacct id :: 33984, skipping report section!
2011-07-17 21:13:08.311 INFO [YellDAO]: Entered getDataBySECriteria(Integer, Timestamp)!
2011-07-17 21:13:08.311 INFO [YellDAO]: Entered getNodeBySEAcctId(Integer)!
2011-07-17 21:13:08.313 (2) [main]: No yell mapping found for seacct id :: 20493, skipping report section!
2011-07-17 21:13:08.314 INFO [YellDAO]: Entered getDataBySECriteria(Integer, Timestamp)!
2011-07-17 21:13:08.314 INFO [YellDAO]: Entered getNodeBySEAcctId(Integer)!
2011-07-17 21:13:08.314 (2) [main]: No yell mapping found for seacct id :: 32362, skipping report section!
2011-07-17 21:13:08.315 INFO [YellDAO]: Entered getDataBySECriteria(Integer, Timestamp)!
2011-07-17 21:13:08.315 INFO [YellDAO]: Entered getNodeBySEAcctId(Integer)!
2011-07-17 21:13:08.315 (2) [main]: No yell mapping found for seacct id :: 33696, skipping report section!
2011-07-17 21:13:08.363 (3) [main]: Deleted report for Account #(17) for Sun Nov 01 00:00:00 PDT 2009