[amlops@aml-qa7-monman1 conf]$ ./rejection-report.sh -U 651,649
-bash: ./rejection-report.sh: No such file or directory
[amlops@aml-qa7-monman1 conf]$ cd ..
[amlops@aml-qa7-monman1 ops-reports]$ ./rejection-report.sh -U 651,649
=================== Starting YJP Rejection Report Downloader with [ -U 651,649]
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/amlops/YPJReporting/ops-reporting-build-0.0.1-SNAPSHOT/libs/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/amlops/YPJReporting/ops-reporting-build-0.0.1-SNAPSHOT/libs/yj-soap-client-1.0.1-SNAPSHOT.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
2014-11-26 11:41:50 INFO - Using todays date: 2014-11-26
2014-11-26 11:41:50 INFO - =============== Starting YahooJapanRejectionReportDownloader ================
2014-11-26 11:41:50 INFO - ----------------YahooJapanRejectionReportDownloader starting
2014-11-26 11:41:50 INFO - Refreshing org.springframework.context.support.FileSystemXmlApplicationContext@51a669d5: display name [org.springframework.context.support.FileSystemXmlApplicationContext@51a669d5]; startup date [Wed Nov 26 11:41:50 UTC 2014]; root of context hierarchy
2014-11-26 11:41:50 INFO - Loading XML bean definitions from file [/home/amlops/YPJReporting/ops-reporting-build-0.0.1-SNAPSHOT/conf/applicationContext.xml]
2014-11-26 11:41:51 INFO - Bean factory for application context [org.springframework.context.support.FileSystemXmlApplicationContext@51a669d5]: org.springframework.beans.factory.support.DefaultListableBeanFactory@38a07e00
2014-11-26 11:41:51 INFO - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@38a07e00: defining beans [tsaCommonMaster,stagingMaster,tsaCommonSearchEngineUserDAO,rejectedTextAdReportDAO,rejectedKeywordReportDAO,rejectedFeedItemReportDAO]; root of factory hierarchy
2014-11-26 11:41:51 INFO - Running query: select u.id,u.accountID,u.distributionID,u.searchEngineIdentifier,u.description,u.username,u.password,u.enabled,u.inTsaMcc,u.apiKey,u.managerUsernames,u.managerIDs,a.currencyCode from searchEngineUsers u join accounts a on a.id=u.accountID where a.isActive = 'true' and u.enabled = 'true' and u.distributionID = 178 and u.id in (651,649) and u.accountID != 0 ORDER BY a.id DESC
2014-11-26 11:41:51 ERROR - Error getting search engine users
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Unknown initial character set index '45' received from server. Initial client character set can be forced via the 'characterEncoding' property.)
        at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:382)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:464)
        at com.thesearchagency.opsreporting.yahoojapan.dao.impl.SearchEngineUserDAOImpl.getSearchEngineUsers(SearchEngineUserDAOImpl.java:81)
        at com.thesearchagency.opsreporting.yahoojapan.YJSearchEngineUserDispatcher.call(YJSearchEngineUserDispatcher.java:95)
        at com.thesearchagency.opsreporting.yahoojapan.reporting.YahooJapanRejectionReportDownloader.run(YahooJapanRejectionReportDownloader.java:194)
        at com.thesearchagency.opsreporting.yahoojapan.reporting.YahooJapanRejectionReportDownloader.main(YahooJapanRejectionReportDownloader.java:81)
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Unknown initial character set index '45' received from server. Initial client character set can be forced via the 'characterEncoding' property.)
        at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
        at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
        at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
        at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
        at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
        ... 7 more
Caused by: java.sql.SQLException: Unknown initial character set index '45' received from server. Initial client character set can be forced via the 'characterEncoding' property.
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
        at com.mysql.jdbc.Connection.configureClientCharacterSet(Connection.java:2345)
        at com.mysql.jdbc.Connection.initializePropsFromServer(Connection.java:3913)
        at com.mysql.jdbc.Connection.createNewIO(Connection.java:2683)
        at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
        at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
        at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
        at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
        at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
        ... 11 more
2014-11-26 11:41:51 INFO - ------------YahooJapanRejectionReportDownloader done
2014-11-26 11:41:51 INFO - =============== Completed YahooJapanRejectionReportDownloader ================

=================== Starting YJP Rejection Report Generator with [ -U 651,649 ]
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/amlops/YPJReporting/ops-reporting-build-0.0.1-SNAPSHOT/libs/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/amlops/YPJReporting/ops-reporting-build-0.0.1-SNAPSHOT/libs/yj-soap-client-1.0.1-SNAPSHOT.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
2014-11-26 11:41:52 INFO - No date provided. Using todays date: 2014-11-26
2014-11-26 11:41:52 INFO - =============== Starting YahooJapanReportGenerator ================
2014-11-26 11:41:52 INFO - ----------------YahooJapanReportGenerator starting
2014-11-26 11:41:52 INFO - Refreshing org.springframework.context.support.FileSystemXmlApplicationContext@114beb40: display name [org.springframework.context.support.FileSystemXmlApplicationContext@114beb40]; startup date [Wed Nov 26 11:41:52 UTC 2014]; root of context hierarchy
2014-11-26 11:41:52 INFO - Loading XML bean definitions from file [/home/amlops/YPJReporting/ops-reporting-build-0.0.1-SNAPSHOT/conf/applicationContext.xml]
2014-11-26 11:41:52 INFO - Bean factory for application context [org.springframework.context.support.FileSystemXmlApplicationContext@114beb40]: org.springframework.beans.factory.support.DefaultListableBeanFactory@62afc459
2014-11-26 11:41:53 INFO - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@62afc459: defining beans [tsaCommonMaster,stagingMaster,tsaCommonSearchEngineUserDAO,rejectedTextAdReportDAO,rejectedKeywordReportDAO,rejectedFeedItemReportDAO]; root of factory hierarchy
2014-11-26 11:41:53 INFO - Running query: select u.id,u.accountID,u.distributionID,u.searchEngineIdentifier,u.description,u.username,u.password,u.enabled,u.inTsaMcc,u.apiKey,u.managerUsernames,u.managerIDs,a.currencyCode from searchEngineUsers u join accounts a on a.id=u.accountID where a.isActive = 'true' and u.enabled = 'true' and u.distributionID = 178 and u.id in (651,649) ORDER BY a.id DESC
2014-11-26 11:41:53 ERROR - Error running YahooJapanReportGenerator
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Unknown initial character set index '45' received from server. Initial client character set can be forced via the 'characterEncoding' property.)
        at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:382)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:464)
        at com.thesearchagency.opsreporting.yahoojapan.dao.impl.SearchEngineUserDAOImpl.getSearchEngineUsers(SearchEngineUserDAOImpl.java:81)
        at com.thesearchagency.opsreporting.yahoojapan.YJReportGeneratorDispatcher.call(YJReportGeneratorDispatcher.java:91)
        at com.thesearchagency.opsreporting.yahoojapan.reporting.YahooJapanReportGenerator.run(YahooJapanReportGenerator.java:218)
        at com.thesearchagency.opsreporting.yahoojapan.reporting.YahooJapanReportGenerator.main(YahooJapanReportGenerator.java:79)
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Unknown initial character set index '45' received from server. Initial client character set can be forced via the 'characterEncoding' property.)
        at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
        at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
        at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
        at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
        at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
        ... 7 more
Caused by: java.sql.SQLException: Unknown initial character set index '45' received from server. Initial client character set can be forced via the 'characterEncoding' property.
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
        at com.mysql.jdbc.Connection.configureClientCharacterSet(Connection.java:2345)
        at com.mysql.jdbc.Connection.initializePropsFromServer(Connection.java:3913)
        at com.mysql.jdbc.Connection.createNewIO(Connection.java:2683)
        at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
        at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
        at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
        at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
        at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
        ... 11 more