Troubleshooting
Problem
Information Server installations that run on UNIX with WebSphere Liberty encounter a number of issues after it is upgraded to Information Server 11.7.1.3. They might not be able to log in to Information Server Administration console or WebSphere Liberty. Additionally, installations that use DB2 as the metadata repository might experience database failures in actions like metadata import, or discovery.
Symptom
Information Server operations (for example, metadata import) encounter database errors with a Db2 metadata repository due to missing configuration information.
Cause
Environment
1. Information Server is installed on Linux or AIX.
2. The installation uses WebSphere Liberty.
3. Information Server 11.7.1.0 was upgraded to Information Server 11.7.1.1 or Information Server 11.7.1.2
4. Next, the installation was upgraded to Information Server 11.7.1.3.
Diagnosing The Problem
For example, /opt/IBM/InformationServer
If any of the following are applicable, then the problem is present in your installation:
1. Check for the presence of a wlp.backup folder.
If it exists, check whether a wlp folder exists within this folder.
2. On the services tier, in ASBServer/conf/iis-client-truststore.p12 check whether any certificates are missing after the upgrade.
3. If Db2 is used as the metadata repository, in wlp/usr/servers/iis/dataSources.xml check whether strings useJDBC4DataType and useJDBC4ColumnNameAndLabelSemantics are not present.
Resolving The Problem
This approach is less risky and less likely to encounter regression issues.
Restore from backup the Information Server version that was installed before 11.7.1.3 was installed.
Follow the 11.7.1.3 installation instructions and ensure that section 3.3.8 is followed to clean up the WebSphere Liberty folders before the installation is started.
Option 2: Restore the WebSphere Liberty folders, and reapply the Fix pack
1. Stop WebSphere Liberty.
<INSTALL_LOCATION>/ASBServer/bin/MetadataServer.sh stop
2. Back up your wlp.backup and wlp folders.
mkdir /opt/backup
cp -r <INSTALL_LOCATION>/wlp.backup /opt/backup/wlp.backup
cp -r <INSTALL_LOCATION>/wlp /opt/backup/wlp
3. Remove <INSTALL_LOCATION>/wlp folder.
rm -rf <INSTALL_LOCATION>/wlp
4. Restore contents of wlp folder from the wlp.backup folder.
cp -r <INSTALL_LOCATION>/wlp.backup/wlp <INSTALL_LOCATION>/wlp
5. Remove wlp.backup folder.
rm -rf <INSTALL_LOCATION>/wlp.backup
6. If the wlp.new folder exists, remove it.
rm -rf <INSTALL_LOCATION>/wlp.new
7. Check that you have only one wlp folder.
ls -ldr <INSTALL_LOCATION>/wlp*
Now, the wlp folder is back into the state it was in before 11.7.1.3 was installed.
8. Reapply 11.7.1.3 with the -force option.
Option 3: Apply Information Server 11.7.1.3 Service Pack 4.
Document Location
Worldwide
Was this topic helpful?
Document Information
Modified date:
27 April 2022
UID
ibm16515220