BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

Auto Correct Load !


 
Search this topic... | Search DI: Designer and Job Design... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Author Message
darius
Senior Member
Senior Member



Joined: 21 Dec 2004

Posts: 44
Location: France


flag
PostPosted: Tue Mar 15, 2005 10:23 am 
Post subject: Auto Correct Load !

Strange Issue
In a dataflow, if I do not set the Auto Correct Load option, only part of the data are loaded ? Can anybody explain me that ?
Chears

Darius
Back to top
Werner Daehn
Forum Devotee
Forum Devotee



Joined: 17 Dec 2004

speaker.gif*6
Posts: 10591
Location: Germany


flag
PostPosted: Tue Mar 15, 2005 2:06 pm 
Post subject: Re: Auto Correct Load !

icon_confused.gif Nope.

No errors, no warning messages in the error log, nothing?

I would execute the job again but this time turn on "trace sql loader" to find out what kind of sql is generated. But I have no clue what might go wrong. In case you cannot explain, please provide us with some more information, table definition, database type etc.

_________________
Werner Daehn
Product Manager Data Services
SAP AG
�The opinions expressed in this post are my own views and not those of SAP.�
Back to top
darius
Senior Member
Senior Member



Joined: 21 Dec 2004

Posts: 44
Location: France


flag
PostPosted: Wed Mar 16, 2005 4:37 am 
Post subject: Re: Auto Correct Load !

I tryed today, setting off the Auto Correct Load option ... and it worked fine mad.gif icon_confused.gif mad.gif
I hate computer science ... in those cases crazy.gif
I got to investigate deeper, I can't rely on "day yes day not" job .....

Darius

ps: it's text files to oracle database ... But what does exactly the Auto Correct Load option ?
Back to top
Nicolas Hadj-Blaha
Principal Member
Principal Member



Joined: 10 Mar 2005
ASUG Icon
Posts: 481
Location: New Zealand


flag
PostPosted: Wed Mar 16, 2005 4:47 am 
Post subject: Re: Auto Correct Load !

Hi,

From the technical manuals:

Quote:
The auto correct load option checks the target table for existing rows before adding new rows to the table. Using the auto correct load option, however, can needlessly slow jobs executed in non-recovery mode.


Nicolas

www.dataintegrator.net[/quote]

_________________
Lead Data Architect, Synchrony Global
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0274 seconds using 17 queries. (SQL 0.0026 Parse 0.0009 Other 0.0239)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo