Re: Unable to Process Cube on 64bit Server with DTS package

Ok. Let's see if this is a SQL Agent issues or a DSO issue.
Can you try three things:
1) Login into the 32-bit system using the domain account that SQL Agent is
configured to use. Can you execute the package interactively using dtsrun?
2) In the same login session as #1, Can you run Analysis Manager to remotely
process the partition or dimension?
2) Can you write a package which executes a TSQL task (using integrated
security) that does a SELECT * FROM OLAP OBJECTS in the OLAP repostiory
database? Does it run interactvely (using dtsrun)? Can it run scheduled
interactively?

My guess is that we have a mis-configuration here somewhere. Let's see if we
can identify which subsystem is the real problems.

Hope that helps.
--
Dave Wickert [MSFT]
dwickert@xxxxxxxxxxxxxxxxxxxx
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"lancemc5" <lancemc5@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7E9B5E73-D703-4270-9429-185FAB5CDA8E@xxxxxxxxxxxxxxxx
> Yes on both counts.
> --
> Lance McCaskey
>
>
> "Dave Wickert [MSFT]" wrote:
>
>> 1) Have you configured the SQL Agent service account to be a domain
>> account
>> in common between the 32-bit server and the 64-bit server?
>>
>> Then 2) Add that domain account to the OLAP Administrators group on the
>> 64-bit server.
>>
>> --
>> Dave Wickert [MSFT]
>> dwickert@xxxxxxxxxxxxxxxxxxxx
>> Program Manager
>> BI SystemsTeam
>> SQL BI Product Unit (Analysis Services)
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>>
>> "lancemc5" <lancemc5@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:72032522-35FD-4253-A47E-6D52C458F652@xxxxxxxxxxxxxxxx
>> >I can execute the DTS package on the remote server from within the
>> >package
>> > without a problem. When we try to schedule the DTS package, the
>> > scheduled
>> > job has the issues outlined below. I am unclear on how scheduling the
>> > package creates the problem. I found a Microsoft knowledge based
>> > article
>> > that had me add permissions via DCOMcnfg.exe. This proved fruitless.
>> > It
>> > almost looks like a VB error that is being encountered.
>> > Thanks,
>> > --
>> > Lance McCaskey
>> >
>> >
>> > "Jesse O" wrote:
>> >
>> >> Seems like a security issue...might be a firewall problem. Or even
>> >> credentials.
>> >>
>> >> It's not a 64 / 32 bit issue. We do the exact same thing you're
>> >> attempting
>> >> to do with success. I have run into the same problem you have and it's
>> >> always been due to firewall problems.
>> >>
>> >> Can you run the package manually on that server? Or are you running
>> >> the
>> >> package remotely with success?
>> >>
>> >>
>> >>
>> >>
>> >> "lancemc5" <lancemc5@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> >> news:3BF8162E-ADA8-4B1A-81F5-1E0AB109F6D0@xxxxxxxxxxxxxxxx
>> >> > 'I have a cube on a 64bit server. I obviously can't process the
>> >> > cube
>> >> > automatically through a scheduled job or DTS package since they
>> >> > can't
>> >> > be
>> >> > run
>> >> > on the 64bit version of SQL 2000. I have a DTS package utilizing
>> >> > the
>> >> > 'Analysis Services Processing Task' on a 32 bit server trying to
>> >> > process
>> >> > the
>> >> > cube on the 64bit box. The DTS package will process the cube when
>> >> > executed
>> >> > from within the package, however, when scheduling the package as a
>> >> > job
>> >> > it
>> >> > fails. This is the error message. Any help is appreciated.
>> >> > Executed as user: evercom\svcsql. DTSRun: Loading... Error:
>> >> > -2147221005 (800401F3); Provider Error: 0 (0) Error string:
>> >> > Invalid
>> >> > class string Error source: Microsoft Data Transformation
>> >> > Services
>> >> > (DTS) Package Help file: sqldts80.hlp Help context: 713.
>> >> > Process
>> >> > Exit Code 1. The step failed.
>> >> > --
>> >> > Lance McCaskey
>> >>
>> >>
>> >>
>>
>>
>>


.

Relevant Pages

  • Re: Privilege in scheduling packages through sql agent jobs
    ... > How to Run a DTS Package as a Scheduled Job ... >>A programmer can schedule jobs through sql agent and the job step that is ... >>programmer runs the package interactively, ... >>attempts to schedule a package as sql agent job, ...
    (microsoft.public.sqlserver.security)
  • Re: DTS schedule problem
    ... since I infer from your original post that you are on a SQL Server 2000 ... Who owns the scheduled SQL Agent job? ... the package is under the system account, which was only a SQL account. ... I tried to schedule a DTS package. ...
    (microsoft.public.sqlserver.dts)
  • Privilege in scheduling packages through sql agent jobs
    ... A programmer can schedule jobs through sql agent and the job step that is ... programmer runs the package interactively, ...
    (microsoft.public.sqlserver.security)
  • RE: dts package error
    ... "Donna Lambert" wrote: ... > under the context of the SQL Agent account. ... > account and try to manually kick off the package. ...
    (microsoft.public.sqlserver.dts)
  • RE: 64bit SSIS package calling 32bit SSIS package
    ... Now tried 32bit end to end from sql agent (so running the control job in ... packages using 32bit jet theres also a config value to execute these with the ... Execute the control package from the command line on the server as my proxy ... I cannot run the same package from a sql agent job as whe nthe control ...
    (microsoft.public.sqlserver.dts)