Search isn't working following upgrade to 7936
Following an upgrade from 7929 to 7931 and then 7936, search doesn't work - no results are returned.
DocumentIndexingTaskSchedule is set to run every 5 minutes, but when it runs, it runs only for a hundredth of a second, according to the scheduled activities list. Log files for a run are attached.
Invoking indexdata.bat returns:
indexdata.bat request 2014 2014
This script will index the data for quick and effective searching. This script
may take anywhere between 15 mins to 2 hours to complete based on the amount of
data.
Approx Statistics : 1 GB of data : 20 mins , 6 GB of data : 2 hrs
More info indexData.bat --help
Continue [y/n]>y
Oct 13, 2014 9:23:08 AM com.adventnet.servicedesk.lucene.util.DocumentIndexer ma
in
INFO:
Starting Database Server >>>>>>>>
Oct 13, 2014 9:23:08 AM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: Entering changeDocType
Oct 13, 2014 9:23:08 AM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: publicChanged :: false
Oct 13, 2014 9:23:08 AM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: written the file :: [server\default\conf\datasource-configuration.xml_tmp]
Oct 13, 2014 9:23:08 AM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: Finally publicChanged :: false
Oct 13, 2014 9:23:08 AM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: public ID not there in datasource-configuration.xml
Oct 13, 2014 9:23:08 AM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: Exiting changeDocType
Oct 13, 2014 9:23:08 AM com.adventnet.updatemgr.util.ConfUtils parseXML
INFO: extractLocation : file:/C:/ManageEngine/SupportCenter/applications/extract
ed/
Oct 13, 2014 9:23:08 AM com.adventnet.updatemgr.util.ConfUtils parseXML
INFO: startDBServer :: [true]
Oct 13, 2014 9:23:08 AM com.adventnet.updatemgr.util.ConfUtils parseXML
INFO: jndiName :: [MSSQLDS]
Oct 13, 2014 9:23:08 AM com.adventnet.updatemgr.util.ConfUtils parseXML
INFO: setdbhomearg set in mappings.xml :: [null]
Oct 13, 2014 9:23:08 AM com.adventnet.updatemgr.util.ConfUtils parseXML
INFO: Final setdbhomearg :: [false]
Oct 13, 2014 9:23:08 AM com.adventnet.updatemgr.util.ConfUtils parseXML
INFO: properties sent to adapter initialization :: {jndiname=MSSQLDS, name=mssql
, setdbhomearg=false, sqlgenerator=com.adventnet.db.adapter.mssql.MssqlSQLGenera
tor}
Oct 13, 2014 9:23:08 AM com.adventnet.updatemgr.util.ConfUtils parseXML
INFO: db.home :: [C:\ManageEngine\SupportCenter\bin\\..\pgsql] finally
Oct 13, 2014 9:23:09 AM com.adventnet.updatemgr.util.ConfUtils initDataAccess
INFO: connectionProperties :: [null]
Oct 13, 2014 9:23:09 AM com.adventnet.updatemgr.util.ConfUtils initDataAccess
INFO: url :: [jdbc:jtds:sqlserver://localhost:1433;DatabaseName=supportcenter;Td
s=8.0;PrepareSql=3;XaEmulation=false;]
Oct 13, 2014 9:23:09 AM com.adventnet.db.adapter.Jdbc20DBAdapter initialize
INFO: AUTO_QUOTE_IDENTIFIER value : false
Oct 13, 2014 9:23:09 AM com.adventnet.db.adapter.Jdbc20DBAdapter getListFromIden
tifierFile
WARNING: AUTO_QUOTE_IDENTIFIERS not supported for this DB...
Error while trying to instantiate SQLGeneratir com.adventnet.db.adapter.mssql.Ms
sqlSQLGenerator javax.naming.NoInitialContextException: Need to specify class na
me in environment or system property, or as an applet parameter, or in an applic
ation resource file: java.naming.factory.initial
Oct 13, 2014 9:23:09 AM com.adventnet.db.adapter.Jdbc20DBAdapter setUpDB
SEVERE: Start DBServer operation is not supported
Oct 13, 2014 9:23:09 AM com.adventnet.db.adapter.mssql.MssqlDBAdapter getToggleC
ollation
INFO: Incoming collation string is Latin1_General_CI_AS
Oct 13, 2014 9:23:09 AM com.adventnet.db.adapter.mssql.MssqlDBAdapter getToggleC
ollation
INFO: Collation String constructed is Latin1_General_CS_A%
Oct 13, 2014 9:23:09 AM com.adventnet.db.adapter.mssql.MssqlDBAdapter getToggleC
ollation
INFO: The Toggle collation string is Latin1_General_CS_AI
Oct 13, 2014 9:23:12 AM com.adventnet.servicedesk.lucene.util.DocumentIndexer ma
in
INFO:
Loading Modules DD >>>>>>>>
Oct 13, 2014 9:23:12 AM com.adventnet.persistence.SchemaBrowserUtil loadAllModul
eDD
INFO: loadAllModuleDD :: loaded the DD for the module :: MetaPersistence
Oct 13, 2014 9:23:12 AM com.adventnet.persistence.SchemaBrowserUtil loadAllModul
eDD
INFO: loadAllModuleDD :: loaded the DD for the module :: MetaPersistence
Oct 13, 2014 9:23:12 AM com.adventnet.persistence.SchemaBrowserUtil loadAllModul
eDD
INFO: loadAllModuleDD :: loaded the DD for the module :: Persistence
Oct 13, 2014 9:23:12 AM com.adventnet.persistence.SchemaBrowserUtil loadAllModul
eDD
INFO: loadAllModuleDD :: loaded the DD for the module :: DeploymentManager
Oct 13, 2014 9:23:12 AM com.adventnet.persistence.SchemaBrowserUtil loadAllModul
eDD
INFO: loadAllModuleDD :: loaded the DD for the module :: CoreContainer
Oct 13, 2014 9:23:13 AM com.adventnet.persistence.SchemaBrowserUtil loadAllModul
eDD
INFO: loadAllModuleDD :: loaded the DD for the module :: Security
Oct 13, 2014 9:23:13 AM com.adventnet.persistence.SchemaBrowserUtil loadAllModul
eDD
INFO: loadAllModuleDD :: loaded the DD for the module :: Reporting
Oct 13, 2014 9:23:13 AM com.adventnet.persistence.SchemaBrowserUtil loadAllModul
eDD
INFO: loadAllModuleDD :: loaded the DD for the module :: WorkEngine
Oct 13, 2014 9:23:13 AM com.adventnet.persistence.SchemaBrowserUtil loadAllModul
eDD
INFO: loadAllModuleDD :: loaded the DD for the module :: ClientFramework
Oct 13, 2014 9:23:13 AM com.adventnet.persistence.SchemaBrowserUtil loadAllModul
eDD
INFO: loadAllModuleDD :: loaded the DD for the module :: ClientComponents
Oct 13, 2014 9:23:14 AM com.adventnet.persistence.SchemaBrowserUtil loadAllModul
eDD
INFO: loadAllModuleDD :: loaded the DD for the module :: Helpdesk
Oct 13, 2014 9:23:14 AM com.adventnet.persistence.SchemaBrowserUtil loadAllModul
eDD
INFO: loadAllModuleDD :: loaded the DD for the module :: ServiceDesk_Client
Oct 13, 2014 9:23:14 AM com.adventnet.servicedesk.lucene.util.DocumentIndexer <i
nit>
INFO: DocumentIndexer instantiated
Oct 13, 2014 9:23:14 AM com.adventnet.servicedesk.server.utils.SDClientUtil isSe
rverAlreadyRunning
INFO: requestScheme is https
Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/commons/co
dec/DecoderException
at org.apache.commons.httpclient.HttpMethodBase.<init>(HttpMethodBase.ja
va:217)
at org.apache.commons.httpclient.methods.GetMethod.<init>(GetMethod.java
:88)
at com.adventnet.servicedesk.server.utils.SDClientUtil.isServerAlreadyRu
nning(SDClientUtil.java:184)
at com.adventnet.servicedesk.lucene.util.DocumentIndexer.main(DocumentIn
dexer.java:107)
Caused by: java.lang.ClassNotFoundException: org.apache.commons.codec.DecoderExc
eption
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
... 4 more