| Info |
|---|
This hanging issue can occur only between Sep 2017 and Oct 2018 EagleML versions (fixed in Nov-2018). EagleML version can be found in the first line of \tpe\dynamic\msgcenter\eagle_ml-2-0_cm\w_config.inc |
...
- The value is the hard-coded timeout in the EagleML include file tpe\dynamic\msgcenter\eagle_ml-2-0_cm\waiting_processor.inc for parallel_exec stream to check if a file has been loaded
- It can be overridden in the w_config_custom as W_REQ_CNT_LOOP_MAX parameter (but it is too late if it is already processing)
...
We are going to need the file name and stream name of the line which stays in progress (green circular arrow).
...
...
| lang | SQL |
|---|
| update msgcenter_dbo.msg_message_stat set stream_id = (select msg_stream_id from msgcenter_dbo.msg_streams where msg_stream_title = 'eagle_ml-2-0_default_cm_acquire_data') where file_name like '%AK_PE_108%' and stream_id = (select msg_stream_id from msgcenter_dbo.msg_streams where msg_stream_title = 'eagle_default_in_csv_all') |
2. Wait until the waiting process stops the polling and marks itself as completeThis statement will change stream name for the topmost (failed) record. The *parallel_exec stream is in progress only because it does not “see” that completed record.
2. Wait until the waiting process stops the polling and marks itself as complete
The picture will turn into something like this:
...
Same statement, but stream names swapped:
...
| lang | SQL |
|---|
| update msgcenter_dbo.msg_message_stat set stream_id = (select msg_stream_id from msgcenter_dbo.msg_streams where msg_stream_title = 'eagle_default_in_csv_all') where file_name like '%AK_PE_108%' and stream_id = (select msg_stream_id from msgcenter_dbo.msg_streams where msg_stream_title = ' eagle_ml-2-0_default_cm_acquire_data'') |
The result is now the same as it would be without the “18000 issue” :
In our case we will have to repeat these three steps for all the stuck files.
...