SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSAS-


SSAS-

Author
Message
hpatelc
hpatelc
SSC-Enthusiastic
SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)

Group: General Forum Members
Points: 125 Visits: 313
hello

I am getting error when i am processing qube on instance . But it works fine on one instance but not on the other one.

Error is "Process failed. Trace information is still being transferred. If you do not want to wait for all of the information to arrive press Stop"

if anyone have solution please let me know so i can fix this issue.

Thanks
Hiren
richykong
richykong
Old Hand
Old Hand (374 reputation)Old Hand (374 reputation)Old Hand (374 reputation)Old Hand (374 reputation)Old Hand (374 reputation)Old Hand (374 reputation)Old Hand (374 reputation)Old Hand (374 reputation)

Group: General Forum Members
Points: 374 Visits: 621
This error really describes nothing of why the process failed. Please try waiting until you get the entire trace information.

One thing to check and make sure is that the data source for the cube is valid on this instance. Check the Connection String and Impersonation Info. If the Impersonation is set to Use Service Account, make sure the account running the Analysis Services has access to the data source.
hpatelc
hpatelc
SSC-Enthusiastic
SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)

Group: General Forum Members
Points: 125 Visits: 313
Thanks for replaying for problem
but this what i am getting if press stop.

The connection was lost. Close all processing dialog boxes and try processing the object again. (Microsoft Visual Studio)

===================================

The connection either timed out or was lost. (Microsoft.AnalysisServices)

------------------------------
Program Location:

at Microsoft.AnalysisServices.XmlaClient.EndRequest()
at Microsoft.AnalysisServices.XmlaClient.SendExecuteAndReadResponse(Boolean skipResults, Boolean throwIfError)
at Microsoft.AnalysisServices.AnalysisServicesClient.Execute(String command)
at Microsoft.AnalysisServices.Server.Execute(String command)
at Microsoft.AnalysisServices.ManagementDialogs.OlapProcessProgressContainer.ProcessObjects()

===================================

Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. (System)

------------------------------
Program Location:

at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
at Microsoft.AnalysisServices.DimeRecord.ForceRead(Stream stream, Byte[] buffer, Int32 length)
at Microsoft.AnalysisServices.DimeRecord.ReadHeader()
at Microsoft.AnalysisServices.DimeRecord..ctor(Stream stream)
at Microsoft.AnalysisServices.DimeReader.ReadRecord()
at Microsoft.AnalysisServices.TcpStream.GetResponseDataType()

===================================

An existing connection was forcibly closed by the remote host (System)

------------------------------
Program Location:

at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
richykong
richykong
Old Hand
Old Hand (374 reputation)Old Hand (374 reputation)Old Hand (374 reputation)Old Hand (374 reputation)Old Hand (374 reputation)Old Hand (374 reputation)Old Hand (374 reputation)Old Hand (374 reputation)

Group: General Forum Members
Points: 374 Visits: 621
Can you run a SQL trace on the data source? It seems like your connection to the data source is getting dropped and causing the SSAS process to error out.

Is the error happening almost immediately or after it's been running for a while? Immediate most likely means the Analysis Service instance cannot connect to the data source.
herladygeekedness
herladygeekedness
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1362 Visits: 813
sounds to me like normal verbiage on a failed process.

What you need to do when it fails is poke around in the top window to find the actual error message because nothing you have provided is it, it's just ancilliary info that I would see regardless of what error I actually generated.
hpatelc
hpatelc
SSC-Enthusiastic
SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)

Group: General Forum Members
Points: 125 Visits: 313
Hello!!!
Thanks for Replying

but i am not sure

in top window where ? i am DBA and i Dont have sound knowledge about ssas ?

Thanks
Mackers
Mackers
Say Hey Kid
Say Hey Kid (693 reputation)Say Hey Kid (693 reputation)Say Hey Kid (693 reputation)Say Hey Kid (693 reputation)Say Hey Kid (693 reputation)Say Hey Kid (693 reputation)Say Hey Kid (693 reputation)Say Hey Kid (693 reputation)

Group: General Forum Members
Points: 693 Visits: 499
When SSAS errors you will often see the error messages under the measure group or dimension (whatever has failed) that are processing at the time whether they have failed or not.

Expand all the measure groups/dimensions and look at each error message. Some of the error messages will be a generic error message as the processing has been cancelled by whatever has errored. Eventually you will find the correct error message

Clear? It is a bit of a mission and I often get my support team misinforming me due to this

Mack
herladygeekedness
herladygeekedness
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1362 Visits: 813
Sorry, I was referring to the Process Cube window ("Process Progress") that I believe is generated no matter how you attempt to process. Bottom part is all gray, shows status which is probably Process Failed for you right now.

The "top" shows the objects and their status, you are wanting to poke around up there wherever you find those dreaded red Xs.

As you traverse you may find "Operation canceled; HY0008" which is standard on a failure and not the least bit helpful. keep digging!

Eventually you will find a real, actionable error, something like "attribute key cannot be found" or "no logon servers available". It's a big pain for all the dims and facts to look like they failed, but it is generally one failure and the others are prevented from attempting.

In the lucky case where it's Attribute Key Cannot Be Found, the query is Right There, you can copy it and run it yourself.

One thing to watch for is to process your dimensions first. Process Full is supposed to do those first, but when I'm in the weeds it is almost always helpful to blow through every dimension first so that I known that an unfound attribute key error should NOT happen.
hpatelc
hpatelc
SSC-Enthusiastic
SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)

Group: General Forum Members
Points: 125 Visits: 313
i have posted snapshot error i tried everything almost but it is not showing details of error.

if you any more suggestion by seeing this snapshot

That will great help to me.....
Thanks
Attachments
analysis error.jpg (34 views, 104.00 KB)
a4apple
a4apple
Mr or Mrs. 500
Mr or Mrs. 500 (514 reputation)Mr or Mrs. 500 (514 reputation)Mr or Mrs. 500 (514 reputation)Mr or Mrs. 500 (514 reputation)Mr or Mrs. 500 (514 reputation)Mr or Mrs. 500 (514 reputation)Mr or Mrs. 500 (514 reputation)Mr or Mrs. 500 (514 reputation)

Group: General Forum Members
Points: 514 Visits: 406
hpatelc (10/16/2012)
hello

I am getting error when i am processing qube on instance . But it works fine on one instance but not on the other one.

Error is "Process failed. Trace information is still being transferred. If you do not want to wait for all of the information to arrive press Stop"

if anyone have solution please let me know so i can fix this issue.

Thanks
Hiren


Did you try to process all individual dimensions first and then process the whole cube at the end? Sometime it works. Manytimes, did for me.

Good Luck Smile .. Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search