Error when Deploying Cube

Hey guys,

Have a really strange error, I have a AS Cube designed and ready to go. Have been deploying it previosly and was erroring out due to attributes not being found in the tables. So ive worked on fixing all of them and now, i have an error message occuring and all it says is:

Server: The Operation has been cancelled.

I havnt cancelled anything, it doesnt show any more details for the error either.. Is there a log file somewhere that i can look further into?

Or has anyone had this message before? I am stumpped and now its annoying me as i was so close to having my first cube up and deployed...

Thanks in advance

Scotty

If you have made some changes in the source DB, you can try re creating the Data source and data source view and processing the dimensions and the cube after that.

|||

Are you receiving the error when you build and deploy the cube? Or does the error happenwhen you process the cube *after* deploying. If you have the Processing Options set to "default", then your cube will automatically process after each deployment.

If Processing Options are set to "default", then first set this to "do not process" (Right click on Project name to find this).

Then go into the Data Source View tab and right click anywhere in the diagram pane and select "Refresh...." This will perform some comparisons between your DSV and your relational database.

At this point, you can start processing your cube. What I would do at this point is select all the dimensions and process them first. If you see any errors, look at the error messages and backtrack until they are all corrected. Keep in mind that because your dimensions are being processed in parallel any error will cause any dimensions that are still being processed to stop and they will display a "canceled" message.

One you get the dimensions processed then start processing the partitions.

This is somewhere tedius, but if you haven't been keeping the relational database and your cube structure in synch, you'll have to take the time to do it now.

Hope this helps,

Pam

|||

Thanks Pam, I am receiving the error when i am deploying the cube. Building the cube works fine.

I will go through your instructions and see if it works. i am thinking you are right as i have been changing one particular table,. keeping all the columns names the same, but the problem started happening after i did this..

Ill let you know how i go in a couple of minutes..

Once again,,thanks.. this place in invaluable for advice!!

|||

Pam,

I went through and did what you suggested. Everything processed correctly to i go to the partition and tried to process that. This is where i got the message : Server: The Operation has Been Cancelled.

Any ideas on this? Should i try to create a new partition? if so, can i base if of the old one? I havnt done much with partitions yet as im pretty new to SSAS but im willing to read up on it if need be..

Thanks

Scotty

|||

hi guys,

Even i have error while deploying the cube

Error is as follows:

Error 1 The project could not be deployed to the "Server name" server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server.

but the server was working fine..

i didnt get what excatly was the error

could any help me out

lalitha

|||

Hi
I am getting the same error while running the MDX. The query uses subcube. Query runs ok when there is less data BUT it gives me error "Server: The operation has been cancelled." there is large amount of data.
Thanks in advance!
Rakesh

|||Looks like its a perfomance issue. long-running queries can lock the system as a whole. |||When I highlight a few partitions and start processing, the process occasionally stops with a message that operation has been canceled, like this:

Response 3
Server: the operation has been cancelled.
Response 4

Server: the operation has been cancelled.

Response 5
Server: the operation has been cancelled.

..etc...

(no further error message details are provided)
SQL profiler shows that batch was completed (but rowcount shown in process progress log is too small).
Analysis Services profiler shows no messages at that time at all. It just shows messages when it started, and when I restarted the processing.

This is an occasional error and sometime occurs within 15-20 minutes from starting to process. It could fail on 1st partition in the process list , or on some partition in the middle. Some partitions might run for a few hours and not error out, but sometimes it fails quickly.

Also looks like the profiler (engine and ssas) are not working correctly - they are skipping messages (not capturing or not showing). I do not have any filters on the Profiler.

Error when Deploying Cube

Hey guys,

Have a really strange error, I have a AS Cube designed and ready to go. Have been deploying it previosly and was erroring out due to attributes not being found in the tables. So ive worked on fixing all of them and now, i have an error message occuring and all it says is:

Server: The Operation has been cancelled.

I havnt cancelled anything, it doesnt show any more details for the error either.. Is there a log file somewhere that i can look further into?

Or has anyone had this message before? I am stumpped and now its annoying me as i was so close to having my first cube up and deployed...

Thanks in advance

Scotty

If you have made some changes in the source DB, you can try re creating the Data source and data source view and processing the dimensions and the cube after that.

|||

Are you receiving the error when you build and deploy the cube? Or does the error happenwhen you process the cube *after* deploying. If you have the Processing Options set to "default", then your cube will automatically process after each deployment.

If Processing Options are set to "default", then first set this to "do not process" (Right click on Project name to find this).

Then go into the Data Source View tab and right click anywhere in the diagram pane and select "Refresh...." This will perform some comparisons between your DSV and your relational database.

At this point, you can start processing your cube. What I would do at this point is select all the dimensions and process them first. If you see any errors, look at the error messages and backtrack until they are all corrected. Keep in mind that because your dimensions are being processed in parallel any error will cause any dimensions that are still being processed to stop and they will display a "canceled" message.

One you get the dimensions processed then start processing the partitions.

This is somewhere tedius, but if you haven't been keeping the relational database and your cube structure in synch, you'll have to take the time to do it now.

Hope this helps,

Pam

|||

Thanks Pam, I am receiving the error when i am deploying the cube. Building the cube works fine.

I will go through your instructions and see if it works. i am thinking you are right as i have been changing one particular table,. keeping all the columns names the same, but the problem started happening after i did this..

Ill let you know how i go in a couple of minutes..

Once again,,thanks.. this place in invaluable for advice!!

|||

Pam,

I went through and did what you suggested. Everything processed correctly to i go to the partition and tried to process that. This is where i got the message : Server: The Operation has Been Cancelled.

Any ideas on this? Should i try to create a new partition? if so, can i base if of the old one? I havnt done much with partitions yet as im pretty new to SSAS but im willing to read up on it if need be..

Thanks

Scotty

|||

hi guys,

Even i have error while deploying the cube

Error is as follows:

Error 1 The project could not be deployed to the "Server name" server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server.

but the server was working fine..

i didnt get what excatly was the error

could any help me out

lalitha

|||

Hi
I am getting the same error while running the MDX. The query uses subcube. Query runs ok when there is less data BUT it gives me error "Server: The operation has been cancelled." there is large amount of data.
Thanks in advance!
Rakesh

|||Looks like its a perfomance issue. long-running queries can lock the system as a whole. |||When I highlight a few partitions and start processing, the process occasionally stops with a message that operation has been canceled, like this:

Response 3
Server: the operation has been cancelled.
Response 4

Server: the operation has been cancelled.

Response 5
Server: the operation has been cancelled.

..etc...

(no further error message details are provided)
SQL profiler shows that batch was completed (but rowcount shown in process progress log is too small).
Analysis Services profiler shows no messages at that time at all. It just shows messages when it started, and when I restarted the processing.

This is an occasional error and sometime occurs within 15-20 minutes from starting to process. It could fail on 1st partition in the process list , or on some partition in the middle. Some partitions might run for a few hours and not error out, but sometimes it fails quickly.

Also looks like the profiler (engine and ssas) are not working correctly - they are skipping messages (not capturing or not showing). I do not have any filters on the Profiler.

Error when Deploying Cube

Hey guys,

Have a really strange error, I have a AS Cube designed and ready to go. Have been deploying it previosly and was erroring out due to attributes not being found in the tables. So ive worked on fixing all of them and now, i have an error message occuring and all it says is:

Server: The Operation has been cancelled.

I havnt cancelled anything, it doesnt show any more details for the error either.. Is there a log file somewhere that i can look further into?

Or has anyone had this message before? I am stumpped and now its annoying me as i was so close to having my first cube up and deployed...

Thanks in advance

Scotty

If you have made some changes in the source DB, you can try re creating the Data source and data source view and processing the dimensions and the cube after that.

|||

Are you receiving the error when you build and deploy the cube? Or does the error happenwhen you process the cube *after* deploying. If you have the Processing Options set to "default", then your cube will automatically process after each deployment.

If Processing Options are set to "default", then first set this to "do not process" (Right click on Project name to find this).

Then go into the Data Source View tab and right click anywhere in the diagram pane and select "Refresh...." This will perform some comparisons between your DSV and your relational database.

At this point, you can start processing your cube. What I would do at this point is select all the dimensions and process them first. If you see any errors, look at the error messages and backtrack until they are all corrected. Keep in mind that because your dimensions are being processed in parallel any error will cause any dimensions that are still being processed to stop and they will display a "canceled" message.

One you get the dimensions processed then start processing the partitions.

This is somewhere tedius, but if you haven't been keeping the relational database and your cube structure in synch, you'll have to take the time to do it now.

Hope this helps,

Pam

|||

Thanks Pam, I am receiving the error when i am deploying the cube. Building the cube works fine.

I will go through your instructions and see if it works. i am thinking you are right as i have been changing one particular table,. keeping all the columns names the same, but the problem started happening after i did this..

Ill let you know how i go in a couple of minutes..

Once again,,thanks.. this place in invaluable for advice!!

|||

Pam,

I went through and did what you suggested. Everything processed correctly to i go to the partition and tried to process that. This is where i got the message : Server: The Operation has Been Cancelled.

Any ideas on this? Should i try to create a new partition? if so, can i base if of the old one? I havnt done much with partitions yet as im pretty new to SSAS but im willing to read up on it if need be..

Thanks

Scotty

|||

hi guys,

Even i have error while deploying the cube

Error is as follows:

Error 1 The project could not be deployed to the "Server name" server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server.

but the server was working fine..

i didnt get what excatly was the error

could any help me out

lalitha

|||

Hi
I am getting the same error while running the MDX. The query uses subcube. Query runs ok when there is less data BUT it gives me error "Server: The operation has been cancelled." there is large amount of data.
Thanks in advance!
Rakesh

|||Looks like its a perfomance issue. long-running queries can lock the system as a whole. |||When I highlight a few partitions and start processing, the process occasionally stops with a message that operation has been canceled, like this:

Response 3
Server: the operation has been cancelled.
Response 4

Server: the operation has been cancelled.

Response 5
Server: the operation has been cancelled.

..etc...

(no further error message details are provided)
SQL profiler shows that batch was completed (but rowcount shown in process progress log is too small).
Analysis Services profiler shows no messages at that time at all. It just shows messages when it started, and when I restarted the processing.

This is an occasional error and sometime occurs within 15-20 minutes from starting to process. It could fail on 1st partition in the process list , or on some partition in the middle. Some partitions might run for a few hours and not error out, but sometimes it fails quickly.

Also looks like the profiler (engine and ssas) are not working correctly - they are skipping messages (not capturing or not showing). I do not have any filters on the Profiler.

Error selecting text from a SQL database

Hello,
I have an application that used an access database and I am currently
migrating to SQL Server. The software is designed to use Odbc object
found in the .Net framework version 1.1. I have a simple select
statement that is driving me nuts. It works fine with the Access
databases but dies under SQL Server.
The statement is:
SELECT
settingValue
FROM
tblSettings
WHERE ( owner=@.owner and setting=@.setting )
settingValue is an ntext field and owner and setting are varchar fields.
When I try to execute the query I get an error:
ERROR [42000][Microsoft][ODBC SQL Server Driver][SQL Server]The text,
ntext, and image data types cannot be compared or sorted, except when
using IS NULL, or LIKE operator.
There are no indexes on any of the fields so I cannot figure out what
the problem is.
Mageos
Try this to see if you still get an error:
SELECT
owner,
setting,
settingValue
FROM
tblSettings
WHERE owner = @.owner
and setting=@.setting
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"mageos" <matt.dot.osborne@.cox.dot.com> wrote in message
news:vbGyd.2281$wZ2.581@.newssvr13.news.prodigy.com ...
> Hello,
> I have an application that used an access database and I am currently
> migrating to SQL Server. The software is designed to use Odbc object
> found in the .Net framework version 1.1. I have a simple select
> statement that is driving me nuts. It works fine with the Access
> databases but dies under SQL Server.
> The statement is:
> SELECT
> settingValue
> FROM
> tblSettings
> WHERE ( owner=@.owner and setting=@.setting )
> settingValue is an ntext field and owner and setting are varchar fields.
> When I try to execute the query I get an error:
> ERROR [42000][Microsoft][ODBC SQL Server Driver][SQL Server]The text,
> ntext, and image data types cannot be compared or sorted, except when
> using IS NULL, or LIKE operator.
> There are no indexes on any of the fields so I cannot figure out what
> the problem is.
> Mageos
|||> settingValue is an ntext field and owner and setting are varchar fields.
> When I try to execute the query I get an error:
> ERROR [42000][Microsoft][ODBC SQL Server Driver][SQL Server]The text,
> ntext, and image data types cannot be compared or sorted, except when
> using IS NULL, or LIKE operator.
The error tells you exactly where the problem is. You are trying to do a
compare on an ntext field. Double check your create table statement. I think
you will find that either owner or setting is not of the datatype you
expected. What method of creating the tables in SQL did you use. I find that
often when I let SQL help me out converting data from an outside source, it
comes up with insane assumptions about what the datatype needs to be.
I tried reproducing the error with the script below and it works fine for
me.
create table test(
settingvalue ntext,
owner varchar(5),
setting varchar(5)
)
insert test (settingvalue, owner, setting)
values ('jgdfkjgiugsv8ohyohfef mne hevbe vmnerv', '1', '2')
declare @.owner varchar(5)
declare @.setting varchar(5)
set @.owner = '1'
set @.setting ='2'
select * from test where owner = @.owner and setting = @.setting