FortiAnalyzer | Server Error:DB Exception - Table does not exist

5 replies
3554 views
Translate All

Hello!

I installed FortiAnalyzer (Trial) on a VM, but some panels (FortiView -> Traffic Analysis or Treats, for example) return the error:

Server error: DB::Exception: Table siem.fv_fgt_t_threat_5min_sp1 does not exist

Already tried:

#execute sql-local rebuild-db

#diag test application fazcfgd 85

Did I miss some config., or any suggestions on how to fix it?

Thx

FortiAnalyzer

smkml

Staff

Hello @NoneEng ,

Kindly share the debug output for below command:

diag debug enable
diag debug app siemdbd 7

Translate

NoneEngAuthor

Explorer II

@smkml, sure:

#diag debug app siemdbd
#diag debug enable:

[T18007:siemdb_main.c:538] siemdbd is starting.... siemdb_database_init ++++ siemdb_table_alladom_init --- [T18007:siemdb_upgrade.c:272] siemdb_ver_get table_ver on table __priv_alladom return=0, ver:20240628->20240628 [T18007:siemdb_upgrade.c:272] siemdb_ver_get table_ver on table __priv_adomtempl return=0, ver:20240628->20240628 [T18007:cmd_proxy.c:288] 1726830207 result of popen sed 's/$SPID/0/g; s/$VERSION/070600.0025/g; s/$STORAGE//g' /usr/local/siem/fv_templ/functions.sql > /drive0/private/siemdbd/sql/functions.sql: [T18007:cmd_proxy.c:288] 1726830208 result of popen clickhouse-client --password $(cat /etc/clickhouse-security) -mn < /drive0/private/siemdbd/sql/functions.sql 2>&1: <jemalloc>: Number of CPUs detected is not deterministic. Per-CPU arena disabled.  [T18007:siemdb_main.c:582] Init fabric view failed.

Translate

NoneEngAuthor

Explorer II

Still not working... Idk if I should re-download the .vhd and start again, but I'm afrait it will break the trial by doing do...

Translate

Sign up

Login with SSO

Login to the community

Login with SSO