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

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?
Comments
-
support?
0 -
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-recoveredNext
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
6
Categories
- All Categories
- 4.8K WithSecure Community
- 3.6K Products
- 3 Get Support