In first instance I'm looking for a way to remove all internal DCF connections to get rid of duplicate connections.
I tried slnet calls, which doesn't allow deleting internal connections. Also through the general parameters page it's not possible to delete these internal connections.
I've been now advised to remove them from the elementdata table.
I'm trying following cql querry, but it doesn't allow the bigger than and smaller than characters.
delete from elementdata where d=34907 and e=159 and p>65060 and p<65070;
Anyone who knows the best way to delete internal connections without deleting the external connections?
I believe the following should do the trick:
Cleaning all connections from a specific element
delete from elementdata_DMAID where iEID = ELEMENTID and iPID in (65061,65096,65062,65089,65064,65101) and chIndex in (select chIndex from (select * from elementdata_DMAID where iEID = ELEMENTID and iPID in (65089) and chValue = "696E7465726E616C") As x);
that will delete all internal connections for a specific element.
ELEMENTID and DMAID are filled in twice in the query so you can just substitute for the right one. Restart the element when done.
That example query is SQL, applicable for e.g. a MySql DB. This will not work on a Cassandra DB, as Jeroen is mentioning that he’s using CQL.