When launching Pilot, the following error message appears:
Connection to database could not be made.
java.sql.SQLException: Failed to create database "iCutAutomate:' see the next exception for details
Error pops up when launching Pilot and the Gang Run Printing is not working.
This error appears when the setup is incorrect in Pilot > Tools > Configure > Automation Engine Databases > Gang Run Printing. This should be setup as follows:
Database - BSJobs
DBMS type - Microsoft SQL Server
Host - localhost
User - admin
password - admin
Once the setup is done correctly, click the Synchronize button. The Database message should show "OK".
The above pop-up message appears when the DBMS type is set to Embedded and not MSSQL BSJobs database.