U00003528 UCUDB: Database is not in the internal status 'ready' but 'L' when loading into blank db

Products

• Automic Automation

Issue/Introduction

The Automation Engine Database Load utility (ucybdbld) terminates with error U00003528 UCUDB: Database is not in the internal status 'ready' but 'L' during the DATALOAD phase. This error occurs when the database schema has been migrated without the accompanying system and application data. 

Symptoms:

• DB Load log file message: U00003528 UCUDB: Database is not in the internal status 'ready' but 'L'
• Database Load utility (ucybdbld) terminates during DATALOAD phase.
• Database was populated using "metadata only" (e.g., Oracle Data Pump metadata export) from an existing schema.

Environment

Component: DB Load Utility (ucybdbld)
Version: 24.4, 26.0, all others

Cause

The ucybdbld utility requires a fully populated database (including system data and initialization records) to proceed. Migrating only the database structure (metadata) leaves the internal database status inconsistent, causing the utility to detect it as 'L' instead of 'ready'.

Resolution

To resolve this issue, use one of the following methods:

1. Perform a Full Data Migration: When refreshing a database for testing or upgrade purposes, ensure all system and application data is migrated, not just the database metadata. The migration must include the tables, indexes, constraints, sequences, and all AE system data.

2. Perform a Fresh Installation: If the goal is to test a new installation or version upgrade, create a fresh, blank database. Do not import existing metadata or structures into the target environment.