Update to a previous post…
Provided as is – you break your box all on your own buddy! Lab this first.
The offending DNs can be queried using:
select n.dnorpattern from numplan n
left outer join devicenumplanmap m on m.fkdevice = n.pkid
where m.fkdevice is null
and n.tkpatternusage = ‘2’
and n.iscallable = ‘t’
- m.fkdevice is null assures the Route Plan element is unassigned
- tkpatternusage = ‘2’ matches DNs only
- iscallable=’t’ defines the “Active” checkbox on the DN page – and our offending behaviour.
Some help came from here.
Construct your own UPDATE SQL statement to fix it! As assistance – start here, it’s not too difficult.