Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
prithu12
Starting Member
1 Post |
 Posted - 2002-08-21 : 14:08:08
|
| Hi, I am running OLAP Services 7.0 (SP3)and my SQL Server is 7.0 (SP4). I am able to process all the cubes and browse the data from OLAP Manager. I designed a package to process the OLAP cubes and when I try to execute the package, it fails with the following error message.CubeNameHResult of 0x800400ce (-2147221298) returnedUnexpected error occurred. An error result was returned without an error message. This HResult code refers to error number 206 (Process operation failed) as per the KB article (Q256178)http://support.microsoft.com/default.aspx?scid=kb;en-us;Q256178I have configured my SQLServerAgent to run in the security context of a user who's a member of OLAP Administrators group. The owner of the package is Administrator of the Domain.Any help is appreciated.ThanksPriya |
|
|
ksw
Starting Member
24 Posts |
Posted - 2002-08-23 : 18:17:41
|
| Have you read the KB article Q263871? Also, I don't know what the error would be from DTS for this, but if you've migrated your OLAP repository into SQL Server, make sure that the login you are using has permissions to the new database. In the OLAP Manager, you'd get something like "Could not open repository."--KSW |
 |
|
|
|
|
|
Urgent - DTS for OLAP task fails