.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
abhays
Clintonzz
arronlee
mattyclown
cathyhill345
Post New Web Links

Error Processing Cube

Posted By:      Posted Date: November 20, 2010    Points: 0   Category :Sql Server
 

I get the following error when attempting to process the cube:

OLE DB error: OLE DB or ODBC error: Protocol error in TDS stream; HY000; Communication link failure; 08S01; TCP Provider: An existing connection was forcibly closed by the remote host. ; 08S01;

I tried changing the data source connection type to use .Net ODBC then I get this error.

Errors in the high-level relational engine. The following exception occurred while the managed IDataReader interface was being used: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)

It is taking approximately 2 hours to process, all the dimensions process ok, the error is thrown after it starts the cube.

Any ideas?

 

Thanks in advance.

 




View Complete Post


More Related Resource Links

Cube Processing Error

  
Hi All when i process the cube some times i get the error  "OLE DB or ODBC  Error: Operation Cancelled; HY008. Internal Error: The Operation Terminated unsuccessfully  " https://connect.microsoft.com/SQLServer/feedback/details/286505/error-in-processing-cube?wa=wsignin1.0 In above link Microsoft they said to increase Query time out, i made it 0 even it repros I am using SQL Server 2008.   Thanks

Error while processing the cube

  
Hi All,  I am trying to execute a cube using the xml script. Below is the error what I am facing.   Message Executed as user: NT AUTHORITY\NETWORK SERVICE. ...s="http://schemas.microsoft.com/analysisservices/2003/xmla-multipleresults"><root xmlns="urn:schemas-microsoft-com:xml-analysis:empty"><Exception xmlns="urn:schemas-microsoft-com:xml-analysis:exception" /><Messages xmlns="urn:schemas-microsoft-com:xml-analysis:exception"><Error ErrorCode="3238002695" Description="Internal error: The operation terminated unsuccessfully." Source="Microsoft SQL Server 2008 Analysis Services" HelpFile="" /><Error ErrorCode="3238002695" Description="Internal error: The operation terminated unsuccessfully." Source="Microsoft SQL Server 2008 Analysis Services" HelpFile="" /><Error ErrorCode="3238395904" Description="OLE DB error: OLE DB or ODBC error: [DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation.; 08S01." Source="Microsoft SQL Server 2008 Analysis Services" HelpFile="" /><Error ErrorCode="3240034316" Description="Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'IA DIST VEH VOL A1', Name of

0x80040154 error processing a cube from SQL Server 2008 R2 x64 database engine to OLAP Server 2000 x

  

I recently upgrade from SQL Server 2000 x32 to SQLServer 2008 R2 x64 but only the database engine not the Analysis Server, I used to use this code to proces the cubes.

http://weblogs.sqlteam.com/jeffs/archive/2008/10/27.aspx

but now it do not  work more with the error:
Error at create server:
Error      Source                    Description          HelpFile HelpID
---------- ------------------------- -------------------- -------- -----------
0x80040154 ODSOLE Extended Procedure  Clase no registrada NULL     0

(1 row(s) affected)

I found this article:
http://support.microsoft.com/kb/932872

It means that I can not process the cube using the same method any more ?


there was an error processing the request

  

 Hi, I implement a project which has a ajax plus web service. It works out on IDE VS 2008 Express.

Now I host it on a free space, get an error "there was an error processing the request".

The error type is empty.

Any experience is thankful.


Nintex Workflow Error: No workflows are waiting for a BizTalk message [...] No processing has been d

  

Hi,

I created a Workflow with Nintex Workflow 2007 (on SharePoint 2007) to send/receive data to BizTalk 2009. It worked fine already. But now I get the following error mesage in the EventViewer:

Nintex Workflow; Build: 11000 (http://ls457/_layouts/nintexworkflow/BiztalkHandler.ashx)
No workflows are waiting for a BizTalk message with message Id of 'GeneralAccessRequest_2010-08-23T15_00_04_44961212B370C554EDFAC41C1201ED6CEFB' on teamsite http://ls457/sites/testapp. No processing has been done.

What could that mean? Any ideas? I definitely changed nothing on the orchestration or BizTalk administration. The BizTalk action sends the data correctly to it's destination (database), but it seems that nintex doesn't receive any return data. I don't think it's a BizTalk problem, because in the BizTalk Message Tracking Database the Message is listet, so it has been sent correctly by BizTalk. But the handler probably has problems to find/receive this message.

Kind regards,

Markus

Getting Below error while accessing SQL server cube

  
Getting Below error while accessing SQL server cube   Error Generating Drop Down Values   Odbc driver returned an error (SQLExecDirectW).   Error Details Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. URL: http://SIMAPPWQS99/olap/msmdpump.dll. The http return status is 503. The service is unavailable. (HY000) SQL Issued: SELECT "- AppReceivedTimeYQMDD"."Year" FROM "Medicare E2E Tracking" ORDER BY 1

OLE DB Error: Network-Related or Instance-Specific while Deploying SSAS 2008 Cube

  
Hi, I encountered the below listed error while attempting to deploy SSAS 2008 DB: Error 1 OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Named Pipes Provider: Could not open a connection to SQL Server [5]. ; 08001.  0 0  I am running a standalone MSSQL 2008 named instance on Windows Server 2008 R2. Here are the steps I have taken but yet the issue is not resolve: 1) Enable Remote connections on the server 2) Enable TCP\IP 3) SQL Browser is Running 4) Set Firewall Inbound Exceptions for SQL Browser, Default Port 1433, UDP Port 1434 5) Using Management Studio I can successfully connect to the MSSQL named instance from the app server 6) I can ping I MSSQL box from the app server 7) Read and implemented all steps in the MSDN post below: http://blogs.msdn.com/b/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx Thanks for your help.

Problem in Cube processing

  
Hi All, I have created cube and processed with the setting "Stop Logging",and it would take 30 min to complete processing with the error shown  Error in Olap storage engine The attribute key cannot found when processing table "Factcalldata", column programid,value 7070.the attribute is Programid.   Kindly let me know is this is the reason which is responsible for Longer processing Time ,i have created partition and aggregation in all measure groups.   Regards Amit  

Cube processing

  
HI All, I am new to SSAS and but i suppose to work on cube part. I have created cube with two partition both of 5 days using getdate()-10 to getdate()-5  and getdate (4) to getdate() ,,,,so tel me if i process full cube once and then other partition in full process,then will the 5 day process data overite the full data into 5 day data or not.   regards Shraddha

AdomdDataAdapter.Fill returns memory error when querying an SSAS Cube(2008)

  
For certain SQL's I will get the following error when calling the Fill method on an AdomdDataAdapter object. "Memory error: While attempting to store a string, a string was found that was larger than the page size selected. The operation cannot be completed."   Snippet of Code: DataSet ds1 = new DataSet(); AdomdCommand acmd1 = cn1.CreateCommand(); acmd1.CommandText = "SELECT ..."; AdomdDataAdapter ad1 = new AdomdDataAdapter(acmd1); ad1.Fill(ds1);   Now when we run this query in Ms Sql Studio we don't get any errors but the query returns 1 row with over 40,000 columns. I'm guessing the # of columns might be an issue but not sure.   When doing a Google search it appears that this problem was found in the 2005 and fixed in that version. Have any of you come across this problem?  

processing measure group : memory error : the operation cannot be completed because the memory quota

  
Hi, I'm stucked with this problem. Untill last week, the cube processed without any problem. Since last week, I'm getting this error. I have been searching in different forums, and I tried some suggestions, like changing memory limit properties, ... It is getting worse.. So I reset all properties to default again. I am running SQL-Server + MS-AS 2005 SP2 on server with 4GB of memory. This is a dedicated server, nothing else is running on it. The fact table has +/- 14 million records, several dimensions en 2 measure groups. I don't have problems to process the dimensions, but when I try to process the cube or the measure groups of that cube separately , the error persists. I have changed the datasource view, and replaced the fact table by a Named query. Even when I put a 'WHERE datapart( year , fact_date ) >= 2009 ' clause to reduce the number of records to +/- 5 million, I'm still getting the error. I don't understand what is wrong, the cube always processed since +/- 2 years. As I said, I have found a lot of this kind of Issues on different websites, I have been trying to change some properties. But this still does not solve the problem. Could it be that MS-AS settings are corrupt somewhere ? Is it a good idea to re-install MS-AS 2005 + SP1 + SP2 ? Or is there another reason possible ? I really appreciate any kind of help, because I'm

Cube Processing

  
Hi all, I have a cube and it is processed every 6 hours. 3 different process calls the SSIS package through SQL Server Agent to process the cube, and they all may call the SSIS package at the same time. But for that I set an Indicator which tells the cube is processing and it waits for a minute and re-checks it and then processes the cube. My problem here is while the cube is processing other ETL jobs might update/delete/insert the data into Fact Tables. What will happen when cuube is processing and these things are done simulatneously. Can anyone explain what will be the possible outcome. Thanks Vineeshvineesh1701

Error while Report Processing :

  
Hi Friends,               In client report server i have deployed reports. I have given access to around five people. Some times the report executes fine but some times it throws error sayingAn error occurred during client rendering.An error has occurred during report processing.Query execution failed for dataset 'dataset name'.For more information about this error navigate to the report server on the local server machine, or enable remoteI have tried all the possibilities that i know, but still the error persists.I am generating a parameterized report. The data is being loaded through a stored procedure. Can any one please shed some light on this issue. In developer machine it is working fine only in client network i am facing this issue.Database : SQL 2000SQL Report Server : 2008Any help would be appreciated.Regards,Anish 

Out of memory error during processing of OLAP database

  
Hello We have a problem with processing our customer's database. When we use processing in one transaction, processing often fails with out of memory error. This doesn't happen if we use seperate transactions for each processed object. Is there any way, how to predict (count) necessary memory, needed for processing the OLAP db?   Thanks a lot!!!   Martin Honajzer
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend