ジョブアレンジャーのご利用ありがとうございます。
エラーに関して状況のご説明、ログ、SQLiteDBの資料提供有難うございます。
サーバログに出ております inner_jobid [851894]は、Agentログにはありません。
同時刻帯にはjobid: 851892、851897 はAgentログに出ており、SQLiteDBのデータにもあります。
同じく同時刻帯にAgentログに以下のエラーが数件出ています。
[ERROR] query failed: [BEGIN IMMEDIATE;] error [cannot start a transaction within a transaction]★
このエラーは、SQLiteが出しているエラーです。検索しますとその理由は一筋縄ではいかない模様です。
これらの状況から、サーバから送付されたジョブ実行データがAgent側でSQLiteが取込みに失敗して実行されなかったように思われます。
以下について、情報を頂けますか?
①20201014:0500時台では、3件エラーが出ていますが、問題になったジョブはこの一件だけでしょうか?
20201014:0523時台では、2件エラーがありますが、こちらはいかがですか?
それ以前にもこのAgentログでは頻発しているようですが、それら発生の時にはジョブ未実行エラーは起きていますか?
②ジョブのエラーは2台のWindowsServerで、同様に起きますか?
③また、このサーバはどういったマシンでしょうか?(AWS、VMwareなどの仮想サーバ?)
ご確認お願いいたします。
---SQLiteDBのデータ
sqlite> select * from jobs where jobid = 851894; 無し
sqlite> select * from jobs where jobid = 851892;
851892|1|20200310162755318|0|extjob||||0|3|268860|1602619244|1602619244||||0|0|||10.96.19.71
sqlite> select * from jobs where jobid = 851897;
851897|1|20200310162755318|0|command||||0|3|271992|1602619260|1602619263||||0|0|||10.96.19.71
---Server.log
13425:20201014:050056.604 [ERROR] [JARUNICONJOB200012] Cannot send data:inner_jobid [851894], message [received data is null]
13425:20201014:050056.716 [INFO] [JAJOBNETRUN000001] In ja_set_runerr() job execution error. inner_job_id: 851894 status is RUNERR jobnet_id: IZM_2_DA1_01, job_id: IZM_2_DA1_01/2_DA2_01_05/01_05_03, user_name: Server-Sub-Admin, job_exit_cd: 0, icon_status: 2
---Agent.log
3352:20201014:050044.806 [INFO] In ja_job_object_list_executive () jobid: 851892, type: extjob, status: BEGIN
3352:20201014:050044.806 [INFO] jobid: 851892, status: 0
3352:20201014:050045.244 [INFO] In ja_job_object_list_executive() jobid: 851892, status: END
3352:20201014:050045.244 [INFO] In ja_agent_close() jobid: 851892, status: 2
3356:20201014:050046.322 [INFO] In ja_agent_begin() jobid: 851897, method: 0
3356:20201014:050046.400 [WARN] In ja_jobdb_get_status() can not find jobid: 851897
3356:20201014:050046.463 [INFO] In ja_jobdb_insert() jobid: 851897 is created
3352:20201014:050046.525 [INFO] In ja_job_object_list_executive() jobid: 851892, status: CLOSE
3352:20201014:050046.525 [INFO] In ja_job_object_list_executive () jobid: 851905, type: extjob, status: BEGIN
3352:20201014:050046.541 [INFO] jobid: 851905, status: 0
3356:20201014:050046.557 [INFO] jobid: 851897, method: 0 is begin
~~~省略
3352:20201014:050051.035 [INFO] In ja_job_object_list_executive () jobid: 851855, type: command, status: BEGIN
3352:20201014:050051.035 [INFO] jobid: 851855, status: 0
3352:20201014:050051.285 [INFO] In ja_job_object_list_executive () jobid: 851868, type: command, status: BEGIN
3352:20201014:050051.301 [INFO] jobid: 851868, status: 0
3352:20201014:050052.567 [INFO] In ja_job_object_list_executive () jobid: 851881, type: command, status: BEGIN
3352:20201014:050052.567 [INFO] jobid: 851881, status: 0
3352:20201014:050054.057 [INFO] In ja_job_object_list_executive() jobid: 851855, status: END
3352:20201014:050054.072 [INFO] In ja_agent_close() jobid: 851855, status: 2
3352:20201014:050054.400 [INFO] In ja_job_object_list_executive() jobid: 851855, status: CLOSE
3356:20201014:050055.276 [INFO] In ja_agent_begin() jobid: 851858, method: 0
3356:20201014:050055.354 [WARN] In ja_jobdb_get_status() can not find jobid: 851858
3352:20201014:050055.432 [ERROR] query failed: [BEGIN IMMEDIATE;] error [cannot start a transaction within a transaction]★
3356:20201014:050055.432 [INFO] In ja_jobdb_insert() jobid: 851858 is created
3356:20201014:050055.541 [INFO] jobid: 851858, method: 0 is begin
3352:20201014:050056.651 [INFO] In ja_job_object_list_executive() jobid: 851868, status: END
3352:20201014:050056.651 [INFO] In ja_agent_close() jobid: 851868, status: 2
3352:20201014:050056.982 [INFO] In ja_job_object_list_executive() jobid: 851868, status: CLOSE
3356:20201014:050057.900 [INFO] In ja_agent_begin() jobid: 851871, method: 0
3356:20201014:050057.979 [WARN] In ja_jobdb_get_status() can not find jobid: 851871
3352:20201014:050058.010 [ERROR] query failed: [BEGIN IMMEDIATE;] error [cannot start a transaction within a transaction]★
3356:20201014:050058.057 [INFO] In ja_jobdb_insert() jobid: 851871 is created
3356:20201014:050058.150 [INFO] jobid: 851871, method: 0 is begin
3352:20201014:050059.229 [INFO] In ja_job_object_list_executive() jobid: 851881, status: END
3352:20201014:050059.229 [INFO] In ja_agent_close() jobid: 851881, status: 2
3352:20201014:050059.557 [INFO] In ja_job_object_list_executive() jobid: 851881, status: CLOSE
3356:20201014:050059.823 [INFO] In ja_agent_begin() jobid: 851884, method: 0
3356:20201014:050059.901 [WARN] In ja_jobdb_get_status() can not find jobid: 851884
3356:20201014:050059.979 [INFO] In ja_jobdb_insert() jobid: 851884 is created
---Agent.log [cannot start a transaction within a transaction] 抜粋
3356:20201013:120015.275 [ERROR] query failed: [BEGIN IMMEDIATE;] error [cannot start a transaction within a transaction]
~~~省略
3352:20201014:050037.582 [ERROR] query failed: [BEGIN IMMEDIATE;] error [cannot start a transaction within a transaction]
3352:20201014:050055.432 [ERROR] query failed: [BEGIN IMMEDIATE;] error [cannot start a transaction within a transaction]
3352:20201014:050058.010 [ERROR] query failed: [BEGIN IMMEDIATE;] error [cannot start a transaction within a transaction]
3352:20201014:052307.356 [ERROR] query failed: [BEGIN IMMEDIATE;] error [cannot start a transaction within a transaction]
3352:20201014:052313.958 [ERROR] query failed: [BEGIN IMMEDIATE;] error [cannot start a transaction within a transaction]
弊社ではご契約ユーザ様向け回答を最優先で実施しております。
速やかな返信のためにサポート契約をご検討頂ければ幸甚です。
宜しくお願い致します。