API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 20th, 2016
168
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 107.53 KB | None | 0 0
raw download clone embed print report
  1. 21-01 16:03:07.609 ERROR [ga.misc] 113 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  2. Appender:mFile was null: 21-01 16:03:07.608 TCPServerConnection..........................connect() (initializing connection to [localhost:9000])
  3.  
  4. 21-01 16:03:07.608 INFO [client] 113 - TCPServerConnection..........................connect() (initializing connection to [localhost:9000])
  5. 21-01 16:03:07.611 ERROR [ga.misc] 114 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  6. Appender:mFile was null: 21-01 16:03:07.610 TCPServerConnection..........................connect() (Failed to connect to [localhost:9000])
  7.  
  8. 21-01 16:03:07.610 ERROR [client] 114 - TCPServerConnection..........................connect() (Failed to connect to [localhost:9000])
  9. 21-01 16:03:07.612 ERROR [ga.misc] 114 - cannot log to /Users/novatti/Documents/java_project/log/evds_exception_20160121_00.log
  10. Appender:mFile was null: 21-01 16:03:07.611 TCPServerConnection..........................connect() (Failed to connect to [localhost:9000])
  11.  
  12. 21-01 16:03:07.611 ERROR [exception] 114 - TCPServerConnection..........................connect() (Failed to connect to [localhost:9000])
  13. 21-01 16:03:08.342 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  14. Appender:mFile was null: 21-01 16:03:08.342 SoapServer...................................logging() (Inbound Message
  15. ----------------------------
  16. ID: 66
  17. Address: /agent
  18. Encoding: UTF-8
  19. Content-Type: application/soap+xml; charset=utf-8
  20. Headers: {Accept=[application/soap+xml, text/html, image/gif, image/jpeg, *; q=.2, */*; q=.2], accept-encoding=[gzip], Content-Length=[625], content-type=[application/soap+xml; charset=utf-8], Host=[localhost:9046], SOAPAction=[""], User-Agent=[Jakarta Commons-HttpClient/3.1]}
  21. Payload: <?xml version="1.0" encoding="UTF-8"?>
  22. <env:Envelope xmlns:env="http://www.w3.org/2003/05/soap-envelope">
  23.   <env:Header/>
  24.   <env:Body>
  25.     <ns3:SoapAgentLoginRequest xmlns:ns3="http://soap.api.novatti.com/types" xmlns:ns4="urn:secureHaiService/types" xmlns="">
  26.       <header>
  27.         <authentication>
  28.           <terminalId>AGENT517</terminalId>
  29.           <userName>agent517</userName>
  30.           <password>*****</password>
  31.         </authentication>
  32.         <agentVersion>scp-1.0</agentVersion>
  33.         <agentTransactionId>1453352588303</agentTransactionId>
  34.         <agentTerminalId>1</agentTerminalId>
  35.         <agentTimeStamp>2016-01-21T16:03:08.303+11:00</agentTimeStamp>
  36.         <languageCode>en</languageCode>
  37.       </header>
  38.     </ns3:SoapAgentLoginRequest>
  39.   </env:Body>
  40. </env:Envelope>
  41.  
  42. --------------------------------------)
  43.  
  44. 21-01 16:03:08.342 DEBUG [client] 112 - SoapServer...................................logging() (Inbound Message
  45. ----------------------------
  46. ID: 66
  47. Address: /agent
  48. Encoding: UTF-8
  49. Content-Type: application/soap+xml; charset=utf-8
  50. Headers: {Accept=[application/soap+xml, text/html, image/gif, image/jpeg, *; q=.2, */*; q=.2], accept-encoding=[gzip], Content-Length=[625], content-type=[application/soap+xml; charset=utf-8], Host=[localhost:9046], SOAPAction=[""], User-Agent=[Jakarta Commons-HttpClient/3.1]}
  51. Payload: <?xml version="1.0" encoding="UTF-8"?>
  52. <env:Envelope xmlns:env="http://www.w3.org/2003/05/soap-envelope">
  53.   <env:Header/>
  54.   <env:Body>
  55.     <ns3:SoapAgentLoginRequest xmlns:ns3="http://soap.api.novatti.com/types" xmlns:ns4="urn:secureHaiService/types" xmlns="">
  56.       <header>
  57.         <authentication>
  58.           <terminalId>AGENT517</terminalId>
  59.           <userName>agent517</userName>
  60.           <password>*****</password>
  61.         </authentication>
  62.         <agentVersion>scp-1.0</agentVersion>
  63.         <agentTransactionId>1453352588303</agentTransactionId>
  64.         <agentTerminalId>1</agentTerminalId>
  65.         <agentTimeStamp>2016-01-21T16:03:08.303+11:00</agentTimeStamp>
  66.         <languageCode>en</languageCode>
  67.       </header>
  68.     </ns3:SoapAgentLoginRequest>
  69.   </env:Body>
  70. </env:Envelope>
  71.  
  72. --------------------------------------)
  73. 21-01 16:03:08.351 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  74. Appender:mFile was null: 21-01 16:03:08.351 Listener.....................................doProcess() (start)
  75.  
  76. 21-01 16:03:08.351 DEBUG [client] 112 - Listener.....................................doProcess() (start)
  77. 21-01 16:03:08.352 ERROR [ga.misc] 113 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  78. Appender:mFile was null: 21-01 16:03:08.352 GenericRequestTranslator.....................parse() (Mapping [com.novatti.api.soap.types.SoapAgentLoginRequest] to [com.novatti.api.message.request.AgentLoginRequest])
  79.  
  80. 21-01 16:03:08.352 INFO [client] 113 - GenericRequestTranslator.....................parse() (Mapping [com.novatti.api.soap.types.SoapAgentLoginRequest] to [com.novatti.api.message.request.AgentLoginRequest])
  81. 21-01 16:03:08.355 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_general_20160121_00.log
  82. Appender:mFile was null: 21-01 16:03:08.354 [EVDS_3 453352588353132] AgentLoginRequest...............setTransId - Setting transId to 453352588353132
  83.  
  84. 21-01 16:03:08.354 DEBUG [general] 112 - [EVDS_3 453352588353132] AgentLoginRequest...............setTransId - Setting transId to 453352588353132
  85. 21-01 16:03:08.357 ERROR [ga.misc] 113 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  86. Appender:mFile was null: 21-01 16:03:08.356 RegexConverter...............................convertFrom() (Validations: [true, false, true])
  87.  
  88. 21-01 16:03:08.356 INFO [client] 113 - RegexConverter...............................convertFrom() (Validations: [true, false, true])
  89. 21-01 16:03:08.358 ERROR [ga.misc] 113 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  90. Appender:mFile was null: 21-01 16:03:08.357 RegexConverter...............................doConvert() (Mapping value: [127.0.0.1|] using regex: [^(\d+\.\d+\.\d+\.\d+)\|.*$])
  91.  
  92. 21-01 16:03:08.357 INFO [client] 113 - RegexConverter...............................doConvert() (Mapping value: [127.0.0.1|] using regex: [^(\d+\.\d+\.\d+\.\d+)\|.*$])
  93. 21-01 16:03:08.359 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  94. Appender:mFile was null: 21-01 16:03:08.358 RegexConverter...............................doConvert() (Group 1 = 127.0.0.1)
  95.  
  96. 21-01 16:03:08.358 DEBUG [client] 112 - RegexConverter...............................doConvert() (Group 1 = 127.0.0.1)
  97. 21-01 16:03:08.359 ERROR [ga.misc] 113 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  98. Appender:mFile was null: 21-01 16:03:08.359 RegexConverter...............................doConvert() (Result: [127.0.0.1])
  99.  
  100. 21-01 16:03:08.359 INFO [client] 113 - RegexConverter...............................doConvert() (Result: [127.0.0.1])
  101. 21-01 16:03:08.360 ERROR [ga.misc] 113 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  102. Appender:mFile was null: 21-01 16:03:08.360 ExpressionConverter..........................convert() (Validations: [true, false, true])
  103.  
  104. 21-01 16:03:08.360 INFO [client] 113 - ExpressionConverter..........................convert() (Validations: [true, false, true])
  105. 21-01 16:03:08.361 ERROR [ga.misc] 113 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  106. Appender:mFile was null: 21-01 16:03:08.361 ExpressionConverter..........................doConvert() (Mapping value: [2016-01-21T16:03:08.303+11:00] using expression: [#{@soapUtils.normalizeXmlAgentTimeStamp(#sourceFieldValue)}])
  107.  
  108. 21-01 16:03:08.361 INFO [client] 113 - ExpressionConverter..........................doConvert() (Mapping value: [2016-01-21T16:03:08.303+11:00] using expression: [#{@soapUtils.normalizeXmlAgentTimeStamp(#sourceFieldValue)}])
  109. 21-01 16:03:08.363 ERROR [ga.misc] 113 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  110. Appender:mFile was null: 21-01 16:03:08.363 ExpressionConverter..........................doConvert() (Result: [Thu Jan 21 16:03:08 AEDT 2016])
  111.  
  112. 21-01 16:03:08.363 INFO [client] 113 - ExpressionConverter..........................doConvert() (Result: [Thu Jan 21 16:03:08 AEDT 2016])
  113. 21-01 16:03:08.364 ERROR [ga.misc] 113 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  114. Appender:mFile was null: 21-01 16:03:08.364 ExpressionConverter..........................convert() (Validations: [true, false, true])
  115.  
  116. 21-01 16:03:08.364 INFO [client] 113 - ExpressionConverter..........................convert() (Validations: [true, false, true])
  117. 21-01 16:03:08.365 ERROR [ga.misc] 113 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  118. Appender:mFile was null: 21-01 16:03:08.364 ExpressionConverter..........................doConvert() (Mapping value: [2016-01-21T16:03:08.303+11:00] using expression: [#{@soapUtils.extractXmlAgentTimeZone(#sourceFieldValue)}])
  119.  
  120. 21-01 16:03:08.364 INFO [client] 113 - ExpressionConverter..........................doConvert() (Mapping value: [2016-01-21T16:03:08.303+11:00] using expression: [#{@soapUtils.extractXmlAgentTimeZone(#sourceFieldValue)}])
  121. 21-01 16:03:08.366 ERROR [ga.misc] 113 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  122. Appender:mFile was null: 21-01 16:03:08.365 ExpressionConverter..........................doConvert() (Result: [660])
  123.  
  124. 21-01 16:03:08.365 INFO [client] 113 - ExpressionConverter..........................doConvert() (Result: [660])
  125. 21-01 16:03:08.367 ERROR [ga.misc] 113 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  126. Appender:mFile was null: 21-01 16:03:08.366 GenericRequestTranslator.....................validate() (Validating [com.novatti.api.message.request.AgentLoginRequest])
  127.  
  128. 21-01 16:03:08.366 INFO [client] 113 - GenericRequestTranslator.....................validate() (Validating [com.novatti.api.message.request.AgentLoginRequest])
  129. 21-01 16:03:08.373 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_dao_20160121_00.log
  130. Appender:mFile was null: 21-01 16:03:08.372 Preparing Query SQL
  131.  
  132. SELECT id,code,description,value,operator_id,cts,uts FROM tti_app_setting WHERE code=? AND operator_id IS NULL ORDER BY id ASC
  133.  
  134.  
  135. 21-01 16:03:08.372 DEBUG [dao] 112 - Preparing Query SQL
  136.  
  137. SELECT id,code,description,value,operator_id,cts,uts FROM tti_app_setting WHERE code=? AND operator_id IS NULL ORDER BY id ASC
  138.  
  139. 21-01 16:03:08.373 DEBUG [com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate] 637 - Executing prepared SQL query
  140. 21-01 16:03:08.373 DEBUG [com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate] 572 - Executing prepared SQL statement
  141. 21-01 16:03:08.378 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_data_20160121_00.log
  142. Appender:mFile was null: 21-01 16:03:08.378 [EVDS_3] GenericJDBCDao..................setStatementClauses - Setting param at index [1] to [CACHE.REFRESH]
  143.  
  144. 21-01 16:03:08.378 DEBUG [data] 112 - [EVDS_3] GenericJDBCDao..................setStatementClauses - Setting param at index [1] to [CACHE.REFRESH]
  145. 21-01 16:03:08.383 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_data_20160121_00.log
  146. Appender:mFile was null: 21-01 16:03:08.383 [EVDS_3] GenericJDBCDao..................getCacheList - SELECT id,code,description,value,operator_id,cts,uts FROM tti_app_setting ORDER BY id ASC
  147.  
  148. 21-01 16:03:08.383 DEBUG [data] 112 - [EVDS_3] GenericJDBCDao..................getCacheList - SELECT id,code,description,value,operator_id,cts,uts FROM tti_app_setting ORDER BY id ASC
  149. 21-01 16:03:08.384 DEBUG [com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate] 637 - Executing prepared SQL query
  150. 21-01 16:03:08.384 DEBUG [com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate] 572 - Executing prepared SQL statement
  151. 21-01 16:03:08.398 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_cache_20160121_00.log
  152. Appender:mFile was null: 21-01 16:03:08.398  [null]CACHE.................................clearListsOfType() (type=com.totaltel.prepaid.tticommon.data.tti.AppSetting)
  153.  
  154. 21-01 16:03:08.398 DEBUG [cache] 112 -  [null]CACHE.................................clearListsOfType() (type=com.totaltel.prepaid.tticommon.data.tti.AppSetting)
  155. 21-01 16:03:08.400 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_cache_20160121_00.log
  156. Appender:mFile was null: 21-01 16:03:08.399  [null]CACHE.................................addType() (com.totaltel.prepaid.tticommon.data.tti.AppSetting)
  157.  
  158. 21-01 16:03:08.399 DEBUG [cache] 112 -  [null]CACHE.................................addType() (com.totaltel.prepaid.tticommon.data.tti.AppSetting)
  159. 21-01 16:03:08.401 ERROR [ga.misc] 116 - cannot log to /Users/novatti/Documents/java_project/log/evds_general_20160121_00.log
  160. Appender:mFile was null: 21-01 16:03:08.400 Value of [API.SETTING.CHANNEL.VALIDATE] application setting is not found. Using the default [NO]
  161.  
  162. 21-01 16:03:08.400 WARN [general] 116 - Value of [API.SETTING.CHANNEL.VALIDATE] application setting is not found. Using the default [NO]
  163. 21-01 16:03:08.402 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_core_20160121_00.log
  164. Appender:mFile was null: 21-01 16:03:08.402 DBG [EVDS_3 453352588353132] VALIDATOR_FACTORY....doCreateFor() (interfaceType=WS key)
  165.  
  166. 21-01 16:03:08.402 DEBUG [core] 112 - DBG [EVDS_3 453352588353132] VALIDATOR_FACTORY....doCreateFor() (interfaceType=WS key)
  167. 21-01 16:03:08.404 ERROR [ga.misc] 116 - cannot log to /Users/novatti/Documents/java_project/log/evds_dao_20160121_00.log
  168. Appender:mFile was null: 21-01 16:03:08.403 DataAccessFactory...cloneDao() (WARNING: Attempt to clone DAO that does not implement  com.totaltel.prepaid.tticommon.dao.ICloneableDao. Returning singleton instead for class: com.totaltel.prepaid.tticommon.dao.erds.jdbc.ClientDao)
  169.  
  170. 21-01 16:03:08.403 WARN [dao] 116 - DataAccessFactory...cloneDao() (WARNING: Attempt to clone DAO that does not implement  com.totaltel.prepaid.tticommon.dao.ICloneableDao. Returning singleton instead for class: com.totaltel.prepaid.tticommon.dao.erds.jdbc.ClientDao)
  171. 21-01 16:03:08.404 ERROR [ga.misc] 116 - cannot log to /Users/novatti/Documents/java_project/log/evds_dao_20160121_00.log
  172. Appender:mFile was null: 21-01 16:03:08.404 DataAccessFactory...cloneDao() (WARNING: Attempt to clone DAO that does not implement  com.totaltel.prepaid.tticommon.dao.ICloneableDao. Returning singleton instead for class: com.totaltel.prepaid.tticommon.dao.erds.jdbc.AgentDao)
  173.  
  174. 21-01 16:03:08.404 WARN [dao] 116 - DataAccessFactory...cloneDao() (WARNING: Attempt to clone DAO that does not implement  com.totaltel.prepaid.tticommon.dao.ICloneableDao. Returning singleton instead for class: com.totaltel.prepaid.tticommon.dao.erds.jdbc.AgentDao)
  175. 21-01 16:03:08.406 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_dao_20160121_00.log
  176. Appender:mFile was null: 21-01 16:03:08.405 Preparing Query SQL
  177.  
  178. SELECT id,code,description,value,operator_id,cts,uts FROM tti_app_setting WHERE code=? AND operator_id IS NULL ORDER BY id ASC
  179.  
  180.  
  181. 21-01 16:03:08.405 DEBUG [dao] 112 - Preparing Query SQL
  182.  
  183. SELECT id,code,description,value,operator_id,cts,uts FROM tti_app_setting WHERE code=? AND operator_id IS NULL ORDER BY id ASC
  184.  
  185. 21-01 16:03:08.406 DEBUG [com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate] 637 - Executing prepared SQL query
  186. 21-01 16:03:08.406 DEBUG [com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate] 572 - Executing prepared SQL statement
  187. 21-01 16:03:08.410 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_data_20160121_00.log
  188. Appender:mFile was null: 21-01 16:03:08.410 [EVDS_3] GenericJDBCDao..................setStatementClauses - Setting param at index [1] to [CACHE.REFRESH]
  189.  
  190. 21-01 16:03:08.410 DEBUG [data] 112 - [EVDS_3] GenericJDBCDao..................setStatementClauses - Setting param at index [1] to [CACHE.REFRESH]
  191. 21-01 16:03:08.414 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_data_20160121_00.log
  192. Appender:mFile was null: 21-01 16:03:08.414 [EVDS_3] GenericJDBCDao..................getCacheList - SELECT id,code,description,value,operator_id,cts,uts FROM tti_app_setting ORDER BY id ASC
  193.  
  194. 21-01 16:03:08.414 DEBUG [data] 112 - [EVDS_3] GenericJDBCDao..................getCacheList - SELECT id,code,description,value,operator_id,cts,uts FROM tti_app_setting ORDER BY id ASC
  195. 21-01 16:03:08.414 DEBUG [com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate] 637 - Executing prepared SQL query
  196. 21-01 16:03:08.414 DEBUG [com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate] 572 - Executing prepared SQL statement
  197. 21-01 16:03:08.729 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_cache_20160121_00.log
  198. Appender:mFile was null: 21-01 16:03:08.729  [null]CACHE.................................clearListsOfType() (type=com.totaltel.prepaid.tticommon.data.tti.AppSetting)
  199.  
  200. 21-01 16:03:08.729 DEBUG [cache] 112 -  [null]CACHE.................................clearListsOfType() (type=com.totaltel.prepaid.tticommon.data.tti.AppSetting)
  201. 21-01 16:03:08.730 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_cache_20160121_00.log
  202. Appender:mFile was null: 21-01 16:03:08.730  [null]CACHE.................................addType() (com.totaltel.prepaid.tticommon.data.tti.AppSetting)
  203.  
  204. 21-01 16:03:08.730 DEBUG [cache] 112 -  [null]CACHE.................................addType() (com.totaltel.prepaid.tticommon.data.tti.AppSetting)
  205. 21-01 16:03:08.731 ERROR [ga.misc] 116 - cannot log to /Users/novatti/Documents/java_project/log/evds_general_20160121_00.log
  206. Appender:mFile was null: 21-01 16:03:08.731 Value of [CLIENT.OPERATOR.SHARED.CATI] application setting is not found. Using the default [false]
  207.  
  208. 21-01 16:03:08.731 WARN [general] 116 - Value of [CLIENT.OPERATOR.SHARED.CATI] application setting is not found. Using the default [false]
  209. 21-01 16:03:08.732 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_data_20160121_00.log
  210. Appender:mFile was null: 21-01 16:03:08.732 [EVDS_3] ClientDao.......................find - sql: select cnt_id,cnt_int_id,cnt_at_id,cnt_msisdn,cnt_op_id,cnt_sts_id,  cnt_soft_ver,cnt_pin,cnt_val_limit,cnt_val_current,  cnt_min_limit,cnt_start_limit,cnt_explain,cnt_cati,  cnt_stan, cnt_trans_maint,cnt_serial_number,cnt_printer_sn,  cnt_current_location,cnt_macid,cnt_init,cnt_cts,cnt_ipaddr,  cnt_tg_id,cnt_use_keys,cnt_data_key,cnt_tmac_key,cnt_rmac_key,  cnt_daily_trans_limit,cnt_daily_trans,  cnt_weekly_trans_limit,cnt_weekly_trans,  cnt_monthly_trans_limit,cnt_monthly_trans,  cnt_last_trans_ts,cnt_dt_id,cnt_failed_authkey_count,cnt_authkey_hint, cnt_saf_type_id, cnt_interface_sub_type_id,cnt_first_trans_ts  from er_client  WHERE cnt_cati=? order by cnt_id
  211.  
  212. 21-01 16:03:08.732 DEBUG [data] 112 - [EVDS_3] ClientDao.......................find - sql: select cnt_id,cnt_int_id,cnt_at_id,cnt_msisdn,cnt_op_id,cnt_sts_id,  cnt_soft_ver,cnt_pin,cnt_val_limit,cnt_val_current,  cnt_min_limit,cnt_start_limit,cnt_explain,cnt_cati,  cnt_stan, cnt_trans_maint,cnt_serial_number,cnt_printer_sn,  cnt_current_location,cnt_macid,cnt_init,cnt_cts,cnt_ipaddr,  cnt_tg_id,cnt_use_keys,cnt_data_key,cnt_tmac_key,cnt_rmac_key,  cnt_daily_trans_limit,cnt_daily_trans,  cnt_weekly_trans_limit,cnt_weekly_trans,  cnt_monthly_trans_limit,cnt_monthly_trans,  cnt_last_trans_ts,cnt_dt_id,cnt_failed_authkey_count,cnt_authkey_hint, cnt_saf_type_id, cnt_interface_sub_type_id,cnt_first_trans_ts  from er_client  WHERE cnt_cati=? order by cnt_id
  213. 21-01 16:03:08.732 DEBUG [com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate] 637 - Executing prepared SQL query
  214. 21-01 16:03:08.733 DEBUG [com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate] 572 - Executing prepared SQL statement
  215. 21-01 16:03:08.741 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_data_20160121_00.log
  216. Appender:mFile was null: 21-01 16:03:08.741 [EVDS_3] AgentDao........................find - sql: select at_id,at_op_id,at_tz_id,at_lev_id,at_md_id,at_at_id,  at_agent_status_id,at_name,at_pay_any,at_is_pp,at_tx_id,at_cts,  at_billing_agent_id,  at_code, at_activation_date, at_short_name, at_sms_cli, at_ad_id,  at_country_id, at_state_id, at_region_id, agent_category_id, sales_user_id, commis_setting_id,  at_hierarchy_level, at_uts  from er_agent a where at_id=517 order by at_id
  217.  
  218. 21-01 16:03:08.741 DEBUG [data] 112 - [EVDS_3] AgentDao........................find - sql: select at_id,at_op_id,at_tz_id,at_lev_id,at_md_id,at_at_id,  at_agent_status_id,at_name,at_pay_any,at_is_pp,at_tx_id,at_cts,  at_billing_agent_id,  at_code, at_activation_date, at_short_name, at_sms_cli, at_ad_id,  at_country_id, at_state_id, at_region_id, agent_category_id, sales_user_id, commis_setting_id,  at_hierarchy_level, at_uts  from er_agent a where at_id=517 order by at_id
  219. 21-01 16:03:08.741 DEBUG [com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate] 637 - Executing prepared SQL query
  220. 21-01 16:03:08.742 DEBUG [com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate] 572 - Executing prepared SQL statement
  221. 21-01 16:03:08.749 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  222. Appender:mFile was null: 21-01 16:03:08.748 Soap Request Translator......................validateApiPermission() (agentId=517)
  223.  
  224. 21-01 16:03:08.748 DEBUG [client] 112 - Soap Request Translator......................validateApiPermission() (agentId=517)
  225. 21-01 16:03:08.750 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  226. Appender:mFile was null: 21-01 16:03:08.749 Soap Request Translator......................validateApiPermission() (agent MD Id=199)
  227.  
  228. 21-01 16:03:08.749 DEBUG [client] 112 - Soap Request Translator......................validateApiPermission() (agent MD Id=199)
  229. 21-01 16:03:08.751 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  230. Appender:mFile was null: 21-01 16:03:08.751 Soap Request Translator......................validateApiPermission() (start match agent authority)
  231.  
  232. 21-01 16:03:08.751 DEBUG [client] 112 - Soap Request Translator......................validateApiPermission() (start match agent authority)
  233. 21-01 16:03:08.752 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  234. Appender:mFile was null: 21-01 16:03:08.752 Soap Request Translator......................matchEntityAuthority() (API Authorities found =0)
  235.  
  236. 21-01 16:03:08.752 DEBUG [client] 112 - Soap Request Translator......................matchEntityAuthority() (API Authorities found =0)
  237. 21-01 16:03:08.753 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  238. Appender:mFile was null: 21-01 16:03:08.753 Soap Request Translator......................validateApiPermission() (start match client authority)
  239.  
  240. 21-01 16:03:08.753 DEBUG [client] 112 - Soap Request Translator......................validateApiPermission() (start match client authority)
  241. 21-01 16:03:08.754 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  242. Appender:mFile was null: 21-01 16:03:08.754 Soap Request Translator......................matchEntityAuthority() (API Authorities found =0)
  243.  
  244. 21-01 16:03:08.754 DEBUG [client] 112 - Soap Request Translator......................matchEntityAuthority() (API Authorities found =0)
  245. 21-01 16:03:08.755 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  246. Appender:mFile was null: 21-01 16:03:08.754 Soap Request Translator......................validateApiPermission() (Agent Client Matched = false)
  247.  
  248. 21-01 16:03:08.754 DEBUG [client] 112 - Soap Request Translator......................validateApiPermission() (Agent Client Matched = false)
  249. 21-01 16:03:08.755 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  250. Appender:mFile was null: 21-01 16:03:08.755 Soap Request Translator......................validateApiPermission() (Agent is Master Distributor = false)
  251.  
  252. 21-01 16:03:08.755 DEBUG [client] 112 - Soap Request Translator......................validateApiPermission() (Agent is Master Distributor = false)
  253. 21-01 16:03:08.756 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_data_20160121_00.log
  254. Appender:mFile was null: 21-01 16:03:08.756 [EVDS_3] AgentDao........................find - sql: select at_id,at_op_id,at_tz_id,at_lev_id,at_md_id,at_at_id,  at_agent_status_id,at_name,at_pay_any,at_is_pp,at_tx_id,at_cts,  at_billing_agent_id,  at_code, at_activation_date, at_short_name, at_sms_cli, at_ad_id,  at_country_id, at_state_id, at_region_id, agent_category_id, sales_user_id, commis_setting_id,  at_hierarchy_level, at_uts  from er_agent a where at_id=199 order by at_id
  255.  
  256. 21-01 16:03:08.756 DEBUG [data] 112 - [EVDS_3] AgentDao........................find - sql: select at_id,at_op_id,at_tz_id,at_lev_id,at_md_id,at_at_id,  at_agent_status_id,at_name,at_pay_any,at_is_pp,at_tx_id,at_cts,  at_billing_agent_id,  at_code, at_activation_date, at_short_name, at_sms_cli, at_ad_id,  at_country_id, at_state_id, at_region_id, agent_category_id, sales_user_id, commis_setting_id,  at_hierarchy_level, at_uts  from er_agent a where at_id=199 order by at_id
  257. 21-01 16:03:08.756 DEBUG [com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate] 637 - Executing prepared SQL query
  258. 21-01 16:03:08.756 DEBUG [com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate] 572 - Executing prepared SQL statement
  259. 21-01 16:03:08.762 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  260. Appender:mFile was null: 21-01 16:03:08.762 Soap Request Translator......................validateApiPermission() (start match MD agent api)
  261.  
  262. 21-01 16:03:08.762 DEBUG [client] 112 - Soap Request Translator......................validateApiPermission() (start match MD agent api)
  263. 21-01 16:03:08.763 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  264. Appender:mFile was null: 21-01 16:03:08.763 Soap Request Translator......................validateApiPermission() (start match MD agent authority)
  265.  
  266. 21-01 16:03:08.763 DEBUG [client] 112 - Soap Request Translator......................validateApiPermission() (start match MD agent authority)
  267. 21-01 16:03:08.764 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  268. Appender:mFile was null: 21-01 16:03:08.764 Soap Request Translator......................matchEntityAuthority() (API Authorities found =1)
  269.  
  270. 21-01 16:03:08.764 DEBUG [client] 112 - Soap Request Translator......................matchEntityAuthority() (API Authorities found =1)
  271. 21-01 16:03:08.765 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  272. Appender:mFile was null: 21-01 16:03:08.765 Soap Request Translator......................matchEntityAuthority() (API Permissions found =1)
  273.  
  274. 21-01 16:03:08.765 DEBUG [client] 112 - Soap Request Translator......................matchEntityAuthority() (API Permissions found =1)
  275. 21-01 16:03:08.766 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  276. Appender:mFile was null: 21-01 16:03:08.765 Soap Request Translator......................validateApiPermission() (Agent Client MD Matched = true)
  277.  
  278. 21-01 16:03:08.765 DEBUG [client] 112 - Soap Request Translator......................validateApiPermission() (Agent Client MD Matched = true)
  279. 21-01 16:03:08.766 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  280. Appender:mFile was null: 21-01 16:03:08.766 Soap Request Translator......................validate() (API Validation processing time=364)
  281.  
  282. 21-01 16:03:08.766 DEBUG [client] 112 - Soap Request Translator......................validate() (API Validation processing time=364)
  283. 21-01 16:03:08.767 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_general_20160121_00.log
  284. Appender:mFile was null: 21-01 16:03:08.767 [EVDS_3] PROCESSOR_TRACKER...............start - Work started
  285.  
  286. 21-01 16:03:08.767 DEBUG [general] 112 - [EVDS_3] PROCESSOR_TRACKER...............start - Work started
  287. 21-01 16:03:08.768 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_general_20160121_00.log
  288. Appender:mFile was null: 21-01 16:03:08.768 [EVDS_3] PROCESSOR_TRACKER...............start - Connection name: [NOVATTI WEB SERVICE]
  289.  
  290. 21-01 16:03:08.768 DEBUG [general] 112 - [EVDS_3] PROCESSOR_TRACKER...............start - Connection name: [NOVATTI WEB SERVICE]
  291. 21-01 16:03:08.769 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_dao_20160121_00.log
  292. Appender:mFile was null: 21-01 16:03:08.769 Preparing SQL
  293.  
  294. insert into er_seq (seq_id) values (?)
  295.     Set: id=0
  296.  
  297.  
  298. 21-01 16:03:08.769 DEBUG [dao] 112 - Preparing SQL
  299.  
  300. insert into er_seq (seq_id) values (?)
  301.     Set: id=0
  302.  
  303. 21-01 16:03:08.770 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_data_20160121_00.log
  304. Appender:mFile was null: 21-01 16:03:08.769 DBG  SequenceDao.............getInsertSqlWithParams() (insert into er_seq (seq_id) values (?))
  305.  
  306. 21-01 16:03:08.769 DEBUG [data] 112 - DBG  SequenceDao.............getInsertSqlWithParams() (insert into er_seq (seq_id) values (?))
  307. 21-01 16:03:08.770 DEBUG [com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate] 847 - Executing SQL update and returning generated keys
  308. 21-01 16:03:08.770 DEBUG [com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate] 572 - Executing prepared SQL statement
  309. 21-01 16:03:08.774 DEBUG [com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate] 866 - SQL update affected 1 rows and returned 1 keys
  310. 21-01 16:03:08.775 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_general_20160121_00.log
  311. Appender:mFile was null: 21-01 16:03:08.774 [EVDS_3 151598    ] AgentLoginRequest...............setTransId - Resetting transId from 453352588353132 to 151598
  312.  
  313. 21-01 16:03:08.774 DEBUG [general] 112 - [EVDS_3 151598    ] AgentLoginRequest...............setTransId - Resetting transId from 453352588353132 to 151598
  314. 21-01 16:03:08.775 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_general_20160121_00.log
  315. Appender:mFile was null: 21-01 16:03:08.775 [EVDS_3] PROCESSOR_FACTORY...............createForKey - Creating processor for key = com.novatti.api.soap.types.SoapAgentLoginRequest
  316.  
  317. 21-01 16:03:08.775 DEBUG [general] 112 - [EVDS_3] PROCESSOR_FACTORY...............createForKey - Creating processor for key = com.novatti.api.soap.types.SoapAgentLoginRequest
  318. 21-01 16:03:08.776 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_general_20160121_00.log
  319. Appender:mFile was null: 21-01 16:03:08.776 [EVDS_3] PROCESSOR_FACTORY...............createForClass - Instantiating class: AgentLoginProcessor
  320.  
  321. 21-01 16:03:08.776 DEBUG [general] 112 - [EVDS_3] PROCESSOR_FACTORY...............createForClass - Instantiating class: AgentLoginProcessor
  322. 21-01 16:03:08.823 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_general_20160121_00.log
  323. Appender:mFile was null: 21-01 16:03:08.822 [EVDS_3] PROCESSOR_TRACKER...............extendProcessor - Processor enhanced: AgentLoginProcessor
  324.  
  325. 21-01 16:03:08.822 DEBUG [general] 112 - [EVDS_3] PROCESSOR_TRACKER...............extendProcessor - Processor enhanced: AgentLoginProcessor
  326. 21-01 16:03:08.823 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_general_20160121_00.log
  327. Appender:mFile was null: 21-01 16:03:08.823 [EVDS_3] PROCESSOR_TRACKER...............extendProcessor - Processor was a StatusProcessor: false
  328.  
  329. 21-01 16:03:08.823 DEBUG [general] 112 - [EVDS_3] PROCESSOR_TRACKER...............extendProcessor - Processor was a StatusProcessor: false
  330. 21-01 16:03:08.825 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_message_20160121_00.log
  331. Appender:mFile was null: 21-01 16:03:08.825 [EVDS_3 151598    ] STACKMGR........................addProcess - Start stackId=151598
  332.  
  333. 21-01 16:03:08.825 DEBUG [message] 112 - [EVDS_3 151598    ] STACKMGR........................addProcess - Start stackId=151598
  334. 21-01 16:03:08.826 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_general_20160121_00.log
  335. Appender:mFile was null: 21-01 16:03:08.825 [EVDS_3 151598    ] AGENT_LOGIN.....................execute - Start
  336.  
  337. 21-01 16:03:08.825 DEBUG [general] 112 - [EVDS_3 151598    ] AGENT_LOGIN.....................execute - Start
  338. 21-01 16:03:08.826 ERROR [ga.misc] 116 - cannot log to /Users/novatti/Documents/java_project/log/evds_event_20160121_00.log
  339. Appender:mFile was null: 21-01 16:03:08.826 (Thread) Subscriber [com.totaltel.prepaid.cwsengine.event.queue.SynchronousEventCallback] has already subscribed to topic [MFA_PINCODE] in queue [EVDSEventQueue].  Removing duplicate subscription
  340.  
  341. 21-01 16:03:08.826 WARN [event] 116 - (Thread) Subscriber [com.totaltel.prepaid.cwsengine.event.queue.SynchronousEventCallback] has already subscribed to topic [MFA_PINCODE] in queue [EVDSEventQueue].  Removing duplicate subscription
  342. 21-01 16:03:08.827 ERROR [ga.misc] 113 - cannot log to /Users/novatti/Documents/java_project/log/evds_event_20160121_00.log
  343. Appender:mFile was null: 21-01 16:03:08.827 (Thread) Subscriber [com.totaltel.prepaid.cwsengine.event.queue.SynchronousEventCallback#1123432624] subscribed to topic [MFA_PINCODE] for thread [NOVATTI WEB SERVICE REQ[null_2],ID:229] in queue [EVDSEventQueue].
  344.  
  345. 21-01 16:03:08.827 INFO [event] 113 - (Thread) Subscriber [com.totaltel.prepaid.cwsengine.event.queue.SynchronousEventCallback#1123432624] subscribed to topic [MFA_PINCODE] for thread [NOVATTI WEB SERVICE REQ[null_2],ID:229] in queue [EVDSEventQueue].
  346. 21-01 16:03:08.827 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_event_20160121_00.log
  347. Appender:mFile was null: 21-01 16:03:08.827 Subscriber [SynchronousEventCallback]added to queue [EVDSEventQueue] for topic [MFA_PINCODE]
  348.  
  349. 21-01 16:03:08.827 DEBUG [event] 112 - Subscriber [SynchronousEventCallback]added to queue [EVDSEventQueue] for topic [MFA_PINCODE]
  350. 21-01 16:03:08.828 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_general_20160121_00.log
  351. Appender:mFile was null: 21-01 16:03:08.828 [EVDS_3] AGENT_LOGIN.....................notifyEvent - Processor event [STARTED] is not notified. Notifier is not configured
  352.  
  353. 21-01 16:03:08.828 DEBUG [general] 112 - [EVDS_3] AGENT_LOGIN.....................notifyEvent - Processor event [STARTED] is not notified. Notifier is not configured
  354. 21-01 16:03:08.830 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_general_20160121_00.log
  355. Appender:mFile was null: 21-01 16:03:08.830 [EVDS_3 151598    ] AgentLoginProcessor.............execute - phase: custom validation start
  356.  
  357. 21-01 16:03:08.830 DEBUG [general] 112 - [EVDS_3 151598    ] AgentLoginProcessor.............execute - phase: custom validation start
  358. 21-01 16:03:08.830 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_core_20160121_00.log
  359. Appender:mFile was null: 21-01 16:03:08.830 DBG [EVDS_3 151598] VALIDATOR_FACTORY.............doCreateFor() (interfaceType=PTL key)
  360.  
  361. 21-01 16:03:08.830 DEBUG [core] 112 - DBG [EVDS_3 151598] VALIDATOR_FACTORY.............doCreateFor() (interfaceType=PTL key)
  362. 21-01 16:03:08.831 ERROR [ga.misc] 116 - cannot log to /Users/novatti/Documents/java_project/log/evds_dao_20160121_00.log
  363. Appender:mFile was null: 21-01 16:03:08.831 DataAccessFactory...cloneDao() (WARNING: Attempt to clone DAO that does not implement  com.totaltel.prepaid.tticommon.dao.ICloneableDao. Returning singleton instead for class: com.totaltel.prepaid.tticommon.dao.erds.jdbc.ClientDao)
  364.  
  365. 21-01 16:03:08.831 WARN [dao] 116 - DataAccessFactory...cloneDao() (WARNING: Attempt to clone DAO that does not implement  com.totaltel.prepaid.tticommon.dao.ICloneableDao. Returning singleton instead for class: com.totaltel.prepaid.tticommon.dao.erds.jdbc.ClientDao)
  366. 21-01 16:03:08.832 ERROR [ga.misc] 116 - cannot log to /Users/novatti/Documents/java_project/log/evds_dao_20160121_00.log
  367. Appender:mFile was null: 21-01 16:03:08.831 DataAccessFactory...cloneDao() (WARNING: Attempt to clone DAO that does not implement  com.totaltel.prepaid.tticommon.dao.ICloneableDao. Returning singleton instead for class: com.totaltel.prepaid.tticommon.dao.erds.jdbc.AgentDao)
  368.  
  369. 21-01 16:03:08.831 WARN [dao] 116 - DataAccessFactory...cloneDao() (WARNING: Attempt to clone DAO that does not implement  com.totaltel.prepaid.tticommon.dao.ICloneableDao. Returning singleton instead for class: com.totaltel.prepaid.tticommon.dao.erds.jdbc.AgentDao)
  370. 21-01 16:03:08.832 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_core_20160121_00.log
  371. Appender:mFile was null: 21-01 16:03:08.832 DBG [EVDS_3 151598] AgentValidator................setBypassAuthKey() (Start false)
  372.  
  373. 21-01 16:03:08.832 DEBUG [core] 112 - DBG [EVDS_3 151598] AgentValidator................setBypassAuthKey() (Start false)
  374. 21-01 16:03:08.833 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_core_20160121_00.log
  375. Appender:mFile was null: 21-01 16:03:08.833 DBG [EVDS_3 151598] AgentValidatorPtl.............validate() (Start atCode=null bypassUserVal=true)
  376.  
  377. 21-01 16:03:08.833 DEBUG [core] 112 - DBG [EVDS_3 151598] AgentValidatorPtl.............validate() (Start atCode=null bypassUserVal=true)
  378. 21-01 16:03:08.834 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_core_20160121_00.log
  379. Appender:mFile was null: 21-01 16:03:08.833 DBG [EVDS_3 151598] AgentValidatorPtl.............validateClient() (Start)
  380.  
  381. 21-01 16:03:08.833 DEBUG [core] 112 - DBG [EVDS_3 151598] AgentValidatorPtl.............validateClient() (Start)
  382. 21-01 16:03:08.834 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_core_20160121_00.log
  383. Appender:mFile was null: 21-01 16:03:08.834 DBG [EVDS_3 151598] AgentValidator................findClientByTerminalId() (Start termId=AGENT517)
  384.  
  385. 21-01 16:03:08.834 DEBUG [core] 112 - DBG [EVDS_3 151598] AgentValidator................findClientByTerminalId() (Start termId=AGENT517)
  386. 21-01 16:03:08.835 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_dao_20160121_00.log
  387. Appender:mFile was null: 21-01 16:03:08.835 Preparing Query SQL
  388.  
  389. SELECT id,code,description,value,operator_id,cts,uts FROM tti_app_setting WHERE code=? AND operator_id IS NULL ORDER BY id ASC
  390.  
  391.  
  392. 21-01 16:03:08.835 DEBUG [dao] 112 - Preparing Query SQL
  393.  
  394. SELECT id,code,description,value,operator_id,cts,uts FROM tti_app_setting WHERE code=? AND operator_id IS NULL ORDER BY id ASC
  395.  
  396. 21-01 16:03:08.835 DEBUG [com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate] 637 - Executing prepared SQL query
  397. 21-01 16:03:08.835 DEBUG [com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate] 572 - Executing prepared SQL statement
  398. 21-01 16:03:08.839 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_data_20160121_00.log
  399. Appender:mFile was null: 21-01 16:03:08.839 [EVDS_3] GenericJDBCDao..................setStatementClauses - Setting param at index [1] to [CACHE.REFRESH]
  400.  
  401. 21-01 16:03:08.839 DEBUG [data] 112 - [EVDS_3] GenericJDBCDao..................setStatementClauses - Setting param at index [1] to [CACHE.REFRESH]
  402. 21-01 16:03:08.843 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_data_20160121_00.log
  403. Appender:mFile was null: 21-01 16:03:08.842 [EVDS_3] GenericJDBCDao..................getCacheList - SELECT id,code,description,value,operator_id,cts,uts FROM tti_app_setting ORDER BY id ASC
  404.  
  405. 21-01 16:03:08.842 DEBUG [data] 112 - [EVDS_3] GenericJDBCDao..................getCacheList - SELECT id,code,description,value,operator_id,cts,uts FROM tti_app_setting ORDER BY id ASC
  406. 21-01 16:03:08.843 DEBUG [com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate] 637 - Executing prepared SQL query
  407. 21-01 16:03:08.843 DEBUG [com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate] 572 - Executing prepared SQL statement
  408. 21-01 16:03:08.857 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_cache_20160121_00.log
  409. Appender:mFile was null: 21-01 16:03:08.856  [null]CACHE.................................clearListsOfType() (type=com.totaltel.prepaid.tticommon.data.tti.AppSetting)
  410.  
  411. 21-01 16:03:08.856 DEBUG [cache] 112 -  [null]CACHE.................................clearListsOfType() (type=com.totaltel.prepaid.tticommon.data.tti.AppSetting)
  412. 21-01 16:03:08.858 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_cache_20160121_00.log
  413. Appender:mFile was null: 21-01 16:03:08.858  [null]CACHE.................................addType() (com.totaltel.prepaid.tticommon.data.tti.AppSetting)
  414.  
  415. 21-01 16:03:08.858 DEBUG [cache] 112 -  [null]CACHE.................................addType() (com.totaltel.prepaid.tticommon.data.tti.AppSetting)
  416. 21-01 16:03:08.859 ERROR [ga.misc] 116 - cannot log to /Users/novatti/Documents/java_project/log/evds_general_20160121_00.log
  417. Appender:mFile was null: 21-01 16:03:08.858 Value of [CLIENT.OPERATOR.SHARED.CATI] application setting is not found. Using the default [false]
  418.  
  419. 21-01 16:03:08.858 WARN [general] 116 - Value of [CLIENT.OPERATOR.SHARED.CATI] application setting is not found. Using the default [false]
  420. 21-01 16:03:08.859 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_data_20160121_00.log
  421. Appender:mFile was null: 21-01 16:03:08.859 [EVDS_3] ClientDao.......................find - sql: select cnt_id,cnt_int_id,cnt_at_id,cnt_msisdn,cnt_op_id,cnt_sts_id,  cnt_soft_ver,cnt_pin,cnt_val_limit,cnt_val_current,  cnt_min_limit,cnt_start_limit,cnt_explain,cnt_cati,  cnt_stan, cnt_trans_maint,cnt_serial_number,cnt_printer_sn,  cnt_current_location,cnt_macid,cnt_init,cnt_cts,cnt_ipaddr,  cnt_tg_id,cnt_use_keys,cnt_data_key,cnt_tmac_key,cnt_rmac_key,  cnt_daily_trans_limit,cnt_daily_trans,  cnt_weekly_trans_limit,cnt_weekly_trans,  cnt_monthly_trans_limit,cnt_monthly_trans,  cnt_last_trans_ts,cnt_dt_id,cnt_failed_authkey_count,cnt_authkey_hint, cnt_saf_type_id, cnt_interface_sub_type_id,cnt_first_trans_ts  from er_client  WHERE cnt_cati=? order by cnt_id
  422.  
  423. 21-01 16:03:08.859 DEBUG [data] 112 - [EVDS_3] ClientDao.......................find - sql: select cnt_id,cnt_int_id,cnt_at_id,cnt_msisdn,cnt_op_id,cnt_sts_id,  cnt_soft_ver,cnt_pin,cnt_val_limit,cnt_val_current,  cnt_min_limit,cnt_start_limit,cnt_explain,cnt_cati,  cnt_stan, cnt_trans_maint,cnt_serial_number,cnt_printer_sn,  cnt_current_location,cnt_macid,cnt_init,cnt_cts,cnt_ipaddr,  cnt_tg_id,cnt_use_keys,cnt_data_key,cnt_tmac_key,cnt_rmac_key,  cnt_daily_trans_limit,cnt_daily_trans,  cnt_weekly_trans_limit,cnt_weekly_trans,  cnt_monthly_trans_limit,cnt_monthly_trans,  cnt_last_trans_ts,cnt_dt_id,cnt_failed_authkey_count,cnt_authkey_hint, cnt_saf_type_id, cnt_interface_sub_type_id,cnt_first_trans_ts  from er_client  WHERE cnt_cati=? order by cnt_id
  424. 21-01 16:03:08.860 DEBUG [com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate] 637 - Executing prepared SQL query
  425. 21-01 16:03:08.860 DEBUG [com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate] 572 - Executing prepared SQL statement
  426. 21-01 16:03:08.869 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_core_20160121_00.log
  427. Appender:mFile was null: 21-01 16:03:08.869 DBG [EVDS_3 151598] AgentValidator................findClientByTerminalId() (Complete clID=605)
  428.  
  429. 21-01 16:03:08.869 DEBUG [core] 112 - DBG [EVDS_3 151598] AgentValidator................findClientByTerminalId() (Complete clID=605)
  430. 21-01 16:03:08.870 ERROR [ga.misc] 113 - cannot log to /Users/novatti/Documents/java_project/log/evds_core_20160121_00.log
  431. Appender:mFile was null: 21-01 16:03:08.870 INF [EVDS_3] AgentValidator.......................validateClientType() (Comparing equality between client type code (PTL) and interface code (PTL) - equality=true)
  432.  
  433. 21-01 16:03:08.870 INFO [core] 113 - INF [EVDS_3] AgentValidator.......................validateClientType() (Comparing equality between client type code (PTL) and interface code (PTL) - equality=true)
  434. 21-01 16:03:08.871 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_core_20160121_00.log
  435. Appender:mFile was null: 21-01 16:03:08.870 DBG [EVDS_3 151598] AgentValidatorPtl.............validateClient() (Complete clId=605)
  436.  
  437. 21-01 16:03:08.870 DEBUG [core] 112 - DBG [EVDS_3 151598] AgentValidatorPtl.............validateClient() (Complete clId=605)
  438. 21-01 16:03:08.871 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_core_20160121_00.log
  439. Appender:mFile was null: 21-01 16:03:08.871 DBG [EVDS_3 151598] AgentValidator................validateAgent() (Start bypass=false)
  440.  
  441. 21-01 16:03:08.871 DEBUG [core] 112 - DBG [EVDS_3 151598] AgentValidator................validateAgent() (Start bypass=false)
  442. 21-01 16:03:08.872 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_core_20160121_00.log
  443. Appender:mFile was null: 21-01 16:03:08.871 DBG [EVDS_3 151598] AgentValidator................findAgent() (Start atId=517 atCode=)
  444.  
  445. 21-01 16:03:08.871 DEBUG [core] 112 - DBG [EVDS_3 151598] AgentValidator................findAgent() (Start atId=517 atCode=)
  446. 21-01 16:03:08.872 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_data_20160121_00.log
  447. Appender:mFile was null: 21-01 16:03:08.872 [EVDS_3] AgentDao........................find - sql: select at_id,at_op_id,at_tz_id,at_lev_id,at_md_id,at_at_id,  at_agent_status_id,at_name,at_pay_any,at_is_pp,at_tx_id,at_cts,  at_billing_agent_id,  at_code, at_activation_date, at_short_name, at_sms_cli, at_ad_id,  at_country_id, at_state_id, at_region_id, agent_category_id, sales_user_id, commis_setting_id,  at_hierarchy_level, at_uts  from er_agent a where at_id=517 order by at_id
  448.  
  449. 21-01 16:03:08.872 DEBUG [data] 112 - [EVDS_3] AgentDao........................find - sql: select at_id,at_op_id,at_tz_id,at_lev_id,at_md_id,at_at_id,  at_agent_status_id,at_name,at_pay_any,at_is_pp,at_tx_id,at_cts,  at_billing_agent_id,  at_code, at_activation_date, at_short_name, at_sms_cli, at_ad_id,  at_country_id, at_state_id, at_region_id, agent_category_id, sales_user_id, commis_setting_id,  at_hierarchy_level, at_uts  from er_agent a where at_id=517 order by at_id
  450. 21-01 16:03:08.873 DEBUG [com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate] 637 - Executing prepared SQL query
  451. 21-01 16:03:08.873 DEBUG [com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate] 572 - Executing prepared SQL statement
  452. 21-01 16:03:08.880 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_core_20160121_00.log
  453. Appender:mFile was null: 21-01 16:03:08.880 DBG [EVDS_3 151598] AgentValidator................findAgent() (Complete atID=517)
  454.  
  455. 21-01 16:03:08.880 DEBUG [core] 112 - DBG [EVDS_3 151598] AgentValidator................findAgent() (Complete atID=517)
  456. 21-01 16:03:08.881 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_core_20160121_00.log
  457. Appender:mFile was null: 21-01 16:03:08.880 DBG [EVDS_3 151598] AgentValidator................validateAgentStatus() (Start atID=517)
  458.  
  459. 21-01 16:03:08.880 DEBUG [core] 112 - DBG [EVDS_3 151598] AgentValidator................validateAgentStatus() (Start atID=517)
  460. 21-01 16:03:08.881 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_core_20160121_00.log
  461. Appender:mFile was null: 21-01 16:03:08.881 DBG [EVDS_3 151598] AgentValidator................validateAgentStatus() (Complete atID=517)
  462.  
  463. 21-01 16:03:08.881 DEBUG [core] 112 - DBG [EVDS_3 151598] AgentValidator................validateAgentStatus() (Complete atID=517)
  464. 21-01 16:03:08.882 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_core_20160121_00.log
  465. Appender:mFile was null: 21-01 16:03:08.882 DBG [EVDS_3 151598] AgentValidator................validateAgent() (Complete atID=517)
  466.  
  467. 21-01 16:03:08.882 DEBUG [core] 112 - DBG [EVDS_3 151598] AgentValidator................validateAgent() (Complete atID=517)
  468. 21-01 16:03:08.883 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_core_20160121_00.log
  469. Appender:mFile was null: 21-01 16:03:08.882 DBG [EVDS_3 151598] AgentValidatorPtl.............validate() (Complete atID=517)
  470.  
  471. 21-01 16:03:08.882 DEBUG [core] 112 - DBG [EVDS_3 151598] AgentValidatorPtl.............validate() (Complete atID=517)
  472. 21-01 16:03:08.883 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_general_20160121_00.log
  473. Appender:mFile was null: 21-01 16:03:08.883 [EVDS_3 151598    ] AgentLoginProcessor.............execute - phase: custom validation complete
  474.  
  475. 21-01 16:03:08.883 DEBUG [general] 112 - [EVDS_3 151598    ] AgentLoginProcessor.............execute - phase: custom validation complete
  476. 21-01 16:03:08.884 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_general_20160121_00.log
  477. Appender:mFile was null: 21-01 16:03:08.883 [EVDS_3 151598    ] AgentLoginProcessor.............execute - phase: execution start
  478.  
  479. 21-01 16:03:08.883 DEBUG [general] 112 - [EVDS_3 151598    ] AgentLoginProcessor.............execute - phase: execution start
  480. 21-01 16:03:08.885 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_dao_20160121_00.log
  481. Appender:mFile was null: 21-01 16:03:08.884 Preparing Query SQL
  482.  
  483. select u.id, u.username, u.password, u.firstname, u.surname, u.description, u.operator_id, u.language_id, u.user_status_id, u.cts, u.success_login_count, u.failed_login_count, u.last_login_date, u.password_expiry_date, u.password_confirmed,  u.password_reset_required  from tti_user u WHERE USERNAME=? ORDER BY id ASC
  484.  
  485.  
  486. 21-01 16:03:08.884 DEBUG [dao] 112 - Preparing Query SQL
  487.  
  488. select u.id, u.username, u.password, u.firstname, u.surname, u.description, u.operator_id, u.language_id, u.user_status_id, u.cts, u.success_login_count, u.failed_login_count, u.last_login_date, u.password_expiry_date, u.password_confirmed,  u.password_reset_required  from tti_user u WHERE USERNAME=? ORDER BY id ASC
  489.  
  490. 21-01 16:03:08.885 DEBUG [com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate] 637 - Executing prepared SQL query
  491. 21-01 16:03:08.885 DEBUG [com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate] 572 - Executing prepared SQL statement
  492. 21-01 16:03:08.889 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_data_20160121_00.log
  493. Appender:mFile was null: 21-01 16:03:08.889 [EVDS_3] GSDUserDao......................setStatementClauses - Setting param at index [1] to [agent517]
  494.  
  495. 21-01 16:03:08.889 DEBUG [data] 112 - [EVDS_3] GSDUserDao......................setStatementClauses - Setting param at index [1] to [agent517]
  496. 21-01 16:03:10.617 ERROR [ga.misc] 113 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  497. Appender:mFile was null: 21-01 16:03:10.616 TCPServerConnection..........................connect() (initializing connection to [localhost:9000])
  498.  
  499. 21-01 16:03:10.616 INFO [client] 113 - TCPServerConnection..........................connect() (initializing connection to [localhost:9000])
  500. 21-01 16:03:10.617 ERROR [ga.misc] 114 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  501. Appender:mFile was null: 21-01 16:03:10.617 TCPServerConnection..........................connect() (Failed to connect to [localhost:9000])
  502.  
  503. 21-01 16:03:10.617 ERROR [client] 114 - TCPServerConnection..........................connect() (Failed to connect to [localhost:9000])
  504. 21-01 16:03:10.618 ERROR [ga.misc] 114 - cannot log to /Users/novatti/Documents/java_project/log/evds_exception_20160121_00.log
  505. Appender:mFile was null: 21-01 16:03:10.617 TCPServerConnection..........................connect() (Failed to connect to [localhost:9000])
  506.  
  507. 21-01 16:03:10.617 ERROR [exception] 114 - TCPServerConnection..........................connect() (Failed to connect to [localhost:9000])
  508. 21-01 16:03:12.510 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_general_20160121_00.log
  509. Appender:mFile was null: 21-01 16:03:12.510 Timer operation EmailQueue_doProcessJobs started
  510.  
  511. 21-01 16:03:12.510 DEBUG [general] 112 - Timer operation EmailQueue_doProcessJobs started
  512. 21-01 16:03:12.511 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_general_20160121_00.log
  513. Appender:mFile was null: 21-01 16:03:12.510 Timer operation EmailQueue_doProcessJobs stop in 0 msec
  514.  
  515. 21-01 16:03:12.510 DEBUG [general] 112 - Timer operation EmailQueue_doProcessJobs stop in 0 msec
  516. 21-01 16:03:12.621 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_general_20160121_00.log
  517. Appender:mFile was null: 21-01 16:03:12.620 Timer operation EventQueue_doProcessJobs started
  518.  
  519. 21-01 16:03:12.620 DEBUG [general] 112 - Timer operation EventQueue_doProcessJobs started
  520. 21-01 16:03:12.621 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_general_20160121_00.log
  521. Appender:mFile was null: 21-01 16:03:12.621 Timer operation EventQueue_doProcessJobs stop in 0 msec
  522.  
  523. 21-01 16:03:12.621 DEBUG [general] 112 - Timer operation EventQueue_doProcessJobs stop in 0 msec
  524. 21-01 16:03:13.622 ERROR [ga.misc] 113 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  525. Appender:mFile was null: 21-01 16:03:13.621 TCPServerConnection..........................connect() (initializing connection to [localhost:9000])
  526.  
  527. 21-01 16:03:13.621 INFO [client] 113 - TCPServerConnection..........................connect() (initializing connection to [localhost:9000])
  528. 21-01 16:03:13.623 ERROR [ga.misc] 114 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  529. Appender:mFile was null: 21-01 16:03:13.622 TCPServerConnection..........................connect() (Failed to connect to [localhost:9000])
  530.  
  531. 21-01 16:03:13.622 ERROR [client] 114 - TCPServerConnection..........................connect() (Failed to connect to [localhost:9000])
  532. 21-01 16:03:13.623 ERROR [ga.misc] 114 - cannot log to /Users/novatti/Documents/java_project/log/evds_exception_20160121_00.log
  533. Appender:mFile was null: 21-01 16:03:13.623 TCPServerConnection..........................connect() (Failed to connect to [localhost:9000])
  534.  
  535. 21-01 16:03:13.623 ERROR [exception] 114 - TCPServerConnection..........................connect() (Failed to connect to [localhost:9000])
  536. 21-01 16:03:15.094 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_general_20160121_00.log
  537. Appender:mFile was null: 21-01 16:03:15.093 [EVDS_3] EntityLockManager...............unlockExpired - Entity lock monitor: Attempting to find expired locks
  538.  
  539. 21-01 16:03:15.093 DEBUG [general] 112 - [EVDS_3] EntityLockManager...............unlockExpired - Entity lock monitor: Attempting to find expired locks  
  540. 21-01 16:03:15.094 DEBUG [com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate] 637 - Executing prepared SQL query
  541. 21-01 16:03:15.094 DEBUG [com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate] 572 - Executing prepared SQL statement
  542. 21-01 16:03:15.402 DEBUG [com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate] 1328 - SQLWarning ignored: SQL state '02000', error code '100', message [No data]
  543. 21-01 16:03:16.629 ERROR [ga.misc] 113 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  544. Appender:mFile was null: 21-01 16:03:16.628 TCPServerConnection..........................connect() (initializing connection to [localhost:9000])
  545.  
  546. 21-01 16:03:16.628 INFO [client] 113 - TCPServerConnection..........................connect() (initializing connection to [localhost:9000])
  547. 21-01 16:03:16.630 ERROR [ga.misc] 114 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  548. Appender:mFile was null: 21-01 16:03:16.629 TCPServerConnection..........................connect() (Failed to connect to [localhost:9000])
  549.  
  550. 21-01 16:03:16.629 ERROR [client] 114 - TCPServerConnection..........................connect() (Failed to connect to [localhost:9000])
  551. 21-01 16:03:16.630 ERROR [ga.misc] 114 - cannot log to /Users/novatti/Documents/java_project/log/evds_exception_20160121_00.log
  552. Appender:mFile was null: 21-01 16:03:16.630 TCPServerConnection..........................connect() (Failed to connect to [localhost:9000])
  553.  
  554. 21-01 16:03:16.630 ERROR [exception] 114 - TCPServerConnection..........................connect() (Failed to connect to [localhost:9000])
  555. 21-01 16:03:18.804 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_general_20160121_00.log
  556. Appender:mFile was null: 21-01 16:03:18.804 Timer operation TTIQueue_doProcessJobs started
  557.  
  558. 21-01 16:03:18.804 DEBUG [general] 112 - Timer operation TTIQueue_doProcessJobs started
  559. 21-01 16:03:18.805 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_general_20160121_00.log
  560. Appender:mFile was null: 21-01 16:03:18.804 Timer operation TTIQueue_doProcessJobs stop in 0 msec
  561.  
  562. 21-01 16:03:18.804 DEBUG [general] 112 - Timer operation TTIQueue_doProcessJobs stop in 0 msec
  563. 21-01 16:03:18.896 DEBUG [com.totaltel.prepaid.tticommon.jdbc.spring.translation.TTISQLErrorCodeSQLExceptionTranslator] 287 - Unable to translate SQLException with Error code '-213', will now try the fallback translator
  564. 21-01 16:03:18.898 ERROR [ga.misc] 114 - cannot log to /Users/novatti/Documents/java_project/log/evds_general_20160121_00.log
  565. Appender:mFile was null: 21-01 16:03:18.897 [EVDS_3] AGENT_LOGIN.....................doHandleException - null ------
  566. org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL []; SQL state [IX000]; error code [-213]; Statement interrupted by user.; nested exception is java.sql.SQLException: Statement interrupted by user.
  567.     at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
  568.     at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
  569.     at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
  570.     at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:605)
  571.     at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:639)
  572.     at com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate.query(TTIJdbcTemplate.java:54)
  573.     at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:664)
  574.     at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:684)
  575.     at com.totaltel.prepaid.tticommon.dao.generic.jdbc.GenericJDBCDao.createList(GenericJDBCDao.java:365)
  576.     at com.totaltel.prepaid.tticommon.dao.generic.jdbc.GenericJDBCDao.find(GenericJDBCDao.java:287)
  577.     at com.totaltel.prepaid.tticommon.dao.tti.jdbc.GenericUserDao.find(GenericUserDao.java:111)
  578.     at com.totaltel.prepaid.tticommon.dao.datasource.BaseDataSourceDao.find(BaseDataSourceDao.java:274)
  579.     at com.totaltel.prepaid.tticommon.dao.datasource.BaseDataSourceDao.find(BaseDataSourceDao.java:245)
  580.     at com.totaltel.prepaid.tticommon.gsd331.adapter.tti.TTIUserManager.load(TTIUserManager.java:141)
  581.     at com.totaltel.prepaid.tticommon.gsd331.GSDSecurity.login(GSDSecurity.java:378)
  582.     at com.novatti.api.processors.AgentLoginProcessor.doExecute(AgentLoginProcessor.java:101)
  583.     at com.novatti.api.processors.AgentLoginProcessor.doExecute(AgentLoginProcessor.java:41)
  584.     at com.totaltel.prepaid.tticommon.connectioninterface.tti.processor.TTIProcessor.execute(TTIProcessor.java:91)
  585.     at sun.reflect.GeneratedMethodAccessor354.invoke(Unknown Source)
  586.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  587.     at java.lang.reflect.Method.invoke(Method.java:606)
  588.     at com.totaltel.prepaid.cwsengine.event.processor.EventAwareProcessorProxy.intercept(EventAwareProcessorProxy.java:68)
  589.     at com.novatti.api.processors.AgentLoginProcessor$$EnhancerByCGLIB$$3e2fd992.execute(<generated>)
  590.     at sun.reflect.GeneratedMethodAccessor354.invoke(Unknown Source)
  591.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  592.     at java.lang.reflect.Method.invoke(Method.java:606)
  593.     at com.totaltel.prepaid.tticommon.connectioninterface.server.processor.ProcessorTracker$ProcessorTrackerCallback.intercept(ProcessorTracker.java:70)
  594.     at com.novatti.api.processors.AgentLoginProcessor$$EnhancerByCGLIB$$47e0282a.execute(<generated>)
  595.     at com.totaltel.prepaid.tticommon.connectioninterface.server.RequestDeliverer.process(RequestDeliverer.java:325)
  596.     at com.totaltel.prepaid.tticommon.connectioninterface.server.RequestDeliverer.processRequest(RequestDeliverer.java:295)
  597.     at com.totaltel.prepaid.tticommon.connectioninterface.server.RequestDeliverer.processRequest(RequestDeliverer.java:183)
  598.     at com.totaltel.prepaid.tticommon.connectioninterface.server.RequestDeliverer.process(RequestDeliverer.java:67)
  599.     at com.totaltel.prepaid.tticommon.connection.server.RequestWorker.run(RequestWorker.java:121)
  600.     at java.lang.Thread.run(Thread.java:745)
  601. Caused by: java.sql.SQLException: Statement interrupted by user.
  602.     at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3457)
  603.     at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3774)
  604.     at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2580)
  605.     at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2496)
  606.     at com.informix.jdbc.IfxSqli.a(IfxSqli.java:1752)
  607.     at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1704)
  608.     at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1635)
  609.     at com.informix.jdbc.IfxResultSet.a(IfxResultSet.java:206)
  610.     at com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:1229)
  611.     at com.informix.jdbc.IfxPreparedStatement.executeQuery(IfxPreparedStatement.java:376)
  612.     at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
  613.     at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:646)
  614.     at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:589)
  615.     ... 30 more
  616. Caused by: java.sql.SQLException: ISAM error: Interrupted ISAM call
  617.     at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:408)
  618.     at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3779)
  619.     ... 41 more
  620. ------
  621.  
  622.  
  623. 21-01 16:03:18.897 ERROR [general] 114 - [EVDS_3] AGENT_LOGIN.....................doHandleException - null ------
  624. org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL []; SQL state [IX000]; error code [-213]; Statement interrupted by user.; nested exception is java.sql.SQLException: Statement interrupted by user.
  625.     at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
  626.     at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
  627.     at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
  628.     at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:605)
  629.     at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:639)
  630.     at com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate.query(TTIJdbcTemplate.java:54)
  631.     at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:664)
  632.     at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:684)
  633.     at com.totaltel.prepaid.tticommon.dao.generic.jdbc.GenericJDBCDao.createList(GenericJDBCDao.java:365)
  634.     at com.totaltel.prepaid.tticommon.dao.generic.jdbc.GenericJDBCDao.find(GenericJDBCDao.java:287)
  635.     at com.totaltel.prepaid.tticommon.dao.tti.jdbc.GenericUserDao.find(GenericUserDao.java:111)
  636.     at com.totaltel.prepaid.tticommon.dao.datasource.BaseDataSourceDao.find(BaseDataSourceDao.java:274)
  637.     at com.totaltel.prepaid.tticommon.dao.datasource.BaseDataSourceDao.find(BaseDataSourceDao.java:245)
  638.     at com.totaltel.prepaid.tticommon.gsd331.adapter.tti.TTIUserManager.load(TTIUserManager.java:141)
  639.     at com.totaltel.prepaid.tticommon.gsd331.GSDSecurity.login(GSDSecurity.java:378)
  640.     at com.novatti.api.processors.AgentLoginProcessor.doExecute(AgentLoginProcessor.java:101)
  641.     at com.novatti.api.processors.AgentLoginProcessor.doExecute(AgentLoginProcessor.java:41)
  642.     at com.totaltel.prepaid.tticommon.connectioninterface.tti.processor.TTIProcessor.execute(TTIProcessor.java:91)
  643.     at sun.reflect.GeneratedMethodAccessor354.invoke(Unknown Source)
  644.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  645.     at java.lang.reflect.Method.invoke(Method.java:606)
  646.     at com.totaltel.prepaid.cwsengine.event.processor.EventAwareProcessorProxy.intercept(EventAwareProcessorProxy.java:68)
  647.     at com.novatti.api.processors.AgentLoginProcessor$$EnhancerByCGLIB$$3e2fd992.execute(<generated>)
  648.     at sun.reflect.GeneratedMethodAccessor354.invoke(Unknown Source)
  649.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  650.     at java.lang.reflect.Method.invoke(Method.java:606)
  651.     at com.totaltel.prepaid.tticommon.connectioninterface.server.processor.ProcessorTracker$ProcessorTrackerCallback.intercept(ProcessorTracker.java:70)
  652.     at com.novatti.api.processors.AgentLoginProcessor$$EnhancerByCGLIB$$47e0282a.execute(<generated>)
  653.     at com.totaltel.prepaid.tticommon.connectioninterface.server.RequestDeliverer.process(RequestDeliverer.java:325)
  654.     at com.totaltel.prepaid.tticommon.connectioninterface.server.RequestDeliverer.processRequest(RequestDeliverer.java:295)
  655.     at com.totaltel.prepaid.tticommon.connectioninterface.server.RequestDeliverer.processRequest(RequestDeliverer.java:183)
  656.     at com.totaltel.prepaid.tticommon.connectioninterface.server.RequestDeliverer.process(RequestDeliverer.java:67)
  657.     at com.totaltel.prepaid.tticommon.connection.server.RequestWorker.run(RequestWorker.java:121)
  658.     at java.lang.Thread.run(Thread.java:745)
  659. Caused by: java.sql.SQLException: Statement interrupted by user.
  660.     at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3457)
  661.     at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3774)
  662.     at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2580)
  663.     at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2496)
  664.     at com.informix.jdbc.IfxSqli.a(IfxSqli.java:1752)
  665.     at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1704)
  666.     at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1635)
  667.     at com.informix.jdbc.IfxResultSet.a(IfxResultSet.java:206)
  668.     at com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:1229)
  669.     at com.informix.jdbc.IfxPreparedStatement.executeQuery(IfxPreparedStatement.java:376)
  670.     at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
  671.     at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:646)
  672.     at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:589)
  673.     ... 30 more
  674. Caused by: java.sql.SQLException: ISAM error: Interrupted ISAM call
  675.     at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:408)
  676.     at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3779)
  677.     ... 41 more
  678. ------
  679.  
  680. 21-01 16:03:18.898 ERROR [ga.misc] 114 - cannot log to /Users/novatti/Documents/java_project/log/evds_exception_20160121_00.log
  681. Appender:mFile was null: 21-01 16:03:18.898 [EVDS_3] AGENT_LOGIN.....................doHandleException - null ------
  682. org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL []; SQL state [IX000]; error code [-213]; Statement interrupted by user.; nested exception is java.sql.SQLException: Statement interrupted by user.
  683.     at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
  684.     at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
  685.     at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
  686.     at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:605)
  687.     at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:639)
  688.     at com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate.query(TTIJdbcTemplate.java:54)
  689.     at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:664)
  690.     at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:684)
  691.     at com.totaltel.prepaid.tticommon.dao.generic.jdbc.GenericJDBCDao.createList(GenericJDBCDao.java:365)
  692.     at com.totaltel.prepaid.tticommon.dao.generic.jdbc.GenericJDBCDao.find(GenericJDBCDao.java:287)
  693.     at com.totaltel.prepaid.tticommon.dao.tti.jdbc.GenericUserDao.find(GenericUserDao.java:111)
  694.     at com.totaltel.prepaid.tticommon.dao.datasource.BaseDataSourceDao.find(BaseDataSourceDao.java:274)
  695.     at com.totaltel.prepaid.tticommon.dao.datasource.BaseDataSourceDao.find(BaseDataSourceDao.java:245)
  696.     at com.totaltel.prepaid.tticommon.gsd331.adapter.tti.TTIUserManager.load(TTIUserManager.java:141)
  697.     at com.totaltel.prepaid.tticommon.gsd331.GSDSecurity.login(GSDSecurity.java:378)
  698.     at com.novatti.api.processors.AgentLoginProcessor.doExecute(AgentLoginProcessor.java:101)
  699.     at com.novatti.api.processors.AgentLoginProcessor.doExecute(AgentLoginProcessor.java:41)
  700.     at com.totaltel.prepaid.tticommon.connectioninterface.tti.processor.TTIProcessor.execute(TTIProcessor.java:91)
  701.     at sun.reflect.GeneratedMethodAccessor354.invoke(Unknown Source)
  702.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  703.     at java.lang.reflect.Method.invoke(Method.java:606)
  704.     at com.totaltel.prepaid.cwsengine.event.processor.EventAwareProcessorProxy.intercept(EventAwareProcessorProxy.java:68)
  705.     at com.novatti.api.processors.AgentLoginProcessor$$EnhancerByCGLIB$$3e2fd992.execute(<generated>)
  706.     at sun.reflect.GeneratedMethodAccessor354.invoke(Unknown Source)
  707.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  708.     at java.lang.reflect.Method.invoke(Method.java:606)
  709.     at com.totaltel.prepaid.tticommon.connectioninterface.server.processor.ProcessorTracker$ProcessorTrackerCallback.intercept(ProcessorTracker.java:70)
  710.     at com.novatti.api.processors.AgentLoginProcessor$$EnhancerByCGLIB$$47e0282a.execute(<generated>)
  711.     at com.totaltel.prepaid.tticommon.connectioninterface.server.RequestDeliverer.process(RequestDeliverer.java:325)
  712.     at com.totaltel.prepaid.tticommon.connectioninterface.server.RequestDeliverer.processRequest(RequestDeliverer.java:295)
  713.     at com.totaltel.prepaid.tticommon.connectioninterface.server.RequestDeliverer.processRequest(RequestDeliverer.java:183)
  714.     at com.totaltel.prepaid.tticommon.connectioninterface.server.RequestDeliverer.process(RequestDeliverer.java:67)
  715.     at com.totaltel.prepaid.tticommon.connection.server.RequestWorker.run(RequestWorker.java:121)
  716.     at java.lang.Thread.run(Thread.java:745)
  717. Caused by: java.sql.SQLException: Statement interrupted by user.
  718.     at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3457)
  719.     at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3774)
  720.     at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2580)
  721.     at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2496)
  722.     at com.informix.jdbc.IfxSqli.a(IfxSqli.java:1752)
  723.     at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1704)
  724.     at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1635)
  725.     at com.informix.jdbc.IfxResultSet.a(IfxResultSet.java:206)
  726.     at com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:1229)
  727.     at com.informix.jdbc.IfxPreparedStatement.executeQuery(IfxPreparedStatement.java:376)
  728.     at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
  729.     at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:646)
  730.     at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:589)
  731.     ... 30 more
  732. Caused by: java.sql.SQLException: ISAM error: Interrupted ISAM call
  733.     at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:408)
  734.     at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3779)
  735.     ... 41 more
  736. ------
  737.  
  738.  
  739. 21-01 16:03:18.898 ERROR [exception] 114 - [EVDS_3] AGENT_LOGIN.....................doHandleException - null ------
  740. org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL []; SQL state [IX000]; error code [-213]; Statement interrupted by user.; nested exception is java.sql.SQLException: Statement interrupted by user.
  741.     at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
  742.     at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
  743.     at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
  744.     at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:605)
  745.     at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:639)
  746.     at com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate.query(TTIJdbcTemplate.java:54)
  747.     at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:664)
  748.     at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:684)
  749.     at com.totaltel.prepaid.tticommon.dao.generic.jdbc.GenericJDBCDao.createList(GenericJDBCDao.java:365)
  750.     at com.totaltel.prepaid.tticommon.dao.generic.jdbc.GenericJDBCDao.find(GenericJDBCDao.java:287)
  751.     at com.totaltel.prepaid.tticommon.dao.tti.jdbc.GenericUserDao.find(GenericUserDao.java:111)
  752.     at com.totaltel.prepaid.tticommon.dao.datasource.BaseDataSourceDao.find(BaseDataSourceDao.java:274)
  753.     at com.totaltel.prepaid.tticommon.dao.datasource.BaseDataSourceDao.find(BaseDataSourceDao.java:245)
  754.     at com.totaltel.prepaid.tticommon.gsd331.adapter.tti.TTIUserManager.load(TTIUserManager.java:141)
  755.     at com.totaltel.prepaid.tticommon.gsd331.GSDSecurity.login(GSDSecurity.java:378)
  756.     at com.novatti.api.processors.AgentLoginProcessor.doExecute(AgentLoginProcessor.java:101)
  757.     at com.novatti.api.processors.AgentLoginProcessor.doExecute(AgentLoginProcessor.java:41)
  758.     at com.totaltel.prepaid.tticommon.connectioninterface.tti.processor.TTIProcessor.execute(TTIProcessor.java:91)
  759.     at sun.reflect.GeneratedMethodAccessor354.invoke(Unknown Source)
  760.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  761.     at java.lang.reflect.Method.invoke(Method.java:606)
  762.     at com.totaltel.prepaid.cwsengine.event.processor.EventAwareProcessorProxy.intercept(EventAwareProcessorProxy.java:68)
  763.     at com.novatti.api.processors.AgentLoginProcessor$$EnhancerByCGLIB$$3e2fd992.execute(<generated>)
  764.     at sun.reflect.GeneratedMethodAccessor354.invoke(Unknown Source)
  765.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  766.     at java.lang.reflect.Method.invoke(Method.java:606)
  767.     at com.totaltel.prepaid.tticommon.connectioninterface.server.processor.ProcessorTracker$ProcessorTrackerCallback.intercept(ProcessorTracker.java:70)
  768.     at com.novatti.api.processors.AgentLoginProcessor$$EnhancerByCGLIB$$47e0282a.execute(<generated>)
  769.     at com.totaltel.prepaid.tticommon.connectioninterface.server.RequestDeliverer.process(RequestDeliverer.java:325)
  770.     at com.totaltel.prepaid.tticommon.connectioninterface.server.RequestDeliverer.processRequest(RequestDeliverer.java:295)
  771.     at com.totaltel.prepaid.tticommon.connectioninterface.server.RequestDeliverer.processRequest(RequestDeliverer.java:183)
  772.     at com.totaltel.prepaid.tticommon.connectioninterface.server.RequestDeliverer.process(RequestDeliverer.java:67)
  773.     at com.totaltel.prepaid.tticommon.connection.server.RequestWorker.run(RequestWorker.java:121)
  774.     at java.lang.Thread.run(Thread.java:745)
  775. Caused by: java.sql.SQLException: Statement interrupted by user.
  776.     at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3457)
  777.     at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3774)
  778.     at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2580)
  779.     at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2496)
  780.     at com.informix.jdbc.IfxSqli.a(IfxSqli.java:1752)
  781.     at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1704)
  782.     at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1635)
  783.     at com.informix.jdbc.IfxResultSet.a(IfxResultSet.java:206)
  784.     at com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:1229)
  785.     at com.informix.jdbc.IfxPreparedStatement.executeQuery(IfxPreparedStatement.java:376)
  786.     at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
  787.     at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:646)
  788.     at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:589)
  789.     ... 30 more
  790. Caused by: java.sql.SQLException: ISAM error: Interrupted ISAM call
  791.     at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:408)
  792.     at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3779)
  793.     ... 41 more
  794. ------
  795.  
  796. 21-01 16:03:18.899 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_general_20160121_00.log
  797. Appender:mFile was null: 21-01 16:03:18.899 [EVDS_3 151598    ] AgentLoginProcessor.............execute - processing failed error code [999] message [Unknown error: PreparedStatementCallback; uncategorized SQLException for SQL []; SQL state [IX000]; error code [-213]; Statement interrupted by user.; nested exception is java.sql.SQLException: Statement interrupted by user.]
  798.  
  799. 21-01 16:03:18.899 DEBUG [general] 112 - [EVDS_3 151598    ] AgentLoginProcessor.............execute - processing failed error code [999] message [Unknown error: PreparedStatementCallback; uncategorized SQLException for SQL []; SQL state [IX000]; error code [-213]; Statement interrupted by user.; nested exception is java.sql.SQLException: Statement interrupted by user.]
  800. 21-01 16:03:18.900 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_general_20160121_00.log
  801. Appender:mFile was null: 21-01 16:03:18.900 [EVDS_3] AGENT_LOGIN.....................notifyEvent - Processor event [FAILED] is not notified. Notifier is not configured
  802.  
  803. 21-01 16:03:18.900 DEBUG [general] 112 - [EVDS_3] AGENT_LOGIN.....................notifyEvent - Processor event [FAILED] is not notified. Notifier is not configured
  804. 21-01 16:03:18.901 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_general_20160121_00.log
  805. Appender:mFile was null: 21-01 16:03:18.900 [EVDS_3 151598    ] AgentLoginProcessor.............execute - phase: finalisation start
  806.  
  807. 21-01 16:03:18.900 DEBUG [general] 112 - [EVDS_3 151598    ] AgentLoginProcessor.............execute - phase: finalisation start
  808. 21-01 16:03:18.901 ERROR [ga.misc] 113 - cannot log to /Users/novatti/Documents/java_project/log/evds_callflow_20160121_00.log
  809. Appender:mFile was null: 21-01 16:03:18.901 INF [EVDS_3 151598] AgentLoginProcessor...........doFinalise() (agentId=517 terminalId=AGENT517 ip=127.0.0.1 username=agent517 sessionToken=null resultCode=999)
  810.  
  811. 21-01 16:03:18.901 INFO [callflow] 113 - INF [EVDS_3 151598] AgentLoginProcessor...........doFinalise() (agentId=517 terminalId=AGENT517 ip=127.0.0.1 username=agent517 sessionToken=null resultCode=999)
  812. 21-01 16:03:18.902 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_general_20160121_00.log
  813. Appender:mFile was null: 21-01 16:03:18.901 [EVDS_3 151598    ] AgentLoginProcessor.............execute - phase: finalisation end
  814.  
  815. 21-01 16:03:18.901 DEBUG [general] 112 - [EVDS_3 151598    ] AgentLoginProcessor.............execute - phase: finalisation end
  816. 21-01 16:03:18.902 ERROR [ga.misc] 113 - cannot log to /Users/novatti/Documents/java_project/log/evds_general_20160121_00.log
  817. Appender:mFile was null: 21-01 16:03:18.902 Expected event queue job from callback [com.totaltel.prepaid.cwsengine.event.queue.SynchronousEventCallback] in processor [AGENT_LOGIN] but none (null) was found. This means a job (event) for one of the topics was never published
  818.  
  819. 21-01 16:03:18.902 INFO [general] 113 - Expected event queue job from callback [com.totaltel.prepaid.cwsengine.event.queue.SynchronousEventCallback] in processor [AGENT_LOGIN] but none (null) was found. This means a job (event) for one of the topics was never published
  820. 21-01 16:03:18.903 ERROR [ga.misc] 116 - cannot log to /Users/novatti/Documents/java_project/log/evds_general_20160121_00.log
  821. Appender:mFile was null: 21-01 16:03:18.902 Failed to gracefully unsubscribe callback [com.totaltel.prepaid.cwsengine.event.queue.SynchronousEventCallback] from event queue in topic [MFA_PINCODE]
  822.  
  823. 21-01 16:03:18.902 WARN [general] 116 - Failed to gracefully unsubscribe callback [com.totaltel.prepaid.cwsengine.event.queue.SynchronousEventCallback] from event queue in topic [MFA_PINCODE]
  824. 21-01 16:03:18.904 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_general_20160121_00.log
  825. Appender:mFile was null: 21-01 16:03:18.903 [EVDS_3 151598    ] AGENT_LOGIN.....................execute - Complete tid=151598
  826.  
  827. 21-01 16:03:18.903 DEBUG [general] 112 - [EVDS_3 151598    ] AGENT_LOGIN.....................execute - Complete tid=151598
  828. 21-01 16:03:18.904 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_general_20160121_00.log
  829. Appender:mFile was null: 21-01 16:03:18.904 [EVDS_3] PROCESSOR_TRACKER...............intercept - Processor execute method complete: AgentLoginProcessor
  830.  
  831. 21-01 16:03:18.904 DEBUG [general] 112 - [EVDS_3] PROCESSOR_TRACKER...............intercept - Processor execute method complete: AgentLoginProcessor
  832. 21-01 16:03:18.905 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_message_20160121_00.log
  833. Appender:mFile was null: 21-01 16:03:18.905 [EVDS_3 151598    ] STACKMGR........................freeProcessor - Start stackId=151598
  834.  
  835. 21-01 16:03:18.905 DEBUG [message] 112 - [EVDS_3 151598    ] STACKMGR........................freeProcessor - Start stackId=151598
  836. 21-01 16:03:18.905 ERROR [ga.misc] 113 - cannot log to /Users/novatti/Documents/java_project/log/evds_message_20160121_00.log
  837. Appender:mFile was null: 21-01 16:03:18.905 [EVDS_3 151598    ] RequestDeliverer................logStatistics - Processing time of com.novatti.api.soap.types.SoapAgentLoginRequest ms=10138 (qTime=0)
  838.  
  839. 21-01 16:03:18.905 INFO [message] 113 - [EVDS_3 151598    ] RequestDeliverer................logStatistics - Processing time of com.novatti.api.soap.types.SoapAgentLoginRequest ms=10138 (qTime=0)
  840. ##### request null time 10138 msec
  841. 21-01 16:03:18.906 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_general_20160121_00.log
  842. Appender:mFile was null: 21-01 16:03:18.906 [EVDS_3] PROCESSOR_TRACKER...............end - Work finished
  843.  
  844. 21-01 16:03:18.906 ERROR [ga.misc] 113 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  845. Appender:mFile was null: 21-01 16:03:18.906 GenericSOAPResponseTranslator................translate() (Mapping [com.novatti.api.message.response.AgentLoginResponse] to [com.novatti.api.soap.types.SoapAgentLoginResponse])
  846.  
  847. 21-01 16:03:18.906 DEBUG [general] 112 - [EVDS_3] PROCESSOR_TRACKER...............end - Work finished
  848. 21-01 16:03:18.906 INFO [client] 113 - GenericSOAPResponseTranslator................translate() (Mapping [com.novatti.api.message.response.AgentLoginResponse] to [com.novatti.api.soap.types.SoapAgentLoginResponse])
  849. 21-01 16:03:18.908 ERROR [ga.misc] 113 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  850. Appender:mFile was null: 21-01 16:03:18.907 ExpressionConverter..........................convert() (Validations: [true, false, true])
  851.  
  852. 21-01 16:03:18.907 INFO [client] 113 - ExpressionConverter..........................convert() (Validations: [true, false, true])
  853. 21-01 16:03:18.909 ERROR [ga.misc] 113 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  854. Appender:mFile was null: 21-01 16:03:18.908 ExpressionConverter..........................doConvert() (Mapping value: [999] using expression: [#{@soapUtils.mapCode(#sourceFieldValue)}])
  855.  
  856. 21-01 16:03:18.908 INFO [client] 113 - ExpressionConverter..........................doConvert() (Mapping value: [999] using expression: [#{@soapUtils.mapCode(#sourceFieldValue)}])
  857. 21-01 16:03:18.913 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_cache_20160121_00.log
  858. Appender:mFile was null: 21-01 16:03:18.913  [null]CACHE.................................removeType() (com.totaltel.prepaid.tticommon.data.tti.ResultMap, reset = true)
  859.  
  860. 21-01 16:03:18.913 DEBUG [cache] 112 -  [null]CACHE.................................removeType() (com.totaltel.prepaid.tticommon.data.tti.ResultMap, reset = true)
  861. 21-01 16:03:18.915 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_cache_20160121_00.log
  862. Appender:mFile was null: 21-01 16:03:18.914  [null]RegisteredCacheType...................setLoaded() (com.totaltel.prepaid.tticommon.data.tti.ResultMap, loaded=false)
  863.  
  864. 21-01 16:03:18.914 DEBUG [cache] 112 -  [null]RegisteredCacheType...................setLoaded() (com.totaltel.prepaid.tticommon.data.tti.ResultMap, loaded=false)
  865. 21-01 16:03:18.916 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_cache_20160121_00.log
  866. Appender:mFile was null: 21-01 16:03:18.915  [null]CACHE.................................cacheTypeOf() (type=com.totaltel.prepaid.tticommon.data.tti.ResultMap, force=true)
  867.  
  868. 21-01 16:03:18.915 DEBUG [cache] 112 -  [null]CACHE.................................cacheTypeOf() (type=com.totaltel.prepaid.tticommon.data.tti.ResultMap, force=true)
  869. 21-01 16:03:18.916 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_dao_20160121_00.log
  870. Appender:mFile was null: 21-01 16:03:18.916 Preparing Query SQL
  871.  
  872. SELECT id,code,description,value,operator_id,cts,uts FROM tti_app_setting WHERE code=? AND operator_id IS NULL ORDER BY id ASC
  873.  
  874.  
  875. 21-01 16:03:18.916 DEBUG [dao] 112 - Preparing Query SQL
  876.  
  877. SELECT id,code,description,value,operator_id,cts,uts FROM tti_app_setting WHERE code=? AND operator_id IS NULL ORDER BY id ASC
  878.  
  879. 21-01 16:03:18.917 DEBUG [com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate] 637 - Executing prepared SQL query
  880. 21-01 16:03:18.917 DEBUG [com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate] 572 - Executing prepared SQL statement
  881. 21-01 16:03:18.924 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_data_20160121_00.log
  882. Appender:mFile was null: 21-01 16:03:18.923 [EVDS_3] GenericJDBCDao..................setStatementClauses - Setting param at index [1] to [CACHE.REFRESH]
  883.  
  884. 21-01 16:03:18.923 DEBUG [data] 112 - [EVDS_3] GenericJDBCDao..................setStatementClauses - Setting param at index [1] to [CACHE.REFRESH]
  885. 21-01 16:03:18.930 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_data_20160121_00.log
  886. Appender:mFile was null: 21-01 16:03:18.929 [EVDS_3] ResultMapGenericDao.............getCacheList - SELECT id,result_code_id,mapped_code,mapped_description,context,result_config_id,cts FROM tti_result_map ORDER BY id ASC
  887.  
  888. 21-01 16:03:18.929 DEBUG [data] 112 - [EVDS_3] ResultMapGenericDao.............getCacheList - SELECT id,result_code_id,mapped_code,mapped_description,context,result_config_id,cts FROM tti_result_map ORDER BY id ASC
  889. 21-01 16:03:18.931 DEBUG [com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate] 637 - Executing prepared SQL query
  890. 21-01 16:03:18.931 DEBUG [com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate] 572 - Executing prepared SQL statement
  891. 21-01 16:03:18.968 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_cache_20160121_00.log
  892. Appender:mFile was null: 21-01 16:03:18.967  [null]CACHE.................................addType() (com.totaltel.prepaid.tticommon.data.tti.ResultMap)
  893.  
  894. 21-01 16:03:18.967 DEBUG [cache] 112 -  [null]CACHE.................................addType() (com.totaltel.prepaid.tticommon.data.tti.ResultMap)
  895. 21-01 16:03:18.969 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_cache_20160121_00.log
  896. Appender:mFile was null: 21-01 16:03:18.968  [null]RegisteredCacheType...................setLoaded() (com.totaltel.prepaid.tticommon.data.tti.ResultMap, loaded=true)
  897.  
  898. 21-01 16:03:18.968 DEBUG [cache] 112 -  [null]RegisteredCacheType...................setLoaded() (com.totaltel.prepaid.tticommon.data.tti.ResultMap, loaded=true)
  899. 21-01 16:03:18.970 ERROR [ga.misc] 113 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  900. Appender:mFile was null: 21-01 16:03:18.969 ExpressionConverter..........................doConvert() (Result: [4099])
  901.  
  902. 21-01 16:03:18.969 INFO [client] 113 - ExpressionConverter..........................doConvert() (Result: [4099])
  903. 21-01 16:03:18.971 ERROR [ga.misc] 113 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  904. Appender:mFile was null: 21-01 16:03:18.971 ExpressionConverter..........................convert() (Validations: [true, false, true])
  905.  
  906. 21-01 16:03:18.971 INFO [client] 113 - ExpressionConverter..........................convert() (Validations: [true, false, true])
  907. 21-01 16:03:18.972 ERROR [ga.misc] 113 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  908. Appender:mFile was null: 21-01 16:03:18.971 ExpressionConverter..........................doConvert() (Mapping value: [999] using expression: [#{@soapUtils.mapDescription(#sourceFieldValue, null)}])
  909.  
  910. 21-01 16:03:18.971 INFO [client] 113 - ExpressionConverter..........................doConvert() (Mapping value: [999] using expression: [#{@soapUtils.mapDescription(#sourceFieldValue, null)}])
  911. 21-01 16:03:18.975 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_cache_20160121_00.log
  912. Appender:mFile was null: 21-01 16:03:18.975  [null]CACHE.................................removeType() (com.totaltel.prepaid.tticommon.data.tti.ResultMap, reset = true)
  913.  
  914. 21-01 16:03:18.975 DEBUG [cache] 112 -  [null]CACHE.................................removeType() (com.totaltel.prepaid.tticommon.data.tti.ResultMap, reset = true)
  915. 21-01 16:03:18.976 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_cache_20160121_00.log
  916. Appender:mFile was null: 21-01 16:03:18.976  [null]RegisteredCacheType...................setLoaded() (com.totaltel.prepaid.tticommon.data.tti.ResultMap, loaded=false)
  917.  
  918. 21-01 16:03:18.976 DEBUG [cache] 112 -  [null]RegisteredCacheType...................setLoaded() (com.totaltel.prepaid.tticommon.data.tti.ResultMap, loaded=false)
  919. 21-01 16:03:18.977 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_cache_20160121_00.log
  920. Appender:mFile was null: 21-01 16:03:18.977  [null]CACHE.................................cacheTypeOf() (type=com.totaltel.prepaid.tticommon.data.tti.ResultMap, force=true)
  921.  
  922. 21-01 16:03:18.977 DEBUG [cache] 112 -  [null]CACHE.................................cacheTypeOf() (type=com.totaltel.prepaid.tticommon.data.tti.ResultMap, force=true)
  923. 21-01 16:03:18.978 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_dao_20160121_00.log
  924. Appender:mFile was null: 21-01 16:03:18.977 Preparing Query SQL
  925.  
  926. SELECT id,code,description,value,operator_id,cts,uts FROM tti_app_setting WHERE code=? AND operator_id IS NULL ORDER BY id ASC
  927.  
  928.  
  929. 21-01 16:03:18.977 DEBUG [dao] 112 - Preparing Query SQL
  930.  
  931. SELECT id,code,description,value,operator_id,cts,uts FROM tti_app_setting WHERE code=? AND operator_id IS NULL ORDER BY id ASC
  932.  
  933. 21-01 16:03:18.978 DEBUG [com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate] 637 - Executing prepared SQL query
  934. 21-01 16:03:18.978 DEBUG [com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate] 572 - Executing prepared SQL statement
  935. 21-01 16:03:18.983 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_data_20160121_00.log
  936. Appender:mFile was null: 21-01 16:03:18.982 [EVDS_3] GenericJDBCDao..................setStatementClauses - Setting param at index [1] to [CACHE.REFRESH]
  937.  
  938. 21-01 16:03:18.982 DEBUG [data] 112 - [EVDS_3] GenericJDBCDao..................setStatementClauses - Setting param at index [1] to [CACHE.REFRESH]
  939. 21-01 16:03:18.987 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_data_20160121_00.log
  940. Appender:mFile was null: 21-01 16:03:18.986 [EVDS_3] ResultMapGenericDao.............getCacheList - SELECT id,result_code_id,mapped_code,mapped_description,context,result_config_id,cts FROM tti_result_map ORDER BY id ASC
  941.  
  942. 21-01 16:03:18.986 DEBUG [data] 112 - [EVDS_3] ResultMapGenericDao.............getCacheList - SELECT id,result_code_id,mapped_code,mapped_description,context,result_config_id,cts FROM tti_result_map ORDER BY id ASC
  943. 21-01 16:03:18.987 DEBUG [com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate] 637 - Executing prepared SQL query
  944. 21-01 16:03:18.987 DEBUG [com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate] 572 - Executing prepared SQL statement
  945. 21-01 16:03:19.012 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_cache_20160121_00.log
  946. Appender:mFile was null: 21-01 16:03:19.012  [null]CACHE.................................addType() (com.totaltel.prepaid.tticommon.data.tti.ResultMap)
  947.  
  948. 21-01 16:03:19.012 DEBUG [cache] 112 -  [null]CACHE.................................addType() (com.totaltel.prepaid.tticommon.data.tti.ResultMap)
  949. 21-01 16:03:19.013 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_cache_20160121_00.log
  950. Appender:mFile was null: 21-01 16:03:19.013  [null]RegisteredCacheType...................setLoaded() (com.totaltel.prepaid.tticommon.data.tti.ResultMap, loaded=true)
  951.  
  952. 21-01 16:03:19.013 DEBUG [cache] 112 -  [null]RegisteredCacheType...................setLoaded() (com.totaltel.prepaid.tticommon.data.tti.ResultMap, loaded=true)
  953. 21-01 16:03:19.015 ERROR [ga.misc] 113 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  954. Appender:mFile was null: 21-01 16:03:19.015 ExpressionConverter..........................doConvert() (Result: [Unknown Error])
  955.  
  956. 21-01 16:03:19.015 INFO [client] 113 - ExpressionConverter..........................doConvert() (Result: [Unknown Error])
  957. 21-01 16:03:19.016 ERROR [ga.misc] 113 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  958. Appender:mFile was null: 21-01 16:03:19.015 GenericSoapMapConverter......................convert() (Validations: [true, false, false])
  959.  
  960. 21-01 16:03:19.015 INFO [client] 113 - GenericSoapMapConverter......................convert() (Validations: [true, false, false])
  961. 21-01 16:03:19.016 ERROR [ga.misc] 113 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  962. Appender:mFile was null: 21-01 16:03:19.016 GenericSoapMapConverter......................doValidations() (This custom converter requires the source field, but it has a null value)
  963.  
  964. 21-01 16:03:19.016 INFO [client] 113 - GenericSoapMapConverter......................doValidations() (This custom converter requires the source field, but it has a null value)
  965. 21-01 16:03:19.018 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_data_20160121_00.log
  966. Appender:mFile was null: 21-01 16:03:19.017 [EVDS_3] AgentDao........................find - sql: select at_id,at_op_id,at_tz_id,at_lev_id,at_md_id,at_at_id,  at_agent_status_id,at_name,at_pay_any,at_is_pp,at_tx_id,at_cts,  at_billing_agent_id,  at_code, at_activation_date, at_short_name, at_sms_cli, at_ad_id,  at_country_id, at_state_id, at_region_id, agent_category_id, sales_user_id, commis_setting_id,  at_hierarchy_level, at_uts  from er_agent a where at_id=199 order by at_id
  967.  
  968. 21-01 16:03:19.017 DEBUG [data] 112 - [EVDS_3] AgentDao........................find - sql: select at_id,at_op_id,at_tz_id,at_lev_id,at_md_id,at_at_id,  at_agent_status_id,at_name,at_pay_any,at_is_pp,at_tx_id,at_cts,  at_billing_agent_id,  at_code, at_activation_date, at_short_name, at_sms_cli, at_ad_id,  at_country_id, at_state_id, at_region_id, agent_category_id, sales_user_id, commis_setting_id,  at_hierarchy_level, at_uts  from er_agent a where at_id=199 order by at_id
  969. 21-01 16:03:19.018 DEBUG [com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate] 637 - Executing prepared SQL query
  970. 21-01 16:03:19.018 DEBUG [com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate] 572 - Executing prepared SQL statement
  971. 21-01 16:03:19.025 ERROR [ga.misc] 113 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  972. Appender:mFile was null: 21-01 16:03:19.025 ExpressionConverter..........................convert() (Validations: [true, false, true])
  973.  
  974. 21-01 16:03:19.025 INFO [client] 113 - ExpressionConverter..........................convert() (Validations: [true, false, true])
  975. 21-01 16:03:19.026 ERROR [ga.misc] 113 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  976. Appender:mFile was null: 21-01 16:03:19.026 ExpressionConverter..........................doConvert() (Mapping value: [id=517 code=AGENT517 name=IGA Denise's SD] using expression: [#{@soapUtils.parseWallets(#sourceFieldValue)}])
  977.  
  978. 21-01 16:03:19.026 INFO [client] 113 - ExpressionConverter..........................doConvert() (Mapping value: [id=517 code=AGENT517 name=IGA Denise's SD] using expression: [#{@soapUtils.parseWallets(#sourceFieldValue)}])
  979. 21-01 16:03:19.027 ERROR [ga.misc] 113 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  980. Appender:mFile was null: 21-01 16:03:19.027 ExpressionConverter..........................doConvert() (Result: [null])
  981.  
  982. 21-01 16:03:19.027 INFO [client] 113 - ExpressionConverter..........................doConvert() (Result: [null])
  983. 21-01 16:03:19.028 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_data_20160121_00.log
  984. Appender:mFile was null: 21-01 16:03:19.028 [EVDS_3] AgentDao........................find - sql: select at_id,at_op_id,at_tz_id,at_lev_id,at_md_id,at_at_id,  at_agent_status_id,at_name,at_pay_any,at_is_pp,at_tx_id,at_cts,  at_billing_agent_id,  at_code, at_activation_date, at_short_name, at_sms_cli, at_ad_id,  at_country_id, at_state_id, at_region_id, agent_category_id, sales_user_id, commis_setting_id,  at_hierarchy_level, at_uts  from er_agent a where at_id=199 order by at_id
  985.  
  986. 21-01 16:03:19.028 DEBUG [data] 112 - [EVDS_3] AgentDao........................find - sql: select at_id,at_op_id,at_tz_id,at_lev_id,at_md_id,at_at_id,  at_agent_status_id,at_name,at_pay_any,at_is_pp,at_tx_id,at_cts,  at_billing_agent_id,  at_code, at_activation_date, at_short_name, at_sms_cli, at_ad_id,  at_country_id, at_state_id, at_region_id, agent_category_id, sales_user_id, commis_setting_id,  at_hierarchy_level, at_uts  from er_agent a where at_id=199 order by at_id
  987. 21-01 16:03:19.028 DEBUG [com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate] 637 - Executing prepared SQL query
  988. 21-01 16:03:19.028 DEBUG [com.totaltel.prepaid.tticommon.dao.generic.jdbc.TTIJdbcTemplate] 572 - Executing prepared SQL statement
  989. 21-01 16:03:19.037 ERROR [ga.misc] 113 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  990. Appender:mFile was null: 21-01 16:03:19.036 DateConverter................................convert() (Validations: [true, false, true])
  991.  
  992. 21-01 16:03:19.036 INFO [client] 113 - DateConverter................................convert() (Validations: [true, false, true])
  993. 21-01 16:03:19.037 ERROR [ga.misc] 113 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  994. Appender:mFile was null: 21-01 16:03:19.037 DateConverter................................doConvert() (Mapping this value: [2015-07-10 17:04:04.0] using source value: [class java.sql.Timestamp])
  995.  
  996. 21-01 16:03:19.037 INFO [client] 113 - DateConverter................................doConvert() (Mapping this value: [2015-07-10 17:04:04.0] using source value: [class java.sql.Timestamp])
  997. 21-01 16:03:19.038 ERROR [ga.misc] 113 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  998. Appender:mFile was null: 21-01 16:03:19.038 DateConverter................................doConvertDateToString() (Mapping Date value: [Fri Jul 10 17:04:04 AEST 2015] using format: [yyyy-MM-dd HH:mm:ss])
  999.  
  1000. 21-01 16:03:19.038 INFO [client] 113 - DateConverter................................doConvertDateToString() (Mapping Date value: [Fri Jul 10 17:04:04 AEST 2015] using format: [yyyy-MM-dd HH:mm:ss])
  1001. 21-01 16:03:19.039 ERROR [ga.misc] 116 - cannot log to /Users/novatti/Documents/java_project/log/evds_dao_20160121_00.log
  1002. Appender:mFile was null: 21-01 16:03:19.039 DataAccessFactory...cloneDao() (WARNING: Attempt to clone DAO that does not implement  com.totaltel.prepaid.tticommon.dao.ICloneableDao. Returning singleton instead for class: com.totaltel.prepaid.tticommon.dao.erds.jdbc.AgentDao)
  1003.  
  1004. 21-01 16:03:19.039 WARN [dao] 116 - DataAccessFactory...cloneDao() (WARNING: Attempt to clone DAO that does not implement  com.totaltel.prepaid.tticommon.dao.ICloneableDao. Returning singleton instead for class: com.totaltel.prepaid.tticommon.dao.erds.jdbc.AgentDao)
  1005. 21-01 16:03:19.046 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_data_20160121_00.log
  1006. Appender:mFile was null: 21-01 16:03:19.046 [EVDS_3] AgentDataDao....................findById - select ad_id, ad_bank, ad_branch, ad_bsb, ad_acc, ad_bill_abn, ad_bill_acn, ad_bt_id, ad_bfr_id, ad_bill_cycle_config_id, ad_code, ad_acct_grade, ad_lang_id, ad_seclang_id, ad_trading_name, ad_trading_abn, ad_email_invoice, ad_invoice_email_address, ad_comments  from er_agent_data where ad_id = ?
  1007.  
  1008. 21-01 16:03:19.046 DEBUG [data] 112 - [EVDS_3] AgentDataDao....................findById - select ad_id, ad_bank, ad_branch, ad_bsb, ad_acc, ad_bill_abn, ad_bill_acn, ad_bt_id, ad_bfr_id, ad_bill_cycle_config_id, ad_code, ad_acct_grade, ad_lang_id, ad_seclang_id, ad_trading_name, ad_trading_abn, ad_email_invoice, ad_invoice_email_address, ad_comments  from er_agent_data where ad_id = ?
  1009. 21-01 16:03:19.063 ERROR [ga.misc] 112 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  1010. Appender:mFile was null: 21-01 16:03:19.063 SoapServer...................................onClose() (Outbound Message
  1011. ---------------------------
  1012. ID: 66
  1013. Encoding: UTF-8
  1014. Content-Type: application/soap+xml
  1015. Headers: {Content-Encoding=[gzip], Vary=[Accept-Encoding]}
  1016. Payload: <?xml version="1.0" encoding="UTF-8"?>
  1017. <soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope">
  1018.   <soap:Body>
  1019.     <ns2:SoapAgentLoginResponse xmlns:ns2="http://soap.api.novatti.com/types">
  1020.       <header>
  1021.         <agentTransactionId>1453352588303</agentTransactionId>
  1022.         <transactionId>151598</transactionId>
  1023.         <resultCode>4099</resultCode>
  1024.         <resultDescription>Unknown Error</resultDescription>
  1025.       </header>
  1026.       <agent>
  1027.         <agentId>517</agentId>
  1028.         <agentCode>AGENT517</agentCode>
  1029.         <agentDescription>IGA Denise's SD</agentDescription>
  1030.        <countryCode>MYS</countryCode>
  1031.        <countryName>Malaysia</countryName>
  1032.        <masterDistributorId>199</masterDistributorId>
  1033.        <masterDistributorCode>IGA</masterDistributorCode>
  1034.        <prepaid>false</prepaid>
  1035.        <wallets/>
  1036.        <bulletins/>
  1037.        <parentCode>IGA</parentCode>
  1038.        <parentDescription>IGA Postpaid's name</parentDescription>
  1039.         <parentType>17</parentType>
  1040.         <agentType>19</agentType>
  1041.         <status>1</status>
  1042.         <creationDate>2015-07-10 17:04:04</creationDate>
  1043.         <state>Kedah</state>
  1044.         <stateName>Kedah</stateName>
  1045.         <stateCode>KDH</stateCode>
  1046.         <timezone>MYT</timezone>
  1047.         <tax>GST+QST</tax>
  1048.         <billingInvoiceEmail>denise.butcher@novatti.com</billingInvoiceEmail>
  1049.         <businessNumber/>
  1050.         <companyNumber/>
  1051.         <agentCategoryId>0</agentCategoryId>
  1052.         <agentComments/>
  1053.       </agent>
  1054.       <user>
  1055.         <userId>0</userId>
  1056.         <acls/>
  1057.       </user>
  1058.     </ns2:SoapAgentLoginResponse>
  1059.   </soap:Body>
  1060. </soap:Envelope>
  1061.  
  1062. --------------------------------------)
  1063.  
  1064. 21-01 16:03:19.063 DEBUG [client] 112 - SoapServer...................................onClose() (Outbound Message
  1065. ---------------------------
  1066. ID: 66
  1067. Encoding: UTF-8
  1068. Content-Type: application/soap+xml
  1069. Headers: {Content-Encoding=[gzip], Vary=[Accept-Encoding]}
  1070. Payload: <?xml version="1.0" encoding="UTF-8"?>
  1071. <soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope">
  1072.   <soap:Body>
  1073.     <ns2:SoapAgentLoginResponse xmlns:ns2="http://soap.api.novatti.com/types">
  1074.       <header>
  1075.         <agentTransactionId>1453352588303</agentTransactionId>
  1076.         <transactionId>151598</transactionId>
  1077.         <resultCode>4099</resultCode>
  1078.         <resultDescription>Unknown Error</resultDescription>
  1079.       </header>
  1080.       <agent>
  1081.         <agentId>517</agentId>
  1082.         <agentCode>AGENT517</agentCode>
  1083.         <agentDescription>IGA Denise's SD</agentDescription>
  1084.        <countryCode>MYS</countryCode>
  1085.        <countryName>Malaysia</countryName>
  1086.        <masterDistributorId>199</masterDistributorId>
  1087.        <masterDistributorCode>IGA</masterDistributorCode>
  1088.        <prepaid>false</prepaid>
  1089.        <wallets/>
  1090.        <bulletins/>
  1091.        <parentCode>IGA</parentCode>
  1092.        <parentDescription>IGA Postpaid's name</parentDescription>
  1093.         <parentType>17</parentType>
  1094.         <agentType>19</agentType>
  1095.         <status>1</status>
  1096.         <creationDate>2015-07-10 17:04:04</creationDate>
  1097.         <state>Kedah</state>
  1098.         <stateName>Kedah</stateName>
  1099.         <stateCode>KDH</stateCode>
  1100.         <timezone>MYT</timezone>
  1101.         <tax>GST+QST</tax>
  1102.         <billingInvoiceEmail>denise.butcher@novatti.com</billingInvoiceEmail>
  1103.         <businessNumber/>
  1104.         <companyNumber/>
  1105.         <agentCategoryId>0</agentCategoryId>
  1106.         <agentComments/>
  1107.       </agent>
  1108.       <user>
  1109.         <userId>0</userId>
  1110.         <acls/>
  1111.       </user>
  1112.     </ns2:SoapAgentLoginResponse>
  1113.   </soap:Body>
  1114. </soap:Envelope>
  1115.  
  1116. --------------------------------------)
  1117. 21-01 16:03:19.635 ERROR [ga.misc] 113 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  1118. Appender:mFile was null: 21-01 16:03:19.634 TCPServerConnection..........................connect() (initializing connection to [localhost:9000])
  1119.  
  1120. 21-01 16:03:19.634 INFO [client] 113 - TCPServerConnection..........................connect() (initializing connection to [localhost:9000])
  1121. 21-01 16:03:19.638 ERROR [ga.misc] 114 - cannot log to /Users/novatti/Documents/java_project/log/evds_client_20160121_00.log
  1122. Appender:mFile was null: 21-01 16:03:19.636 TCPServerConnection..........................connect() (Failed to connect to [localhost:9000])
  1123.  
  1124. 21-01 16:03:19.636 ERROR [client] 114 - TCPServerConnection..........................connect() (Failed to connect to [localhost:9000])
  1125. 21-01 16:03:19.640 ERROR [ga.misc] 114 - cannot log to /Users/novatti/Documents/java_project/log/evds_exception_20160121_00.log
  1126. Appender:mFile was null: 21-01 16:03:19.638 TCPServerConnection..........................connect() (Failed to connect to [localhost:9000])
  1127.  
  1128. 21-01 16:03:19.638 ERROR [exception] 114 - TCPServerConnection..........................connect() (Failed to connect to [localhost:9000])
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!