FortiMail Web UI said "CMDB error", What does it mean?

[S-GenZ]

FortiMail version 7.0.4.

When I change a custom messages and saved from Web UI, then PopUp showes

"Failed: CMDB error: cmdb error: -1002 (System is being shutting down)"

What does this error mean?

It says "System is being shutting down", but never shutting down...

Do I need to do anything? or Could I ignore?

Thank you.

[Anonymous]

Hello @S-GenZ,

Thank you for using the Community Forum. I will seek to get you an answer or help. We will reply to this thread with an update as soon as possible.

Thanks,

[Dirty_wizard]

Hi,

What custom message change are you attempting to make?

In the CLI could you enter the following commands, then attempt to make the same change:

diag debug cli 7

diag debug enable

After the change is made, disable with:
diag debug disable

Then download the tracelog from System > Maintenance > Configuration.
And please attach here. Thanks.

[S-GenZ]

Hello Dirty_wizard.

Thank you for your reply.

I changed 'default' report-quarantine-summary, and debug command done.

10.25-10:53:25 admin.fe(13631): _db_d_find, query=[SELECT field_status,hsubject,hfrom ,hto,envfrom ,envto,alternative_part,textbody,htmlbody,description,ctype_name,template_name,name FROM email_template WHERE  name='default' AND ctype_name = 'report-quarantine-summary' AND   cmf_domain = 'system';]
10.25-10:53:48 admin.fe(13629): _db_d_find, query=[SELECT field_status,hsubject,hfrom ,hto,envfrom ,envto,alternative_part,textbody,htmlbody,description,ctype_name,template_name,name FROM email_template WHERE  name='default' AND ctype_name = 'report-quarantine-summary' AND   cmf_domain = 'system';]
10.25-10:53:48 admin.fe(13629): _db_d_find, query=[SELECT field_status,hsubject,hfrom ,hto,envfrom ,envto,alternative_part,textbody,htmlbody,description,ctype_name,template_name,name FROM email_template WHERE  name='default' AND ctype_name = 'report-quarantine-summary' AND   cmf_domain = 'system';]
10.25-10:53:48 cmdbsvr(2886): req: 37181, admin.fe(13629), gui_commit(21), 0
10.25-10:53:48 cmdbsvr(2886): service call 'gui_commit' from socket 17,  admin.fe (13629) 
10.25-10:53:48 cmdbsvr(2886): _db_d_find, query=[SELECT id,category,class,description,max_instances,name FROM ctype WHERE  name='report-quarantine-summary' AND   cmf_domain = 'system';]
10.25-10:53:48 cmdbsvr(2886): db_get_entry_total, query=[SELECT count(*) FROM cvariable WHERE  ctype_name = 'report-quarantine-summary' AND  cmf_domain = 'system';]
10.25-10:53:48 cmdbsvr(2886): _db_d_for_each, query=[SELECT coption,content,displayname,ctype_name,name FROM cvariable WHERE ctype_name = 'report-quarantine-summary' AND   cmf_domain = 'system';]
10.25-10:53:48 cmdbsvr(2886): db_get_entry_total, query=[SELECT count(*) FROM cmessage WHERE  ctype_name = 'report-quarantine-summary' AND  cmf_domain = 'system';]
10.25-10:53:48 cmdbsvr(2886): db_get_entry_total, query=[SELECT count(*) FROM email_template WHERE  ctype_name = 'report-quarantine-summary' AND  cmf_domain = 'system';]
10.25-10:53:48 cmdbsvr(2886): _db_d_for_each, query=[SELECT field_status,hsubject,hfrom ,hto,envfrom ,envto,alternative_part,textbody,htmlbody,description,ctype_name,template_name,name FROM email_template WHERE ctype_name = 'report-quarantine-summary' AND   cmf_domain = 'system';]
10.25-10:53:48 cmdbsvr(2886): _db_d_find, query=[SELECT field_status,hsubject,hfrom ,hto,envfrom ,envto,alternative_part,textbody,htmlbody,description,ctype_name,template_name,name FROM email_template WHERE  name='default' AND ctype_name = 'report-quarantine-summary' AND   cmf_domain = 'system';]
10.25-10:53:48 cmdbsvr(2886): 0: config  customized-message
10.25-10:53:48 cmdbsvr(2886): _db_d_find, query=[SELECT id,category,class,description,max_instances,name FROM ctype WHERE  name='report-quarantine-summary' AND   cmf_domain = 'system';]
10.25-10:53:48 cmdbsvr(2886): db_get_entry_total, query=[SELECT count(*) FROM cvariable WHERE  ctype_name = 'report-quarantine-summary' AND  cmf_domain = 'system';]
10.25-10:53:48 cmdbsvr(2886): _db_d_for_each, query=[SELECT coption,content,displayname,ctype_name,name FROM cvariable WHERE ctype_name = 'report-quarantine-summary' AND   cmf_domain = 'system';]
10.25-10:53:48 cmdbsvr(2886): db_get_entry_total, query=[SELECT count(*) FROM cmessage WHERE  ctype_name = 'report-quarantine-summary' AND  cmf_domain = 'system';]
10.25-10:53:48 cmdbsvr(2886): db_get_entry_total, query=[SELECT count(*) FROM email_template WHERE  ctype_name = 'report-quarantine-summary' AND  cmf_domain = 'system';]
10.25-10:53:48 cmdbsvr(2886): _db_d_for_each, query=[SELECT field_status,hsubject,hfrom ,hto,envfrom ,envto,alternative_part,textbody,htmlbody,description,ctype_name,template_name,name FROM email_template WHERE ctype_name = 'report-quarantine-summary' AND   cmf_domain = 'system';]
10.25-10:53:48 cmdbsvr(2886): db_get_entry_total, query=[SELECT count(*) FROM cvariable WHERE  ctype_name = 'report-quarantine-summary' AND  cmf_domain = 'system';]
10.25-10:53:48 cmdbsvr(2886): _db_d_for_each, query=[SELECT coption,content,displayname,ctype_name,name FROM cvariable WHERE ctype_name = 'report-quarantine-summary' AND   cmf_domain = 'system';]
10.25-10:53:48 cmdbsvr(2886): db_get_entry_total, query=[SELECT count(*) FROM cmessage WHERE  ctype_name = 'report-quarantine-summary' AND  cmf_domain = 'system';]
10.25-10:53:48 cmdbsvr(2886): db_get_entry_total, query=[SELECT count(*) FROM email_template WHERE  ctype_name = 'report-quarantine-summary' AND  cmf_domain = 'system';]
10.25-10:53:48 cmdbsvr(2886): _db_d_for_each, query=[SELECT field_status,hsubject,hfrom ,hto,envfrom ,envto,alternative_part,textbody,htmlbody,description,ctype_name,template_name,name FROM email_template WHERE ctype_name = 'report-quarantine-summary' AND   cmf_domain = 'system';]
10.25-10:53:48 cmdbsvr(2886): _db_d_update, query=[SELECT id,category,class,description,max_instances,name FROM ctype  WHERE   cmf_domain = 'system'  AND  name = 'report-quarantine-summary';]
10.25-10:53:48 cmdbsvr(2886): db_get_entry_total, query=[SELECT count(*) FROM cvariable WHERE  ctype_name = 'report-quarantine-summary' AND  cmf_domain = 'system';]
10.25-10:53:48 cmdbsvr(2886): _db_d_for_each, query=[SELECT coption,content,displayname,ctype_name,name FROM cvariable WHERE ctype_name = 'report-quarantine-summary' AND   cmf_domain = 'system';]
10.25-10:53:48 cmdbsvr(2886): db_get_entry_total, query=[SELECT count(*) FROM cmessage WHERE  ctype_name = 'report-quarantine-summary' AND  cmf_domain = 'system';]
10.25-10:53:48 cmdbsvr(2886): db_get_entry_total, query=[SELECT count(*) FROM email_template WHERE  ctype_name = 'report-quarantine-summary' AND  cmf_domain = 'system';]
10.25-10:53:48 cmdbsvr(2886): _db_d_for_each, query=[SELECT field_status,hsubject,hfrom ,hto,envfrom ,envto,alternative_part,textbody,htmlbody,description,ctype_name,template_name,name FROM email_template WHERE ctype_name = 'report-quarantine-summary' AND   cmf_domain = 'system';]
10.25-10:53:48 cmdbsvr(2886): 0: edit report-quarantine-summary
10.25-10:53:48 cmdbsvr(2886): 0: config email-template
10.25-10:53:48 cmdbsvr(2886): _db_d_find, query=[SELECT field_status,hsubject,hfrom ,hto,envfrom ,envto,alternative_part,textbody,htmlbody,description,ctype_name,template_name,name FROM email_template WHERE  name='default' AND ctype_name = 'report-quarantine-summary' AND   cmf_domain = 'system';]
10.25-10:53:48 cmdbsvr(2886): _db_d_getflag, query=[SELECT cmf_flag FROM email_template WHERE  name='default' AND  ctype_name = 'report-quarantine-summary' AND  cmf_domain = 'system';]
10.25-10:53:48 cmdbsvr(2886): _db_d_update, query=[SELECT field_status,hsubject,hfrom ,hto,envfrom ,envto,alternative_part,textbody,htmlbody,description,ctype_name,template_name,name FROM email_template WHERE ctype_name = 'report-quarantine-summary'  AND   cmf_domain = 'system'  AND  name = 'default';]
10.25-10:53:48 cmdbsvr(2886): 0: edit default
10.25-10:53:48 cmdbsvr(2886): set text-body "
10.25-10:53:48 cmdbsvr(2886): 0: "
10.25-10:53:48 cmdbsvr(2886): _db_d_update, query=[SELECT field_status,hsubject,hfrom ,hto,envfrom ,envto,alternative_part,textbody,htmlbody,description,ctype_name,template_name,name FROM email_template WHERE ctype_name = 'report-quarantine-summary'  AND   cmf_domain = 'system'  AND  name = 'default';]
10.25-10:53:48 cmdbsvr(2886): _db_d_getflag, query=[SELECT cmf_flag FROM email_template WHERE  name='default' AND  ctype_name = 'report-quarantine-summary' AND  cmf_domain = 'system';]
10.25-10:53:48 cmdbsvr(2886): _db_d_setflag, query=[UPDATE  email_template SET cmf_flag=1 WHERE  name='default' AND  ctype_name = 'report-quarantine-summary' AND  cmf_domain = 'system';]
10.25-10:53:48 cmdbsvr(2886): _db_d_commit, query=[UPDATE email_template SET  field_status=107, hsubject='', hfrom ='', hto='', envfrom ='', envto='', alternative_part=3, textbody='', description='', template_name='predefined' WHERE  name='default' AND  ctype_name = 'report-quarantine-summary' AND  cmf_domain = 'system';]
10.25-10:53:48 cmdbsvr(2886): _etpl_shm_set: etpl 38 not loaded yet!
10.25-10:53:48 cmdbsvr(2886): send buff to ha. cmdfrom=1, pid=2886, buff=
config customized-message 
edit report-quarantine-summary 
config email-template 
edit default 
set text-body "" 
abort
10.25-10:53:48 cmdbsvr(2886): -1002: next
10.25-10:53:48 cmdbsvr(2886): send buff to ha. cmdfrom=1, pid=2886, buff=
end 
10.25-10:53:48 cmdbsvr(2886): 0: [end]
10.25-10:53:48 cmdbsvr(2886): send buff to ha. cmdfrom=1, pid=2886, buff=
abort 
10.25-10:53:48 cmdbsvr(2886): 0: [abort]
10.25-10:53:48 admin.fe(13629): reply received 'gui_commit': 0 r=-1002 pid=13629

It always shows the Popup message...

[Dirty_wizard]

Thanks,

From debug we are getting:

set text-body "" 

What is being entered into the Text field in GUI?

[S-GenZ]

I put the Value of Null...

But anything will be popuped warning.

[Dirty_wizard]

Could you show the full template?

config customized-message 
edit report-quarantine-summary 
config email-template 
edit default 
show

It's odd that it attempts to commit "" as the text-body even with no change made.

If you were deleting the text it would simply 'unset text-body'.

Have you tried resetting the template to default (would like to see your current template first).

Or clearing browser data?