Unable to logon to Web Viewer 14.0 after applying LU08416 SECURITY OR INTEGRITY PROBLEM and LU06974 maintenance
See below messages in started task log.
org.h2.jdbc.JdbcSQLNonTransientConnectionException: Unsupported database file version or invalid file header in file "/LPAR/cai/CADe
ploy/ContentViewer/CAWVHOME/database.mv.db"
ERROR <*INIT> <0> Pool-1 - Exception during pool initialization.
org.h2.jdbc.JdbcSQLNonTransientConnectionException: Unsupported database file version or invalid file header in file "/LPAR/cai/CADe
ploy/ContentViewer/CAWVHOME/database.mv.db"
Later see this message after login: CAHVS0300E Service module CAHVUSR INIT failed with J2ZException Missing or invalid applid
Release : 14.0
There was an incompatible H2 database from skipping a HOLDDATA migration step. The HOLDDATA for LU06974 states:
The updated CVDELOAD load library is not compatible with prior web-viewer.war/web-viewer.ear builds. Using the updated CVDELOAD load library with a prior build causes the following errrors when a user attempts to access a repository:
(screen) CAHVS0300E Service module MMMMMMMM XXXX failed with
J2ZException Missing or invalid applid
(log) WARN <UUUUUUUU> <NNN> J2Z_Invoke throwing exception:
Missing or invalid applid
ERROR <UUUUUUUU> <NNN> CAHVS0300E Service module MMMMMMMM
XXXX failed with J2ZException Missing or invalid
applid
The product was upgraded without restarting Tomcat, leading to the inability to call any J2Z service (interact with View data), see: java.lang.UnsatisfiedLinkError: J2ZJNIJ4 (Library is already loaded in another ClassLoader).
The PTF that upgraded the H2 database is LU08416. Double-check the HOLDDATA, and complete the required database migration. Also, the migration requires PTFs LU08230 and LU08231 to be applied as prerequisites.
Incident 1:
Maintenance was applied which included LU08416 (the new H2 jar version) and LU06974 (configurable applid support). Both of these include changes which are incompatible with earlier versions.
The .jar file was backleveled to h2.jar to 1.4.199 so they were able to login but not access reports. Getting CAHVS0300E Service module MMMMMMMM XXXX failed with J2ZException Missing or invalid applid which is described in the HOLDDATA for LU06974.
There were two war files in tomcat/webapps one named MTC-ContentViewer.war and one named web-viewer.war. According to the file size MTC-ContentViewer.war is at build 14.0.43 and web-viewer.war is at 14.0.30. They use MTC-ContentViewer as part of the url and the about box showed 14.0.43, however neither level is compatible with the load library updates from LU06974.
The install directory had a number of war file versions (with various MTC-ContentViewer and web-viewer names), but there was a war file for build 14.0.60 here (from LU08231).
There was a backup of the old tomcat/webapps/MTC-ContentViewer.war file (to something that does not end in WAR so it will not get deployed).
Stopped the MTCCV started task. Cleaned up the old 14.0.30 war file and the old extracted directories. Deployed the 14.0.60 war file as tomcat/webapps/MTC-ContentViewer.war and restarted MTCCV. Log shows build 14.0.60 and using h2 1.4.199. Users confirmed they can login and view reports now.
Are still running a back-leveled version of H2 and should following the H2 migration process described in the Web Viewer documentation as time permits.
Incident 2:
"About - Web Viewer" version/build showed 14.0.2/14.0.22 which confirms the older war file is being used by Tomcat which is causing the problem i.e. incompatible with the CVDELOAD load library from PTF LU06974.
Using CCS Tomcat with "MTC-ContentViewer" as the application name in the URL, so it is the file MTC-ContentViewer.war in the tomcat/webapps/ directory that needs to be replaced. That is because to achieve that, the deployment step is to rename the default file named web-viewer.war to MTC-ContentViewer.war for copying to the tomcat/webapps/ directory from the Web Viewer installation directory i.e. per Install Deploy Configure the Product to a CCS Apache Tomcat Server.
Steps taken:
a. Stop the CCS Tomcat STC
b. Backup/move both the file tomcat/webapps/MTC-ContentViewer.war and the directory tomcat/webapps/MTC-ContentViewer. Please move them to a safe directory but completely outside of the tomcat/webapps directory as any .war file left there will be deployed by tomcat. After Tomcat deploys the new MTC-ContentViewer.war a new directory named MTC-ContentViewer should be created.
c. Copy the file web-viewer.war from the Web Viewer install directory to the tomcat/webapps directory and rename it to MTC-ContentViewer.war
d. Start the CCS Tomcat STC and check a new tomcat/webapps/MTC-ContentViewer directory has been created.
After login to Web Viewer the original error was resolved and "About - Web Viewer" version/build then showed 14.0.3/14.0.70