Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

OLAP Cube processing error

Status
Not open for further replies.

Bryant

Programmer
Apr 12, 2000
1
US
I am having a problem with a DTS job that updates an OLAP cube. The job excutes properly from the DTS Designer and by running it from Enterprise Manager but fails with the following error when run from SQLAgent.<br><br><br>DTSRun:&nbsp;&nbsp;Loading...<br>DTSRun:&nbsp;&nbsp;Executing...<br>DTSRun OnStart:&nbsp;&nbsp;DTSStep_DTSOlapProcess.Task_1<br>DTSRun OnError:&nbsp;&nbsp;DTSStep_DTSOlapProcess.Task_1, Error = -2146828081 (800A00CF)<br>&nbsp;&nbsp;&nbsp;Error string:&nbsp;&nbsp;The ring 2 stack is in use.<br>&nbsp;&nbsp;&nbsp;Error source:&nbsp;&nbsp;Microsoft Data Transformation Services (DTS) Package<br>&nbsp;&nbsp;&nbsp;Help file:&nbsp;&nbsp;sqldts.hlp<br>&nbsp;&nbsp;&nbsp;Help context:&nbsp;&nbsp;700<br>Error Detail Records:<br>Error:&nbsp;&nbsp;-2146828081 (800A00CF); Provider Error:&nbsp;&nbsp;0 (0)<br>&nbsp;&nbsp;&nbsp;Error string:&nbsp;&nbsp;The ring 2 stack is in use.<br>&nbsp;&nbsp;&nbsp;Error source:&nbsp;&nbsp;Microsoft Data Transformation Services (DTS) Package<br>&nbsp;&nbsp;&nbsp;Help file:&nbsp;&nbsp;sqldts.hlp<br>&nbsp;&nbsp;&nbsp;Help context:&nbsp;&nbsp;700<br>Error:&nbsp;&nbsp;-2147467259 (80004005); Provider Error:&nbsp;&nbsp;0 (0)<br>&nbsp;&nbsp;&nbsp;Error string:&nbsp;&nbsp;Server initializing Level 'Agent Number' (final)<br>&nbsp;&nbsp;&nbsp;Error source:&nbsp;&nbsp;Agent Number<br>&nbsp;&nbsp;&nbsp;Help file:&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp;Help context:&nbsp;&nbsp;1000207<br>DTSRun OnFinish:&nbsp;&nbsp;DTSStep_DTSOlapProcess.Task_1<br>DTSRun:&nbsp;&nbsp;Package execution complete.<br><br><br>The platform is NT 4 Server SP6, SQL 7.0 SP1, OLAP w/SP1.<br><br>Any ideas would be greatly appreciated.<br><br>Thanks for your consideration.<br><br>G. Bryant McClellan<br>Sr. Systems Technical Analyst<br>North American Van Lines<br><A HREF="mailto:bryant_mcclellan@navlmail.com">bryant_mcclellan@navlmail.com</A>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top