qudoos
asked on
DTS Package Steps not executed
Hi I have a DTS package that is scheduled to run on a server every hour. The package got deleted accidently and I created it again from a backup. I fixed all the file pointers and ran the package. The pacakge runs, but only three steps actually get completed. for the rest it just says
"Step '' was not executed".
If I run the steps one by one, they run fine. I started logging the result and was able to get one error which I fixed. But now The log doesn't get any error. but still those steps are not run.
anyone who would know what the problem could be?
here is the log out put:
========================== ========
The execution of the following DTS Package succeeded:
Package Name: NCC - PCSWebDBUpload
Package Description: (null)
Package ID: {93A96295-F647-447C-868B-4 5C062F46C6 F}
Package Version: {2056B661-A494-4200-8A73-6 E091372207 4}
Package Execution Lineage: {9F85A803-2D9A-4F25-926A-6 44522EB6CE B}
Executed On: HOBBIT
Executed By: nortak
Execution Started: 10/12/2004 11:25:49 AM
Execution Completed: 10/12/2004 11:25:49 AM
Total Execution Time: 0.125 seconds
Package Steps execution information:
Step 'DTSStep_DTSActiveScriptTa sk_1' was not executed
Step 'DTSStep_DTSExecuteSQLTask _1' was not executed
Step 'DTSStep_DTSExecuteSQLTask _2' succeeded
Step Execution Started: 10/12/2004 11:25:49 AM
Step Execution Completed: 10/12/2004 11:25:49 AM
Total Step Execution Time: 0.031 seconds
Progress count in Step: 0
Step 'DTSStep_DTSExecuteSQLTask _3' was not executed
Step 'DTSStep_DTSExecuteSQLTask _4' was not executed
Step 'DTSStep_DTSActiveScriptTa sk_2' was not executed
Step 'DTSStep_DTSExecuteSQLTask _5' was not executed
Step 'DTSStep_DTSDataPumpTask_1 ' was not executed
Step 'DTSStep_DTSDataPumpTask_2 ' was not executed
Step 'DTSStep_DTSDataPumpTask_3 ' was not executed
Step 'DTSStep_DTSDataPumpTask_5 ' was not executed
Step 'DTSStep_DTSDataPumpTask_6 ' succeeded
Step Execution Started: 10/12/2004 11:25:49 AM
Step Execution Completed: 10/12/2004 11:25:49 AM
Total Step Execution Time: 0.031 seconds
Progress count in Step: 29
Step 'DTSStep_DTSDataPumpTask_4 ' was not executed
Step 'DTSStep_DTSDataPumpTask_7 ' was not executed
Step 'DTSStep_DTSDataPumpTask_8 ' was not executed
Step 'DTSStep_DTSDataPumpTask_9 ' was not executed
Step 'DTSStep_DTSDataPumpTask_1 0' was not executed
Step 'DTSStep_DTSDataPumpTask_1 1' was not executed
Step 'DTSStep_DTSDataPumpTask_1 2' was not executed
Step 'DTSStep_DTSDataPumpTask_1 3' succeeded
Step Execution Started: 10/12/2004 11:25:49 AM
Step Execution Completed: 10/12/2004 11:25:49 AM
Total Step Execution Time: 0.063 seconds
Progress count in Step: 1
************************** ********** ********** ********** ********** ********** ********** ********** ****
========================== ========
"Step '' was not executed".
If I run the steps one by one, they run fine. I started logging the result and was able to get one error which I fixed. But now The log doesn't get any error. but still those steps are not run.
anyone who would know what the problem could be?
here is the log out put:
==========================
The execution of the following DTS Package succeeded:
Package Name: NCC - PCSWebDBUpload
Package Description: (null)
Package ID: {93A96295-F647-447C-868B-4
Package Version: {2056B661-A494-4200-8A73-6
Package Execution Lineage: {9F85A803-2D9A-4F25-926A-6
Executed On: HOBBIT
Executed By: nortak
Execution Started: 10/12/2004 11:25:49 AM
Execution Completed: 10/12/2004 11:25:49 AM
Total Execution Time: 0.125 seconds
Package Steps execution information:
Step 'DTSStep_DTSActiveScriptTa
Step 'DTSStep_DTSExecuteSQLTask
Step 'DTSStep_DTSExecuteSQLTask
Step Execution Started: 10/12/2004 11:25:49 AM
Step Execution Completed: 10/12/2004 11:25:49 AM
Total Step Execution Time: 0.031 seconds
Progress count in Step: 0
Step 'DTSStep_DTSExecuteSQLTask
Step 'DTSStep_DTSExecuteSQLTask
Step 'DTSStep_DTSActiveScriptTa
Step 'DTSStep_DTSExecuteSQLTask
Step 'DTSStep_DTSDataPumpTask_1
Step 'DTSStep_DTSDataPumpTask_2
Step 'DTSStep_DTSDataPumpTask_3
Step 'DTSStep_DTSDataPumpTask_5
Step 'DTSStep_DTSDataPumpTask_6
Step Execution Started: 10/12/2004 11:25:49 AM
Step Execution Completed: 10/12/2004 11:25:49 AM
Total Step Execution Time: 0.031 seconds
Progress count in Step: 29
Step 'DTSStep_DTSDataPumpTask_4
Step 'DTSStep_DTSDataPumpTask_7
Step 'DTSStep_DTSDataPumpTask_8
Step 'DTSStep_DTSDataPumpTask_9
Step 'DTSStep_DTSDataPumpTask_1
Step 'DTSStep_DTSDataPumpTask_1
Step 'DTSStep_DTSDataPumpTask_1
Step 'DTSStep_DTSDataPumpTask_1
Step Execution Started: 10/12/2004 11:25:49 AM
Step Execution Completed: 10/12/2004 11:25:49 AM
Total Step Execution Time: 0.063 seconds
Progress count in Step: 1
**************************
==========================
ASKER
hmm...I tried creating precedence arrows again but still the same.
I would try creating a new package from scratch, but that would be my last resort cause there is a lot of transformation in the tasks.
thanks.
I would try creating a new package from scratch, but that would be my last resort cause there is a lot of transformation in the tasks.
thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
try this too make a copy of this .. strip out everything except for one of the data pump tasks
and execute it ..
maybee you can make a bunch of little packages out of your big one that will work..
i think that the file you restored is corrupted in some way
data pump tasks are very touchy ..
Jay
and execute it ..
maybee you can make a bunch of little packages out of your big one that will work..
i think that the file you restored is corrupted in some way
data pump tasks are very touchy ..
Jay
ASKER
I right click on a selected workflow item i.e. my 'On success' and 'On completion' and check properties. I cannot see a checkbox or something where we can disable the step. Same with my transoformation tasks.
Maybe I am missing where this flag is set, can you specify if I am not looking at the correct place?
Maybe I am missing where this flag is set, can you specify if I am not looking at the correct place?
ASKER
i found the flag under the option tab for workflow properties. no they are not checked to be disabled.
ASKER
ok the answer I accepted actually guided me in the right direction.
What happened was that all the workflow was screwed.
When I went to see the workflow properties of a task, I came to know that all other tasks are defined as precedence to it. Hence creating a cycle for all tasks thus none would get executed.
I fixed the workflow precedence and it is working fine now.
thanks a lot for the help.
What happened was that all the workflow was screwed.
When I went to see the workflow properties of a task, I came to know that all other tasks are defined as precedence to it. Hence creating a cycle for all tasks thus none would get executed.
I fixed the workflow precedence and it is working fine now.
thanks a lot for the help.
Excellent ...
probably a corruption problem ...
Glad you were able to resolve it.
I have seen other similar problems that the package had to be recreated to fix
Jay
probably a corruption problem ...
Glad you were able to resolve it.
I have seen other similar problems that the package had to be recreated to fix
Jay
create a new package
open the old package and start copying the steps one at a time into the new package.
and of course re-linking the flow steps.
it may be possible to just delete the flow arrows and re-create them too, give it a try.
Jay