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

Register | Login 

Streamline and extend SAP BusinessObjects software 
Streamline and extend SAP BusinessObjects software (Opens a new window)  

General Notice: Upcoming Events: BONYMAUG: May 14, BI2014 Nice, France: May 21.

DS 4.0 Execution Error: terminated due to error<170105>


 
Search this topic... | Search Data Integrator... | Search Box
Register or Login to Post    Forum Index -> Data Integrator  Previous TopicPrint TopicNext Topic
Author Message
kdspvp
Principal Member
Principal Member



Joined: 15 Oct 2007

Posts: 114



PostPosted: Fri Feb 10, 2012 11:45 am 
Post subject: DS 4.0 Execution Error: terminated due to error<170105>

Hi,

I am getting the below error:
Cannot write onto Disk for the file <Program Files (x86)\SAP BusinessObjects\Data Services \log \pCache/ ncpd__boxir2system/19421Sort35_8760_46>. OS Error: <No space left on device>


Please advise.

_________________
Thanks,
VPK
Back to top
ganeshxp
Forum Addict
Forum Addict



Joined: 17 Jul 2008
ASUG Icon
Posts: 3563
Location: Denver, Colorado, USA


flag
PostPosted: Fri Feb 10, 2012 1:16 pm 
Post subject: Re: DS 4.0 Execution Error: terminated due to error<17010

Do you have good amount of space in the Job Server? Looks like the pCache directory is getting filled/crossing the alloted size....

are you using Persistent Cache Datastore?

_________________
Cheers
Ganesh
Back to top
kdspvp
Principal Member
Principal Member



Joined: 15 Oct 2007

Posts: 114



PostPosted: Sat Feb 11, 2012 3:17 am 
Post subject: Re: DS 4.0 Execution Error: terminated due to error<17010

Hi Ganesh,

Thanks for quick response.

No, we are not using Persistent Cache Datastore.

How to over come the situation, please suggest.
Is this something to set at OS level?

Edit: yes we have enough disk space on Job server.

_________________
Thanks,
VPK


Last edited by kdspvp on Mon Feb 13, 2012 10:43 am, edited 1 time in total
Back to top
manoj_d
Forum Addict
Forum Addict



Joined: 01 Jan 2009

Posts: 2634



PostPosted: Sat Feb 11, 2012 6:36 pm 
Post subject: Re: DS 4.0 Execution Error: terminated due to error<17010

pcache folder is also used for caching data for processing internally not necessarily for Persistent Cache datastore, in your case Sort is happening in DS, and looks like you have larger data set that is getting sorted

check your Dataflow and see if you can sort (order by) frm happening in DS instead getting pushed to the database
Back to top
kdspvp
Principal Member
Principal Member



Joined: 15 Oct 2007

Posts: 114



PostPosted: Mon Feb 13, 2012 10:49 am 
Post subject: Re: DS 4.0 Execution Error: terminated due to error<17010

Thanks Manoj.
Yes sorting is being done.
I have one query, you said the sorting is being pushed down to Database and I should try to make it happen at DI itself.

I have one confusion here, if sorting is being pushed down to database than why the paging is being done.

Please make me clear here, looks I am missing imp point here.

Thanks in advance.

_________________
Thanks,
VPK
Back to top
manoj_d
Forum Addict
Forum Addict



Joined: 01 Jan 2009

Posts: 2634



PostPosted: Mon Feb 13, 2012 7:01 pm 
Post subject: Re: DS 4.0 Execution Error: terminated due to error<17010

check if ORDER BY (sorting) is getting pushdown to the database or not, since you are getting a error related to building of sort cache (19421Sort35_8760_46) I am aassuming the sorting is happening in DataServices

check the View Optimized SQL of the DF, if you see the order by going to the source tables, if not then see if there is anyway you can acheive this
Back to top
davc4
Senior Member
Senior Member



Joined: 03 Jul 2009

Posts: 88
Location: Aberdeen, Scotland


flag
PostPosted: Tue Feb 14, 2012 5:50 am 
Post subject: Re: DS 4.0 Execution Error: terminated due to error<17010

I have had a couple of issues with this where there was multiple sorting scenarios going on to access previous row values,

If you cannot push the sort down to the database from your source i found the data_transfer transform can help in this situation i.e. push the data into a staging table in the middle of your flow and then perfom the sort on the data transfer.
Back to top
kdspvp
Principal Member
Principal Member



Joined: 15 Oct 2007

Posts: 114



PostPosted: Tue Feb 14, 2012 5:58 am 
Post subject: Re: DS 4.0 Execution Error: terminated due to error<17010

Thanks a lot, this gives me a direction.
_________________
Thanks,
VPK
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator  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.0492 seconds using 17 queries. (SQL 0.0030 Parse 0.0355 Other 0.0107)
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