SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Data Generator Troubles

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
Data Generator Troubles
Author Message
Astrid



Joined: 03 Nov 2005
Posts: 2

Post Data Generator Troubles Reply with quote

Hola

I need help, I am using data generator I have established connection
with my database using sysdba account (10g).
I am able to see the tables for my different schemas.
When i try to generate data for a particular table
I got the error ora-20001: too many errors ocurred while
loading table data, ora-06512:at line 76

I am trying to generate data for a simple table with
number and varchar data types. I have tried to generate with
Fast script and data load, enable and disabled truncate table
and disable triggers but any combination work

Somebody knows how to handle it?

Thank you so much in advance


Thu Nov 03, 2005 2:24 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Re: Data Generator Troubles Reply with quote

Please provide your table DDL including table name, column names and types.

: Hola

: I need help, I am using data generator I have established connection
: with my database using sysdba account (10g).
: I am able to see the tables for my different schemas.
: When i try to generate data for a particular table
: I got the error ora-20001: too many errors ocurred while
: loading table data, ora-06512:at line 76

: I am trying to generate data for a simple table with
: number and varchar data types. I have tried to generate with
: Fast script and data load, enable and disabled truncate table
: and disable triggers but any combination work

: Somebody knows how to handle it?

: Thank you so much in advance

Thu Nov 03, 2005 3:48 pm View user's profile Send private message
Astrid



Joined: 03 Nov 2005
Posts: 2

Post Re: Data Generator Troubles Reply with quote

: Please provide your table DDL including table name, column names and types.

Here it is:

CREATE TABLE CLIENT_ASSET_ACCT
(
CLIENT_ID_K NUMBER(9) NOT NULL,
EFF_DTE DATE NOT NULL,
CREATE_TS TIMESTAMP(6) NOT NULL,
SET_ID NUMBER(9) NOT NULL,
ID NUMBER(9),
ASSET_ID NUMBER(9),
END_DTE DATE,
EXISTS_FLG VARCHAR2(1 CHAR) NOT NULL,
ASSET_ACCT_TYP_CD_CODE_K VARCHAR2(6 CHAR),
LAST_UPDT_UID_NAM VARCHAR2(8 CHAR) NOT NULL,
LAST_UPDT_TS TIMESTAMP(6) NOT NULL
)
TABLESPACE HM_CORE_TBL_TB
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (

INITIAL 72K

MINEXTENTS 1

MAXEXTENTS 2147483645

PCTINCREASE 0

BUFFER_POOL DEFAULT

)
LOGGING
NOCOMPRESS
NOCACHE
PARALLEL ( DEGREE 2 INSTANCES 3 )
MONITORING;

COMMENT ON TABLE CLIENT_ASSET_ACCT IS 'Parent table that stores client asset account data, e.g., data on accounts for checking, savings, etc. Table employs a "date series using sets" pattern as a client can have multiple concurrent asset accounts. To support joint ownership, i.e. assigning multiple clients to a given asset, the same asset can exist for multiple clients, i.e. have the same ASSET_ID. On the Account workflow step window, when an asset is added for a client, then that asset is added for the client and any other client that was tagged as a joint owner. To make a client no longer a joint owner of an asset, the EXISTS_FLG is set to "N ". Child table of CLIENT.';

COMMENT ON COLUMN CLIENT_ASSET_ACCT.CREATE_TS IS 'System timestamp of when the row was inserted. Included to support version the data on this table.';

COMMENT ON COLUMN CLIENT_ASSET_ACCT.SET_ID IS 'Set identifier. Used on tables that store concurrent multiple instance data. This ID ties together all versions of a particular data instance, i.e. initial row and change history rows.';

COMMENT ON COLUMN CLIENT_ASSET_ACCT.ID IS 'Client asset account ID. System generated unique identifier. This is propagated to this tables child tables to serve as a parent - child link.';

COMMENT ON COLUMN CLIENT_ASSET_ACCT.ASSET_ID IS 'System generated identifier to support joint ownership of security assets. Multiple clients can own a given asset. That asset data is duplicated for each client owner. This ID ties this relationship together.';

COMMENT ON COLUMN CLIENT_ASSET_ACCT.END_DTE IS 'Date upon which client stopped having the account.';

COMMENT ON COLUMN CLIENT_ASSET_ACCT.EXISTS_FLG IS 'Flag indicating if the asset account instance exists for the client..';

COMMENT ON COLUMN CLIENT_ASSET_ACCT.ASSET_ACCT_TYP_CD_CODE_K IS 'Asset account type - pointer to the Reference Data table ASSET_ACCT_TYP_CD.';

COMMENT ON COLUMN CLIENT_ASSET_ACCT.LAST_UPDT_UID_NAM IS 'User ID of the user who last updated the row.';

COMMENT ON COLUMN CLIENT_ASSET_ACCT.LAST_UPDT_TS IS 'Timestamp of when the row was last updated.';

COMMENT ON COLUMN CLIENT_ASSET_ACCT.CLIENT_ID_K IS 'Associated client ID. Foreign key to CLIENT.ID.';

COMMENT ON COLUMN CLIENT_ASSET_ACCT.EFF_DTE IS 'Date upon which the system recognizes the data to be effective. This date is set by the application framework.';

CREATE UNIQUE INDEX PK_CLIENT_ASSET_ACCT ON CLIENT_ASSET_ACCT
(CLIENT_ID_K, EFF_DTE, CREATE_TS, SET_ID)
LOGGING
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (

INITIAL 72K

MINEXTENTS 1

MAXEXTENTS 2147483645

PCTINCREASE 0

BUFFER_POOL DEFAULT

)
NOPARALLEL;

CREATE UNIQUE INDEX UK_CLIENT_ASSET_ACCT ON CLIENT_ASSET_ACCT
(ID, CLIENT_ID_K)
LOGGING
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (

INITIAL 72K

MINEXTENTS 1

MAXEXTENTS 2147483645

PCTINCREASE 0

BUFFER_POOL DEFAULT

)
NOPARALLEL;

Thu Nov 03, 2005 4:15 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Re: Data Generator Troubles Reply with quote

Thanks, I will create your table in my db and try it locally

: Here it is: CREATE TABLE CLIENT_ASSET_ACCT
: (
: CLIENT_ID_K NUMBER(9) NOT NULL,
: EFF_DTE DATE NOT NULL,
: CREATE_TS TIMESTAMP(6) NOT NULL,
: SET_ID NUMBER(9) NOT NULL,
: ID NUMBER(9),
: ASSET_ID NUMBER(9),
: END_DTE DATE,
: EXISTS_FLG VARCHAR2(1 CHAR) NOT NULL,
: ASSET_ACCT_TYP_CD_CODE_K VARCHAR2(6 CHAR),
: LAST_UPDT_UID_NAM VARCHAR2(8 CHAR) NOT NULL,
: LAST_UPDT_TS TIMESTAMP(6) NOT NULL
: )
: TABLESPACE HM_CORE_TBL_TB
: PCTUSED 0
: PCTFREE 10
: INITRANS 1
: MAXTRANS 255
: STORAGE (

: INITIAL 72K

: MINEXTENTS 1

: MAXEXTENTS 2147483645

: PCTINCREASE 0

: BUFFER_POOL DEFAULT

: )
: LOGGING
: NOCOMPRESS
: NOCACHE
: PARALLEL ( DEGREE 2 INSTANCES 3 )
: MONITORING;

: COMMENT ON TABLE CLIENT_ASSET_ACCT IS 'Parent table that stores client asset
: account data, e.g., data on accounts for checking, savings, etc. Table
: employs a "date series using sets" pattern as a client can have
: multiple concurrent asset accounts. To support joint ownership, i.e.
: assigning multiple clients to a given asset, the same asset can exist for
: multiple clients, i.e. have the same ASSET_ID. On the Account workflow
: step window, when an asset is added for a client, then that asset is added
: for the client and any other client that was tagged as a joint owner. To
: make a client no longer a joint owner of an asset, the EXISTS_FLG is set
: to "N ". Child table of CLIENT.';

: COMMENT ON COLUMN CLIENT_ASSET_ACCT.CREATE_TS IS 'System timestamp of when
: the row was inserted. Included to support version the data on this
: table.';

: COMMENT ON COLUMN CLIENT_ASSET_ACCT.SET_ID IS 'Set identifier. Used on tables
: that store concurrent multiple instance data. This ID ties together all
: versions of a particular data instance, i.e. initial row and change
: history rows.';

: COMMENT ON COLUMN CLIENT_ASSET_ACCT.ID IS 'Client asset account ID. System
: generated unique identifier. This is propagated to this tables child
: tables to serve as a parent - child link.';

: COMMENT ON COLUMN CLIENT_ASSET_ACCT.ASSET_ID IS 'System generated identifier
: to support joint ownership of security assets. Multiple clients can own a
: given asset. That asset data is duplicated for each client owner. This ID
: ties this relationship together.';

: COMMENT ON COLUMN CLIENT_ASSET_ACCT.END_DTE IS 'Date upon which client
: stopped having the account.';

: COMMENT ON COLUMN CLIENT_ASSET_ACCT.EXISTS_FLG IS 'Flag indicating if the
: asset account instance exists for the client..';

: COMMENT ON COLUMN CLIENT_ASSET_ACCT.ASSET_ACCT_TYP_CD_CODE_K IS 'Asset
: account type - pointer to the Reference Data table ASSET_ACCT_TYP_CD.';

: COMMENT ON COLUMN CLIENT_ASSET_ACCT.LAST_UPDT_UID_NAM IS 'User ID of the user
: who last updated the row.';

: COMMENT ON COLUMN CLIENT_ASSET_ACCT.LAST_UPDT_TS IS 'Timestamp of when the
: row was last updated.';

: COMMENT ON COLUMN CLIENT_ASSET_ACCT.CLIENT_ID_K IS 'Associated client ID.
: Foreign key to CLIENT.ID.';

: COMMENT ON COLUMN CLIENT_ASSET_ACCT.EFF_DTE IS 'Date upon which the system
: recognizes the data to be effective. This date is set by the application
: framework.';

: CREATE UNIQUE INDEX PK_CLIENT_ASSET_ACCT ON CLIENT_ASSET_ACCT
: (CLIENT_ID_K, EFF_DTE, CREATE_TS, SET_ID)
: LOGGING
: TABLESPACE USERS
: PCTFREE 10
: INITRANS 2
: MAXTRANS 255
: STORAGE (

: INITIAL 72K

: MINEXTENTS 1

: MAXEXTENTS 2147483645

: PCTINCREASE 0

: BUFFER_POOL DEFAULT

: )
: NOPARALLEL;

: CREATE UNIQUE INDEX UK_CLIENT_ASSET_ACCT ON CLIENT_ASSET_ACCT
: (ID, CLIENT_ID_K)
: LOGGING
: TABLESPACE USERS
: PCTFREE 10
: INITRANS 2
: MAXTRANS 255
: STORAGE (

: INITIAL 72K

: MINEXTENTS 1

: MAXEXTENTS 2147483645

: PCTINCREASE 0

: BUFFER_POOL DEFAULT

: )
: NOPARALLEL;

Thu Nov 03, 2005 5:01 pm View user's profile Send private message
Astrid



Joined: 03 Nov 2005
Posts: 2

Post Re: Data Generator Troubles Reply with quote

Thank you so much. I think the trouble is with timestamp datatime

saludos, Astrid
: Thanks, I will create your table in my db and try it locally

Thu Nov 03, 2005 6:20 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Re: Data Generator Troubles Reply with quote

You are right, the trouble is caused by timestamp(6) datatype. This kind of timestamp datatype is not supported and the column is not being updated while it is not nullable as a result leading "cannot insert NULL errors"

Here is a workaround that you can use.
1. Create some intermediate table (load_table) with the same columns but use "timestamp" or "date" instead of "timestamp(6)".
2. Use Data Generator to populate that table and then use INSERT INTO main_table SELECT * FROM load_table.
3. Drop the intermediate table.

: Thank you so much. I think the trouble is with timestamp datatime

: saludos, Astrid

Thu Nov 03, 2005 8:46 pm View user's profile Send private message
Astrid



Joined: 03 Nov 2005
Posts: 2

Post Re: Data Generator Troubles Reply with quote

Thank you so much

: You are right, the trouble is caused by timestamp(6) datatype. This kind of
: timestamp datatype is not supported and the column is not being updated
: while it is not nullable as a result leading "cannot insert NULL
: errors"

: Here is a workaround that you can use.
: 1. Create some intermediate table (load_table) with the same columns but use
: "timestamp" or "date" instead of
: "timestamp(6)".
: 2. Use Data Generator to populate that table and then use INSERT INTO
: main_table SELECT * FROM load_table.
: 3. Drop the intermediate table.

Fri Nov 04, 2005 3:59 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.