ENOSERV delivers software to help power companies meet the challenges of relay testing in today's time sensitive regulatory environment. ENOSERV supplies companies with rock-solid automation tools that support workgroup uniformity, process transparency & easy test results reporting.
Copyright © 2020 Doble Engineering Company ® All rights reserved.
| 918 · 622 · 4530 |
| Knowledge Base Article #164 - RTS Test Result values in PowerBase being Truncated or Rounded | |||||
|---|---|---|---|---|---|
| Date | Mar 25, 2008 | ||||
| By | ENOSERV | ||||
| Filed Under | PowerBase General | ||||
| Class | General | ||||
| Issue Addressed | |||||
| Certian test values from RTS are being shown in their full format in RTS, but when imported into PowerBase, are rounded or truncated. | |||||
| Causes of Issue | |||||
| This issue is due to the fact that in some versions of the database, the fields in the table that stores these result values are not set big enough to hold the values from RTS. | |||||
| Solution to this Issue | |||||
| The issue can be fixed for future results by running the following script. ALTER TABLE PB.RTS_RESULTS MODIFY ( PHASE_F1 FLOAT, VOLTAGE_F2 FLOAT, CURRENT_F3 FLOAT, RESULT_F4 FLOAT, CWANGLE_F5 FLOAT, CCWANGLE_F6 FLOAT, RANGEHI_F7 FLOAT, RANGELO_F8 FLOAT, VAR_F9 FLOAT, WATTS_F10 FLOAT, Z_F11 FLOAT, MTG_F12 FLOAT, F13 FLOAT, F14 FLOAT, F15 FLOAT, F16 FLOAT, F17 FLOAT, F18 FLOAT, F19 FLOAT, F20 FLOAT ); Older results can be fixed by using BackupMerge to overwrite the results in PowerBase with what is in RTS. Note that YOU MUST use your original RTS database that have those results tagged. Otherwise, the untagged results you backup merge in will be orhaned. | |||||
| Support Links |
|---|
| Support Main Register for Support Knowledge Base |
| Contact Support |
|---|
| Phone: (918) 622-4530 . . . . . . . . . . . . . . . . . Email: [email protected] |