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

[NoneEng]

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

[smkml]

Hello @NoneEng ,

Kindly share the debug output for below command:

diag debug enable
diag debug app siemdbd 7

[NoneEng]

@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.

[NoneEng]

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...

[Gert-Jan]

Did you managed to fix it? I have an FAZ with the same error.

[NoneEng]

Hey man, sorry for the huge delay.

I had to download the v7.2.X version. I had no issues with this one!