Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

PA Data collection job ends in Error due to HSQL error

crowe1288greg
Tera Contributor

‎10-21-2024 09:40 AM

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)

 

 

0 Helpfuls
  • 427 Views
1 REPLY 1

Bert_c1
Kilo Patron

‎10-21-2024 10:32 AM

I suggest that you open a Support Case for that. Since you can't post details on the Indicator, Indicator Source, Breakdown, and Breakdown Source.

0 Helpfuls