Absolutely classic dry joint. The most likely reason was that the connector was slightly twisted along it's length when originally placed, and the reflow process didn't quite wet the pin properly. The end result would be that there was only a thin vertical bridge of solder connecting the relevant pins to their pads (you can see the remnants of this on the lowermost pin, the small squareish shadow on the pad), and eventually this broke due to temperature cycling/stress. The twist of the connector or strain on the cable then pulls the pins away from the pcb.

It's also likely that the amount of solder paste screened onto the pads in that area of the pcb was slightly deficient. You can see that the pins of the BTS409 power switch (the black, five pinned device right of top center) have the absolute minimum of solder on them.

Anyway, it's a simple job to resolder the pins, but the end of the connector will have to be pushed firmly down while the joints are reflowed to ensure that good contact with the pads is made. Sufficient rework flux is also vital.

pca