dhis2-devs team mailing list archive

[林晓东 <lin_xd@xxxxxxx>]

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?





--

此致

   林晓东

莫愁前路无知己，天下谁人不识君。