DEVTEST_HOME/searchData/solr directory fills up when broker service is started

Document ID : KB000047661
Last Modified Date : 14/02/2018
Show Technical Document Details

Issue: 

DEVTEST_HOME/searchData/solr directory fills up when broker service is started.

Environment:  

DevTest CAI platforms 8.0.1 and above.

Cause: 

By default, several database columns of type “clob” are indexed and cached.
If these columns have an unusual amount of text data, the indexing will be excessive.

Resolution:

1)   Shutdown all DevTest components

2)   Delete the DEVTEST_HOME/searchData/solr directory
Note: This directory contains cache data and will be recreated when DevTest is restarted.

3)   Change to the DEVTEST_HOME/searchData/template/solr/path/conf directory.

4)   Copy db.dat to db.dat_orig

5)   With a text editor, edit db.dat
Remove the following lines

a.    data.STATE STATE,

b.    data.REQUEST REQUEST,

c.    data.RESPONSE RESPONSE,

d.    data.CDATA CDATA,

e.    <field column="STATE" clob="true" />

f.     <field column="REQUEST" clob="true" />

g.    <field column="RESPONSE" clob="true" />

h.    <field column="CDATA" clob="true" />

6)   Truncate the following tables (a DBA may be required):

a.    LISA_TRANSACTION_FRAME

b.    LISA_FRAME_DATA

c.    LISA_FRAME_FLAGS

d.    LISA_FRAME_TAGS

7)   Restart DevTest

Monitor the DEVTEST_HOME/searchData/solr

Additional Information:

 

Not applicable.