We have an initialization error on TestSQLRepositoryFulltextConfig. The repository fails to init. The root cause is on PostgreSQL:
java.sql.SQLException: Error executing: CREATE OR REPLACE FUNCTION NX_TO_TSVECTOR(string VARCHAR)
RETURNS TSVECTOR
AS $$
SELECT TO_TSVECTOR('org.apache.lucene.analysis.fr.FrenchAnalyzer', SUBSTR($1, 1, 250000))
$$
LANGUAGE sql
IMMUTABLE;
ERROR: improper qualified name (too many dotted names): org.apache.lucene.analysis.fr.frenchanalyzer
And on Oracle:
Error post creating table: CREATE INDEX "FULLTEXT_FULLTEXT_IDX" ON "FULLTEXT"("FULLTEXT") INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS('org.apache.lucene.analysis.fr.FrenchAnalyzer SYNC (ON COMMIT) TRANSACTIONAL') : ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-11000: invalid keyword ORG.APACHE.LUCENE.ANALYSIS.FR.FRENCHANALYZER
https://qa.nuxeo.org/jenkins/job/nuxeo-master-fullbuild-part1-multidb-linux/1345/Slave=MULTIDB_LINUX,dbprofile=pgsql,jdk=java-8-oracle/testReport/junit/org.nuxeo.ecm.core/TestSQLRepositoryFulltextConfig/testFulltextOnlyNoteFile/
https://qa.nuxeo.org/jenkins/job/nuxeo-master-fullbuild-part1-multidb-linux/1345/Slave=MULTIDB_LINUX,dbprofile=oracle12c,jdk=java-8-oracle/testReport/junit/org.nuxeo.ecm.core/TestSQLRepositoryFulltextConfig/testFulltextOnlyNoteFile/
- is duplicated by
-
NXP-17337 TestSQLRepositoryFulltextConfig test init failure on SQL Server
-
- Resolved
-
