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!
|
|
Problem Scheduling a DTS Job using DTSRun
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.
|
|
|
|
Re: Problem Scheduling a DTS Job using DTSRun
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? |
|
|
| |
|
Re: Problem Scheduling a DTS Job using DTSRun
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. |
|
|
| |
|
Re: Problem Scheduling a DTS Job using DTSRun
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?
|
|
|
|
Re: Problem Scheduling a DTS Job using DTSRun
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? |
|
|
|
Re: Problem Scheduling a DTS Job using DTSRun
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 |
|
|
|
Re: Problem Scheduling a DTS Job using DTSRun
Posted: 24 Jul 06 4:15 PM
|
fiogf49gjkf0d 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. |
|
|
|
Re: Problem Scheduling a DTS Job using DTSRun
Posted: 24 Jul 06 4:17 PM
|
fiogf49gjkf0d | 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. |
|
|
|
Re: Problem Scheduling a DTS Job using DTSRun
Posted: 24 Jul 06 11:04 PM
|
fiogf49gjkf0d 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. |
|
|
|
Re: Problem Scheduling a DTS Job using DTSRun
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 |
|
|
|
Re: Problem Scheduling a DTS Job using DTSRun
Posted: 25 Jul 06 6:06 AM
|
fiogf49gjkf0d 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.
|
|
|
|
Re: Problem Scheduling a DTS Job using DTSRun
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. |
|
|
|
Re: Problem Scheduling a DTS Job using DTSRun
Posted: 25 Jul 06 9:58 AM
|
fiogf49gjkf0d 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?
|
|
|
|
Re: Problem Scheduling a DTS Job using DTSRun
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. |
|
|
|