Skip to main content
NoneEng
Explorer II
September 19, 2024
Question

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

  • September 19, 2024
  • 5 replies
  • 3522 views

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

 

5 replies

smkml
Staff
Staff
September 20, 2024

Hello @NoneEng ,

 

Kindly share the debug output for below command:


diag debug enable
diag debug app siemdbd 7

NoneEng
NoneEngAuthor
Explorer II
September 20, 2024

@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
NoneEngAuthor
Explorer II
September 27, 2024

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

Thought Leadership. Security Summit. Thursday, November 12th, PGA National Resort, Palm Beach Gardens, FL.
Thought Leadership. Security Summit. Thursday, October 8th. Disney's Grand Californian Hotel & SPA, Anaheim, CA.