Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

SSAS- Expand / Collapse
Author
Message
Posted Tuesday, October 16, 2012 10:51 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 6:57 AM
Points: 21, Visits: 306
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
Post #1373406
Posted Tuesday, October 16, 2012 1:08 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 9:30 AM
Points: 132, Visits: 588
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.
Post #1373485
Posted Tuesday, October 16, 2012 3:35 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 6:57 AM
Points: 21, Visits: 306

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)

Post #1373552
Posted Tuesday, October 16, 2012 4:03 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 9:30 AM
Points: 132, Visits: 588
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.
Post #1373561
Posted Wednesday, October 17, 2012 2:27 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, June 27, 2014 2:05 PM
Points: 287, Visits: 810
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.





Post #1374048
Posted Wednesday, October 17, 2012 4:18 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 6:57 AM
Points: 21, Visits: 306

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

Post #1374076
Posted Thursday, October 18, 2012 7:53 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, January 13, 2014 7:34 AM
Points: 117, 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
Post #1374375
Posted Thursday, October 18, 2012 10:04 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, June 27, 2014 2:05 PM
Points: 287, Visits: 810
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.

Post #1374475
Posted Friday, October 19, 2012 4:06 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 6:57 AM
Points: 21, Visits: 306
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


  Post Attachments 
analysis error.jpg (14 views, 104.82 KB)
Post #1375054
Posted Friday, October 19, 2012 4:53 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 5:53 PM
Points: 143, Visits: 316
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 :) .. Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles.
Post #1375059
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse