Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
Munish
Participant
Posts: 89 Joined: Sun Nov 19, 2006 10:34 pm
Post
by Munish » Tue Jan 02, 2007 7:07 pm
Hi All,
I am loading target tables in Oracle.
Source is a sequential file.
seqFile >Oracle Enterprise Stage(TargetTable)
I am getting the following error.
Code: Select all
Oracle_Enterprise_0: Indexes on table 'OLB_ADJUSTMENT_FACT' preclude direct parallel loading unless an index option is included. Add an index option or drop indexes and rerun step.
My table does not have any indexes so far.
Thanks and regards,
Munish
[/code]
MK
DSguru2B
Charter Member
Posts: 6854 Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX
Post
by DSguru2B » Tue Jan 02, 2007 7:12 pm
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Munish
Participant
Posts: 89 Joined: Sun Nov 19, 2006 10:34 pm
Post
by Munish » Tue Jan 02, 2007 8:27 pm
Thanks it worked.
But still unable to load.
This time
Code: Select all
Sequential_File_1,0: Field "ADJUSTMENT_KEY" has import error and no default value; data: {" 0 "}, at offset: 0
Code: Select all
Sequential_File_1,0: Import complete; 0 records imported successfully, 6 rejected.
I have checked the datatypes of source and target, they are in sync.
Am I missing out something here ?
Any comment would be highly appreciated.
Thanks,
Munish
MK
narasimha
Charter Member
Posts: 1236 Joined: Fri Oct 22, 2004 8:59 am
Location: Staten Island, NY
Post
by narasimha » Tue Jan 02, 2007 8:39 pm
Check if this
helps
An exact search on "has import error and no default value" gave similar posts.
Narasimha Kade
Finding answers is simple, all you need to do is come up with the correct questions.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Tue Jan 02, 2007 9:24 pm
So now you two are some kind of search for hire tag team?
-craig
"You can never have too many knives" -- Logan Nine Fingers
Munish
Participant
Posts: 89 Joined: Sun Nov 19, 2006 10:34 pm
Post
by Munish » Tue Jan 02, 2007 9:39 pm
Thanks Guys,
It really worked.
Closing the job.
Thanks and regards,
Munish
MK
DSguru2B
Charter Member
Posts: 6854 Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX
Post
by DSguru2B » Tue Jan 02, 2007 10:10 pm
Nah...just a friendly reminder for our dsxians that its "all" covered.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
narasimha
Charter Member
Posts: 1236 Joined: Fri Oct 22, 2004 8:59 am
Location: Staten Island, NY
Post
by narasimha » Tue Jan 02, 2007 11:40 pm
That's a nice team name coined
Narasimha Kade
Finding answers is simple, all you need to do is come up with the correct questions.
Munish
Participant
Posts: 89 Joined: Sun Nov 19, 2006 10:34 pm
Post
by Munish » Wed Jan 24, 2007 6:46 pm
Hi Champs,
I am using Oracle Load to load my fact table.
Volume: 280 mills per load.
The DB is partitioned by date.
We have 7 bitmap indexes on this table.
The problem starts after the data is loaded and when OCI stage tries to rebuild the indexes and it is failing there.
The error:
ORA-01502: index 'CBA_DBA.XIF1EDX_RPT_SDF_BMAP' or partition of such index is in unusable state
Any Guesses........
MK
I_Server_Whale
Premium Member
Posts: 1255 Joined: Wed Feb 02, 2005 11:54 am
Location: United States of America
Post
by I_Server_Whale » Wed Jan 24, 2007 6:50 pm
Munish wrote: Hi Champs,
I am using Oracle Load to load my fact table.
Volume: 280 mills per load.
The DB is partitioned by date.
We have 7 bitmap indexes on this table.
The problem starts after the data is loaded and when OCI stage tries to rebuild the indexes and it is failing there.
The error:
ORA-01502: index 'CBA_DBA.XIF1EDX_RPT_SDF_BMAP' or partition of such index is in unusable state
Any Guesses........
My guess is you need to open a new topic rather than appending a new question to an old discussion.
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
narasimha
Charter Member
Posts: 1236 Joined: Fri Oct 22, 2004 8:59 am
Location: Staten Island, NY
Post
by narasimha » Wed Jan 24, 2007 6:58 pm
I agree with Whale.
Contact your DBA's or if you can re-build the index.
Nothing can be done on the datastage side.
Narasimha Kade
Finding answers is simple, all you need to do is come up with the correct questions.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Wed Jan 24, 2007 7:09 pm
Bitmap indexes are notoriously picky and prone to going bad during a load. As people have said, have a chat with your DBAs but I'd bet you'll need to drop them before the load and then rebuild them post load.
-craig
"You can never have too many knives" -- Logan Nine Fingers
Munish
Participant
Posts: 89 Joined: Sun Nov 19, 2006 10:34 pm
Post
by Munish » Wed Jan 24, 2007 7:37 pm
Hi All,
I am closing this job and opening a new thread.
Thanks,
Munish
MK