Issue while installing Solr - Failed to run SetSolrConfiguration.sql

  • Updated
Description

The below error can occur in Ektron 9.1 when a password is longer than 10 characters. 

ERROR! Failed to run C:\Program Files (x86)\Ektron\Search2.0\Backup\DBScripts\SetSolrConfiguration.sql against the database! String or binary data would be truncated.
The statement has been terminated.

Steps

To avoid this error, upgrade to 9.2 or higher of Solr. As a workaround, use less than 10 characters for the Solr SQL user.