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

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: Upcoming Events: BI + Analytics conference: Aug 9.

Data Transfer transform issue in DS4.2 sp8.1


 
Search this topic... | Search DI: Installation, Administration, and Connectivities... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Installation, Administration, and Connectivities  Previous TopicPrint TopicNext Topic
Author Message
Nemesis
Forum Enthusiast
Forum Enthusiast



Joined: 08 Jun 2004

Posts: 1068
Location: London, England


flag
PostPosted: Thu Jul 06, 2017 3:49 am 
Post subject: Data Transfer transform issue in DS4.2 sp8.1

Good day to you All.

I'm having more fun with behaviour changes / bugs in DS 4.2 sp8.1.

The latest interesting finding concerns the Data Transfer transform. I prefer to disable the 'Drop and re-create before loading' in production environments as the transfer table should exist and be stable.

So I was a little annoyed when I executed the latest iteration of one of the warehouse load jobs and it failed with an error message indicating that it couldn't delete data from the data transfer table.
After a little digging I found that the data transfer table didn't exist any more as DS had deleted it at the end of the previous job run! Has anyone else seen this behaviour? I'm not sure if it's specific to DS4.2 sp8.1 as we inherited most of our code from a consultancy and all the other Data Transfers transforms still have the drop and re-create option enabled.

Any observations gratefully received.

_________________
Contracting in London again.
Back to top
eganjp
Forum Addict
Forum Addict



Joined: 12 Sep 2007
ASUG Icon
Posts: 4223
Location: Denver Area


flag
PostPosted: Sun Jul 16, 2017 9:28 pm 
Post subject: Re: Data Transfer transform issue in DS4.2 sp8.1

It will be very interesting if this new behavior is DS cleaning up after itself. I thought that the Data Transfer was already doing that under the covers. I know the Template table feature doesn't clean up after itself.
_________________
Jim Egan
ProKarma-an SAP Consulting Partner
Speaker at RMOUG Training Days 2013
Speaker at Sapphire Now 2013
Speaker at Business Objects User Conference 2013
-My ETL is faster than your database! - Advanced ETL performance tuning for Data Services
-Kill ETL bugs before they kill you!
My ETL blog

Latest Blog Posts
• 2014-04-17 Can Your ETL Make Your Reporting Faster?
• 2014-04-04 ProKarma Acquires Mantis Technology Group
• 2014-04-02 How to Create Charts in Webi (Part 2 of 2)
Back to top
Nemesis
Forum Enthusiast
Forum Enthusiast



Joined: 08 Jun 2004

Posts: 1068
Location: London, England


flag
PostPosted: Mon Jul 17, 2017 3:11 am 
Post subject: Re: Data Transfer transform issue in DS4.2 sp8.1

I've managed to get SAP's attention and the issue is with their helpdesk. Predictably, they are in the 'asking irrelevant questions' phase of the investigation.
_________________
Contracting in London again.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Installation, Administration, and Connectivities  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.0101 seconds using 17 queries. (SQL 0.0028 Parse 0.0002 Other 0.0072)
CCBot/2.0 (http://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