ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

wcc_config to change database results in E190977 - The WCC tables are not present in the database

book

Article ID: 228214

calendar_today

Updated On:

Products

CA Workload Automation AE

Issue/Introduction

Customer tries to switch WCC to another oracle database and gets error


E190977 - The WCC tables are not present in the database. Please check if the operational user has SELECT, INSERT, UPDATE, DELETE permissions on the tables of schema user.
 Also check if --dbschemauser is properly specified and has WCC tables.

 

The user seems to have appropriate in the database and this used to work in WCC 11.4.x release, where the database objects have been created on first connection.

 

The version of WCC being used here is 12.0.1.

Cause

WCC 11.4.x used to create the needed schema tables/data in the database, during the startup/connection stages. 

 

However, for WCC 12.x to function, it requires all the needed WCC schema/skeleton data to exist, prior to connecting to that database.   

Environment

Release : 12

Component :

Resolution

Run the 12.0.x installer and select the option to create WebUI database.  Once this is created, wcc_config can be run to change current database to this newly created database.