Avoiding stack overflow errors on Derby data sources

Edit online

In order to avoid stack overflow errors on the four Derby data sources, reduce the trace level.

Before you begin

Before you begin this task, perform the following activities:

Ensure that the IMPACT_HOME environment variable is correctly set.
Ensure that you know the name of the Netcool®/Impact server. If you have a clustered Netcool/Impact server environment, ensure that you know the name of the primary server.

About this task

You are modifying backend settings for the four Derby data sources.

The four Derby data sources:

ImpactDB
NOIReportDataSource
RelatedEventsDataSourceseasonality
ReportDataSource

In a clustered Netcool/Impact server environment, make these changes on the primary server only. There is no need to make the changes on every server. Changes will be automatically replicated to non-primary members of the cluster.

Procedure

Access the command line of the Netcool/Impact server.
Update the trace settings for the ImpactDB Derby data source.
1. Edit the following file: $IMPACT_HOME/etc/servername_ImpactDB.ds
  
  Where servername is the name of the Netcool/Impact server. In a clustered Netcool/Impact server environment, servername is the name of the primary server.
2. Add the following lines to the file:
```
ImpactDB.Derby.DSPROPERTY.1.NAME=traceLevel
ImpactDB.Derby.DSPROPERTY.1.VALUE=0
ImpactDB.Derby.NUMDSPROPERTIES=1
```
3. Save and close the file.
Update the trace settings for the NOIReportDataSource Derby data source.
1. Edit the following file: $IMPACT_HOME/etc/servername_NOIReportDataSource.ds
  
  Where servername is the name of the Netcool/Impact server. In a clustered Netcool/Impact server environment, servername is the name of the primary server.
2. Add the following lines to the file:
```
ImpactDB.Derby.DSPROPERTY.1.NAME=traceLevel
ImpactDB.Derby.DSPROPERTY.1.VALUE=0
ImpactDB.Derby.NUMDSPROPERTIES=1
```
3. Save and close the file.
Update the trace settings for the RelatedEventsDataSourceseasonality Derby data source.
1. Edit the following file: $IMPACT_HOME/etc/servername_RelatedEventsDataSourceseasonality.ds
  
  Where servername is the name of the Netcool/Impact server. In a clustered Netcool/Impact server environment, servername is the name of the primary server.
2. Add the following lines to the file:
```
ImpactDB.Derby.DSPROPERTY.1.NAME=traceLevel
ImpactDB.Derby.DSPROPERTY.1.VALUE=0
ImpactDB.Derby.NUMDSPROPERTIES=1
```
3. Save and close the file.
Update the trace settings for the ReportDataSource Derby data source.
1. Edit the following file: $IMPACT_HOME/etc/servername_ReportDataSource.ds
  
  Where servername is the name of the Netcool/Impact server. In a clustered Netcool/Impact server environment, servername is the name of the primary server.
2. Add the following lines to the file:
```
ImpactDB.Derby.DSPROPERTY.1.NAME=traceLevel
ImpactDB.Derby.DSPROPERTY.1.VALUE=0
ImpactDB.Derby.NUMDSPROPERTIES=1
```
3. Save and close the file.
Restart the Netcool/Impact server. In a clustered Netcool/Impact server environment, restart all of the servers in the cluster.