search cancel

website not connecting to server after maintenance backed out - 14.0 Web Viewer

book

Article ID: 237933

calendar_today

Updated On:

Products

Output Management Web Viewer

Issue/Introduction

We applied few fixes (SECURITY OR INTEGRITY PROBLEM FIX #LU04933 | for z/OS) as part of the log4j issue. After rolling out the maintenance users reported they were unable to access their reports from Web Viewer, so we backed out the changes. After backing out we are not able to connect to the server at all. Getting messages like, Communication error with server, and Failed to read J2Z service data (log) CAHVS0500E Unable to read J2Z service data: DRIB. How to recover?

Cause

When maintenance was applied, DB tables were added. When the maintenance was backed out, the now incompatible DB tables remained.

Environment

Release : 14.0

Component : Output Management Web Viewer

Resolution

The resolution was to delete the newly added DB tables.

Additional Information

Here are the detailed DB recovery steps:

1) Stop the STCs CAHVTOMX & CAHVHS2 
2) Take a backup copy of the databse file DATABAS14db.mv.db & DATABAS14db.trace.db in the directory /isv/cai/CADeploy/WebviewR14/database/ to /isv/cai/CADeploy/WebviewR14/DBBACKUP1/


Note: Mounted the maint applied ZFS file HFS.GHP1.CAI.WEBVIEW.BK.ZFS to the path /isv/cai/CADeploy/webvH2new/ in order to use new h2.jar file to work on the database


In OMVS do the below steps to delete the tables CV_MASTER.FEATURES_LOG & CV_MASTER.FEATURES from the Database


3) export CLASSPATH=/isv/cai/CADeploy/webvH2new/h2.jar
4) export URL=jdbc:h2:/isv/cai/CADeploy/WebviewR14/database/DATABAS14db
5) $JAVA_HOME/bin/java org.h2.tools.Shell -url $URL -user ContentViewer -password CVPassword


6) Once the DB SQL prompt appear issue the below SQL commands to check the table count for the tables CV_MASTER.FEATURES_LOG & CV_MASTER.FEATURES
SELECT COUNT(*) FROM CV_MASTER.FEATURES_LOG;
SELECT COUNT(*) FROM CV_MASTER.FEATURES;


7) Also verify the table count for CV_MASTER.ALL_REPOSITORIES (We should have count 6)
SELECT COUNT(*) FROM CV_MASTER.ALL_REPOSITORIES;


8) We can list available repositories of the table with the below command CV_MASTER.ALL_REPOSITORIES
SELECT * FROM CV_MASTER.ALL_REPOSITORIES;


9) Drop the tables (remove) CV_MASTER.FEATURES_LOG & CV_MASTER.FEATURES from the database using the below commands
DROP TABLE CV_MASTER.FEATURES_LOG;
DROP TABLE CV_MASTER.FEATURES;


10) Quit the SQL command panel & omvs.
11) Start the stc CAHVHS2. Once the stc CAHVHS2 started then start the stc CAHVTOMX 


If still have connectivity issue with the DB after the above steps, we have to setup a new database using the below steps


1) Stop the STCs CAHVTOMX & CAHVHS2 
2) take a backup of the current config file /isv/cai/WebviewR14/CAWVHOME/config/ConfigFile.cfg as /isv/cai/WebviewR14/CAWVHOME/config/ConfigFileBKP.cfg


3) Do the following changes to the file /isv/cai/WebviewR14/CAWVHOME/config/ConfigFile.cfg
DBLOCATION = "/isv/cai/CADeploy/WebviewR14/database/DATABAS14V2db";


4) Start the stc CAHVHS2. Once the stc CAHVHS2 started then start the stc CAHVTOMX 


==> Once the tasks are started it will build the new database
The Administrator has to login & go to option manage repositories & add the repositories. The list is below. Add them in the same order listed below


ID | NAME  | DESCRIPTION               | SYSTEM | SYSTEM2 | PATH        | PRODUCT | CHARSET | CREATEDBY | CREATEDDATETIME         | MODIFIEDBY | MODIFIEDDATETIME        | REPORT_ACCESS_POLICY                                                 
1  | SARV1 | XXXX Content Viewer | SYSTEM | SYSTEM2 | SAR.SYSTEM1 | VIEW11  | IBM037  | BELLRM1   | 2019-06-29 14:13:00.06  | nimsax1    | 2020-07-19 09:24:06.61  | EXTERNAL_RECALL                                                      
2  | SARV2 | KPWA MTC14 Content Viewer | SYSTEM | SYSTEM2 | SAR.SYSTEM2 | VIEW11  | IBM037  | SAMPLE1   | 2019-06-29 14:13:00.064 | samplex1    | 2021-11-11 17:23:14.8   | EXTERNAL_RECALL                                                      
3  | SARV3 | XXXX MTC14 Content Viewer | SYSTEM | SYSTEM2 | SAR.SYSTEM3 | VIEW11  | IBM037  | SAMPLE1   | 2019-06-29 14:13:00.065 | sample1    | 2019-07-10 21:35:32.394 | EXTERNAL_RECALL                                                      
4  | SARV4 | XXXX MTC14 Content Viewer | SYSTEM | SYSTEM2 | SAR.SYSTEM4 | VIEW11  | IBM037  | SAMPLE1   | 2019-06-29 14:13:00.066 | sample1    | 2019-07-10 21:35:57.829 | EXTERNAL_RECALL                                                      
5  | SARV5 | XXXX MTC14 Content Viewer | SYSTEM | SYSTEM2 | SAR.SYSTEM5 | VIEW11  | IBM037  | SAMPLE1   | 2019-06-29 14:13:00.067 | sample1    | 2019-07-10 21:36:15.602 | EXTERNAL_RECALL                                                      
6  | SARV6 | XXXX MTC14 Content Viewer | SYSTEM | SYSTEM2 | SAR.SYSTEM6 | VIEW11  | IBM037  | SAMPLE1   | 2019-06-29 14:13:00.067 | sample1    | 2019-07-10 21:36:29.889 | EXTERNAL_RECALL 


==> Out of the above inform the add the repositories panel we need below information
NAME, DESCRIPTION, PATH, PRODUCT, CHARSET & REPORT_ACCESS_POLICY