Failed to set the meta data of project default::qualitycenter_demo; SQL error executing statement CREATE FULLTEXT CATALOG QCFTCAT AS DEFAULT; [Mercury][ SQLServer JDBC Driver][ SQLServer ]Full-Text Search is not installed, or a full-text component cannot be loaded.;
The problem appears to be with Kerberos authentication requiring a registered SPN for the Tomcat service. In order to register an SPN, the user must have privileges to read and write SPN entries. Typically this can be performed by a domain administrator.
Stop IIS and Serena JBoss Services Create Oracle User with required privileges and import the sample database. Create Oracle ODBC definition and connect to it via the Mashup Asministrator
Update the database driver to the ODBC driver 17 for SQL Server. SBM 11.5 and better will accept the ODBC driver 17 for SQL Server . SBM 11.4 requires creating the ODBC connection manually so that we can use the ODBC Driver 17 for SQL Server . Create the ODBC connection manually using ODBC driver 17 for SQL Server.
In addition to adding the ";ssl= required " string to the database name, it is not necessary to add your SQL Server SSL certificate chain into the JRE truststore (CACERTS located in [SBM Install Directory]\Common\jdk1.6\jre\lib\security) unless you use ";ssl=authenticate
In addition to adding the ";ssl= required " string to the database name, it is not necessary to add your SQL Server SSL certificate chain into the JRE truststore (CACERTS located in [SBM Install Directory]\Common\jdk1.8\jre\lib\security) unless you use ";ssl=authenticate
