In this situation, mySQL was installed manually and apart from Spectrum so did not take the mySQL config that comes with the Spectrum install. In the OneClick/SRM tomcat log files we will find an import failed message, such as below.
“Import State: Import failed. Reason: null id in com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoFileResource entry (don't flush the Session after an exception occurs) Errors:ErrorDescriptor{message='null', errorCode='import.failed', parameters=[null id in com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoFileResource entry (don't flush the Session after an exception occurs)], errorUid='null', exception=null} Warnings:null”
This points to a problem with the mySQL database configuration.