linux qube supervisor 6.3.1 - errors in /var/log/messages

[westernx]

I have a linux qube supervisor machine running 6.3.1.  So, far it is working well, and doing it's job,
but I am seeing repeated messages in /var/log/messages about a db table entry that doesn't exist ;

Code: [Select]

From: root@qbsupe02.keystone (Cron Daemon)
To: root@qbsupe02.keystone
Subject: Cron <root@qbsupe02> /usr/bin/mysql -u pfx_dw < /usr/local/pfx/qube/datawh/regular_globalResource.sql
Content-Type: text/plain; charset=UTF-8
Auto-Submitted: auto-generated
X-Cron-Env: <SHELL=/bin/sh>
X-Cron-Env: <HOME=/root>
X-Cron-Env: <PATH=/usr/bin:/bin>
X-Cron-Env: <LOGNAME=root>
X-Cron-Env: <USER=root>

ERROR 1146 (42S02) at line 20: Table 'pfx_dw.resource_dim' doesn't exist

I'm seeing this repeated over and over . . . . is it just as simple as manually created the mysql table pfx_dw.resource_dim?

thks,

ryjguy7

[jburk]

This is a known issue and was fixed in 6.3-2.

==== CL 9239 ====
@FIX: global resource tables were not getting created in new instances of the datawarehouse db, only on upgrades.

Upgrade your supervisor to 6.3-4 to resolve it, or run the following SQL when logged into your mysql server instance as root:

Code: [Select]

USE pfx_dw;

DROP TABLE IF EXISTS globalresource_fact;

CREATE TABLE globalresource_fact (
    time_sk INT NOT NULL
    , resource_sk MEDIUMINT UNSIGNED NOT NULL
    , total MEDIUMINT UNSIGNED NOT NULL
    , used MEDIUMINT UNSIGNED NOT NULL
)
ENGINE=MyISAM
;

DROP TABLE IF EXISTS resource_dim;

CREATE TABLE resource_dim (
    resource_sk INT NOT NULL AUTO_INCREMENT PRIMARY KEY
    , name VARCHAR(255) NOT NULL UNIQUE
)
ENGINE=MyISAM
;

INSERT INTO resource_dim
    (resource_sk, name)
    VALUES('1', 'qube')
;

[westernx]

thanks! . . . .