PipelineFX Forum
Qube! => Installation and Configuration => Topic started by: westernx on April 26, 2012, 05:01:23 PM
-
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 ;
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
-
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:
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')
;
-
thanks! . . . .