Designer 6.0 to 6i Migration Problem

From: home use only <123_at_mn.rr.com>
Date: Sun, 08 Jul 2001 22:09:48 GMT
Message-ID: <MS427.123496$R7.22289924_at_typhoon.kc.rr.com>

I have been attempting to upgrade a Designer 6.0.3 repository to a 6.5 (Des6i r4) repository,
and run accross several triggers that do not work while running ckmigdat.sql.

The first statement to crash is:

PROMPT ...Migrating SDD_COL

--Insert Stmt For Table : SDD_COL

• Bugs Fixed 908169, 853901, 909178, 953459, 965910, 1311343
• LABEL * COLUMNS

INSERT INTO SDD_COL ( AUTO_GENERATED, AVERAGE_LENGTH, CHANGED_BY, COLUMN_DENORMALISED_FROM, COLUMN_FOR, COMPLETE_FLAG, CONSTRAINT_DENORMALISED_VIA, CREATED_BY, DATATYPE, DATE_CHANGED, DATE_CREATED, DECIMAL_PLACES, DEFAULT_DISPLAY_TYPE, DEFAULT_IMPLEMENTATION_ITEM, DEFAULT_VALUE, DEFAULT_VALUE_TYPE, DENORMALIZED_SUMMARY_FUNCTION, DERIVATION_EXPRESSION_TYPE, DESCRIPTOR_COLUMN, DISPLAY_FLAG, DISPLAY_HEIGHT, DISPLAY_LENGTH, DISPLAY_SEQUENCE, ELEMENT_TYPE_NAME, EXPRESSION_TEXT, FIELD_INITIAL_VALUE, FIELD_LEVEL, FIELD_NULL_VALUE, FINAL_VOLUME, FORMAT_MODIFIER, HELP_TEXT, HIGHLIGHTING, INITIAL_VOLUME, JUSTIFICATION, MAXIMUM_LENGTH, NAME, NULL_INDICATOR, OBJECT_TYPE_INCLUSION, OCCURS, ORDER_SEQUENCE, PROMPT, REDEFINES, RELATION_TYPE, REMARK, SEQUENCE_NUMBER, SERVER_DEFAULTED_FLAG, SERVER_DERIVED_FLAG, SIGNED, SOFT_LOV, SORTING_ORDER, SOURCE_ENTITY_DERIVED_FROM, SOURCE_RELATIONSHIP_END, SOURCE_REL_ENTITY, SOURCE_REL_ENTITY_ATTRIBUTE, STORAGE_FORMAT, STORE_REF_WITH_ROWID_FLAG, SUGGESTION_LIST_FLAG, TYPES, UPPERCASE, VALIDATION_FAILURE_MESSAGE, WHERE_VALIDATION_TYPE, USRX0, USRX1, USRX2, USRX3, USRX4, USRX5, USRX6, USRX7, USRX8, USRX9, USRX10, USRX11, USRX12, USRX13, USRX14, USRX15, USRX16, USRX17, USRX18, USRX19,

• The following columns are new to version 4.0.8 ,

BASE_COLUMN_REF, CLUSTER_COLUMN_REF, DOMAIN_REF, IRID, IVID, NOTM, ORACLE_OBJECT_TYPE_REF, ORACLE_TYPE_REF, PAC_REF, PARENT_IVID, RELATION_SELECTION_REF, SCOPE_TABLE_REF, SEQUENCE_REF, SOURCE_ATTRIBUTE_REF, TABLE_REF )

(SELECT substrb(AUTO_GENERATED, 1, 2),

substrb(AVERAGE_LENGTH, 1, 5),

CHANGED_BY, GET_UNIQUE_ID(COLUMN_DENORMALISED_FROM,0), substrb(COLUMN_FOR, 1, 3),

nvl(COMPLETE_FLAG,'Y'),

GET_UNIQUE_ID(CONSTRAINT_DENORMALISED_VIA,0), CREATED_BY, nvl( substrb(DATATYPE, 1, 16), 'VARCHAR2'),

DATE_CHANGED, DATE_CREATED, DECIMAL_PLACES, DEFAULT_DISPLAY_TYPE, DEFAULT_IMPLEMENTATION_ITEM, substrb(DEFAULT_VALUE, 1, 60),

decode( get_def_val_type( substrb(DEFAULT_VALUE, 1, 60), DATATYPE), 0, 'LITERAL', 1, 'SERVER FUNCTION' ), substrb(DENORMALIZED_SUMMARY_FUNCTION, 1, 19),

substrb(DERIVATION_EXPRESSION_TYPE, 1, 14),

substrb(DESCRIPTOR_COLUMN, 1, 2),

nvl(DISPLAY_FLAG,'Y'),

substrb(DISPLAY_HEIGHT, 1, 6),

substrb(DISPLAY_LENGTH, 1, 5),

DISPLAY_SEQUENCE, ELEMENT_TYPE_NAME, EXPRESSION_TEXT, FIELD_INITIAL_VALUE, FIELD_LEVEL, substrb(FIELD_NULL_VALUE, 1, 20),

FINAL_VOLUME, get_date_format_mask(FORMAT_MODIFIER),

HELP_TEXT, HIGHLIGHTING, INITIAL_VOLUME, substrb(JUSTIFICATION, 1, 6),

substrb(MAXIMUM_LENGTH, 1, 5),

substrb(NAME, 1, 30),

nvl( substrb(NULL_INDICATOR, 1, 8), 'NULL'),

substrb(OBJECT_TYPE_INCLUSION, 1, 6),

OCCURS, ORDER_SEQUENCE, substrb(PROMPT, 1, 132),

REDEFINES, substrb(RELATION_TYPE, 1, 6),

REMARK, SEQUENCE_NUMBER, nvl(SERVER_DEFAULTED_FLAG,'N'),

nvl(SERVER_DERIVED_FLAG,'N'),

nvl(SIGNED,'N'),

nvl( substrb(SOFT_LOV, 1, 1), 'N'),

SORTING_ORDER, GET_UNIQUE_ID(SOURCE_ENTITY_DERIVED_FROM,0), GET_UNIQUE_ID(SOURCE_RELATIONSHIP_END,0), GET_UNIQUE_ID(SOURCE_REL_ENTITY,0), GET_UNIQUE_ID(SOURCE_REL_ENTITY_ATTRIBUTE,0), STORAGE_FORMAT, nvl( substrb(STORE_REF_WITH_ROWID_FLAG, 1, 1), 'N'),

nvl(SUGGESTION_LIST_FLAG,'N'),

NULL, nvl(UPPERCASE,'N'),

substrb(VALIDATION_FAILURE_MESSAGE, 1, 70),

substrb(WHERE_VALIDATION_TYPE, 1, 14),

USER_DEFINED_PROPERTY_0, USER_DEFINED_PROPERTY_1, USER_DEFINED_PROPERTY_2, USER_DEFINED_PROPERTY_3, USER_DEFINED_PROPERTY_4, USER_DEFINED_PROPERTY_5, USER_DEFINED_PROPERTY_6, USER_DEFINED_PROPERTY_7, USER_DEFINED_PROPERTY_8, USER_DEFINED_PROPERTY_9, USER_DEFINED_PROPERTY_10, USER_DEFINED_PROPERTY_11, USER_DEFINED_PROPERTY_12, USER_DEFINED_PROPERTY_13, USER_DEFINED_PROPERTY_14, USER_DEFINED_PROPERTY_15, USER_DEFINED_PROPERTY_16, USER_DEFINED_PROPERTY_17, USER_DEFINED_PROPERTY_18, USER_DEFINED_PROPERTY_19,

• The following columns are new to version 4.0.8 ,

GET_UNIQUE_ID(BASE_COLUMN_REFERENCE, 0), GET_UNIQUE_ID(CLUSTER_COLUMN_REFERENCE, 0), GET_UNIQUE_ID(DOMAIN_REFERENCE, 0), GET_IRID(ID, 0), GET_IVID(ID, 0), NUMBER_OF_TIMES_MODIFIED, decode(COLUMN_FOR, 'OOT',GET_UNIQUE_ID(ORACLE_OBJECT_TYPE_REFERENCE, 0),NULL), GET_UNIQUE_ID(ORACLE_TYPE_REFERENCE, 0), NULL, NULL, GET_UNIQUE_ID(RELATION_SELECTION_REFERENCE, 0), GET_UNIQUE_ID(SCOPE_TABLE_REFERENCE, 0), GET_UNIQUE_ID(SEQUENCE_REFERENCE, 0), GET_UNIQUE_ID(SOURCE_ATTRIBUTE_REFERENCE, 0), decode(COLUMN_FOR, 'TAB', GET_UNIQUE_ID(TABLE_REFERENCE, 0), NULL)

FROM CI_COLUMNS_at_r212

WHERE APPLICATION_SYSTEM_OWNED_BY IN ( SELECT ID FROM UPG_APP) )

/

As you can see from the above statement, a null is selected for two columns with a not null constraint;

PAC_REF and PARENT_IVID (look about seven lines up from the bottom statement).

Trigger SDD_COL_br is suppose to provide a number when the inserted values are null, but it is not

working. This is also true for inserting data into SDD_MTI and SDD_ITE.

I made sure that the triggers were enabled.

Any help would be appreciated. Received on Mon Jul 09 2001 - 00:09:48 CEST