Enforce console gets RSOD when trying to access the Discover Target page.

Localhost logs shows the error:

SEVERE [com.vontu.manager.spring.web.ManagerHandlerExceptionResolver] Unexpected exception while processing request:

Cause:

java.lang.NullPointerException

java.lang.NullPointerException

                at com.vontu.manager.filescan.ScanAssignmentTable_New.createRows(ScanAssignmentTable_New.java:79)

                at com.vontu.manager.filescan.ScanAssignmentTable_New.<init>(ScanAssignmentTable_New.java:43)

                at com.vontu.manager.filescan.ui.DiscoverTargetsController_New.getTargetLists(DiscoverTargetsController_New.java:226)

                at com.vontu.manager.filescan.ui.DiscoverTargetsController_New.list(DiscoverTargetsController_New.java:133)

                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

                at java.lang.reflect.Method.invoke(Method.java:597)

In 11.6 targettype 12 has been deprecated.

1.  To find out if you are running into this issue, run the following sql query as the Protect user: 

select scanassignmentid, isdeleted from scanassignment where targettype = 12;

If the above query returns rows and the isdeleted=0, then run the sql statement in step 2.

2.   Run as the Protect user:

UPDATE SCANASSIGNMENT
SET ISDELETED = 1
where targettype = 12;

COMMIT;