Hello
Our customer is not able to log into policy manager server.
We offered customer to use the maintenance tool in order to repair the database as it is writen in the admin guide. The problem is that customer does not have the tool in the folder so he is not able to use it. I know also that there is an option to restore backup but unfortunately customer has only backup from 2016.
Will it be possible to install policy manager server on my computer and than just send the exe file from my installation folder via email?
What do you suggest to solve this problem?
Last error from Administrator.error
Wed Jan 31 12:59:01 CET 2018
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]
... 157 more
Caused by: java.lang.ArrayIndexOutOfBoundsException
