Upgrade from 3.6.1 to 3.6.2 - A number of errors (and I can't get it to work)

Well.... Where do I start?

Probably with listing the errors I see in the logs.

I have no idea where to start correcting all this.

If anyone have any ideas, please let me know.

catalina.[date].log

[INFO] 2022-11-06 10:16:12.662 [com.netiq.iac.persistence.dbcheck.DatabaseSchemaCheck] [IG-DTP] Connecting to PostgreSQL version 11.11
[SEVERE] 2022-11-06 10:16:18.430 [com.netiq.iac.persistence.dbcheck.DatabaseSchemaCheck] [IG-DTP]
=================== FATAL ERROR ===========================
Unapplied database change sets have been detected
===========================================================
[SEVERE] 2022-11-06 10:16:18.431 [org.apache.catalina.core.StandardContext] One or more listeners failed to start. Full details will be found in the appropriate container log file
[SEVERE] 2022-11-06 10:16:18.431 [org.apache.catalina.core.StandardContext] Context [/dtp] startup failed due to previous errors
[SEVERE] 2022-11-06 10:16:18.435 [com.netiq.iac.server.dtp.j2ee.ArcInitListener] [IG-DTP] Invalid component key: [dtp_server]
[INFO] 2022-11-06 10:16:18.449 [com.netiq.iac.server.dtp.j2ee.ArcInitListener] [IG-DTP] Service Stopped: dtp_server
[WARNING] 2022-11-06 10:16:18.456 [org.apache.catalina.loader.WebappClassLoaderBase] The web application [dtp] registered the JDBC driver [com.vertica.jdbc.Driver] but failed to unregister it when the web appli
cation was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
[WARNING] 2022-11-06 10:16:18.457 [org.apache.catalina.loader.WebappClassLoaderBase] The web application [dtp] appears to have started a thread named [pool-4-thread-1] but has failed to stop it. This is very li
kely to create a memory leak. Stack trace of thread:
 sun.misc.Unsafe.park(Native Method)
 java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:215)
 java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:2083)
 java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:1093)
 java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:809)
 java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)
 java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134)
 java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
 java.lang.Thread.run(Thread.java:748)


catalina.out
INFO 11/6/22 10:16 AM: liquibase: Reading from public.databasechangelog
Default Locale: en
Logging configuration file name: idmrptclient_logging.xml
org.codehaus.jettison.json.JSONException: Missing value. at character 1 of {\\"auth-sources\\":[{\\"auth-source-id\\":\\"bisadus\\",\\"combine-generators\\":false,\\"role-generators\\":[{\\"type\\":\\"accessreview\\",\\"role-map-casesensitive\\":true,\\"role-map\\":[{\\"mapped-role\\":\\"ADM\\",\\"rpt-role\\":\\"reportadmin\\"},{\\"mapped-role\\":\\"RPTA\\",\\"rpt-role\\":\\"reportadmin\\"}]}]}]}
        at org.codehaus.jettison.json.JSONTokener.syntaxError(JSONTokener.java:463)
        at org.codehaus.jettison.json.JSONTokener.nextValue(JSONTokener.java:356)
        at org.codehaus.jettison.json.JSONObject.<init>(JSONObject.java:215)
        at org.codehaus.jettison.json.JSONObject.<init>(JSONObject.java:311)
...


localhost.[date].log

[SEVERE] 2022-11-06 10:15:56.146 [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/api]] Exception sending context initialized event to listener instance of class [com.netiq.iac.server.j2ee.ArcServerInitListener]
com.netiq.common.i18n.LocalizedRuntimeException: Schema is invalid. One or more required tables are missing. Check log for messages indicating tables that were not found
        at com.netiq.iac.persistence.dbcheck.DatabaseSchemaCheck.validateDatabaseSchema(DatabaseSchemaCheck.java:111)
        at com.netiq.iac.server.j2ee.ArcServerInitListener.contextInitialized(ArcServerInitListener.java:159)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4690)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5151)
....


and

[SEVERE] 2022-11-06 10:16:18.431 [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/dtp]] Exception sending context initialized event to listener instance of class [com.netiq.iac.server.dtp.j2ee.ArcInitListener]
com.netiq.common.i18n.LocalizedRuntimeException: Schema is invalid. One or more required tables are missing. Check log for messages indicating tables that were not found
        at com.netiq.iac.persistence.dbcheck.DatabaseSchemaCheck.validateDatabaseSchema(DatabaseSchemaCheck.java:111)
        at com.netiq.iac.server.dtp.j2ee.ArcInitListener.contextInitialized(ArcInitListener.java:88)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4690)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5151)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:717)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:690)
....

Tags:

  • Hello,

    For this error
    "org.codehaus.jettison.json.JSONException: Missing value. at character 1 of"

    This is happening because an issue occurred during the upgrade when looking at your ism-configuration.properties file for the property "com.netiq.rpt.role.config"
    As a result you have too many backslashes \ there should only be one (1) to escape each double quote and in your case you have at least two (2). You will need to manually fix the file. This issue has been resolved in upcoming 3.7.3 installer


    For the rest of the issues you have outlined, please open a Service Request so we can look at your environment and address it "issue"


    Sincerely,
    Steven Williams
    Principal Enterprise Architect
    Micro Focus

  • Thanks. You are right, there was a lot of backslashes.

    I'll open a service request.