Indexer inbox keeps filling up. Need to recycle DI services to clear the many entries

Article:TECH144656  |  Created: 2010-11-19  |  Updated: 2011-08-15  |  Article URL http://www.symantec.com/docs/TECH144656
Article Type
Technical Solution


Environment

Issue



In Symantec Data Insight  (SDI) version 1.02 there is an issue with the events-publishing mechanism which would be a cause for delayed processing of events by the index-writer job.


Error



IndexWriterJob is not keeping up with the incoming rate
if(state != PAUSED && state != CALLJAVA) throw new IllegalStateException("call() called in inappropriate state");


Environment



SDI 1.02

Windows 2003 / 2008


Cause



a) The starting point for this JDBC is a C implementation of a driver
b) The C-source code of the driver is compiled using GCC to a binary that runs on MIPs architecture (it is easier to translate MIPs instructions to JavaByte code instructions).
c) The MIPs binary is then translated to a JAVA class (the JDBC)
d) The MIPS translated JAVA class is then run on top of NestedVM runtime, which is a virtual machine that emulates the MIPS operating system (system calls) and the MIPS hardware architecture (MMU etc)
e) NestedVM is loaded into the JRE when the JDBC is loaded
 
NestedVM runtime can go into an unexpected state, and would refuse to accept system calls allowing the queue to build up
.


Solution



Provided an updated sqlite-jdbc-3.6.20.1.jar file
Here are the steps to apply the patch:

On all the 64-bit DataInsight machines:

1. Stop DataInsightComm and DataInsightWeb services.
cmd prompt> net stop DataInsightComm
cmd prompt> net stop DataInsightWeb
2. Take a backup of the C:\Program Files\Symantec\
DataInsight\log folder and then delete all the existing log files in that folder.
3. Make a backup copy of the following files :
-- C:\Program Files\Symantec\DataInsight\reports\ReportEngine/plugins\org.eclipse.birt.report.data.oda.jdbc_2.3.2.v20090331-1440\drivers\sqlitejdbc-v056.jar
-- C:\Program Files\Symantec\DataInsight\tomcat\webapps\ROOT\WEB-INF\lib\sqlitejdbc-v056.jar
4. Download the attached file to the locations above.
5. Restart the services stopped in step 1.
cmd prompt> net start DataInsightComm
cmd prompt> net start DataInsightWeb

Verify under the “C:\Program…\DataInsight\log” folder on the Indexer/Management Server that the issue is resolved 

 


Attachments

sqlite-jdbc-3.6.20.1.jar (3.4 MBytes)


Article URL http://www.symantec.com/docs/TECH144656


Terms of use for this information are found in Legal Notices