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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Requested Conversion is not supported, error while processing the partition

Posted By:      Posted Date: September 09, 2010    Points: 0   Category :Sql Server
I have read the other topics that are related this issue and I thought that my issue was related as well until I checked the datatypes of all my measures and made sure that they indeed could be inherited properly.   I even went as far as deleting all measures out the measure group and I still recieved this error.   Is there a way I get more detailed information on what is not being converted properly?  The error is so vague and again, I have thouroughly checked my datatypes and they are fine and why would the partition not process, throwing me the exact same error when I decided to take out all measures in the measure group.   Here the second strange thing, I know that it has to be data related because I also ran the process structure and that finished with success. Please let me know if there is a better way to find the problem child or problem children pertaining to my measure group when processing data Here is a last thought, do you think that it could have something to do with the datasize?  I know SSAS automatically converts the datasize and I see several in my measures that have a zero for the size, I am speculating that could be wrong but is there a way I can check the datasize by running the script on my fact table?   ThanksNetwork Analyst

View Complete Post

More Related Resource Links

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.

Object or Property is not supported in IE8 - javascript error



I am using following code line in my web app through external javascript file.






both these methods are working fine in IE6 but failing in IE8 with a error: "Object or Property is not supported".


any solution would be appreciated!



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



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,


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

Install SQL Server2005 Error:[Native Client]Encryption not supported on the client

Product: Microsoft SQL Server 2005 -- Error 29515. SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Encryption not supported on the client. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.

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

Microsoft.SharePoint.Client.File.OpenBinaryDirect - returns a 404 error if the file being requested

Hopefully someone can help with this. I'm using Sharepoint 2010. On the server I have manually created a folder in the "Shared Documents" folder called "bin" and uploaded a file into this folder If I attempt to access the files in this folder using the Microsoft.SharePoint.Client.File.OpenBinaryDirect function,  I receive the following error: A first chance exception of type 'System.Net.WebException' occurred in System.dll: System.Net.WebException: The remote server returned an error: (404) Not Found.    at System.Net.HttpWebRequest.GetResponse()    at Microsoft.SharePoint.Client.SPWebRequestExecutor.Execute()    at Microsoft.SharePoint.Client.File.OpenBinaryDirect(ClientContext context, String serverRelativeUrl). Any other files in any other folders under the shared documents folder are accessible. Here is my example code: ClientContext clientCTX = new ClientContext(SPURL);             //Pass the credentials to the client context             clientCTX.Credentials = credentials;             List DeployFilesList = clientCTX.Web.Lists.GetByTitle("Shared Documents");             CamlQuery caml

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

processing a particular partition dynamically using the AS Processing Task and Property Expressions

HI ,  Do any one have example/screenshots/article  of "processing  a particular partition dynamically using the AS Processing Task and Property Expressions..."   I have 4 reports  and 12 partitions for the report one it uses 1-4 partitions for report2 it uses 5-8 partitions,, is there any way to process the partitions dynamically , if i say report 1 it should process 1-4 partitions, report 4 it should process 9-12 partitions,     Thanks

Data missed on processing Partition

HI, I have created partition in two partition in SSAS cube, one contain data of >=getdate()-10 to <getdate()-2 while other conains >=getdate()-2 to <getdate(),,,,[[getdate() converted to date part only ]] i have created one SSIS package in which i have used "Analysis Service Processing task" and processed that partition whcih contaons >=gedate()-2 to <getdate() in Full Process mode. but i have got error which i explained you below. supoose on 20 Aug,i have data from 11 Aug to 18 aug and when i process the SSIS package ,it runs fine and update 19 August data but also eliminate the data of 17 August.   Kindly let me know if there is some mistake comiited by me or suggest.   Regards Shraddha  

processing a particular partition dynamically using the AS Processing Task and Property Expressions

HI ,  Does any one have example/screenshots/article  of "processing  a particular partition dynamically using the AS Processing Task and Property Expressions..."     Thanks

Error with database connection - API client not supported

I keep getting a weired alert on the SQL Server 2005 Box, I would appreciate if some one can assist me in this. However my application is running smoothly, just wondering if any of you have seen such an error 'Alert 1:  Critical Failure in log file for Monitor_DB: Monitor_DB: :__FAILURE__: error with database connection 'HOSTNAME\INSTANCE@master' with error message: API client not supported' I am not sure what API client is trying to connect, I have a BizTalk server which connects to the SQL Server box, and the connections and processing are going on smooth, but still I keep getting this error. Can anyone assist me. Thanks in advance.

Help to resolve an error "The conversion of a char data type to a datetime data type resulted in an

Why am I getting an error when executing this: select convert(datetime, '2010-09-12T18:11:48', 120) The message is: "Msg 242, Level 16, State 3, Line 1 The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value." I don’t get the error if I remove “T” from the string. But I need it to work with “T”.

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

Error configuration Wizard WSS3 "The Language is not supported on teh server"

The following error happens during step 2 of the Configuration Wizard.

****** Error MSG from log******
  Task configdb has failed with an unknown exception
Exception: Microsoft.SharePoint.SPException: The language is not supported on the server. ---> System.Runtime.InteropServices.COMException (0x8102005E): The language is not supported on the server.


If I start the Wizard again I now get:
Exception: System.InvalidOperationException: Windows SharePoint Services configuration infrastructure is not initialized.  You must wait until completion before joining another server to the farm.

If I delete the databases and start again I get the first error msg again. 
I have uninstalled and reinstalled WSS3  SP2 numerous times.
The DBServer is the same machine.

TFS 2010 RC is also running on this server.

Any suggestions or help would be appreciated.

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.


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:

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

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