Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Sunday, July 14, 2024 
 
slxdeveloper.com Community Forums  
   
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
 Data & Imports Forums - SSIS/DTS
Forum to discuss using SQL SSIS or DTS to perform SalesLogix imports. View the code of conduct for posting guidelines.
Forums RSS Feed


 Back to Forum List | Back to SSIS/DTS | New ThreadView:  Search:  
 Author  Thread: Problem Scheduling a DTS Job using DTSRun
Phil Parkin
Posts: 819
Top 10 forum poster: 819 posts
 
Problem Scheduling a DTS Job using DTSRunYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 20 Jul 06 4:16 AM
fiogf49gjkf0d
SLX 6.2.1 / SQL 2000

I have a fairly complex DTS package which transfers product data from a Sage db into SLX, using the SLX OLEDB provider to ensure that remotes get the data. This package works fine when I run it interactively in Enterprise Manager. However, when I try to schedule it to run daily, using SQL Server Agent and the DTSRun utility, the job fails. The log says that the problem is that SLXRWEL is not registered.

So I tried

RegSvr32 "c:\program files\SalesLogix\SLXRWEL.DLL"

and got a "registered successfully" message. But I still get the same error when I try and run this job. Any ideas, anyone? Thanks.

[Reply][Quote]
Stuart
Posts: 178
 
Re: Problem Scheduling a DTS Job using DTSRunYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 20 Jul 06 7:58 AM
fiogf49gjkf0d
When you run it in Enterprise Manager, it runs on your PC, and when it runs as a SQL agent job it's running on the DB server. Have you registered the DLL on the Server itself?
[Reply][Quote]
Phil Parkin
Posts: 819
Top 10 forum poster: 819 posts
 
Re: Problem Scheduling a DTS Job using DTSRunYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 20 Jul 06 8:23 AM
fiogf49gjkf0d
Thanks Stuart, very good point, but I was running it all in an RDP session on the server itself.
[Reply][Quote]
Stuart
Posts: 178
 
Re: Problem Scheduling a DTS Job using DTSRunYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 20 Jul 06 9:05 AM
fiogf49gjkf0d
That's a very strange problem then. The only other thing I can think of is the User that the SQL Agent Job runs as (the owner on the first tab of the job) - maybe he doesn't have access to something he needs? I have been caught by this before, but not probems with DLLs.
[Reply][Quote]
Stuart
Posts: 178
 
Re: Problem Scheduling a DTS Job using DTSRunYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 20 Jul 06 9:08 AM
fiogf49gjkf0d
Quote:
using the SLX OLEDB provider to ensure that remotes get the data


I just noticed this and it might be relevent to my current problem http://www.slxdeveloper.com/forum.aspx?forumid=5004&postid=2118

I suspect that my connect string isn't quite right, if you have this working and syncing to remotes could you possibly post your connect string please?

[Reply][Quote]
Stuart
Posts: 178
 
Re: Problem Scheduling a DTS Job using DTSRunYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 20 Jul 06 9:19 AM
fiogf49gjkf0d
I just had another thought - have you tried registering the DLL as a COM+ Application in Component Services? This has worked for me before when a DLL I had registered using REGSVR32 wasn't being picked up for some reason. This wasn't in the SLX environment though, but it might help?
[Reply][Quote]
Phil Parkin
Posts: 819
Top 10 forum poster: 819 posts
 
Re: Problem Scheduling a DTS Job using DTSRunYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 24 Jul 06 11:26 AM
fiogf49gjkf0d
Thanks Stuart & sorry for the slight delay. I have now tried logging into the server as the same user that SQL Agent runs under - the job runs fine interactively underneath DTS / Local Packages.

But if I create a scheduled job by right clicking and then 'Schedule Package' - enter the scheduling information etc and then try to run that job - still interactively - it fails with the horrendous error message below:

Executed as user: [client domain name]\sqlmail. ...cuting... DTSRun OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun OnStart: DTSStep_DTSActiveScriptTask_2 DTSRun OnError: DTSStep_DTSActiveScriptTask_2, Error = -2147220482 (800403FE) Error string: Error Code: 0 Error Source= SLXOLEDB.1 Error Description: SLXRWEL.dll library not registered. Error on Line 16 Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 4500 Error Detail Records: Error: -2147220482 (800403FE); Provider Error: 0 (0) Error string: Error Code: 0 Error Source= SLXOLEDB.1 Error Description: SLXRWEL.dll library not registered. Error on Line 16 Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 4500 Error: -2147467259 (80004005); Provider Error: 0 (0) Error string: SLXRWEL.dll li. The step failed.

So what is the difference between running the job interactively by executing the package or running the SQL job?
[Reply][Quote]
Phil Parkin
Posts: 819
Top 10 forum poster: 819 posts
 
Re: Problem Scheduling a DTS Job using DTSRunYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 24 Jul 06 11:35 AM
fiogf49gjkf0d
By the way, your SLX connection string from an earlier post looks fine. It's early days for me yet and I have still to confirm that sync'ing to remotes is working properly.

Cheers
Phil
[Reply][Quote]
Stuart
Posts: 178
 
Re: Problem Scheduling a DTS Job using DTSRunYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 24 Jul 06 4:15 PM
fiogf49gjkf0d
Quote:
Originally posted by Phil Parkin

By the way, your SLX connection string from an earlier post looks fine. It's early days for me yet and I have still to confirm that sync'ing to remotes is working properly.


Thanks, I found that I needed to update the ACCOUNTSUMMARY table, which I wasn't doing. Now I am it's all fine.
[Reply][Quote]
Stuart
Posts: 178
 
Re: Problem Scheduling a DTS Job using DTSRunYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 24 Jul 06 4:17 PM
fiogf49gjkf0d
Quote:
So what is the difference between running the job interactively by executing the package or running the SQL job?


I really don't know. Will have a think though. Did you try registering the DLL in Component Services? You didn't mention it.
[Reply][Quote]
Ryan Farley
Posts: 2265
slxdeveloper.com Site Administrator
Top 10 forum poster: 2265 posts
 
Re: Problem Scheduling a DTS Job using DTSRunYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 24 Jul 06 11:04 PM
fiogf49gjkf0d
Quote:
Originally posted by Phil Parkin

So what is the difference between running the job interactively by executing the package or running the SQL job?


The main difference is the user account it is running under. When running it via Ent Mgr you're running it under the user account you're logged in with. When running it as a scheduled job, you're running it via the SQL Agent's service account.

Just an idea, but make sure your the user account agent is running under is not the system account (ie: an actual user account instead), then log in as that user and try running it via Ent Mgr (If you still get the same error when scheduled). This would at least rule out permissions, etc, or something like that.
[Reply][Quote]
Phil Parkin
Posts: 819
Top 10 forum poster: 819 posts
 
Re: Problem Scheduling a DTS Job using DTSRunYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 25 Jul 06 3:32 AM
fiogf49gjkf0d
Thanks Ryan - even though my aim is to set it up as a scheduled job, it fails when I test it interactively. I haven't even got as far as letting SQL Agent run it!

So ... if I log in to the server as the same user that SQL Agent is running under (a domain user), I can run the package OK by right-clicking the package and selecting 'Execute Package'. But if I create a SQL Server Agent job to run the package (using DTSRun) and then run that interactively, it fails.

Stuart - I have not registered SLXRWEL through Component Services, mostly because I haven't a clue what I am doing - never used it before. Can you provide some guidance please? Thank you very much.

I will hunt around & see whether I can get some more detailed diagnostics for this.

Phil
[Reply][Quote]
Stuart
Posts: 178
 
Re: Problem Scheduling a DTS Job using DTSRunYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 25 Jul 06 6:06 AM
fiogf49gjkf0d
Quote:
Originally posted by Phil Parkin

Stuart - I have not registered SLXRWEL through Component Services, mostly because I haven't a clue what I am doing - never used it before. Can you provide some guidance please? Thank you very much.

Shall we leave Component services as a last resort, as its a bit fiddly to use? Its most likely a user permissions thing. But one more thing to look at: have you checked that the SLXRWEL.DLL is Readable by 'Everyone'? Right click the file, Properties, Security. 'Everyone' should have at least Allow Read and Execute. If not, even though its registered, the DLL probably won't be found.
[Reply][Quote]
Phil Parkin
Posts: 819
Top 10 forum poster: 819 posts
 
Re: Problem Scheduling a DTS Job using DTSRunYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 25 Jul 06 7:53 AM
fiogf49gjkf0d
Full access by 'Everyone' verified.

Looking logically, doesn't the fact that it runs OK interactively as a package mean that permissions are prob OK?

There must be something different between running the package interactively and running the job interactively that is not to do with who I am logged in as (won't they both run as the same user if I run them interactively?).

Hmm - getting bored of this now! Many thanks again for all your help though.

I'm going to post this question on a SQL Server specialist forum - might get some more ideas.
[Reply][Quote]
Stuart
Posts: 178
 
Re: Problem Scheduling a DTS Job using DTSRunYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 25 Jul 06 9:58 AM
fiogf49gjkf0d
Quote:
Originally posted by Phil Parkin

There must be something different between running the package interactively and running the job interactively that is not to do with who I am logged in as (won't they both run as the same user if I run them interactively?).


There is something different, if there is a job running it then it runs as the owner of the job, not as who you are logged in as. Check in Enterprise Manager/Management/SQL Server Agent/Jobs and find the job which is running your DTS package. If you display its properties, the first Tab has the owner it will run as.

Hope this makes sense?


[Reply][Quote]
Phil Parkin
Posts: 819
Top 10 forum poster: 819 posts
 
Re: Problem Scheduling a DTS Job using DTSRunYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 25 Jul 06 10:15 AM
fiogf49gjkf0d
Yes, thanks Stuart.

A brief moment of hope, followed by disappointment as I found the job owner to be the same as the person I was logged in as ...

I have posted to a SQL Server forum & will post anything useful back here.
[Reply][Quote]
 Page 1 of 1 
  You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

   Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
 

 
 slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation.
 This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.

code of conduct | Subscribe to the slxdeveloper.com Latest Article RSS feed
   
 
page cache (param): 7/14/2024 2:44:40 AM