Package Got Struck on Distribution Point

I have some of these "stalled" packages as well.
Here is an example of how to fix a stalled package with ID=ABC00074 on
DP named SMS1-TENN:

1. On the DP not receiving the package (SMS1-TENN) open d:\sms\logs
\distmgr.log in SMS Trace
2. From the bottom search up for "Package ABC00074 requires a newer"
3. When any line with this text is found, delete the file referred to
on that same line
for example: d:\sms\inboxes\distmgr.box\incoming\5f8a717f.pkg
4. Continue searching up for the text and deleting any .pkg files
referred to on those matching lines
5. Open Query ****yzer on the Central Site. Open your SMS Central
Site database. In the above example it would be SMS_ABC.
Edit the record in the PkgStatus table where package is ABC00074 and
DP is SMS1-TENN by executing this SQL command:
UPDATE PkgStatus SET Status=2, SourceVersion=0 WHERE (ID='ABC00074')
AND (TYPE=1) AND (PkgServer='SMS1-TENN')
6. In the SMS Console on the Central Site goto Packages - %Package
ABC00074% - Distribution Points.
In the right pane right click SMS1-TENN and select All Tasks Refresh
DP.
7. Continue monitoring the distmgr.log in SMS Trace. It will usually
refresh every 3600 seconds or 6 minutes.
Continue deleting .pkg files if the "Package ABC00074 requires a
newer" text is found.
8. If you delete more of these .pkg files during the next 6 minute
cycle do not perform Step 5 again but DO perform Step 6 again.

Once all the .pkg "stalled" files in the INCOMING folder have been
cleared out you will not see the "Package ABC00074 requires a newer"
text again. Instead you will notice that the compressed file has
arrived and shortly thereafter the uncompressed source files will
arrive.

Note : the below command should be executed on parent site server where  package struck child is reporting  


UPDATE PkgStatus SET Status = 2 WHERE ID = '05N0002F' and SiteCode = '96N' AND Type = 1

UPDATE PkgStatus SET SourceVersion = 0 WHERE ID = '05N0002F' and SiteCode = '96N' AND Type = 1