Parameter between double quote when scheduled

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

mjgmc
Participant
Posts: 52
Joined: Thu Nov 25, 2004 8:06 am

Parameter between double quote when scheduled

Post by mjgmc »

Hello,

I'm getting a weird behaviour with my Server Jobs.

If I run them, they finish OK, if I schedule them, they abort.

I tried to figure out why and I realized that the parameter (with the source path) appears between double quote when scheduled:

Log of a normal Run:

Project:formateur (SERVER)
Job name:lkpEmployeeBonus
Event #:152
Timestamp:22/01/2010 16:02:00
Event type:Control
User:SERVER\formateur
Message:
Starting Job lkpEmployeeBonus.
FILE_DIR = D:\formation DS\Formateur\Solutions\DS324


Log of a Scheduled Run:

Project:formateur (SERVER)
Job name:lkpEmployeeBonus
Event #:139
Timestamp:22/01/2010 15:39:00
Event type:Control
User:NT AUTHORITY\system
Message:
Starting Job lkpEmployeeBonus.
FILE_DIR = "D:\formation DS\Formateur\Solutions\DS324"


Can anyone explain me why does this happen and how to fix it?

Thank you
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Double-quoting pathnames with spaces is standard Windows stuff so shouldn't be an issue. What are the actual aborts that you get?
-craig

"You can never have too many knives" -- Logan Nine Fingers
kandyshandy
Participant
Posts: 597
Joined: Fri Apr 29, 2005 6:19 am
Location: Singapore

Post by kandyshandy »

Definitely something wrong with the parameter value you typed while scheduling. Post the actual error from log.
Kandy
_________________
Try and Try again…You will succeed atlast!!
Sreedhar
Participant
Posts: 187
Joined: Mon Oct 30, 2006 12:16 am

Post by Sreedhar »

One more question before I can talk on that.

What is the scheduling tool that you are using, where is that loaded on unix? or Windows?

Regards,
Regards,
Shree
785-816-0728
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Windows, it would seem from both the parameters being used and the OS type as originally posted. Another assumption would be via Director, so "at" on a Windows server. Please let us know if that's not the case.

Still don't think the quotes are the issue and want to see the abort messages.
-craig

"You can never have too many knives" -- Logan Nine Fingers
vivekgadwal
Premium Member
Premium Member
Posts: 457
Joined: Tue Sep 25, 2007 4:05 pm

Post by vivekgadwal »

chulett wrote: Still don't think the quotes are the issue and want to see the abort messages.
Quotes are definitely not the issue as we have scheduled Sequences that passed pathnames to the jobs on a Windows NT.
OP - please post the exact error you are getting and the possible iterations you had while solving it, as suggested.
Vivek Gadwal

Experience is what you get when you didn't get what you wanted
mjgmc
Participant
Posts: 52
Joined: Thu Nov 25, 2004 8:06 am

Post by mjgmc »

Sorry, I couldn't connect to the server during the weekend.

Here's the error:

Project:formateur (SERVER)
Job name:lkpEmployeeBonus
Event #:148
Timestamp:22/01/2010 16:01:44
Event type:Warning
User:SERVER\formateur
Message:
lkpEmployeeBonus..RecentEmployees.EmployeesIn: DSD.SEQOpen Failed to open RecentEmployees.txt in directory "D:\formation DS\Formateur\Solutions\DS324"
STATUS = 22.

Project:formateur (SERVER)
Job name:lkpEmployeeBonus
Event #:149
Timestamp:22/01/2010 16:01:44
Event type:Fatal
User:SERVER\formateur
Message:
lkpEmployeeBonus..GetEmployeeBonus: |lkpEmployeeBonus..RecentEmployees.EmployeesIn: DSD.SEQOpen Failed to open RecentEmployees.txt in directory "D:\formation DS\Formateur\Solutions\DS324"
STATUS = 22.|


I'm scheduling the job directly from Director.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

What are the access rights to that file; since when running a scheduled job from Windows I think it uses different userid.
mjgmc
Participant
Posts: 52
Joined: Thu Nov 25, 2004 8:06 am

Post by mjgmc »

The access right to the file are :

Full Control for System and Administrators
Read and execute for Users.

The user Formateur is an Administrator.

I've already tried to change the user on the Projet properties, but I always get the same error, no matter the user.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Is drive "D" a local disk, or a network mapped drive?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Here is why Arnd is asking that:

http://stanislavs.org/helppc/dos_error_codes.html
-craig

"You can never have too many knives" -- Logan Nine Fingers
mjgmc
Participant
Posts: 52
Joined: Thu Nov 25, 2004 8:06 am

Post by mjgmc »

ArndW wrote:Is drive "D" a local disk, or a network mapped drive? ...
It's a local disk in the server
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

That DOS 22 error is more of a "bug" error than a user type error, in my opinion. You may need to take this up with your official support provider if nothing comes of it here.
-craig

"You can never have too many knives" -- Logan Nine Fingers
mjgmc
Participant
Posts: 52
Joined: Thu Nov 25, 2004 8:06 am

SOLVED

Post by mjgmc »

I just realized where the problem was:

In the path, there was a space and has I had some troubles to run an OS Command also over this folder, I tried to move the files to another folder which has no spaces in its name, and everything works just fine.

Thank you all and I hope this post will be helpful for others.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Hmmm... as noted, that's why the quotes are there - they are needed for a Windows "Long Filename" when it has spaces in it. The workaround of renaming any directories to remove the spaces was pretty obvious and one that I didn't really see the need to mention, thinking that you'd want to work towards a resolution instead and get this working in all cases.

Still think its worth putting in front of your official support provider. :?
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply