Hi guys,
I have wiped my device now and also replaced the BNC connectors on the XVR side and not the camera, SMD is working now but will test and see how long it will last.
My electrician tested and saw that he got a light shock feeling when removing the BNC cable from XVR while XVR is on and advised it could be a ground issue with the coax cable, so will let you guys know if it resolves the issue