Invalid processing option | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Invalid processing option

I am processing OLAP cubes via DTS and I am getting this error but at seemingly intermittent intervals when the DTS packages are scheduled. I am unable to recreate the error to troubleshoot the problem and I am at a loss to it’s source. The cube processes fine through Analysis Services Manager and when executing the DTS package through Enterprise manager but fails when the DTS packages are scheduled. However sometimes it works, so you can see how frustrating this is! Here is the error description from the DTS log. Step Error Source: Analysis Services Processing Task Step
Error Description:Invalid processing option
Step Error code: 8004021D Step Error
Help File: Step Error Help Context ID:1000440 Here is an instance of the error from the SQL Job log file. Error Detail Records: Error: 0 (0); Provider Error: 0 (0)
Error string: Invalid processing option
Error source: Analysis Services Processing Task
Help file:
Help context: 1000440 DTSRun OnError: GBR_PRESENTATION_PROCESS_CUBES_DAILY, Error = -2147220963 (8004021D)
Error string: Full_TSE_July_2005_fwd: Invalid processing option
Error source: Analysis Services Processing Task
Help file:
Help context: 1000440
There seems to be very little info on this error on the Web so any ideas would be very much appriciated. Thanks
Daniel
try creating a stored procedure and run the olap cube processing dts inside the SP.
Create a new job and add a step to execute that Stored procedure.
Thanks for your reply. Are you suggesting I try to run the Cube Processing package on its own? If so I don’t think I need an sp because I can just schedule the dts package using DTSRun. I’m going to try creating the cube package as an individual step inside the SQL Job and see what happens. I’ll let you know. Thanks
Daniel
Right click the task and choose Work Flow properties see if Execute on main package thread is enabled, if not enable it and test if this solves your problem. http://support.microsoft.com/default.aspx?scid=kb;en-us;296533 Raulie
]]>