IBM Support

ia-services and ia-analysis pods go into CrashLoopBackOff after upgrading from 1171 to later 11.7.1 Service Packs in Information Server UG install

Troubleshooting


Problem

After upgrading from 11.7.1 to later 11.7.1 Service Packs (e.g. SP1, SP2) in a UG environment, the ia-services and ia-analysis pods go into CrashLoopBackOff Status.

Symptom

Run the following command from the UG node:

kubectl get pods | grep ia-services

The output should be something similar to the following example:

ia-services-2622810079-bp266          1/1       CrashLoopBackOff                                                          0          6h

Cause

The ASSET_RELATION schema is not present in the xmeta database.

Diagnosing The Problem

Run the following command to get the exact name of the ia-services pod:

kubectl get pods | grep ia-services

The output should contain a line like the following example:

ia-services-2622810079-bp266          1/1       CrashLoopBackOff                                                          0          6h

The name of the pod is ia-services-2622810079-bp266.
Get the logs of pod by running the following command:

kubectl logs ia-services-2622810079-bp266

The output will contain lines like the following example:

Creating schema "ASSET_RELATION" ...
ERROR:
Unable to create schema "ASSET_RELATION"

Resolving The Problem

For a Db2 database

Run the following command as a Db2 admin user to create the schema:

db2 connect to <xmeta db name>
db2 create schema ASSET_RELATION
db2 grant CREATEIN, ALTERIN, DROPIN ON SCHEMA ASSET_RELATION TO USER <xmeta db user>

For example:

db2 connect to xmeta
db2 create schema ASSET_RELATION
db2 grant CREATEIN, ALTERIN, DROPIN ON SCHEMA ASSET_RELATION TO USER XMETA

For an Oracle database

Download the attached zip archive and extract the contents of it.

Oracle_1.zip

Navigate to the directory Oracle in the extracted archive.
Run the following command to create the required schema. All arguments are required and must be specified in the order that is shown in the following example:

./create_ug_schemas.sh OracleSystemUser OracleSystemPassword ServiceName TableSpaceName SchemaName

For example :

./create_ug_schemas.sh SYS MANAGER DBNAME xmetaspace asset_relation

OracleSystemUser
The Oracle system user used to log in to the sqlplus utility to create the schema. This user must be assigned the database administrator role.

OracleSystemPassword
The password for the Oracle system user.

ServiceName
The Oracle TNS service name. The name is the same as the TNS service name that is provided as the NetServiceName argument to the create_xmeta_db.sh script in step 2 during Pre-installing the metadata repository database.

TableSpaceName
Name of the tablespace to use for the new schema. The name is the same as the metadata tablespace that is provided as the XmetaTableSpaceName argument to the create_xmeta_db.sh script in step 2 during Pre-installing the metadata repository database.

SchemaName
Name of the schema to create.

For a Micsrosoft SQL Server database

Download the attached zip archive and extract the contents of it.
Open a command prompt and change to the SQLServer directory in the extracted archive.
Run the following command to create the required schema. All arguments are required and must be specified in the order that is shown in the following example.
create_ug_schemas.bat HostServerName DatabaseName UserName Password SchemaName

For example :
create_ug_schemas.bat hostname xmeta xmeta_user secret_password ASSET_RELATION
HostServerName
Name of the server.

DatabaseName
Name of the database to use for the new schemas.

UserName
Database user used to log in to the sqlcmd utility to create the schema.

Password
Password for the database user.
SchemaName
Name of the schema to create.

Document Location

Worldwide

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"Component":"Information Analyzer","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"11.7.1.SP1 11.7.1.SP2","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
07 November 2019

UID

ibm10887665

Page Feedback