Schema and Table Structure Check

1. Available Databases

Error getting database list: Datasource [gcdm] doesn't exist

2. Check if 'global' database exists

Error checking global database: Datasource [gcdm] doesn't exist

3. Check 'fed' table structure in global database

Error checking fed table structure: Datasource [gcdm] doesn't exist

This might mean the global database or fed table doesn't exist yet.

4. Compare with main GCDM fed table

Error checking main gcdm fed table: Datasource [gcdm] doesn't exist

5. Check all tables in global database

Error checking global database tables: Datasource [gcdm] doesn't exist

The global database likely doesn't exist or isn't accessible.

6. Test Insert into global.fed

Test insert failed: Datasource [gcdm] doesn't exist

SQL State:

Detail: available datasource names are [gccd_log,gccd_global,gccd_archive,globalD,gccd]

7. Database Setup Commands

If the global database doesn't exist, you need to run:

-- Create the global database
CREATE DATABASE IF NOT EXISTS `global` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;

-- Import the global schema
-- Run the global.sql file to create all tables

View global.sql file