Uploaded image for project: 'AdMaxLocal'
  1. AdMaxLocal
  2. AML-3247

Rejection report tool throwing characterEncoding error

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: Fuji
    • Fix Version/s: Fuji
    • Component/s: None
    • Labels:
      None
    • Environment:

      QA7 Monman1

      Description

      When we run the rejection report then we are getting exception.

      Steps to reproduce.

      Step 1: Login to monman server
      Step 2: Run the following command
      ./rejection-report.sh -U 651,649

      Snippet of the log

      2014-11-26 12:01:27 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 12:01:27 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)

      Please find full log attached.

        Attachments

          Activity

            People

            • Assignee:
              anil.kumar Anil Kumar Halmadgi
              Reporter:
              anil.kumar Anil Kumar Halmadgi
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: