DTS error

[Rowan]

Hello, I have been trying to solve this problem for a couple of weeks
now with no progress. I created a package that works when it runs
from my computer but when it runs as a scheduled job, it fails. I
found references to this quite a few times and the responses have
always pointed to permissions, but I am a System Administrator. My
role is Sysadmin. I changed the Windows/NT owner of the job to sa and
that didn't work either. I made sure that the account that runs from
SQL Server has Sysadmin permissions.

The problem I think has to do with the AS400 connection that I make to
pull data out of the AS400 to put into SQL Server 2000. In the
Connection of the package there is a place for User and Password. I
had the person who definitely has all Rumba permissions put his
username and password in there and it came back with the same error.
The Error message is below. I am sure at a loss. Does anyone have
any ideas? I would really appreciate anything. Could this have
anything to do with MDAC?

DTSRun: Loading... DTSRun: Executing... DTSRun OnStart:
DTSStep_DTSExec uteSQLTask_1 DTSRun OnFinish:
DTSStep_DTSExec uteSQLTask_1 DTSRun OnStart:
DTSStep_DTSData PumpTask_1 DTSRun OnError:
DTSStep_DTSData PumpTask_1, Error = -2147467259 (80004005) Error
string: [Wall Data][RUMBA Data Access][RUMBA95]Communication link
failure. APPC Primary RC = Parameter_Check ; Secondary RC =
Bad_LU_Alias. Error source: Microsoft OLE DB Provider for ODBC
Drivers Help file: Help context: 0 Error Detail
Records: Error: -2147467259 (80004005); Provider Error: 0 (0)
Error string: [Wall Data][RUMBA Data Access][RUMBA95]Communication
link failure. APPC Primary RC = Parameter_Check ; Secondary RC =
Bad_LU_Alias. Error source: Microsoft OLE DB Provider for ODBC
Drivers Help file: Help context: 0 DTSRun OnFinish:
DTSStep_DTSData PumpTask_1 DTSRun: Package execution complete.
Process Exit Code 1. The step failed.

[Simon Hayes]

Re: DTS error

phantomtoe@yaho o.com (Rowan) wrote in message news:<4bbf8d70. 0404061235.5e1e 3334@posting.go ogle.com>...[color=blue]
> Hello, I have been trying to solve this problem for a couple of weeks
> now with no progress. I created a package that works when it runs
> from my computer but when it runs as a scheduled job, it fails. I
> found references to this quite a few times and the responses have
> always pointed to permissions, but I am a System Administrator. My
> role is Sysadmin. I changed the Windows/NT owner of the job to sa and
> that didn't work either. I made sure that the account that runs from
> SQL Server has Sysadmin permissions.
>
> The problem I think has to do with the AS400 connection that I make to
> pull data out of the AS400 to put into SQL Server 2000. In the
> Connection of the package there is a place for User and Password. I
> had the person who definitely has all Rumba permissions put his
> username and password in there and it came back with the same error.
> The Error message is below. I am sure at a loss. Does anyone have
> any ideas? I would really appreciate anything. Could this have
> anything to do with MDAC?
>
> DTSRun: Loading... DTSRun: Executing... DTSRun OnStart:
> DTSStep_DTSExec uteSQLTask_1 DTSRun OnFinish:
> DTSStep_DTSExec uteSQLTask_1 DTSRun OnStart:
> DTSStep_DTSData PumpTask_1 DTSRun OnError:
> DTSStep_DTSData PumpTask_1, Error = -2147467259 (80004005) Error
> string: [Wall Data][RUMBA Data Access][RUMBA95]Communication link
> failure. APPC Primary RC = Parameter_Check ; Secondary RC =
> Bad_LU_Alias. Error source: Microsoft OLE DB Provider for ODBC
> Drivers Help file: Help context: 0 Error Detail
> Records: Error: -2147467259 (80004005); Provider Error: 0 (0)
> Error string: [Wall Data][RUMBA Data Access][RUMBA95]Communication
> link failure. APPC Primary RC = Parameter_Check ; Secondary RC =
> Bad_LU_Alias. Error source: Microsoft OLE DB Provider for ODBC
> Drivers Help file: Help context: 0 DTSRun OnFinish:
> DTSStep_DTSData PumpTask_1 DTSRun: Package execution complete.
> Process Exit Code 1. The step failed.[/color]

As a complete guess, does the Rumba driver use information stored in
your profile? I recall that the IBM Client Access driver used to do
this - AS/400 connections were defined and stored in each user's
profile, so when a task was scheduled, it failed, because the profile
wasn't available.

Simon

[Terence]

Re: DTS error

What's your DSN setup look like (for iSeries connection)?


phantomtoe@yaho o.com (Rowan) wrote in message news:<4bbf8d70. 0404061235.5e1e 3334@posting.go ogle.com>...[color=blue]
> Hello, I have been trying to solve this problem for a couple of weeks
> now with no progress. I created a package that works when it runs
> from my computer but when it runs as a scheduled job, it fails. I
> found references to this quite a few times and the responses have
> always pointed to permissions, but I am a System Administrator. My
> role is Sysadmin. I changed the Windows/NT owner of the job to sa and
> that didn't work either. I made sure that the account that runs from
> SQL Server has Sysadmin permissions.
>
> The problem I think has to do with the AS400 connection that I make to
> pull data out of the AS400 to put into SQL Server 2000. In the
> Connection of the package there is a place for User and Password. I
> had the person who definitely has all Rumba permissions put his
> username and password in there and it came back with the same error.
> The Error message is below. I am sure at a loss. Does anyone have
> any ideas? I would really appreciate anything. Could this have
> anything to do with MDAC?
>
> DTSRun: Loading... DTSRun: Executing... DTSRun OnStart:
> DTSStep_DTSExec uteSQLTask_1 DTSRun OnFinish:
> DTSStep_DTSExec uteSQLTask_1 DTSRun OnStart:
> DTSStep_DTSData PumpTask_1 DTSRun OnError:
> DTSStep_DTSData PumpTask_1, Error = -2147467259 (80004005) Error
> string: [Wall Data][RUMBA Data Access][RUMBA95]Communication link
> failure. APPC Primary RC = Parameter_Check ; Secondary RC =
> Bad_LU_Alias. Error source: Microsoft OLE DB Provider for ODBC
> Drivers Help file: Help context: 0 Error Detail
> Records: Error: -2147467259 (80004005); Provider Error: 0 (0)
> Error string: [Wall Data][RUMBA Data Access][RUMBA95]Communication
> link failure. APPC Primary RC = Parameter_Check ; Secondary RC =
> Bad_LU_Alias. Error source: Microsoft OLE DB Provider for ODBC
> Drivers Help file: Help context: 0 DTSRun OnFinish:
> DTSStep_DTSData PumpTask_1 DTSRun: Package execution complete.
> Process Exit Code 1. The step failed.[/color]

[Rowan]

Re: DTS error

We are using a NetManage ODBC for AS400/Rumba with TCP/IP enabled. We
have it look directly at the library where we are trying to get the
data from. The connection has been made on the SQL Server box in
control panel. Is that what you mean?

I have literally tried everything I can think of. I am very
frustrated.


arrowcomputer@b igfoot.com (Terence) wrote in message news:<440c28e5. 0404070344.663f 9d39@posting.go ogle.com>...
[color=blue]
> What's your DSN setup look like (for iSeries connection)?
>
>
> phantomtoe@yaho o.com (Rowan) wrote in message news:<4bbf8d70. 0404061235.5e1e 3334@posting.go ogle.com>...[color=green]
> > Hello, I have been trying to solve this problem for a couple of weeks
> > now with no progress. I created a package that works when it runs
> > from my computer but when it runs as a scheduled job, it fails. I
> > found references to this quite a few times and the responses have
> > always pointed to permissions, but I am a System Administrator. My
> > role is Sysadmin. I changed the Windows/NT owner of the job to sa and
> > that didn't work either. I made sure that the account that runs from
> > SQL Server has Sysadmin permissions.
> >
> > The problem I think has to do with the AS400 connection that I make to
> > pull data out of the AS400 to put into SQL Server 2000. In the
> > Connection of the package there is a place for User and Password. I
> > had the person who definitely has all Rumba permissions put his
> > username and password in there and it came back with the same error.
> > The Error message is below. I am sure at a loss. Does anyone have
> > any ideas? I would really appreciate anything. Could this have
> > anything to do with MDAC?
> >
> > DTSRun: Loading... DTSRun: Executing... DTSRun OnStart:
> > DTSStep_DTSExec uteSQLTask_1 DTSRun OnFinish:
> > DTSStep_DTSExec uteSQLTask_1 DTSRun OnStart:
> > DTSStep_DTSData PumpTask_1 DTSRun OnError:
> > DTSStep_DTSData PumpTask_1, Error = -2147467259 (80004005) Error
> > string: [Wall Data][RUMBA Data Access][RUMBA95]Communication link
> > failure. APPC Primary RC = Parameter_Check ; Secondary RC =
> > Bad_LU_Alias. Error source: Microsoft OLE DB Provider for ODBC
> > Drivers Help file: Help context: 0 Error Detail
> > Records: Error: -2147467259 (80004005); Provider Error: 0 (0)
> > Error string: [Wall Data][RUMBA Data Access][RUMBA95]Communication
> > link failure. APPC Primary RC = Parameter_Check ; Secondary RC =
> > Bad_LU_Alias. Error source: Microsoft OLE DB Provider for ODBC
> > Drivers Help file: Help context: 0 DTSRun OnFinish:
> > DTSStep_DTSData PumpTask_1 DTSRun: Package execution complete.
> > Process Exit Code 1. The step failed.[/color][/color]

[Ryan]

Re: DTS error

I found a reference to this when searching. It may be of help to you.

http://support.microsoft.com/?kbid=269074

I have a similar problem in that my DTS package runs for me (with sa
privileges) but I can't get it to run as a scheduled task. I've not
found the solution yet, but if I do, I'll post something here in case
it is of use.

Ryan

[Rowan]

Re: DTS error

Thanks. I had read through that article a few times. I appreciate
your help and would love to hear your solution if you find one.
Today, I stopped all the services, changed the sql server account to
System and rebooted hoping that would solve my problem. It did solve
another problem I was having with a catalog failing to populate, but
it did not fix my package problem.

Something I left out is that my scheduled backups run just fine. So I
am wondering, if the problem is with SQL Agent permissions...w ouldn't
the scheduled backups not run either? If that is the case, then is it
possible that the connection I am making to the AS400 is somehow not
getting the Username and password I specified in the connection
properties? If that could be the problem, does anybody have any
suggestions on how I might test that or fix it? I can't think of
anything else to try. I am out of ideas.

ryanofford@hotm ail.com (Ryan) wrote in message news:<7802b79d. 0404080146.518e be9d@posting.go ogle.com>...[color=blue]
> I found a reference to this when searching. It may be of help to you.
>
> http://support.microsoft.com/?kbid=269074
>
> I have a similar problem in that my DTS package runs for me (with sa
> privileges) but I can't get it to run as a scheduled task. I've not
> found the solution yet, but if I do, I'll post something here in case
> it is of use.
>
> Ryan[/color]

[Rowan]

Re: DTS error

Well, I finally got it to work today. After reading everything I
could get my hands on I put the right peices together. I had to
first, give the domain user, in our case, domain\Administ rator
sysadmin rights in SQL Server. I figured that one out a while ago.
Then I had to go to the Domain Security, User Rights Assigns in Active
Directory. I modified the administrator user rights assignments to
allow it to Act as part of the operating System, Increase Quotas,
Replace a proces level token, Log on as a batch job, and Log on as a
service. To make sure everything was in sync, I stopped all services,
made sure SQL Server's account was that of the
domain\Administ rator...made sure that the SQL Server Agent had the
same account, rebooted SQL Server, which restarted all the services,
and voila...my scheduled jobs will now run. Thanks to all who tried
to help. I knew it had to do with permissions, but darned if I could
figure out what to do about it. Maybe this will help someone else.


phantomtoe@yaho o.com (Rowan) wrote in message news:<4bbf8d70. 0404081147.67ec 4d5d@posting.go ogle.com>...[color=blue]
> Thanks. I had read through that article a few times. I appreciate
> your help and would love to hear your solution if you find one.
> Today, I stopped all the services, changed the sql server account to
> System and rebooted hoping that would solve my problem. It did solve
> another problem I was having with a catalog failing to populate, but
> it did not fix my package problem.
>
> Something I left out is that my scheduled backups run just fine. So I
> am wondering, if the problem is with SQL Agent permissions...w ouldn't
> the scheduled backups not run either? If that is the case, then is it
> possible that the connection I am making to the AS400 is somehow not
> getting the Username and password I specified in the connection
> properties? If that could be the problem, does anybody have any
> suggestions on how I might test that or fix it? I can't think of
> anything else to try. I am out of ideas.
>
> ryanofford@hotm ail.com (Ryan) wrote in message news:<7802b79d. 0404080146.518e be9d@posting.go ogle.com>...[color=green]
> > I found a reference to this when searching. It may be of help to you.
> >
> > http://support.microsoft.com/?kbid=269074
> >
> > I have a similar problem in that my DTS package runs for me (with sa
> > privileges) but I can't get it to run as a scheduled task. I've not
> > found the solution yet, but if I do, I'll post something here in case
> > it is of use.
> >
> > Ryan[/color][/color]