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

Products

• Service Virtualization

Issue/Introduction

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

Environment

All supported DevTest releases.

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,

b.    data.REQUEST,

c.    data.RESPONSE,

d.    data.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

 

Note: In some DevTest versions (10.7 or greater), you may receive constraint errors while truncating the above tables. If so, use "delete from <table name>" instead of "truncate table <table name>". 

 

7)   Restart DevTest