fatal error
Moderators: chulett, rschirm, roy
fatal error
The call to sqlldr failed; the return code = 256;
please see the loader logfile: /opt/product/Ascential/DataStage/OnePercent/Scratch/ora.8497.14949d.2.log for details.,
please see the loader logfile: /opt/product/Ascential/DataStage/OnePercent/Scratch/ora.8497.14949d.2.log for details.,
sirisha.chandana
-
- Participant
- Posts: 221
- Joined: Fri Feb 17, 2006 3:38 am
- Location: India
- Contact:
Re: fatal error
Please post full problem description.sirisha wrote:The call to sqlldr failed; the return code = 256;
please see the loader logfile: /opt/product/Ascential/DataStage/OnePercent/Scratch/ora.8497.14949d.2.log for details.,
there might be a possibility that You are loading some record in SQL, in which a field has a foreign key relationship and you are loading something which is not present in the master table...just chack
Thanks & Regards
Parag Saundattikar
Certified for Infosphere DataStage v8.0
Parag Saundattikar
Certified for Infosphere DataStage v8.0
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard.
What's in /opt/product/Ascential/DataStage/OnePercent/Scratch/ora.8497.14949d.2.log ?
What's in /opt/product/Ascential/DataStage/OnePercent/Scratch/ora.8497.14949d.2.log ?
Last edited by ray.wurlod on Tue Jan 08, 2008 4:06 am, edited 1 time in total.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 197
- Joined: Sun Jul 15, 2007 11:45 pm
- Location: Prague
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
What says what doesn't exist?
Preserve the data and control files and run the bulk loader with your DBA looking on. Perhaps there are some trace tools available (to the DBA) that would help.
The bulk load is initiated by DataStage, but once it's running DataStage has no more control. You have to diagnose any failure using database diagnostic utilities.
Preserve the data and control files and run the bulk loader with your DBA looking on. Perhaps there are some trace tools available (to the DBA) that would help.
The bulk load is initiated by DataStage, but once it's running DataStage has no more control. You have to diagnose any failure using database diagnostic utilities.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 197
- Joined: Sun Jul 15, 2007 11:45 pm
- Location: Prague
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 197
- Joined: Sun Jul 15, 2007 11:45 pm
- Location: Prague
-
- Premium Member
- Posts: 197
- Joined: Sun Jul 15, 2007 11:45 pm
- Location: Prague