Package will not delete and can not be reset

I have a package where I had to cancel the build. The status from build history is 'Build Started' When I clik on the project (date/time) the Reset STatus button stays grey. I think some status somewhere is wrong but I can't find it.

Does anyone have a process documented on how to manually (via SQL delete a package)

This install is E1 8.12, tools 8.98.3.3 (we upgrade to 8.98.4.4 tomorrow), IBM i

Thanks.

Tom

Via sql, this is what I use to clear out the old package records (obviously, replace the 'JL%' with your package name):

delete from JDE900.SY900.F9603 where PHPKGNAME like 'JL%'
delete from JDE900.SY900.F9622 where BDPKGNAME like 'JL%'
delete from JDE900.SY900.F9631 where PDPKGNAME like 'JL%'


Are you not able to reset the package build status through the Advanced row exit from the Package Assembly-Build Definition screen?

-Camilla