Project

General

Profile

Task #367

Feature #315: 报警后台服务变更:增加恢复机制和开关类报警;

实时库相关修改的升级脚本

Added by xiangyang li over 4 years ago. Updated almost 4 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Start date:
12/09/2019
Due date:
% Done:

100%

Estimated time:
Defect version:

Description

AlmList / AlmList10 (DAC_实时报警队列表/ DAC_实时事项队列表)表模式、列模式修改,需提供oracle升级脚本。
实时库表信息字典修改(TB0010_RDBTABINFO):
1·AlmList / AlmList10关键列(F0010_KEY_)在DevKey和ClassName基础上增加Date和Msec
实时库列信息字典修改(TB0011_RDBCOLINFO):
1·AlmList和AlmList10增加列AckMs,RstTime,RstMs, Acker。AlmList10额外增加列AckTime;
2·AlmList和AlmList10删除Reserved ,Reserved4 列;
3·数据类型、表内序号也有调整: {
AlmList / AlmList10列:
(F0011_RDBCOLCODE):
AlmStatus :F0011_SERIALNO=230
Date :F0011_SERIALNO=1
Msec :F0011_SERIALNO=2
Reserved1 :F0011_DATTYPE=2,F0011_SERIALNO=240
Reserved2 :F0011_SERIALNO=250
Reserved3 :F0011_DATTYPE=2
}

4·报警类表(SEMODEL.TB4201_ALMCLASS)中增加“BreakStd”【开关异常变位报警】类记录,
报警消息格式表(SEMODEL.TB4202_MESSAGE)中相应增加消息ID=1的对应记录。
5·报警类表中(SEMODEL.TB4201_ALMCLASS)的“DigAlmOnly”对应的报警类型需要更改为“信息提示报警”(F4201_ALARMTYPE=2)。


Files

task367.zip (1.57 KB) task367.zip pengfei xu, 12/09/2019 07:03 PM
task367_new.zip (2 KB) task367_new.zip 根据新增描述,重写SQL语句 pengfei xu, 12/12/2019 02:55 PM

History

#1

Updated by xiangyang li over 4 years ago

  • Description updated (diff)
#2

Updated by xiangyang li over 4 years ago

  • Description updated (diff)
#3

Updated by pengfei xu over 4 years ago

#4

Updated by xiangyang li over 4 years ago

  • Description updated (diff)
#5

Updated by xiangyang li over 4 years ago

  • Description updated (diff)
#7

Updated by pengfei xu about 4 years ago

  • Description updated (diff)
#8

Updated by pengfei xu about 4 years ago

  • Description updated (diff)
#9

Updated by pengfei xu about 4 years ago

  • Description updated (diff)
#10

Updated by pengfei xu about 4 years ago

  • Description updated (diff)
#11

Updated by xiangyang li almost 4 years ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF