Start with a visul inspection of this connector. Pull it off, check both male and female pins and crimps for clean and shiny, tug on wires look for brown/burned housing, wiring or pins.
If you don't anything wrong with it let us know.

image-38.jpg

No. This would blow a fuse. More likely is a high resistance/open somewhere.

Diagram below is from PinBot since I could not locate it for Cyclone, so check original manual if you have one. Notice (at least on Pinbot) that there's no Y split on violet/wht-vio pair like there is on the yellow/wht-yel pair. This should be one of the easier branches to troubleshoot.

That is a problem...you have 6.5 vac at the connector but only 4.8vac at the sockets. Measure continuity for low ohms from connector to playfield for each (violet and wht-vio) with bulbs removed from socket. Voltage should be the same from that connector to the first socket in the branch.

Screenshot at 2018-04-03 03-59-32 (resized).png

Good! We all benefit here by sharing. Hope this gets you working.