Strange behaviour of job running in different environment

system · August 5, 2009, 10:47am

Hi All,

We have three environments DEV, TST, UAT as Database instance.

In each instance we have three schemas to make it Source, Target and Repository.

I have added all the repository in the Admin Console and scheduled all the jobs at different times i.e. Dev @ 13:00, TST @ 14:00 and UAT @ 15:00

Now when i check the job history it shows that all the job ran successfully but when i see the log file it run all the jobs from UAT environment. That means UAT job runs three times at 13:00, 14:00 and 15:00. All repositories and jobs are different, I have checked all the connections as well. I have one job server where I have added all the three repositories and we are using Data Services.

If I run manually then it works fine but when i schedule the jobs it always runs the job from UAT repository.

Any help will be really appreciated.

Thanks,
Bow.

boworld (BOB member since 2006-11-15)

system · August 6, 2009, 7:48am

Are you using three different repositories for Dev, test and UAT or are you using a single repository with three different logins? I’ve seen similar behaviour when using the latter method and it’s because the schema owner was left as default (e.g. dbo in SQL Server).

gpn01 (BOB member since 2004-11-30)

system · August 6, 2009, 10:21am

Hi,

I am using different repository for DEV, TST and UAT.

Thanks,
Bow

boworld (BOB member since 2006-11-15)

system · August 6, 2009, 10:33am

Have you taken care to schedule the job in 3 different repository? I mean in the Management Console–> Administrator–>Batch Jobs you should find 3 repository
–>DEV
–>TST
–>UAT
here, go to each item and scheduled? Just confirm this.

ganeshxp (BOB member since 2008-07-17)

system · August 6, 2009, 11:06am

Hi Ganesh,

Yes, I have done the same way.

thanks,
Bow

boworld (BOB member since 2006-11-15)

system · August 6, 2009, 11:09am

Is that something necessary you should go for this kind of stuff?

You can try out using the System Configuration right?

Anyhow I will also try this out and provide you the answers. Between what is the version you use?

ganeshxp (BOB member since 2008-07-17)

system · August 6, 2009, 11:38am

Buddy I believe somewhere you are going wrong!!!

Just I tested a same Job in 2 different Repo.

If you should see it, then I can attach screenshots. I am getting the Logs runned up into the respective LOGINS and not into one single item only.

Please check. Confirm when configuring, selecting the schedule hyperlink on the top if it displays Repository : UAT , like that for each time.

Or please attach your screenshots.

ganeshxp (BOB member since 2008-07-17)

system · August 6, 2009, 1:37pm

Thanks Ganesh,

Answer to your both the replies:

1). Yes, this is necessary to have three different repository and three different sources and targets. Its Finance Sector where we need to have a very tight environment before we push it to production.

2). I have already made sure that I am using different repositories and scheduled in different repositories. We use Data Services. I also make sure each when i schedule the repository that its in the different environments.

Thanks,
Bow

boworld (BOB member since 2006-11-15)

system · August 6, 2009, 1:41pm

Hoooo :o

Even me too using DS only. 12.0 I use. But I am getting them correctly!!!

Not sure where the issue lies!!! Can you show the Schedule list page for each repository? as attachement?

ganeshxp (BOB member since 2008-07-17)

system · August 10, 2009, 10:54am

Hi Ganesh,

I know this is bit strange but I am not sure why this is still causing an issue.

I have attached the screenshots for DEV and TST. UAT is same as this with different time.

We export repo/job from DEV to TST and TST to UAT. Do you think this is causing running all the three scheduled jobs from UAT only?

As as a last effort I will try to create three job server and check it later today.

Thanks for your efforts.
Bow

boworld (BOB member since 2006-11-15)

system · August 10, 2009, 11:16am

Hey looked into your Screenshots!!!
Even me puzzled!!!

Hey please let me know one info. Your logs are getting created 3 different folders or on the UAT Folder only?

Please check your Credentials information in Management–>Repositories - All pointing to different Schema?

ganeshxp (BOB member since 2008-07-17)

system · August 10, 2009, 11:40am

I have checked both.

Log files are created in three different folders per repository.
Connections are pointing to separate repositories.
I have also recreated the jobserver and reassigned all the repositories again with no luck.

Thanks,
Bow

boworld (BOB member since 2006-11-15)

system · August 10, 2009, 11:44am

I expected. Then it is somewhere you are going wrong with the Credentials of UAT itself getting used for all the Jobs.

In between, you are using a System Configuration while running the Job. How about that? Have you went up and checked in the DS configurations? While running the Job from Designer, you might use the default config but your screenshot shows a particular config.

I hope this would definitely solve the issue. Expect your fruitful reply

ganeshxp (BOB member since 2008-07-17)

system · August 10, 2009, 12:05pm

I have a separate DS configuration. I have checked all the configurations in DEV, TST and UAT and they are pointing to their own environments.

I dont know whats going wrong…

Thanks
Bow

boworld (BOB member since 2006-11-15)