Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

When job stuck after system restart, you may need to restart the 

Solution

If job has continued but old record didn't resume

Delete record from ss_order_call_date, check for the time gap between records, delete the record from the largest gap to latest (for example if 2021-9-25 07:15:02 , the next timestamp is 2021-9-26 00:00:00, which is suppose each time gap within 5mins)

Panel
bgColor#fff
titleSQL Command example

delete from ss_order_call_date where last_call_date > '2021-09-25 07:15:02' 

Execute the following command in SSH to etechplus.ddns.net (you need to be in Bizspoke internal network)

Panel
bgColor#fff
titleSSH command

pm2 stop ss-nav-jira-JIRA
pm2 stop ss-nav-jira-NAV
pm2 start ss-nav-jira-JIRA
pm2 start ss-nav-jira-NAV


If

...

some records were not synced. It is because jira_status is marked to 'U' before being created. The status needs to be mark back to 'N' in order to sync.

Execute the following in MYSQL db in etechplus.ddns.net >> ss_jira.

Panel
titleSQL Command example

ALTER sol,
(ss_order_line sol LEFT JOIN ss_order_header soh on sol.Order_Id = soh.Order_Id)
SET sol.jira_status = 'N'
WHERE soh.Order_Date > '2021-12-16' AND ISNULL(sol.jira_key)

...


Content by Label
showLabelsfalse
max5
spacesWSKZAM80XQU4CZEL
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel = "restart" and type = "page" and space = "WSKZAM80XQU4CZEL"
labelsrestart

...

Page properties
hiddentrue


Related issues