Bug Fix: Symptom, on-demand feeds work, scheduled feeds do not

If you are running the following DBObjects versions, there is a bug in the schedule broker:

• 1.4.0
• 1.4.1
• 1.4.2
• 1.4.4

Click here to determine your DBObjects version.

There is no error displayed in the Data Process Control or schedule panel. In essence, you schedule, and nothing happens. You can test for this bug by logging into BPM Connect through the SQL Server Management studio and executing this SQL snippet:

use bpmconnect
go
exec dbo.p_UI_SCHEDULE_BROKER 'my feed name'

(**NOTE: A valid feed name needs to substituted for 'my feed name')

If you yield output as such, you have the bug:
DTSRun: Loading...

Error: -2147220220 (80040504); Provider Error: 0 (0)
Error string: The specified file is not a Package Storage File.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 704

NULL
This issue is solved in the 106 pack (or higher) of BPM Connect or DBOBjects 1.4.5 (or greater).

Any DBObjects versions less than the 1.4.0 are not afflicted with this bug.