Error calling subroutine: DSR_SCHEDULE

rohitchattar · Post by **rohitchattar** » Thu Jul 05, 2007 7:50 am

Hi,

I get following error for a new user added to a group and trying to schedule a job.

Error calling subroutine: DSR_SCHEDULE (Action=3); check DataStage is set up correctly in project XXXX
(Subroutine failed to complete successfully (30107))

Also reschedule icon is disabled.

One more thing noticed, I see jobs in crontab but director says not scheduled.

Can anyone help here?

1. How to let user schedule and not get above message?
2. How to get crontab entry imported to DS scheduler?

Rohit

Hemant_Kulkarni · Post by **Hemant_Kulkarni** » Thu Jul 05, 2007 8:52 am

Does the new user have permission to schedule jobs ?? Entries should be available in cron.allow and at.allow

rohitchattar · Post by **rohitchattar** » Thu Jul 05, 2007 9:10 am

What is this file? cron.allow and at.allow

I see cron entries but director show unscheduled.

Can i sync cron with scheduler?

Rohit

chulett · Post by **chulett** » Thu Jul 05, 2007 9:31 am

The Director will only show a job as Scheduled if the currently logged in user is also the one that scheduled it. This because cron is user specific and each user can have their own crontab.

Your SA would need to manage the 'allow' files for you.

rohitchattar · Post by **rohitchattar** » Thu Jul 05, 2007 9:43 am

Hi,

I am able to schedule what that means is at and cron entries are added for that user.

The only problem is it's not getting added to Data Stage repository and therefore cannot see thru director.

But am able to see at unix level.

I feel some permission issue not for cron or at but for some directory of datastage.

Rohit

kduke · Post by **kduke** » Thu Jul 05, 2007 11:14 am

There is a shell script below the project with schedule in the name. Permissions on this script sometimes mess up this scheduling process. If I remember correctly you do not want the set uid bit set.

ls -la *sched*

-rwsrwsr-x

Should not be a s in any of these on this script.

rohitchattar · Post by **rohitchattar** » Thu Jul 05, 2007 10:48 pm

Hi,

The permission on dsr_sched.sh is correct

-rwxrwxr-x 1 dsadm users 155 Nov 9 2004 dsr_sched.sh

I think it's not the script that schedules that has issue, it's the place where datastage stores the information about the schedule.

Rohit

chulett · Post by **chulett** » Fri Jul 06, 2007 6:10 am

At this point, seems like a call to your Support provider is in order to resolve this.