Knowledge Base Article #174 - RTS Curves not exporting correctly or not showing up correctly in PowerBase
DateSep 23, 2009
ByRoss P
Filed UnderPowerBase General
ClassGeneral
 
Issue Addressed
RTS Curve data, when viewed in PowerBase, or when exported to RTS from Powerbase is not showing correctly. Either the curves appear to be missing, or differ greatly between the original RTS Curves.
 
Causes of Issue
This issue is caused by an incorrect table descripion in the PowerBase database. The fields holding the curve data are set to integer values, rounding the values to the nearest whole number.

This is specific to the Oracle Platform
 
Solution to this Issue
First, the corrupted curves will need to be removed, and the table will need to be rebuilt. The following SQL Statements will need to be ran by a DBA on the PowerBase database.

delete from PB.RTS_CURVE_DESCRIPTION
/
delete from PB.RTS_CURVE_FORMULAS
/
drop table PB.RTS_CURVE_TABLE
/
CREATE TABLE PB.RTS_CURVE_TABLE
(
DESCRIPTION VARCHAR2(50 BYTE) NOT NULL,
CURVE_TYPE VARCHAR2(50 BYTE) NOT NULL,
MULTIPLE FLOAT,
TD05 FLOAT,
TD1 FLOAT,
TD2 FLOAT,
TD3 FLOAT,
TD4 FLOAT,
TD5 FLOAT,
TD6 FLOAT,
TD7 FLOAT,
TD8 FLOAT,
TD9 FLOAT,
TD10 FLOAT,
TD11 FLOAT,
TD12 FLOAT
)

Once those scripts are ran, you will need to repopulate the PowerBase database with the curve data using BackupMerge. This operation will have no effect on Previous Test Results.

Login to Support
Email:
Password:
Contact Support to reset your password

Support Links
Support Main
Register for Support
Knowledge Base

Contact Support
Phone:
(918) 622-4530
. . . . . . . . . . . . . . . . .
Email:
[email protected]