F-Secure Policy Manager Console cannot start: internal error.

Harrys16

during login, when it seems that already, log, error pops up

"F-Secure Policy Manager Console cannot start: internal error"

 

in log "Administrator.error.log" is:

 

com.fsecure.commons.java.spring.remoting.httpinvoker.ReplacedException: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [SELECT id, node_path, node_type, name, comment, host_identity, last_connection_time, policy_counter, oid_id, value, external_reference FROM domain_tree LEFT JOIN host_connection_info ON id = host_connection_info.domain_id LEFT JOIN (SELECT domain_id, status.oid_id, value FROM status INNER JOIN cached_oids ON cached_oids.oid_id = status.oid_id) status ON id = status.domain_id WHERE (parent_id IS NOT NULL OR node_type = 'DOM') ORDER BY node_path ASC]; SQL state [HY000]; error code [50000]; General error: "java.lang.ArrayIndexOutOfBoundsException"; SQL statement:
SELECT id, node_path, node_type, name, comment, host_identity, last_connection_time, policy_counter, oid_id, value, external_reference FROM domain_tree LEFT JOIN host_connection_info ON id = host_connection_info.domain_id LEFT JOIN (SELECT domain_id, status.oid_id, value FROM status INNER JOIN cached_oids ON cached_oids.oid_id = status.oid_id) status ON id = status.domain_id WHERE (parent_id IS NOT NULL OR node_type = 'DOM') ORDER BY node_path ASC [50000-164]; nested exception is org.h2.jdbc.JdbcSQLException: General error: "java.lang.ArrayIndexOutOfBoundsException"; SQL statement:
SELECT id, node_path, node_type, name, comment, host_identity, last_connection_time, policy_counter, oid_id, value, external_reference FROM domain_tree LEFT JOIN host_connection_info ON id = host_connection_info.domain_id LEFT JOIN (SELECT domain_id, status.oid_id, value FROM status INNER JOIN cached_oids ON cached_oids.oid_id = status.oid_id) status ON id = status.domain_id WHERE (parent_id IS NOT NULL OR node_type = 'DOM') ORDER BY node_path ASC [50000-164]

...

 

Caused by: com.fsecure.commons.java.spring.remoting.httpinvoker.ReplacedException: org.h2.jdbc.JdbcSQLException: General error: "java.lang.ArrayIndexOutOfBoundsException"; SQL statement:
SELECT id, node_path, node_type, name, comment, host_identity, last_connection_time, policy_counter, oid_id, value, external_reference FROM domain_tree LEFT JOIN host_connection_info ON id = host_connection_info.domain_id LEFT JOIN (SELECT domain_id, status.oid_id, value FROM status INNER JOIN cached_oids ON cached_oids.oid_id = status.oid_id) status ON id = status.domain_id WHERE (parent_id IS NOT NULL OR node_type = 'DOM') ORDER BY node_path ASC [50000-164]

 

If I can fix it myself? Do I have to send a notification to support?

 

add info:

status monitor OK, ports OK.

it looks like a problem with the database H2DB, or am I wrong?

Harrys16

support?

Harrys16

and so,
after a long verification logs, I noticed information:

"Caused by: org.h2.jdbc.JdbcSQLException: File corrupted while reading record: "page[865898] stream trunk key:536298 next:866406". Possible solution: use the recovery tool [90030-164]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)"

 

then I found it:

C$\Program Files (x86)\F-Secure\Management Server 5\bin\fspms-db-recover.bat

 

first stop the Server service

net stop "F-Secure Policy Manager Server"

I ran with the command in cmd (run as Administrator)

C:\Program Files (x86)\F-Secure\Management Server 5\bin>fspms-db-recover.bat h2d
b h2db-recovered

 

Next

after the completion of repair swapped base (folders h2db) names

 

start the Server service

net start "F-Secure Policy Manager Server"

 

and is OK!!!

 

PS. probably a cliché, but can someone come in handy