Hi

Hi

I have a package executed by SQLSERVER agent.It was executing fine over
months now.It has failed over weekend with message.

Executed as user: DTSRun: Loading... DTSRun: Executing... DTSRun
OnStart: DTSStep_DTSOlapProcess.Task_1 DTSRun OnError:
DTSStep_DTSOlapProcess.Task_1, Error = -2147221416 (80040058)
Error string: Process Canceled Error source: DSO Help file:
Help context: 1000440 Error Detail Records: Error: 0
(0); Provider Error: 0 (0) Error string: Process Canceled
Error source: DSO Help file: Help context: 1000440
DTSRun OnFinish: DTSStep_DTSOlapProcess.Task_1 DTSRun: Package
execution complete. Process Exit Code 1. The step failed.

Thanks in advance

Regards

USha

Hello usha,

Well it is your OLAP Processing task that is failing. A quick google for
this error would suggest it may have to do with illegal characters in your
data. Could this be true?



Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

Hi Allan,
Thanks Allan
Its OLAP Processing-Cube processing job that has failed.I was able
process it manually.
In the error string it says Process Cancelled.So I dont think its
illegal characters...
Regards
Usha


Allan Mitchell wrote: