Showing posts with label cubes. Show all posts
Showing posts with label cubes. Show all posts

Thursday, March 29, 2012

Deserialization Failed - Microsoft Analysis Service


Hi Everyone,

I'm using Microsoft Analysis Service-2005. When I'm trying to open the database which contains 4 cubes and 10 dimensions, I'm getting the following error.

Deserialization Failed - Property not accessible because 'Parent columns
and Child columns don't have type -matching columns'.(Microsoft Analysis Service)

The system is not allowing me to open the cube so I'm unable to fix the issue.

All your suggestions would be highly appreciated.

Thanks,

Selva


Hello. Have you successfully built a parent-child dimension in BIDS that is processed and browsable? Both the parent column and the child-column have the same data types?

If this is the case you have either a problem with the join between the parent-child table and the fact table in the data source view or the join in the dimension usages tab in the cube editor.

Have you made a collection of the parent key(more than one column as the key) och child key in the dimension editor in an existing parent-child dimension? If so you would have to make a change in the dimension usage tab(where you join dimensions and measure groups), in the cube editor to reflect that?

Check this and return if the problem is not solved.

HTH

Thomas Ivarsson

Wednesday, March 21, 2012

Deployment Error with AS2005

Hey guys,

Love this forum, it has helped so much so far!!

Im new to using Analysis services, although i have experience with OLAP cubes. I have desinged my own cube and when i go to deploy it to the analysis server, i am getting the following errors: Could anyone please help me out!!! I think the errors 2-4 relate back to the first error. I have tried searching MSDN and Google, but i cannot find anything!!!

Thanks.. Scotty

Error 1 Errors in the high-level relational engine. The following exception occurred while the managed IDbConnection interface was being used: Could not load file or assembly 'System.Transactions, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. Access is denied.. 0 0

Error 2 Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Movex', Name of 'Movex'. 0 0


Error 3 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'System Calendar', Name of 'System Calendar' was being processed. 0 0


Error 4 Errors in the OLAP storage engine: An error occurred while the 'Year' attribute of the 'System Calendar' dimension from the 'Gates Australia Sales Analysis' database was being processed. 0 0


What provider are you using to connect to relational database?

What is your relataional database? What version?

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||I met the same problem as your Error 2. After I changed the data source properties > connection string and point to the correct server name, i managed to process all my cubes sql

Deployment Error with AS2005

Hey guys,

Love this forum, it has helped so much so far!!

Im new to using Analysis services, although i have experience with OLAP cubes. I have desinged my own cube and when i go to deploy it to the analysis server, i am getting the following errors: Could anyone please help me out!!! I think the errors 2-4 relate back to the first error. I have tried searching MSDN and Google, but i cannot find anything!!!

Thanks.. Scotty

Error 1 Errors in the high-level relational engine. The following exception occurred while the managed IDbConnection interface was being used: Could not load file or assembly 'System.Transactions, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. Access is denied.. 0 0

Error 2 Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Movex', Name of 'Movex'. 0 0


Error 3 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'System Calendar', Name of 'System Calendar' was being processed. 0 0


Error 4 Errors in the OLAP storage engine: An error occurred while the 'Year' attribute of the 'System Calendar' dimension from the 'Gates Australia Sales Analysis' database was being processed. 0 0


What provider are you using to connect to relational database?

What is your relataional database? What version?

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||I met the same problem as your Error 2. After I changed the data source properties > connection string and point to the correct server name, i managed to process all my cubes

Friday, March 9, 2012

Deploying multiple projects

Is it possible to deploy multiple Analysis Services projects into one OLAP database, or you have to create all cubes into same project?

Thanks from answers!

Peter

Hello. The problem is that you will overwrite the existing cubes and other objects with the latest project that you deploy to an existing database. I think the answere is no.

Regards

Thomas Ivarsson

|||

Jeah, that is problem, but I thought there is trick, so unfortunately there isn't..

Thanks.

|||

If it would work you could have problems with name collisions like dimensions with the same name. I also tried copy paste from one project in BIDS to another, still without any luck.

Regards

Thomas Ivarsson

Saturday, February 25, 2012

deploy/ process cube issue

Hi,

I'm having difficulty to deploy and process cubes to the differenct server now.

It may be caused by our internal server problem but before checking that, please advice the following issue:

(To deploy and process cubes to local machine, and differenct server works perfectly previously. This problem just started few days ago.)

If I delopy and process the cube to the localhost then it works fine.

I also ran the sql profiler and trace the process.

But in my local machine, in BIDS if I change the target server and process cubes to the different server then

it just start deploying but keep running and never ending.

Also, I've tried to remote the target server and process cube in server machine while tracing that process.

The thing is every single process works fine but it's not ending. In trace file, I can see " finished processing cube"

But, cube process keeps running and I couldn't see " command end" eventclass in trace file.

Right now, we reload data into another fact table in test server , not production server. ( cube is in production)

but is ther any possibility to affect the cube processing?

Other then that, I have no idea why this happens.

I would appreciate if anybody can give me some advise.

Thanks.

FYI,

I've talked to another developer who are working on ETL now, and he told me that he've truncated some data in exisiting table and reloaded data. And also,he and did some changes in table structures and reload the data into another new fact table.

Does it matter to deploy and process the cube ?

(I'm guessing that table structure won't affect the processing issue since it will give an error before deploying, if it causes the table relationship or attibutes changes.)

/**

Now, I've taken small portion of the cube structure and create new project and deploy to the different server and it works perfectly. But is this the only way to solve this problem? Any suggestion?

Please let me know.

Thanks.

|||

We've occassionally had this same problem. It appears that the files that contain the cube and dimension data sometimes become corrupt. When you process the cube, all the data is written to a second set of files. There is then a drop/rename type of activitythat swaps out the new files in place of the old files. It's the swapping of files that you are waiting for.

Recommendation is to drop existing cube altogether, redeploy structure, and then reprocess. Very likely that everything will correctly at that point.

In fact, you're already seeing that your new project/cube are working correctly on the same server.

Hope this helps,

Pam W.

|||

Thanks for your valuable information.

could you tell me what exact file do I need to drop? All cube files (*.cube and *.partition) ?

What else do I need to take a look?

I've also tried to use ' deployment wizard' and overwrite xmla script and it's showing successful depolyment.

But processing still doesn't work.

I've tried to drop cube file and to rebuild the cube but it's just giving an error and can't process cubes.

I would approciate if you can give me more details in regards to fixing this problem.

Please let me know.

Thanks.

|||

I've just tried to create new database into the target server and redeploy cubes with new db then it works now.

It seems file is corrupted but still doesn't understand well. (I followed your recommendation but it doesn't work)

Anyway, thanks for your recommendation.

If anybody has a similar situation and can give some comments then I would greatly appreciate it.

Thanks.

deploy/ process cube issue

Hi,

I'm having difficulty to deploy and process cubes to the differenct server now.

It may be caused by our internal server problem but before checking that, please advice the following issue:

(To deploy and process cubes to local machine, and differenct server works perfectly previously. This problem just started few days ago.)

If I delopy and process the cube to the localhost then it works fine.

I also ran the sql profiler and trace the process.

But in my local machine, in BIDS if I change the target server and process cubes to the different server then

it just start deploying but keep running and never ending.

Also, I've tried to remote the target server and process cube in server machine while tracing that process.

The thing is every single process works fine but it's not ending. In trace file, I can see " finished processing cube"

But, cube process keeps running and I couldn't see " command end" eventclass in trace file.

Right now, we reload data into another fact table in test server , not production server. ( cube is in production)

but is ther any possibility to affect the cube processing?

Other then that, I have no idea why this happens.

I would appreciate if anybody can give me some advise.

Thanks.

FYI,

I've talked to another developer who are working on ETL now, and he told me that he've truncated some data in exisiting table and reloaded data. And also,he and did some changes in table structures and reload the data into another new fact table.

Does it matter to deploy and process the cube ?

(I'm guessing that table structure won't affect the processing issue since it will give an error before deploying, if it causes the table relationship or attibutes changes.)

/**

Now, I've taken small portion of the cube structure and create new project and deploy to the different server and it works perfectly. But is this the only way to solve this problem? Any suggestion?

Please let me know.

Thanks.

|||

We've occassionally had this same problem. It appears that the files that contain the cube and dimension data sometimes become corrupt. When you process the cube, all the data is written to a second set of files. There is then a drop/rename type of activitythat swaps out the new files in place of the old files. It's the swapping of files that you are waiting for.

Recommendation is to drop existing cube altogether, redeploy structure, and then reprocess. Very likely that everything will correctly at that point.

In fact, you're already seeing that your new project/cube are working correctly on the same server.

Hope this helps,

Pam W.

|||

Thanks for your valuable information.

could you tell me what exact file do I need to drop? All cube files (*.cube and *.partition) ?

What else do I need to take a look?

I've also tried to use ' deployment wizard' and overwrite xmla script and it's showing successful depolyment.

But processing still doesn't work.

I've tried to drop cube file and to rebuild the cube but it's just giving an error and can't process cubes.

I would approciate if you can give me more details in regards to fixing this problem.

Please let me know.

Thanks.

|||

I've just tried to create new database into the target server and redeploy cubes with new db then it works now.

It seems file is corrupted but still doesn't understand well. (I followed your recommendation but it doesn't work)

Anyway, thanks for your recommendation.

If anybody has a similar situation and can give some comments then I would greatly appreciate it.

Thanks.

Sunday, February 19, 2012

Deploy Cubes

Hi

I want to deploy a complete analysis db (with the cubes and dimension) to another server. As I have learned it is possible to use backup and restore. But with this method also the data is transferred which is quite a headache when the cubes are already processed and contain a lot of data. Is it possible to just export the definition. Btw: It's analysis services 2000.

Thanks in advance

Thomas

Nobody?

Your answer would be greatly appreciated.

Thomas

|||

I think copy-paste in Analysis Manager would do the trick.

B.

|||

Hi Brian

Thanks for your reply. I will try it.

But one question to that. Copy paste method is not very friendly in a bigger scenario, where one developer creates the cubes and some companies on other location will use it. Also backup is not possible this way.

What are the methods to achieve this?

Regards

Thomas

|||

The options with AS 2000 are pretty weak. You can either backup & restore or copy-paste & reprocess. One variation is to backup an empty database, restore it, then reprocess.

In 2005, you can migrate changes through scripts. Some change will require reprocessing, but many do not.


B.

|||

Ok, thanks a lot.

Regards

Thomas

deploy Cube to production server?

Hello,
how can I deploy the changes of cubes / dimensions from development to the production server?
cheers
Tobias

Hi,

You can first archive (export) CAB with cubes from the development server and then restore it on the production server.

Remember to process all the cubes before exporting them.

You can use the msmdarch.exe program (it is located in the Analysis Services / BIN folder) or do the export/import directly from the Analysis Manager.

Hope, this helps

Best regards

Ewa