I have 2 threads open on this site and...

I...

Ah a little more of idea than I did have,

Right I have processed in IS and the cubes have failed.

Ive gone to the bottom of the screen and there are...

akin.akinwumi (6/15/2012)

---

The warnings drive the errors. SQL jobs will only capture the errors produced so the dba's will not be any help here. So you need to debug the pacakge...

Ill see if I can do that,

Those errors come from a report that the bda team have created for me during the nightly import.

Are they not grabbing the right thing...

This is the thing,

It errors in IS.

I then go into Analysis Services and it processes fine (On Full and on Updates)

I then go back to the IS package and it...

|Thats what I thought but process update wasnt working.

I was told its best to go for a full Process, its still not working through but neither is process update

Oh whoops,

I didnt realise I was chatting to the same person about the issue on both forumns

Ill come off this one then

Well As expeced, It failed again last night

Source: Analysis Services Processing Task SEN Cube Analysis Services Execute DDL Task Description: Internal error: The operation terminated unsuccessfully

Analysis Services Processing Task...

Brilliant,

Thanks for that. Changing everything to Process FULL threw up a couple of duplication issues with the data that wasnt showing at all with Process Update.

Fingers cross things should be...

Here was I thinking that just doing the updates would speed things up.

One other question.

I have broken my Analysis Services update into seperate tasks. So each dimension sits in its...

Might have found something,

I process Updates in analysis Services but I changed the problem dimension to Process FULL and it failed and it looks like there is Some issues.... E.g.

Attribute...

This just gets worse....

I changed everything to full process and ran and 1 dimension and both cubes failed again (Like an idiot I didnt check the reasons for the fail)

I...

At least its not me then.

I will get that updated and pop a note in my guidance about Processs updates in Integration Services

Thank you

Debbie

Thats what I was thinking,

The only thing that worries me is the extra time it will take to process everything.

Annoying that Process Updates is so flaky.

Thanks for the advice 🙂

Debbie