Re: Error While Processing CUBE through SSIS Package.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

What is the user associated with the SSIS package?


"Maninder" <msdhanjal@xxxxxxxxx> wrote in message
news:1161103606.277070.87620@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Scenario: We have a SSIS Package which processes the 2 Cubes.
When we try to Process the Cube/Dimension Manually.. it Works.. But the
Pain Started when we try to do the same thing Through a SSIS Package.

SSIS Package uses some variables and aggregation dumped into a Tmp
table off which the DImensions are Based..
Some of the Dimensions are created from Views(Which return data from
Linked Server).

Typical Error we get is here.: I am a SA on all of these Boxes, but
that doesnt help.
OH Yes another Scenario: This same Layout Works in the TEST
Environment.
TEST LAYOUT: DBSVR1-->SSASSVR1-->Works BUT DBSVR2-->SSASSVR2--> Doesnt
Work.

I know you have a Quick Answer on the TOP of you Head, but Think about
this, we tried everything for the past 3 days and nothing seems to Help
us. If you are thinking something we already tried it. We tried
Combination of Priviliges across Servers/Dropped and recreated Linked
Servers/Restores TEST Cubes and Databases into PRODUCTION Environment
as it is/ Worked with Windows as well as SQL Authentication/ Tried
changing Object Ownerships etc... We have finally decided to Open a
Call with MSFT. Before Going ahead with the CALL I wanted to give a
LAST SHOT here, if anybody came across this ERROR and has RESOLVED it,
Pl show me the Light.
The Table names and Servers Names are TRUE as Projected in the ERROR.
Here is the Error.
/*
Errors in the metadata manager. Either the dimension with the ID of
'Heat Slab Slip' does not exist in the database with the ID of
'DataGrub, or the user does not have permissions to access the object.
*/

Thanks in advance for your Help



.

Relevant Pages

  • Re: Performance - Best Practices
    ... SP1 is applied on the server. ... I have also heard that parent child dimensions have a significant impact on ... I mean floating calculation and integer ... and the cube in front of this fact provide standard SUMS and DCount!) ...
    (microsoft.public.sqlserver.olap)
  • Re: Performance Benchmarks?
    ... Are attribute relationships defined properly on the dimensions? ... If you run Profiler against the server, how long is spent in "Query ... I have created aggregations (Partitions tab in cube design). ...
    (microsoft.public.sqlserver.olap)
  • High CPU in client (Excel, OWC, Proclarity, etc.) accessing Analysis Services
    ... the OWC10 with 3 dimensions on the row axis, ... The largest size of any of these 4 dimensions < 360 members. ... Performance Guide to optimize the query, the cube, the server, etc. ...
    (microsoft.public.sqlserver.olap)
  • Re: AS 2005 slowness...
    ... closer to 30 true dimensions), ... Am not sure where the tempdb is - most likely on the same disk as SQL ... Server and AS, although this disk is cheap-wrt-IO cost, so I'd hope ... Reported memory consumption is 1.8GB for AS, ...
    (microsoft.public.sqlserver.olap)
  • RE: How to add a server conn in business Intelligence Development Stud
    ... I understand that you could not add a remote SQL Server instance in BIDS ... Why would you like to add a server when you developed a SSIS package? ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.tools)