Data cannot be crawled after applying jdbc5.2sp1

Symptom

After applying SP1 to the JDBC Connector 5.2, one may find that content feeding no longer works. The below errors may be observed:

15:24:37,986 ERROR [JDBCConnector] Error when crawling the source system: Error reading config values from file: D:\esp\data\connectorcontroller\connector_config_file.xml
15:24:37,989 ERROR [JDBCConnector] Caused by: Parameter ConnectorExecution/ThreadSampleInterval is of type Integer. The value provided () cannot be converted to an integer
Parameter ConnectorExecution/DocumentLoggingFrequency is of type Integer. The value provided () cannot be converted to an integer
Parameter ConnectorExecution/MaxPublishers is of type Integer. The value provided () cannot be converted to an integer
Parameter ConnectorExecution/InitPublishers is of type Integer. The value provided () cannot be converted to an integer

Cause

This is caused by not using the new connector configuration file that is supplied with SP1.

The errors above indicate that the connector_config_file.xml configuration file has issues with the four parameters: ThreadSampleInterval, DocumentLoggingFrequency, MaxPublishers, and InitPublishers. This can occur when using an older configuration file, pre- jdbc5.2sp1 with the JDBC Connector 5.2 SP1, rather than the one that is included with SP1 (found at jdbc\etc\db.xml in the release media).

The errors indicate that these parameters have no value configured.  The JDBC Connector 5.2 SP1 requires that an integer value be configured in the connector configuration file for the connector to operate.   

Resolution

Migrating to the new connector configuration file that is included with the JDBC Connector 5.2 SP1 will resolve this issue.  Below are the default values for these parameters, as of SP1:

ConnectorExecution/ThreadSampleInterval:
<parameter name="ThreadSampleInterval" type="integer">
<description>
<![CDATA[Sampling interval for thread optimization in milliseconds. Set to low value in order to have more frequent status checks. <br>Default: 30000]]>
</description>
<value>30000</value>
</parameter>

ConnectorExecution/DocumentLoggingFrequency:
<parameter name="DocumentLoggingFrequency" type="integer" separator=" ">
<value><![CDATA[20000]]></value>
</parameter>

ConnectorExecution/MaxPublishers:
<parameter name="MaxPublishers" type="integer" separator=" ">
<value><![CDATA[1]]></value>
</parameter>

ConnectorExecution/InitPublishers:
<parameter name="InitPublishers" type="integer" separator=" ">
<value><![CDATA[1]]></value>
</parameter>
خصائص

رقم الموضوع: 2612799 - آخر مراجعة: 22‏/09‏/2011 - المراجعة: 1

تعليقات