28725
DISCUSSIONS
101724
MEMBERS
3157
ARTICLES
Created 05-25-2014 07:19 PM
error messages are changing, sometimes get error "
Couldn't open transport for xxxxxxx.com:22000(connect() failed: Connection refused)
",
sometimes get error:"Could not connect to szxhd001-rhl.huawei.com:21050",
sometimes get error:"Bad status for request 1622: TGetOperationStatusResp(status=TStatus(errorCode=None, errorMessage=None, sqlState=None, infoMessages=None, statusCode=0), operationState=5, errorMessage=None, sqlState=None, errorCode=None)"
sql:
select
u_id,
max(m.level_2) appName,
max(m.module_1) module,
max(m.task_create_date) task_create_date,
max(m.params) params,
max(m.event_message) message,
max(m.server_name) server_name,
max(m.app_version) appVersion,
max(m.app_name_todo) appNameTodo
from
meap.event_log m
where
m.create_date_p >= to_date('2014-01-01')
and m.create_date_p <= to_date('2014-12-12')
and m.site_id_p ='xxxx'
group by m.u_id
order by m.u_id desc limit 100