The spherical joint is providing 3 rotational degrees of freedom. The ball should slide along the rod with a Translational joint, not a Cylindrical joint since the spherical joint already has rotational freedom and the cylindrical joint freedom about the rod axis is redundant.
If you need more help, in Workbench, use File, Archive and put the *.wbpz file on your Google Drive and put the link that anyone can open into your reply.
You are navigating away from the AIS Discovery experience