Project

General

Profile

操作問い合わせ #1841

BUG consult sql job execution result

Added by Anonymous about 5 years ago. Updated about 5 years ago.

Status:
終了
Priority:
通常
Assignee:
-
Start date:
05/09/2015
Due date:
% Done:

0%

Estimated time:

Description

default Jarb Manager SQL result not found

1431100724:select JR.*, DM.message as message from ja_run_log_table AS JR, ja_define_run_log_message_table as DM where JR.log_date >= '20150501000000000' and JR.log_date <= '20150508235959999' and JR.message_id=DM.message_id and DM.lang='pt_br' order by JR.inner_jobnet_main_id,JR.log_date;

SQL FOUND
select JR.*, DM.message as message from ja_run_log_table AS JR, ja_define_run_log_message_table as DM where JR.log_date >= '20150501000000000' and JR.log_date <= '20150508235959999' and JR.message_id=DM.message_id and DM.lang='en' order by JR.inner_jobnet_main_id,JR.log_date;

how do I restirar the variable DM.lang='pt_br' of the jorb manager sql query result

job.JPG (74.6 KB) job.JPG Anonymous, 05/09/2015 01:06 AM
sqlfound.JPG (175 KB) sqlfound.JPG Anonymous, 05/09/2015 01:06 AM

History

#1 Updated by Anonymous about 5 years ago

How can I remove this variable from my query?

#2 Updated by Anonymous about 5 years ago

I find out where was the problem! My User in zabbix was set to Brazil the Portuguese to switch to English it worked normally!

#3 Updated by 保守サポート 担当 about 5 years ago

  • Status changed from 新規登録 to 終了

Also available in: Atom PDF