Oracle Finds
Background: Uninstalled the sequence I created to make the last build work but left the db intact.
I opened my previous project in the new IDE the choose Utilities -> Synchronize with db
Result: Build comparison progress bars start then get an error message "This document already has a DocumentElement node" then a few second later get another error message stating "Object reference not set to an instance of an object."
Background: Uninstalled all tables, triggers and sequences from Oracle and created a new project.
Result: Database creation part of the wizard successfully made sequences (FIXED) SEQPLUMFILEINDEX and SEQPLUMUSER and all triggers show valid.
Background: Running new project wizard, screen named "creating plum project file"
Result: Error Dialog, Title: Population Error, Message:
Click ok and get a timeout message later, and start over after the verity collection.
I choose only the plum tables and I did not get the error.
I added one table called 'security' that was in my database and when it is selected to import table is when the above error is created.
There was no data in the 'security' table
Here is the DDL for the 'security' table
CREATE TABLE "DSRLS"."SECURITY" ("SBCUID" VARCHAR2(10 byte) NOT
NULL, "PASSWORD" VARCHAR2(100 byte) NOT NULL, "NAME"
VARCHAR2(100 byte) NOT NULL, "TITLE" VARCHAR2(100 byte) NOT
NULL, "DEPARTMENT" VARCHAR2(100 byte) NOT NULL, "EMAIL"
VARCHAR2(100 byte) NOT NULL, "PHONE" VARCHAR2(15 byte) NOT
NULL, "SEC_LEVEL" VARCHAR2(100 byte),
CONSTRAINT "SYS_C003407" PRIMARY KEY("SBCUID")
USING INDEX
TABLESPACE "USERS"
STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
TABLESPACE "USERS" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS
255
STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
2147483645 PCTINCREASE 0)
LOGGING
More to come but I hope it's all good news.
Timothy J. Blankenship
Amdocs
314.242.7075
