Dear Anygate,
I am sorry, but I am still getting errors using version 2.0.5.4 for py3.
2024-03-21 12:31:23 : Processing table : core_dc_daily_statistics (106/168)
2024-03-21 12:31:23 : Reading table data count...
2024-03-21 12:31:23 : Copying table data...
2024-03-21 12:31:23 : Data too long for column 'REG_DATE' at row 1
024-03-21 12:31:23 : Processing table : core_dc_month_statistics (107/168)
2024-03-21 12:31:23 : Reading table data count...
2024-03-21 12:31:23 : Copying table data...
2024-03-21 12:31:23 : Data too long for column 'REG_DATE' at row 1
2024-03-21 12:31:25 : Processing table : scada_alarm (116/168)
2024-03-21 12:31:25 : Reading table data count...
2024-03-21 12:31:25 : Copying table data...
2024-03-21 12:31:25 : Data too long for column 'description' at row 1
2024-03-21 12:31:25 : Processing table : scada_analog (118/168)
2024-03-21 12:31:25 : Reading table data count...
2024-03-21 12:31:25 : Copying table data...
2024-03-21 12:31:25 : Data too long for column 'description' at row 1
2024-03-21 12:31:26 : Processing table : scada_calculation (120/168)
2024-03-21 12:31:26 : Reading table data count...
2024-03-21 12:31:26 : Copying table data...
2024-03-21 12:31:26 : Data too long for column 'description' at row 1
2024-03-21 12:31:26 : Processing table : scada_status (121/168)
2024-03-21 12:31:26 : Reading table data count...
2024-03-21 12:31:26 : Copying table data...
2024-03-21 12:31:26 : Data too long for column 'description' at row 1
2024-03-21 12:31:27 : Processing table : scada_alarm (125/168)
2024-03-21 12:31:27 : Reading table data count...
2024-03-21 12:31:27 : Copying table data...
2024-03-21 12:31:27 : No data supplied for parameters in prepared statement
2024-03-21 12:32:05 : Processing table : scada_control_log (139/168)
2024-03-21 12:32:05 : Reading table data count...
2024-03-21 12:32:05 : Copying table data...
2024-03-21 12:32:06 : Data too long for column 'pointname' at row 1
I have attached the schemas at the end of the comment.
Also, it seems that powerScene HMI is not opening the same project that is opened in Power Scene Studio. When I use the scada-monitor to start the server, the HMI says "cannot open this project because another project is running." I also tried on another PC, in this case, it simply crashes without providing an error message.
Thank you,
RPE
CREATE TABLE core_dc_daily_statistics ( `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `TARGET_ID` integer DEFAULT 0, `REG_DATE` nvarchar(7) DEFAULT NULL, `DAY_SEQ` integer DEFAULT NULL, `DEMAND_POWER` float DEFAULT NULL, `FEE` float DEFAULT NULL, `MAX_DEMAND_POWER` float DEFAULT NULL, `DEMAND_ENERGY` float DEFAULT NULL, `MAX_DEMAND_TIME` integer DEFAULT NULL, `MAX_PREDICT_POWER` float DEFAULT NULL, `METER_POWER` float DEFAULT NULL, `METER_ENERGY` float DEFAULT NULL, `MAX_METER_POWER` float DEFAULT NULL, `INSERT_DT` nvarchar(20) DEFAULT NULL, `UPDATE_DT` nvarchar(20) DEFAULT NULL)
CREATE TABLE core_dc_month_statistics ( `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `TARGET_ID` integer DEFAULT 0, `REG_DATE` nvarchar(4) DEFAULT NULL, `MONTH_SEQ` integer DEFAULT NULL, `DEMAND_POWER` float DEFAULT NULL, `FEE` float DEFAULT NULL, `MAX_DEMAND_POWER` float DEFAULT NULL, `DEMAND_ENERGY` float DEFAULT NULL, `MAX_DEMAND_TIME` integer DEFAULT NULL, `MAX_PREDICT_POWER` float DEFAULT NULL, `METER_POWER` float DEFAULT NULL, `METER_ENERGY` float DEFAULT NULL, `MAX_METER_POWER` float DEFAULT NULL, `INSERT_DT` nvarchar(20) DEFAULT NULL, `UPDATE_DT` nvarchar(20) DEFAULT NULL)
CREATE TABLE SCADA_ALARM ( id integer NOT NULL PRIMARY KEY AUTOINCREMENT, type INT DEFAULT NULL, origin NVARCHAR(51) DEFAULT NULL, description NVARCHAR(51) DEFAULT NULL, event NVARCHAR(51) DEFAULT NULL, processtime TIMESTAMP, priority SMALLINT DEFAULT NULL, aor NVARCHAR(51) DEFAULT NULL, acked TINYINT DEFAULT NULL, ackedwho NVARCHAR(51) DEFAULT NULL, present TINYINT DEFAULT 0, code INT DEFAULT 0, lastdetected TIMESTAMP , ackedwhen TIMESTAMP)
CREATE TABLE [SCADA_ANALOG] (
[id] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
[pointName] NVARCHAR(129) NOT NULL DEFAULT (NULL),
[displayName] NVARCHAR(129) DEFAULT (NULL),
[rtuId] SMALLINT DEFAULT (NULL),
[stationId] SMALLINT NOT NULL DEFAULT (NULL),
[area] SMALLINT NOT NULL,
[use_low_limit] TINYINT DEFAULT (NULL),
[use_hi_limit] TINYINT DEFAULT (NULL),
[use_hihi_limit] TINYINT DEFAULT (NULL),
[use_lowlow_limit] TINYINT DEFAULT (NULL),
[use_hi_range] TINYINT DEFAULT (NULL),
[use_low_range] TINYINT DEFAULT (NULL),
[low_limit] FLOAT(53,0) DEFAULT (NULL),
[hi_limit] FLOAT(53,0) DEFAULT (NULL),
[hihi_limit] FLOAT(53,0) DEFAULT (NULL),
[lowlow_limit] FLOAT(53,0) DEFAULT (NULL),
[hi_range] FLOAT(53,0) DEFAULT (NULL),
[low_range] FLOAT(53,0) DEFAULT (NULL),
[deadband] FLOAT(53,0) DEFAULT (NULL),
[roc] FLOAT(53,0) DEFAULT (NULL),
[unit] INT DEFAULT (NULL),
[scaleFactor] FLOAT(53,0) DEFAULT (1),
[offset] FLOAT(53,0) DEFAULT (NULL),
[decimal] INT DEFAULT (NULL),
[SOEUse] TINYINT DEFAULT (NULL),
[dataRecord] TINYINT DEFAULT (NULL),
[itemType] SMALLINT DEFAULT (NULL),
[dataType] SMALLINT DEFAULT (NULL),
[telemeted] TINYINT DEFAULT (NULL),
[addressA] NVARCHAR(129) DEFAULT (NULL),
[addressB] NVARCHAR(129) DEFAULT (NULL),
[addressC] NVARCHAR(129) DEFAULT (NULL),
[addressD] NVARCHAR(129) DEFAULT (NULL),
[extName] NVARCHAR(50) DEFAULT (NULL),
[valueType] NVARCHAR(50) DEFAULT (NULL),
[hi_set_priority] SMALLINT DEFAULT (NULL),
[low_set_priority] SMALLINT DEFAULT (NULL),
[hihi_set_priority] SMALLINT DEFAULT (NULL),
[lowlow_set_priority] SMALLINT DEFAULT (NULL),
[hi_reset_priority] SMALLINT DEFAULT (NULL),
[low_reset_priority] SMALLINT DEFAULT (NULL),
[hihi_reset_priority] SMALLINT DEFAULT (NULL),
[lowlow_reset_priority] SMALLINT DEFAULT (NULL),
[roc_priority] SMALLINT DEFAULT (NULL),
[value] FLOAT(53,0) DEFAULT (NULL),
[updateTime] DATETIME DEFAULT (NULL),
[tag] INT DEFAULT (NULL),
[quality] INT DEFAULT (NULL),
[valueLimit] INT DEFAULT (NULL),
[savingTime] DATETIME DEFAULT (NULL),
[description] NVARCHAR(50) DEFAULT (NULL),
[timeNow] FLOAT(53,0) DEFAULT (NULL),
[timeMax] FLOAT(53,0) DEFAULT (NULL),
[timeMaxTime] DATETIME DEFAULT (NULL),
[timeMin] FLOAT(53,0) DEFAULT (NULL),
[timeMinTime] DATETIME DEFAULT (NULL),
[timeAvg] FLOAT(53,0) DEFAULT (NULL),
[timeDelta] FLOAT(53,0) DEFAULT (NULL),
[timeAcc] INT DEFAULT (NULL),
[dayNow] FLOAT(53,0) DEFAULT (NULL),
[dayMax] FLOAT(53,0) DEFAULT (NULL),
[dayMaxTime] DATETIME DEFAULT (NULL),
[dayMin] FLOAT(53,0) DEFAULT (NULL),
[dayMinTime] DATETIME DEFAULT (NULL),
[dayAvg] FLOAT(53,0) DEFAULT (NULL),
[dayDelta] FLOAT(53,0) DEFAULT (NULL),
[dayAcc] INT DEFAULT (NULL),
[monthNow] FLOAT(53,0) DEFAULT (NULL),
[monthMax] FLOAT(53,0) DEFAULT (NULL),
[monthMaxTime] DATETIME DEFAULT (NULL),
[monthMin] FLOAT(53,0) DEFAULT (NULL),
[monthMinTime] DATETIME DEFAULT (NULL),
[monthAvg] FLOAT(53,0) DEFAULT (NULL),
[monthDelta] FLOAT(53,0) DEFAULT (NULL),
[monthAcc] INT DEFAULT (NULL),
[totalNow] FLOAT(53,0) DEFAULT (NULL),
[totalMax] FLOAT(53,0) DEFAULT (NULL),
[totalMaxTime] DATETIME DEFAULT (NULL),
[totalMin] FLOAT(53,0) DEFAULT (NULL),
[totalMinTime] DATETIME DEFAULT (NULL),
[totalAvg] FLOAT(53,0) DEFAULT (NULL),
[totalDelta] FLOAT(53,0) DEFAULT (NULL),
[totalAcc] INT DEFAULT (NULL),
[outputScaleFactor] FLOAT(53,0) DEFAULT (1),
[outputOffset] FLOAT(53,0) DEFAULT (NULL) ,
[basetime] TINYINT DEFAULT (0),
[weekNow] FLOAT(53,0) DEFAULT (NULL),
[weekMax] FLOAT(53,0) DEFAULT (NULL),
[weekMaxTime] DATETIME DEFAULT (NULL),
[weekMin] FLOAT(53,0) DEFAULT (NULL),
[weekMinTime] DATETIME DEFAULT (NULL),
[weekAvg] FLOAT(53,0) DEFAULT (NULL),
[weekDelta] FLOAT(53,0) DEFAULT (NULL),
[weekAcc] INT DEFAULT (NULL),
[transformation_type] TINYINT DEFAULT (NULL),
[measure_min] INT DEFAULT (NULL),
[measure_max] INT DEFAULT (NULL),
[system_min] INT DEFAULT (NULL),
[system_max] INT DEFAULT (NULL),
[yearNow] FLOAT(53,0) DEFAULT (NULL),
[yearMax] FLOAT(53,0) DEFAULT (NULL),
[yearMaxTime] DATETIME DEFAULT (NULL),
[yearMin] FLOAT(53,0) DEFAULT (NULL),
[yearMinTime] DATETIME DEFAULT (NULL),
[yearAvg] FLOAT(53,0) DEFAULT (NULL),
[yearDelta] FLOAT(53,0) DEFAULT (NULL),
[yearAcc] INT DEFAULT (NULL),
[item_order] INTEGER DEFAULT (NULL),
[low_set_message] NVARCHAR(50) DEFAULT (NULL),
[low_reset_message] NVARCHAR(50) DEFAULT (NULL),
[lowlow_set_message] NVARCHAR(50) DEFAULT (NULL),
[lowlow_reset_message] NVARCHAR(50) DEFAULT (NULL),
[hi_set_message] NVARCHAR(50) DEFAULT (NULL),
[hi_reset_message] NVARCHAR(50) DEFAULT (NULL),
[hihi_set_message] NVARCHAR(50) DEFAULT (NULL),
[hihi_reset_message] NVARCHAR(50) DEFAULT (NULL),
[roc_reset_priority] SMALLINT DEFAULT (0),
[roc_set_message] NVARCHAR(50) DEFAULT (NULL),
[roc_reset_message] NVARCHAR(50) DEFAULT (NULL),
[delay_time] INT DEFAULT(NULL),
[use_realarm] TINYINT DEFAULT(0),
[realarm_time] INT DEFAULT(NULL)
, [use_alarmpage] TINYINT DEFAULT(0), [alarmpage_filename] NVARCHAR(129) DEFAULT (NULL))
CREATE TABLE [SCADA_CALCULATION] (
[id] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
[name] NVARCHAR(50) NOT NULL DEFAULT (NULL),
[period] INT DEFAULT (NULL),
[fomular] NVARCHAR(8000) DEFAULT (NULL),
[Description] NVARCHAR(50) DEFAULT (NULL),
[isrun] BOOL DEFAULT (NULL),
[periodtype] TINYINT DEFAULT (NULL),
[alignment] DATETIME DEFAULT ('00:00:00'),
[scheduledday] TINYINT DEFAULT (-1),
[scheduledhour] TINYINT DEFAULT (-1),
[scheduledmin] TINYINT DEFAULT (-1),
[ishighpriority] BOOL DEFAULT (NULL),
[item_order] INTEGER DEFAULT (NULL))
CREATE TABLE [SCADA_STATUS] (
[id] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
[pointName] NVARCHAR(129) NOT NULL DEFAULT (NULL),
[displayName] NVARCHAR(129) DEFAULT (NULL),
[rtuId] SMALLINT DEFAULT (NULL),
[stationId] SMALLINT NOT NULL DEFAULT (NULL),
[area] SMALLINT NOT NULL,
[telemeted] TINYINT DEFAULT (NULL),
[address1A] NVARCHAR(129) DEFAULT (NULL),
[address1B] NVARCHAR(129) DEFAULT (NULL),
[address1C] NVARCHAR(129) DEFAULT (NULL),
[address1D] NVARCHAR(129) DEFAULT (NULL),
[address2A] NVARCHAR(129) DEFAULT (NULL),
[address2B] NVARCHAR(129) DEFAULT (NULL),
[address2C] NVARCHAR(129) DEFAULT (NULL),
[address2D] NVARCHAR(129) DEFAULT (NULL),
[caddress1A] NVARCHAR(129) DEFAULT (NULL),
[caddress1B] NVARCHAR(129) DEFAULT (NULL),
[caddress1C] NVARCHAR(129) DEFAULT (NULL),
[caddress1D] NVARCHAR(129) DEFAULT (NULL),
[caddress2A] NVARCHAR(129) DEFAULT (NULL),
[caddress2B] NVARCHAR(129) DEFAULT (NULL),
[caddress2C] NVARCHAR(129) DEFAULT (NULL),
[caddress2D] NVARCHAR(129) DEFAULT (NULL),
[externalName1] NVARCHAR(50) DEFAULT (NULL),
[externalName2] NVARCHAR(50) DEFAULT (NULL),
[SOEUse] TINYINT DEFAULT (NULL),
[dataType] SMALLINT DEFAULT (NULL),
[convertType] SMALLINT DEFAULT (NULL),
[userConvertTypeId] INT DEFAULT (NULL),
[statusNameGroup] INT DEFAULT (NULL),
[value0Priority] SMALLINT DEFAULT (NULL),
[value1Priority] SMALLINT DEFAULT (NULL),
[value2Priority] SMALLINT DEFAULT (NULL),
[value3Priority] SMALLINT DEFAULT (NULL),
[value0Message] NVARCHAR(50) DEFAULT (NULL),
[value1Message] NVARCHAR(50) DEFAULT (NULL),
[value2Message] NVARCHAR(50) DEFAULT (NULL),
[value3Message] NVARCHAR(50) DEFAULT (NULL),
[abnormalflag] CHAR(4) DEFAULT (NULL),
[eventRecording] TINYINT DEFAULT (NULL),
[Description] NVARCHAR(50) DEFAULT (NULL),
[value] SMALLINT DEFAULT (NULL),
[updateTime] DATETIME DEFAULT (NULL),
[tag] INT DEFAULT (NULL),
[quality] INT DEFAULT (NULL),
[valueLimit] INT DEFAULT (NULL),
[savingTime] DATETIME DEFAULT (NULL),
[onTime] DATETIME DEFAULT (NULL),
[offTime] DATETIME DEFAULT (NULL),
[totalOnDuration] INT64 DEFAULT (NULL),
[totalOffDuration] INT64 DEFAULT (NULL),
[todayOnDuration] INT64 DEFAULT (NULL),
[todayOffDuration] INT64 DEFAULT (NULL),
[monthOnDuration] INT64 DEFAULT (NULL),
[monthOffDuration] INT64 DEFAULT (NULL),
[totalOnCount] INT DEFAULT (NULL),
[totalOffCount] INT DEFAULT (NULL),
[todayOnCount] INT DEFAULT (NULL),
[todayOffCount] INT DEFAULT (NULL),
[monthOnCount] INT DEFAULT (NULL),
[monthOffCount] INT DEFAULT (NULL),
[falseControl] TINYINT DEFAULT (0),
[falseControlTime] INT DEFAULT (NULL),
[timeOnCount] INT DEFAULT (NULL),
[timeOffCount] INT DEFAULT (NULL),
[timeOnDuration] INT64 DEFAULT (NULL),
[timeOffDuration] INT64 DEFAULT (NULL),
[basetime] TINYINT DEFAULT (0),
[weekOnCount] INT DEFAULT (NULL),
[weekOffCount] INT DEFAULT (NULL),
[weekOnDuration] INT64 DEFAULT (NULL),
[weekOffDuration] INT64 DEFAULT (NULL),
[yearOnCount] INT DEFAULT (NULL),
[yearOffCount] INT DEFAULT (NULL),
[yearOnDuration] INT64 DEFAULT (NULL),
[yearOffDuration] INT64 DEFAULT (NULL),
[item_order] INTEGER DEFAULT (NULL) ,
[delay_time] INT DEFAULT(NULL),
[use_realarm] TINYINT DEFAULT(0),
[realarm_time] INT DEFAULT(NULL)
, [use_alarmpage] TINYINT DEFAULT(0), [alarmpage_filename] NVARCHAR(129) DEFAULT (NULL), [value4Priority] SMALLINT DEFAULT(NULL), [value5Priority] SMALLINT DEFAULT(NULL), [value6Priority] SMALLINT DEFAULT(NULL), [value7Priority] SMALLINT DEFAULT(NULL), [value8Priority] SMALLINT DEFAULT(NULL), [value9Priority] SMALLINT DEFAULT(NULL), [value10Priority] SMALLINT DEFAULT(NULL), [value4Message] NVARCHAR(50) DEFAULT(NULL), [value5Message] NVARCHAR(50) DEFAULT(NULL), [value6Message] NVARCHAR(50) DEFAULT(NULL), [value7Message] NVARCHAR(50) DEFAULT(NULL), [value8Message] NVARCHAR(50) DEFAULT(NULL), [value9Message] NVARCHAR(50) DEFAULT(NULL), [value10Message] NVARCHAR(50) DEFAULT(NULL))
CREATE TABLE [SCADA_CONTROL_LOG] (
[id] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
[pid] INT NOT NULL,
[pointName] NVARCHAR(129) NOT NULL,
[stationid] INT DEFAULT (NULL),
[rtuid] INT DEFAULT (NULL),
[rtuName] NVARCHAR(21) DEFAULT (NULL),
[controlString] NVARCHAR(21) DEFAULT (NULL),
[controlBy] NVARCHAR(21) DEFAULT (NULL),
[result] SMALLINT NOT NULL,
[failreason] NVARCHAR(51) DEFAULT (NULL),
[source] NVARCHAR(21) DEFAULT (NULL),
[controlTime] DATETIME DEFAULT (NULL),
[responseTime] DATETIME DEFAULT (NULL)) |
support@anygate.com
02 6256 5500