Troubleshooting
Problem
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
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.
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
create_ug_schemas.bat HostServerName DatabaseName UserName Password SchemaName
For example :
create_ug_schemas.bat hostname xmeta xmeta_user secret_password ASSET_RELATION
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.
Name of the schema to create.
Document Location
Worldwide
Was this topic helpful?
Document Information
Modified date:
07 November 2019
UID
ibm10887665