Unexpected internal error when querying cube data

Tech-Archive recommends: Speed Up your PC by fixing your registry



I have a DTS package in SQL Server 2000 which brings together data from
different sources, including from an Analysis Services cube, and compares it.

Usually this runs perfectly, but sometimes I get an unexpected internal
error from the Data Pump task which queries the cube - no other information,
just the error.



This is usually when I have run the package once (manually from Enterprise
Manager), then changed a global variable and run it again.



The cube it is querying is a virtual cube and the measures are calculated
cells (NOT calculated members).



We are on SP4 of AS so should be up to date.



Does anyone have any ideas?



Thank you
.



Relevant Pages

  • Re: Run DTS Utility on client machine - Process AS cubes: dtstasks.ex
    ... dts package that processes the cube. ... a way to insert a record into the table when they wanted the cube processed. ... The package could then execute on the server and you wouldn't need to worry ... I have got DTS running on a client ...
    (microsoft.public.sqlserver.dts)
  • DTS Package for Incremental Builds of OLAP Cube
    ... also have a OLAP cube which I need to incrementally build/update every ... The problem is that every time I execute the DTS package for cube update, ... get an Access Violation error or sometimes, ...
    (microsoft.public.sqlserver.dts)
  • DTS Package for Incremental Builds of OLAP Cube
    ... also have a OLAP cube which I need to incrementally build/update every ... The problem is that every time I execute the DTS package for cube update, ... get an Access Violation error or sometimes, ...
    (microsoft.public.sqlserver.olap)
  • Re: Error processing a cube when it is scheduled through agent.
    ... the Processing of the cube is inside a DTS package. ... >> putting in the OLAP administrators group also but it still does not ... >> rights. ...
    (microsoft.public.sqlserver.olap)
  • Unable to Process Cube on 64bit Server with DTS package
    ... 'I have a cube on a 64bit server. ... automatically through a scheduled job or DTS package since they can't be run ... I have a DTS package utilizing the ...
    (microsoft.public.sqlserver.olap)