2024-11-01 11:31:58.580 ERROR c.c.r.backend.aspect.DaoMapperAop - 出错方法:getTradeHistoryCount---错误原因: ### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist ### The error may exist in class path resource [mapper/TradeShardingDao.xml] ### The error may involve com.crm.ib.dao.mapper.TradeShardingDao.getTradeHistoryCount-Inline ### The error occurred while setting parameters ### SQL: select count(*) from trade_history_MT4_202501 trade left join custom_login ca on trade.login=ca.login left join user_info agent on ca.agent_id = agent.id WHERE ca.agent_id = ? and agent.ib_no like concat(?,'%') and trade.close_time >= ? and trade.close_time < ? and agent.group_id=? and agent.stamp like binary concat(?,'%') ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist 2024-11-01 11:31:58.581 ERROR java.lang.RuntimeException - 出错类:com.crm.ib.service.impl.TradeHistoryShardingServiceImpluccess ,出错方法getListuccess java.lang.RuntimeException: system erroruccess,异常行号:48 2024-11-01 11:32:06.275 ERROR c.c.r.backend.aspect.DaoMapperAop - 出错方法:getTradeHistoryCount---错误原因: ### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist ### The error may exist in class path resource [mapper/TradeShardingDao.xml] ### The error may involve com.crm.ib.dao.mapper.TradeShardingDao.getTradeHistoryCount-Inline ### The error occurred while setting parameters ### SQL: select count(*) from trade_history_MT4_202501 trade left join custom_login ca on trade.login=ca.login left join user_info agent on ca.agent_id = agent.id WHERE ca.agent_id = ? and agent.ib_no like concat(?,'%') and trade.close_time >= ? and trade.close_time < ? and agent.group_id=? and agent.stamp like binary concat(?,'%') ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist 2024-11-01 11:32:06.276 ERROR java.lang.RuntimeException - 出错类:com.crm.ib.service.impl.TradeHistoryShardingServiceImpluccess ,出错方法getListuccess java.lang.RuntimeException: system erroruccess,异常行号:48 2024-11-01 11:32:11.252 ERROR c.c.r.backend.aspect.DaoMapperAop - 出错方法:getTradeHistoryCount---错误原因: ### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist ### The error may exist in class path resource [mapper/TradeShardingDao.xml] ### The error may involve com.crm.ib.dao.mapper.TradeShardingDao.getTradeHistoryCount-Inline ### The error occurred while setting parameters ### SQL: select count(*) from trade_history_MT4_202501 trade left join custom_login ca on trade.login=ca.login left join user_info agent on ca.agent_id = agent.id WHERE ca.agent_id = ? and agent.ib_no like concat(?,'%') and trade.close_time >= ? and trade.close_time < ? and agent.group_id=? and agent.stamp like binary concat(?,'%') ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist 2024-11-01 11:32:11.253 ERROR java.lang.RuntimeException - 出错类:com.crm.ib.service.impl.TradeHistoryShardingServiceImpluccess ,出错方法getListuccess java.lang.RuntimeException: system erroruccess,异常行号:48 2024-11-01 11:32:14.140 ERROR c.c.r.backend.aspect.DaoMapperAop - 出错方法:getTradeHistoryCount---错误原因: ### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist ### The error may exist in class path resource [mapper/TradeShardingDao.xml] ### The error may involve com.crm.ib.dao.mapper.TradeShardingDao.getTradeHistoryCount-Inline ### The error occurred while setting parameters ### SQL: select count(*) from trade_history_MT4_202501 trade left join custom_login ca on trade.login=ca.login left join user_info agent on ca.agent_id = agent.id WHERE ca.agent_id = ? and agent.ib_no like concat(?,'%') and trade.close_time >= ? and trade.close_time < ? and agent.group_id=? and agent.stamp like binary concat(?,'%') ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist 2024-11-01 11:32:14.140 ERROR java.lang.RuntimeException - 出错类:com.crm.ib.service.impl.TradeHistoryShardingServiceImpluccess ,出错方法getListuccess java.lang.RuntimeException: system erroruccess,异常行号:48 2024-11-01 11:32:23.128 ERROR c.c.r.backend.aspect.DaoMapperAop - 出错方法:getTradeHistoryCount---错误原因: ### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist ### The error may exist in class path resource [mapper/TradeShardingDao.xml] ### The error may involve com.crm.ib.dao.mapper.TradeShardingDao.getTradeHistoryCount-Inline ### The error occurred while setting parameters ### SQL: select count(*) from trade_history_MT4_202501 trade left join custom_login ca on trade.login=ca.login left join user_info agent on ca.agent_id = agent.id WHERE ca.agent_id = ? and agent.ib_no like concat(?,'%') and trade.close_time >= ? and trade.close_time < ? and agent.group_id=? and agent.stamp like binary concat(?,'%') ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist 2024-11-01 11:32:23.128 ERROR java.lang.RuntimeException - 出错类:com.crm.ib.service.impl.TradeHistoryShardingServiceImpluccess ,出错方法getListuccess java.lang.RuntimeException: system erroruccess,异常行号:48 2024-11-01 11:34:27.430 ERROR c.c.r.backend.aspect.DaoMapperAop - 出错方法:getTradeHistoryCount---错误原因: ### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202510' doesn't exist ### The error may exist in class path resource [mapper/TradeShardingDao.xml] ### The error may involve com.crm.ib.dao.mapper.TradeShardingDao.getTradeHistoryCount-Inline ### The error occurred while setting parameters ### SQL: select count(*) from trade_history_MT4_202510 trade left join custom_login ca on trade.login=ca.login left join user_info agent on ca.agent_id = agent.id WHERE ca.agent_id = ? and agent.ib_no like concat(?,'%') and trade.close_time >= ? and trade.close_time < ? and agent.group_id=? and agent.stamp like binary concat(?,'%') ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202510' doesn't exist ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202510' doesn't exist 2024-11-01 11:34:27.430 ERROR java.lang.RuntimeException - 出错类:com.crm.ib.service.impl.TradeHistoryShardingServiceImpluccess ,出错方法getListuccess java.lang.RuntimeException: system erroruccess,异常行号:48 2024-11-01 11:34:28.956 ERROR c.c.r.backend.aspect.DaoMapperAop - 出错方法:getTradeHistoryCount---错误原因: ### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202510' doesn't exist ### The error may exist in class path resource [mapper/TradeShardingDao.xml] ### The error may involve com.crm.ib.dao.mapper.TradeShardingDao.getTradeHistoryCount-Inline ### The error occurred while setting parameters ### SQL: select count(*) from trade_history_MT4_202510 trade left join custom_login ca on trade.login=ca.login left join user_info agent on ca.agent_id = agent.id WHERE ca.agent_id = ? and agent.ib_no like concat(?,'%') and trade.close_time >= ? and trade.close_time < ? and agent.group_id=? and agent.stamp like binary concat(?,'%') ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202510' doesn't exist ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202510' doesn't exist 2024-11-01 11:34:28.957 ERROR java.lang.RuntimeException - 出错类:com.crm.ib.service.impl.TradeHistoryShardingServiceImpluccess ,出错方法getListuccess java.lang.RuntimeException: system erroruccess,异常行号:48 2024-11-01 11:36:41.150 ERROR c.c.r.backend.aspect.DaoMapperAop - 出错方法:getTradeHistoryCount---错误原因: ### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist ### The error may exist in class path resource [mapper/TradeShardingDao.xml] ### The error may involve com.crm.ib.dao.mapper.TradeShardingDao.getTradeHistoryCount-Inline ### The error occurred while setting parameters ### SQL: select count(*) from trade_history_MT4_202501 trade left join custom_login ca on trade.login=ca.login left join user_info agent on ca.agent_id = agent.id WHERE ca.agent_id = ? and agent.ib_no like concat(?,'%') and trade.close_time >= ? and trade.close_time < ? and agent.group_id=? and agent.stamp like binary concat(?,'%') ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist 2024-11-01 11:36:41.150 ERROR java.lang.RuntimeException - 出错类:com.crm.ib.service.impl.TradeHistoryShardingServiceImpluccess ,出错方法getListuccess java.lang.RuntimeException: system erroruccess,异常行号:48 2024-11-01 11:39:45.654 ERROR c.c.r.backend.aspect.DaoMapperAop - 出错方法:getTradeHistoryCount---错误原因: ### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist ### The error may exist in class path resource [mapper/TradeShardingDao.xml] ### The error may involve com.crm.ib.dao.mapper.TradeShardingDao.getTradeHistoryCount-Inline ### The error occurred while setting parameters ### SQL: select count(*) from trade_history_MT4_202501 trade left join custom_login ca on trade.login=ca.login left join user_info agent on ca.agent_id = agent.id WHERE ca.agent_id = ? and agent.ib_no like concat(?,'%') and trade.close_time >= ? and trade.close_time < ? and agent.group_id=? and agent.stamp like binary concat(?,'%') ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist 2024-11-01 11:39:45.654 ERROR java.lang.RuntimeException - 出错类:com.crm.ib.service.impl.TradeHistoryShardingServiceImpluccess ,出错方法getListuccess java.lang.RuntimeException: system erroruccess,异常行号:48 2024-11-01 11:40:09.772 ERROR c.c.r.backend.aspect.DaoMapperAop - 出错方法:getTradeHistoryCount---错误原因: ### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist ### The error may exist in class path resource [mapper/TradeShardingDao.xml] ### The error may involve com.crm.ib.dao.mapper.TradeShardingDao.getTradeHistoryCount-Inline ### The error occurred while setting parameters ### SQL: select count(*) from trade_history_MT4_202501 trade left join custom_login ca on trade.login=ca.login left join user_info agent on ca.agent_id = agent.id WHERE ca.agent_id = ? and agent.ib_no like concat(?,'%') and trade.close_time >= ? and trade.close_time < ? and agent.group_id=? and agent.stamp like binary concat(?,'%') ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist 2024-11-01 11:40:09.772 ERROR java.lang.RuntimeException - 出错类:com.crm.ib.service.impl.TradeHistoryShardingServiceImpluccess ,出错方法getListuccess java.lang.RuntimeException: system erroruccess,异常行号:48