[Dhis2-devs] delete program manually cause error!

[林晓东]

HI,all,
 I can't delete the program from maintains, so, do using sql: 


delete from programinstance where programid='103926124'
delete from dashboard_items where dashboarditemid in (select dashboarditemid 
from dashboarditem where eventreport in (select eventreportid from eventreport 
where programid='103926124'))
delete from dashboarditem where eventreport in (select eventreportid from 
eventreport where programid='103926124')
delete from  eventreport_columns where eventreportid in (select eventreportid 
from eventreport where programid='103926124')
delete from  eventreport_dataelementdimensions where eventreportid in (select 
eventreportid from eventreport where programid='103926124')
delete from  eventreport_organisationunits where eventreportid in (select 
eventreportid from eventreport where programid='103926124')
delete from  eventreport_periods where eventreportid in (select eventreportid 
from eventreport where programid='103926124')


delete from eventreport where programid='103926124'
delete from program_organisationunits where programid='103926124'
delete from  programstagesection_dataelements where programstagesectionid in 
(select programstagesectionid from programstagesection where programstageid in 
( select programstageid from programstage where programid='103926124'))


delete from programstagesection where programstageid in (select programstageid 
from programstage where programid='103926124')
--
delete from trackedentitydatavalue where   programstageinstanceid in (select 
programstageinstanceid from programstageinstance a,programinstance b  where 
a.programinstanceid=b.programinstanceid and b.programid='103926124' )


delete from programstagedataelement where programstageid in (select 
programstageid from programstage where programid='103926124')


delete from programstage where programid='103926124'


delete from program  where programid='103926124'  


but , can't open dhis2:
   http://------/dhis/api/programs :  
{"httpStatus":"Internal Server 
Error","httpStatusCode":500,"status":"ERROR","message":"No row with the given 
identifier exists: [org.hisp.dhis.program.Program#103926124]"}


how?





--

此致

   林晓东

莫愁前路无知己，天下谁人不识君。
_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to     : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp