Periodically, I have PA data collection scheduled jobs that are run either weekly, daily or hourly that end in 'Collected with Errors'. When one of these jobs ends in error, I have verified the job has previously and after the error execution have completed successfully. I have also verified the job has not been editing possibly causing this error.
Due to security within my organization, I'm unable to provide a print screen of the error. Here is the first line of the error message:
Error obtaining connection.com.snc.pa.dc.hsql.merge.CannotCreateConnectionException: HSQLDataCollector ::Unable to create connection to HSQLdatabase at com.snc.pa.dc.hsql.merge.HSQLConnectionManager.getConnection(HSQLConnectionManager.java:111)
