I have searched for this issue and found that other people had similar issues but no real resolution so I wanted to bring this to people’s attention.
SAP BusinessObjects Data Services XI 220.127.116.11
Windows Server 2008 R2 64-bit
Data Services Management Console using supplied Tomcat version that came with BODS.
When first creating a schedule for a job through the Management Console (MC), there is no problem - everything runs fine.
The Windows Server Task Scheduler contains entry “AT1” for the designated time.
Then I disable (but not remove) the schedule. The AT1 entry remains but is not executed so I assume the MC sets this to disabled.
But then I re-enable the schedule for that one job and sure enough, an ADDITIONAL entry is created in the Task Scheduler.
I now have AT1 and AT2 - both are active and kick off at the same time, resulting in table locks on in our Staging area!
We have had this issue twice now in our Production environment and I have been able to re-produce this problem in our Development environment so it does not seem to be server/configuration specific.
Do other people have this issue as well? Is SAP aware of it? Has it been resolved in an update?
We have tried to install the 18.104.22.168 update which failed due to the installer problem that is known and documented. We are looking to upgrade to BODS 4.x in the near future but this will be some time away as it will be one push for both the BO Reporting and BODS area.
ErikR (BOB member since 2007-01-10)