Bartender System Service Error: The Bartender System Service failed an attempt to insert unique Information
Getting this message multiple time and the eventually Iabels start failing to print. The full message in the application error log is:
BarTender System Service: A server id record could not be selected due to the following error; Inner Message: The BarTender System Service Failed an attempt to insert unique information.
Table Servers, Command: A network-releated or instance-specific error occurred while establishing a connnection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error 40 - Could not open a connection to SQL Server); Inner Message: the network path was not found
We are running Bartender 2016 R9
Thank you for reaching us via the BarTender Community Forums!
Please open the BarTender Administration Console and navigate to the System Database tab; can you see if the System Database's Status is showing as connected?
If the System Database is not set up, please open BarTender Administration Console and try the following:
- Click on System Database
- Click on "System Database Wizard" in the banner
- Click Next
- Click "customize settings"
- Enter the credentials on the next screen. If you used the default settings, choose Windows Authentication.
- Select "Create a new system database"
- Enter the name of the database. DataStore is the default.
- Follow the dialog until you receive a confirmation screen
See if this would help to resolve the errors shown in Event Viewer.
On a side note, if you are unable to open the BarTender Designer application, it may be the BarTender installation is corrupted or not installed properly. If this is the case, I would recommend performing a clean uninstall of BarTender (see attached document for steps on this), then installing BarTender again when logged on to the computer with an administrator account.
Please, follow these recommendations and let us know how it went! :)